Recent content by Warren Van Duesbury

Sorry about that, I meant to post it in the tables forum and accidentally posted it here too.

Does the fact that I have a linked table slow an application down? With 60 concurrent Users, my app at the moment stores all collected data on the local drives and at the end of the day posts it to the main DB on the server. This is to reduce network traffic and improve the speed of the app...

Hello llyal, I have two bits of code for you to control the applications environment. Please note that this is for MSAccess 95 and later versions of access have other properties that you can/must include. The first function sets up MSAccess Properties....... Public Function...

I am trying to perform a query based on time values. The field in a table (MyTable) is called 'MyTime' and is set with the Date datatype and formatted to show "hh:nn". Each record is entered/(or appears)in half hour increments like 09:00, 09:30, 10:00, 10:30 etc. I have a form that Users enter...

The easiest way is to create an Append query to append the data into your new table. Then create a Delete query to delete the record in the original table. Save both queries in your database as qryMoveIt and qryDeleteIt (or something meaningful). Next add the following code to a button on the...