Recent content by gandhawk

I have tested running the front end of my application from my synchronized OneDrive on my computer. The back end is on the server. Does anyone know if there are any problems doing this?

I love the use of graphs in my reports. However I like my reports to be functional where can drill down to lower level of detail based a clicked field. For example a client summary report I would drill down to the client details by clicking on the client name and even drill down more base on...

I created a module and added thew code below. (got it from one of the MVP's) I had to create a table named "audit" with the following fields EditRecordId autonumber editdate date/time User short text recordid number sourcedata short text sourcefield short text...

Use the macro command "Closewindow" command. Then you name the query

How about adding a close query(s) command before you exit the macro

I would not strore calculated fields in your table. Do what Minty said and calculate in the query