Annoying popup messages

[boblarson]

I'm working at it and, don't take this personal as I think you have a lot to learn, it's proving to be a challenge due to the non-standard structure.

But, hopefully I'll have something for you. I'm going to bed though, it's late here. Keep trying though, you might get it before I do.

 

[Anonymous_354]

Just to let you know, I didn't make the database. I just repair them. The original database was built in Access 97. There are no relationships in it.

 

[boblarson]

Actually, the OrdersByProject form may be corrupt. I've now received the "Network Connection May Have Been Lost" error which tends to indicate that. I received that error when I tried importing all objects into a new database and it glitched on that form.

 

[Anonymous_354]

Reason being... There is a table called POs that is linked to a server on my side. That's probably why. I'll e-mail it to you at home.

 

[Anonymous_354]

Thanks guys!

Well, I got that part figured out. You were right. The names were "Textnn." I just referenced the ones farther down and it worked just fine. Now the table the query made isn't displaying any data. I think it's just a misspelling, but I'll look into it after lunch. Thanks for all you guys' help and little response time.

 

[Anonymous_354]

Now the issue has moved!

Ok, it all works...mostly. There's a macro issue. How do you get a make-table query to run every time you use a macro?

 

[boblarson]

1. Delete the table first
2. With rare exceptions you really don't need a make table query and with what you are currently doing you should actually not really be making a table for a few records as you can use a query just like a table.
3. If a query takes a long time to run, then it would probably make sense to do it - once during the time the user has the database open but continued make table queries being run will slow things down too.
4. Also, if this is shared then one person doing it will affect others. What if you run it and just as you're running it someone else tries to do so - problem...
5. Making and deleting tables will cause your database to bloat very quickly. Compacting must be done very frequently to keep the size down, but also to avoid corruption.