Search results

After stepping back and reviewing my code. I think I have my problems resolved.

I apologize in advance for a long post. But I think more the details, the better. I have two questions at the bottom of my post. --------------- I have a mainform called frmMainForm. On this mainfrm, I have a ComboBox called cboQuickSearch which list all of my Company’s Id and Name. It...

Thanks for the quick and "DIRTY" rundown. I know, probably an old pun. Awesome. BTW, you all are quick. I love this forum.

I will have to research in the future on the use of Audit Trail. Still learning. Thanks. I also plan on looping when needed.

Thanks for that Tip.

Interesting. So on the OnDirty event, can you give me a quick example of comparison on a control? What would be the syntax in the OnDirty event?

I have an form which is bound to a query recordset. If a user changes any items in the form, how do I check if any of the items have been changed before it is saved when they click on a SAVE button? I assume I would use a BEFOREUPDATE event, but what is the syntax to loop through the controls...

Makes perfect sense, much appreciated. Thanks. This helps a lot.

Then how would I set it up to allow the user to edit the record if it needs editing/deleting or addnew record if one doest exist? I am sure it has to be done via VBA code right? Is there an example that I can follow? I appreciate your quick response.

Can anyone point me to an example where there is a vba code to create a query and bound the result to a form? This allows the user to see the result, but cannot directly edit the information so it wont affect the data from the underlying table. But if the user wants to edit the information...

wiklendt, Thanks for your response. I will have to fix that piece where all the tabs should be subforms. That is a problem on my first tab. Yes, its is normalised. My problem was trying to get it to be visually pleasing to the User. I will have to rethink on how to present the layout. I...

Hello, First post. Glad to find this. I am using Access 2003. I have a Form which uses a tab control. Tab1 has my main form called FrmMain Tab2 is a subform which has contact information called sFrmContact Tab3 is a subform which has an unbound form In my Tab3, which has an unbound form...