Search results

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?

After more searching I tried this and it works. Exactly what i needed. I delete the relationship to the table it is related to, run the query and recreate the relationship. ALTER TABLE [tblDemoUCAs] ALTER COLUMN [DemoUCAID] Counter (1,1)

When i load new data. I have to go in and change ID numbers in specific Queries that would not have to do. If they always start at 1, then my ID in the queries should never change.

I believe it is starting off from where i left off deleting out all the records.

Ok, then I revise my question to say start at 1.

I have a Database that I use as a Template to load new data into when setting up for other people. When I append the new data it does not start at 1. With the database empty, I have created a new ID with Auto Number in each table and I have compacted the Database. The appended Data does still...