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!

more VBA help needed please... I need to combine the above code with other code I have. This is the code. When I compile the db the first line is highlighted and the error message is "Compile Error - Expected End of Sub". Any ideas? Private Sub Command398_Click() Function...

Thank you so much!

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

Thank you! That was indeed a better way. Works great!

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

Thanks to you both for the suggestions. I'll check them out!

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

Thank you!!

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

Thanks so much for your help. Looks like it's working the way I'd like... Except.... How do I close the form that I just came from? The user opens the SelectCaseChange form and enters the case number of the case they need to work on (make changes to). Then they click a button that opens the...

Thanks so much for the help.... I tried the stop and found the solution to another problem I was having....(the bound column on a combo box filled based on the value in a text box) BUT... If I put the code in the BeforeUpdate property then the query to fill a combo box based on the value of a...

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