Search results

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...

I am using Access 2007. I would like to create a function in a module for a text field, similar to the function created by Bob Larson on 10/12/2012 when answering a thread called "Default Value in Forms based on value in another table". It appears that he is creating a function for a numeric...

Okay 'pr' that is big help now....but one last request, please. I have a Split Form that is based on a table of transactions where I want to implement this combo box pull-dwon selection, as we have discussed. When I add the combo button through the wizard it works fine, but it gives me the...

Perfect 'pr', that is exactly what I want. Thank you very much for the sample db! But I am weak with VBA code so I may need some help in utilizing 'FindFirst'. I assume that I must copy the code from the After Update propert of your company combo box. Correct? Should I simply copy from the...

Thank you 'pr', very impressive. I appreciate the sample database. This helps me out a lot, but I still would like to understand some things here with your suggested structure. The user clicks on the "front" form to select the company number, which 'drives' the opening of the "second" form...

Thank you 'pr', I appreciate the thorough response but I'm still confused on the structure here. Please bear with me. Are you saying that I must set up a "front" Form that contains the Combo Box, where the user makes a selection? If so, how does this "front" form connects to the Form I have...