Search results

What's the best way to record userID, record#, field name & values before update for every record changed in an access database? Thanks!

I have a form that captures info on a case BUT if the case (record) already exits and the user wants to add services I need to add a P to the end of the case # - which is the primary key - and paste append. How do I bring up a custom message box when there is a record present that asks if they...

How do I copy a record with 200 or so fields to another table in code?

I have the following code in the After Update event of a combo box. Sub Como78_AfterUpdate() Me!RecordsetClone.FindFirst "[Membership #] = '" & Me![Combo78] & " ' " Me!Bookmark = Me.RecordsetClone.Bookmark Me![renewal date].setfocus End Sub It worked fine for years but now...

Hello all! Thanks for your past assistance! Hope you can help with this one... I have this code attached to a button on a form. The fields in the underlying table that I'm atempting to update are null. If Me![STAA1] Is Null Then Me![STAA1] = Me![stacurx]...

A text box named statcurx holds the value of the current status of a case. A text box named NewStatusx holds the value of the new status of a case. I have the following code at the on close event of the form - Select Case stacurx Case 22 If Me![NewStatusx] = 14 'save a date to...

I have a combo box whose row source property is a query with two joined tables. The criteria is the value of a text box on the same form. The values are listed correctly in the combo box based on the value in the text box BUT I can't choose a value from the combo box list. Only the first value...