Recent content by JoeyB_99

Thanks Gina, but that is not the case here. All 'front-ends' are archived and run from the user's local hard-drive (C:\).

Thanks Mihail. But I checked every form and this setting is No Locks. Do you happen to have any other suggestions/checks?

I am currently using Access 2010, and have successfully split a database, using the Access wizard. However, whenever a second or third user opens the database - with their front-end database file - they encounter the following message; The Microsoft Access Database engine cannot open or...

Thanks Privateer for the quick and thorough response. Unfortunately I do require the driving distance between the two addresses. But you have given me something to work with so I will start with your suggestion on prerequisites. Thanks again.

I am using Access 2010 and am developing a form where the user provides a full address - street number, street name, city, province and postal code. I want a control to calculate the distance from this address and a fixed address. I'm not sure where to start. Any input would be greatly...

I am using Access 2007 and have created a split form that is bound to the fields in a table. It was working fine in terms of Tabbing through certain controls, and successfully Tabbing onto the next record, as intended. Then I added a calculated control on this split form, that is based on...

I am using Access 2007 and created a split form based on a table. There is a field called cost code. A cost code may have one or several records from this table. I created a combo box based on cost code to select the records that appear on this form. I have raw data (hours) from the table on...

Success! Thank you jdraw that did it! It is working fine. I have tested it with different record selections (cost codes) and the output is as desired! Thanks again jdraw. I have another VBA coding quirky situation so I will post it separately.

Okay jdraw, I think we might be making progress. Cost Code is a string/text. When I compile the revised code as per your last post I do not get an error message. But when I open the form I get a VBA error message, run-time error 3075. "Syntax error in number in query expression '[Cost...

Thanks again jdraw, for sticking with me. Things are getting confusing for me too! If you check Bob Larson's post you will see that I am entering code into a standard module, as opposed to an event procedure. Does that make any difference here? Yes, there is a field on the main form called...

Thanks Jdraw but it doesn't work. When I compile the code I get an error message "Invalid use of Me keyword".

Thanks jdraw but its not quite right. 　 No matter what record I select from the combo box it returns the default text value from the first record of the table called tblCostCodeReferenceData. 　 So I guess I will need something in the criteria for the Dlookup function that connects the proper...

The control is bound to tblAmountsBilled.DescriptionOfWork. I want the default value for this control to come from the table tblCostCodeReferenceData and the name of the field here is CostCodeDescription. Something else I forgot to mention. The records on this form are done through the...

Thank you DavidAtWork and jdraw, for your interest and offer to help. The field I want to use in this situation is a text field from a table. I want to use it as a default value in a control which is bound to a field in a different table. The user can accept this default value when creating...

I am using Access 2007 and have created a split form. Using the wizard I then added a combo box for the user to select records based on a field called Formatted Cost Code. The wizard left a macro in the After Update property of the control for the combo box. I converted this to VBA using the...