Recent content by sdsmith

Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim iResponse As Integer ' Specify the message to display. strMsg = "Do you wish to save the changes?" & Chr(10) strMsg = strMsg & "Click Yes to Save or No to Discard changes." ' Display the message box...

I can not get my dialog box to perform correctly. Right now, I'm using the code below. The Yes button saves and the No button clears everything out. I want the Cancel button to do nothing and just return to the same page with no changes. How can I correct this? Private Sub...

Ok, I understand. Yes, with the particular type of report that I'll have to pull from it and how the client wants it to look, two separate tables are necessary.

Thanks! And yes, one table is of active records and the other table is of archived records. When an active record becomes obsolete, I have to archive it. But it still has to remain in the database for historical purposes. So I am wanting to just move the record from the active table to the...

Hi! I have built two tables (active and archived) and I have created an "active" form. On the form, I've placed an "archive" button on the form that I would like to be able to click and move the record to the "archived" table. It's not allowing me to put in a code and I am not sure what options...

I am now having a similar issue. I have made a button on my form and I am trying to get the action to move a record from one table to another table. The situation is moving an active record table to an archived record table. It's not even allowing me to put in a code. What steps do I put in for...