Search results

For the purpose of the original issue, it worked on each record independently. There has been a new issue today where I am not able to relate combo boxes properly, and all similar boxes use the rules for the one currently in focus. I can only go back to the fact that that Datasheet View has...

Update: Changing the activation of the VB Code from the OnChange Event of the ActionID Field to the OnCurrent Event of the Form looks like it will resolve the issue. Thanks for your response. -- Rookie

Thanks for replying. The SubForm is set to DataSheet View, not any type of Form View. The Code is executed in the OnChange Event of the ActionID Field. I am beginning to think that Datasheet View has issues that are similar to Continuous Forms View, and will look into whether Conditional...

I have a Form to Display Projects that has a SubForm displaying Sub-Projects related to them. The main Project Form has a Combo Box which allows a user to select a ProjectID to display. The SubForm has a ProjectID Field as well. When the Project ID is selected in the Main Form, only the...

to eat breakfast

I suspect that your biggest offender is the embedded OLE Objects. If you take pr2-eugin's advice you could create a related Table to store the pictures in, you could save space on any record that does not have two pictures. in addition, you could also arrange to accomodate a record that requires...

It is very hard to make any observations with so little information to consider. For instance, what are the structures in your Tables? If your table structures that are not normalized and have repeated data such as names and ID Codes, the repeated items could be moved to additional tables...

eggplant and garlic

handlers forgot to

kennel club show

for a trip

get out of

or at least

a large mass

laboratory, Dr Strangelove

I have to wonder if he missed the possibility of searching for it before inserting. INSERT INTO t_SubmissionDates (SubmissionDate) VALUES(#11/11/2013#) WHERE DCount("*", "t_SubmissionDates", "Nz(SubmissionDate, "")="") = 0 I suppose there is also a version that uses DLookup(). -- Rookie

tall steel pole

ONE THOUGHT: You said that you closed all open database Instances when they were no longer needed. Did you also remove them from memory by defining them as Nothing? Dim MyDB AS Database Set MyDB = CurrentDb . {Do Something with MyDB} . MyDB.Close Set MyDB = Nothing -- Rookie

I use OnChange, because most of my Combo Boxes are defined with the Limit to List property set, and OnChange fires as soon as an item in the list has been selected. -- Rookie

I do not think that this is the right place for the code. I believe that it belongs in the OnChange Event for the Combo Box. -- Rookie