Recent content by dullster

Exactly. Why didn't I think of On Load. The one thing I didn't try. Thank you

I have my form fixed. I have tried this code "On Close" and it still doesn't clear the data. Private Sub Form_Close() On Error Resume Next ' Prevent error if subform is not loaded ' Check if the subform control exists and is loaded If Not Me!frmVendorsearchsub.Form Is Nothing Then...

I am using an unbound control. It's the Vendor Payment Search. I just realized it is not search all records for a Vendor. I will correct that.

I hope I'm understanding you right. I filter with a Macro with the following code. Then I have a Master - Child link on ClientID to populate the subform. I use the above code for a button that prints the results of the filter. I would like to clear the data after printing the report or on exit...

I have a form that searches all Vendor payments and the subform produces all the payments to that vendor. I have created a report that prints the results by clicking "Print Report" button. I would like to clear the data on the form when I open that report. Attached is the code that opens the...

That is one of the queries. I have three others. I have a code wrote in the template to make that table start at 1 when I append data. When I have data to append next I will see if it's working the way it needs to be.

No I don't think you're missing anything. I have a template database but for some reason when I append the tables they do not start at 1 again. I don't know if it's bringing in the number from the tables I'm appending, I don't know why it's not starting as 1. I don't understand it either. I've...

I have a template DB that is used for all appends. I did the C&R when the tables were empty but it did not reset the ID to 1. Everything is read said it should reset but it didn't. Thus why I will run the reset statement. Thank you.

It's was a pain when I checked the forms and found them blank. Everytime a appended a new DB it would continue numbering where it left off and i had to go in and edit the queries. I think this should fix it. Next couple DB I append will be the test.

I need the table to have the same ID numbers so I don't have to go in and change the ID numbers in 4 queries every time I append new data. SELECT tblEmployees.EmployeeID, tblDemoClients.ClientFullName, tblEmployees.[Adjusted Basic Salary], [Amount from Column A]-(([Adjusted Basic...

I needed it to start at 1. I posted a SQL above but will share it again. ALTER TABLE [tblDemoUCAs] ALTER COLUMN [DemoUCAID] Counter (1,1)

The tables are all empty in my template. I do not need to delete the relationship to run the reset query. I can run it with the relationship already there. I only need to run it on one table. I don't care how high the other numbers get on any of the other tables. It just keeps me from going in...

After I load another database I will check and see if this starts out at 1 without running the reset query. If it doesn't go back to one I'll try that and see if that does it. But I think it's just as easy to run the reset query

Do you mean delete the relationship before appending data?