Search results

Can you expand on this please

Update query doesn't work, but copying and pasting did the trick, Thanks

Thanks, I’ll give it a try. Do you make a back up of the table or the db? The reason I ask is because I run and action query to update pricing all the time and don’t make a backup.

Yes, Thanks Again Pat!

Ahh..yes I didn't think about putting it in that. Thank you

In the orders table I have three fields, OrderID, OrderNumber, and QuoteNumber. QuoteNumber was just added and is empty for all 200 records. I want to copy the OrderNumber Field to the QuoteNumber Field

You are correct, I have edited my original post - it was bad DB design, I want to fix it but need to keep original orders in tack. I just need to do this update query one time. I need to copy the order number to the quote number field for the current records, then I will delete the update query...

I have a DB that takes a quote number and turns it into an order using the same Quote number as the order number. I have added a quote number field to the order table and need to copy all of the current order numbers to the new field in the same table. I can't seem to get the update query to...

The front end is on the user's desktop, they just click it and it should open the front end located on the physical drive and connect to the BE on the server.

So how do I put that into the linked table manager, I don't see where I can put the UNC into the linked table manager.

Worked like a charm Thanks!

Both english access 2016 What gets me is my intensive app works in both places but not the smaller one, they do share a BE though.

Looking further, I am getting "your network access was interrupted, re-open the database and try again" One thing I forgot to mention is that I am sharing the back end with two different applications, the job tracking app and the plant management app. I am not sure if that is okay or not.

I have my app completed, it's in the format DB, I have full menus disabled and unchecked show navigation. When I open the FE from my home computer and connect to the BE on my server at work everything works as it should. When I get to work and open the FE on workstation and try to connect to the...

Both my plant management db and my time tracking db are coming along nicely thanks to guys like you. Thanks to all that help us part timers work through these things, we couldn’t do it without you.

Thanks again!

All I did was saveas accde. It didn’t work. Then I compiled the project and it worked.

I have a question, does the location on the end users workstation have to be added to the trusted sites and if so how do you do that if they use runtime version. Some are and some will use accde

I think I had some empty procedures. From my research that can cause and issue.

It is working now. I thought access would compile all the modules when it created the accde file I compiled everything in the db and it is working. Thank you DBGuy!