Search results

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

I had time to run this code today. I immediately got the message box, "Me.FilterOn was not enabled/true", even though I should have data for the report.

Thank you. I will take a look at that maybe this weekend. I'm headed off to my daughter's later so I've got to get some stuff done today but thank you for noticing that

After trial and error. I got it to work exactly as I wanted. When the subform populates with the records based off the DemoClientID on the main form, it opens a report with that information to print. I wanted to share my results for others that need to do this. Private Sub...

I have a form that filters data by the DemoClientID to the subform. When a Client is selected on the form it brings up all the records for that Client in the subform. I have created a report that contains all the data I want to display and I have created a button to open that report. I want the...

I don't think it was said I would get an error. I found a way around it. Thanks