My company is not very big, but we have a department that sees about 30 individuals using an Access db to manage workflow. The department head created the database through out the past few years and it has steadily gotten bigger over that time. All users utilize the front end only interface that calls on the back end database. This works fantastic for Access 2010, however all users must retain Office 2010 for this reason. Anytime in 2013 and/or 2016, when calling on tables from the form we receive the "Select Data Source" window. This is where I am stuck. What has changed with access from 2010 to 2013 to cause this?

There is intention to migrate to a full SQL server in the future, but things take time. Currently we are stuck with trying to figure this out.

If anyone has any direction to move forward, that would help.
]]>FormsAcroJumperhttp://www.accessforums.net/showthread.php?t=67591Pass Parameter To Form From Button Clickhttp://www.accessforums.net/showthread.php?t=67586&goto=newpost
Wed, 16 Aug 2017 18:46:22 GMTI am using the onclick() event of a button to open up a second form. The second form is based off a query (hypothetical) let's say the query is

Code:

select * from employeedata

now I want to be able to add a where clause and a parameter to the syntax based off a button press. If my button press event looks like this

So based off the above I would want to modify the query the form is based on to be

Code:

Select * from employeedata where employeename = WC

There will always be a parameter passed from the button click event. What is the proper way to set this up in a button click event?

EDIT ------
Or would it be easier to pass a vba variable to the where clause of onload() event of the form, as opposed to altering a query?
]]>Formsjo15765http://www.accessforums.net/showthread.php?t=67586http://www.accessforums.net/showthread.php?t=67585&goto=newpost
Wed, 16 Aug 2017 17:44:08 GMTHi Forum,

I need some assistance I have two date boxes in my form. The first date box is used by the person entering the date. I'd like the 'Calibration Due Date' to be added automatically but with 1 year added on.

]]>FormsJNevillehttp://www.accessforums.net/showthread.php?t=67576Filtering Dynamic Combo Boxeshttp://www.accessforums.net/showthread.php?t=67575&goto=newpost
Wed, 16 Aug 2017 02:26:52 GMTI am fairly new to working with Access and I am working on a form that contains several dynamic combo boxes. I have 3 combo boxes,...I am fairly new to working with Access and I am working on a form that contains several dynamic combo boxes. I have 3 combo boxes, (cboGroups_Packages_1, cboGroups_Packages_2, cboGroups_Packages_3) that are generating a list from the same query, qryGroups_Packages. I would like to be able to filter out the first selected item in the first combo box from the second and third combo boxes. For example, all three combo boxes would display FX4 Pkg, Sport Appearance Pkg, Chrome Appearance Pkg, Trailer Tow Pkg, and Max Trailer Tow Pkg. If in the first combo box I choose the Sport Appearance Pkg, I would like the 2nd and 3rd combo boxes to display the rest of the options except for the Sport Appearance Pkg. Then the same for the other combo boxes. I would like to only display in the 3rd combo box the options that were not selected in the 1st and 2nd combo boxes. I hope this makes sense. Thanks in advance.
]]>FormsTopflite66http://www.accessforums.net/showthread.php?t=67575Moving a Record to another tablehttp://www.accessforums.net/showthread.php?t=67571&goto=newpost
Tue, 15 Aug 2017 21:22:43 GMTHello fellow Access enthusiasts :cool:
I have a form with 3 List Boxes lets call them This Week, Next Week, and old.
On the form you can move a...Hello fellow Access enthusiasts :cool:

I have a form with 3 List Boxes lets call them This Week, Next Week, and old.

On the form you can move a record from one list to the other using a command button. (Like from Next Week to This Week)

I'd Imagine it would have to be something along the lines of copy record to tbl and delete record from prev tbl.

Both tables have the exact same layouts and fields.

I guess I'm just looking for a starting point to educate myself on the best way to do this.
]]>FormsForbeshttp://www.accessforums.net/showthread.php?t=67571http://www.accessforums.net/showthread.php?t=67562&goto=newpost
Tue, 15 Aug 2017 16:09:49 GMTBelow is code I wrote to try and allow the user to search all records for a Part Number and then go to the record that has that number.
I have a...Below is code I wrote to try and allow the user to search all records for a Part Number and then go to the record that has that number.
I have a combo box on the main form that is unbound but gets its data from the same record source as the sub-subform. The user picks a part from the combobox then presses the Part button.The code works the 1st time and usually more than once. It almost seems as though as long as its searching forward it finds and moves to the correct record, but if you try to go backwards its just finds the customer and the first record for that customer. Does anyone see a issue that sticks out?

]]>Formsbbrazeauhttp://www.accessforums.net/showthread.php?t=67562http://www.accessforums.net/showthread.php?t=67551&goto=newpost
Mon, 14 Aug 2017 20:39:44 GMTI'm trying to create a field on a form that launches a value that I want Access to treat like a hyperlink. I know I could create a hyperlink field type in the table, but since I'm eventually going to put this table into SQL Server, I wanted to have the field type something that can be stored in the new table format. I have created a text box field [MyhyperlinkField] on a form that displays the value from the table. The value is a path to a file on my computer (i.e. G:\documents\.....). I have changed the properties in this text box to Hyperlink-yes, and Display as Hyperlink-Always. When I run the form, and click on the blue, underlined value, it does not launch the hyperlink. Obviously, I'm missing some code. I've tried to research FollowHyperlink and GoHyperlink methods, but I couldn't follow where I should be putting this method, and didn't understand the proper syntax to launch my path that is displayed in the text box.

Thanks for any suggestions
]]>FormsPbear88http://www.accessforums.net/showthread.php?t=67551http://www.accessforums.net/showthread.php?t=67547&goto=newpost
Mon, 14 Aug 2017 17:30:41 GMTI have 3 fields. The CAP field and the 3rd Qtr YTD are currency fields. The third field is Alert and is a text field.
I want to have the Alert...I have 3 fields. The CAP field and the 3rd Qtr YTD are currency fields. The third field is Alert and is a text field.

I want to have the Alert field results based upon a calculation using the CAP and YTD fields. If the YTD field is greater than 89.99% of the CAP I want the Alert field to display the word "Alert". Otherwise it would display "Okay". Here is my current expression which so far result in the record displaying #NAME".

=IIf([3rd Qtr YTD>".89999*CAP"],[Alert],[Okay])

Can someone point out the error of my ways?
]]>FormsPATRICKPBMEhttp://www.accessforums.net/showthread.php?t=67547percentagehttp://www.accessforums.net/showthread.php?t=67537&goto=newpost
Sun, 13 Aug 2017 20:00:20 GMT=1000,0.05)
If the Finance...]]>I have a text box that I would like it to figure a price from another text box

=[Finance Price]*IIf([Finance Price]>=1000,0.05)

If the Finance Price is greater than 1000 I would like it to discount that price by 5%

I have a button named bttn4 on a form which generally is not visible. (The Visible setting on the Property Sheet is set to "No") The button is to open another form when clicked.

I have a tick box field on the form called [BML Driver]

If BML Driver is ticked, I want the button to show. If BML Driver is not ticked I want the button to remain hidden.

I have put the following code on the On Current event ...

Code:

Code:

Sub Form_Current()
'show bttn4

If Me.[BML Driver] = "yes" Then
bttn4.visible = True
bttn4.SetFocus

Else
bttn4.visible = False

End If

The bttn4.visible seemed to work OK, but when I added the criteria of the tick box it stopped working !!!

Any help or advice would be appreciated.

Cheers

Stuart
]]>FormsStuartRhttp://www.accessforums.net/showthread.php?t=67536Search age from the combo box and invoke records in other formhttp://www.accessforums.net/showthread.php?t=67534&goto=newpost
Sun, 13 Aug 2017 15:08:25 GMTI have a search form1 with a combo box of range of age.
"Under 18
18-25
26-35
Over 35"
Once the user chooses from one of the options, another form2 should open up with all the matching ages. I've created a text field in form2 which calculates the age based on the date of birth field from the table.
I used the macro and stated if combo box of age from form1 is "Under 18" then I'm opening a new form2 and in the where clause trying to get all the records that are less than 18 years old.
My concern is that age in form2 will get calculated only once its open, so it will not work. Should I create a query and calculate age, then use that query in the where clause.
Please help me out here. I'm totally new to the macros and the coding. Thanks
]]>Formsrabiahttp://www.accessforums.net/showthread.php?t=67534http://www.accessforums.net/showthread.php?t=67531&goto=newpost
Sat, 12 Aug 2017 22:47:01 GMTI have the following code that adds to a text box (proposal), it works great but would like to add that if after I check the box the item is added,...I have the following code that adds to a text box (proposal), it works great but would like to add that if after I check the box the item is added, if I change my mind and uncheck the box the item will be removed from the text box (proposal).

thanks Angie
]]>Formsangiehttp://www.accessforums.net/showthread.php?t=67531http://www.accessforums.net/showthread.php?t=67525&goto=newpost
Fri, 11 Aug 2017 19:10:19 GMT... that references an autonumber PK in another table. I'd like to be able to just paste information in from Excel, however in Excel the information is stored as a client name. So, as an example:

My excel spreadsheet looks like this:

Hedge Fund Name

Portfolio Name

Portfolio Type

Value

Chase Fund

Chase Fixed Income

Buyout

$1,000,000

and my access data dump form has the following headings:

fundManagerID_FK

portfolioName

portfolioType

portfolioValue

I have a 'fundManager' table that holds only fundManagerID_PK and the fundName.

So: my dilemma is it does not allow me to easily paste my excel data in as it expects the auto-numbered PK. From looking at the properties of a combo box I see that the answer lies somewhere in changing the 'Row Source / Row Source Type' however it appears that text boxes do not have that option.

I apologize in advance if this is a silly question. I am very very new to Access. Thanks!
]]>FormsChaseChttp://www.accessforums.net/showthread.php?t=67525Stop Writing duplicatehttp://www.accessforums.net/showthread.php?t=67516&goto=newpost
Fri, 11 Aug 2017 04:59:34 GMThello to all friends
I have 5 fields in the subform called (name1 , name2 , name3 , name4 ,...hello to all friends

I have 5 fields in the subform called (name1 , name2 , name3 , name4 , NFather )
but I Want when complete the 4 names and if NFather similar show me Error message