Recent content by DavidAtWork

If it's a one-off process or very infrequent process, have you considered using SSMS and import the data into the database direct. Even if you pull it into a temp table and then write some SQL to append/transform from the temp into the destination, it will be so much quicker David

The method I've always used is to have a table of tablenames you want to link, open a recordset of the tablenames and loop through, relinking the tables using a connection string, your connection string can be defined as a constant variable. No need to worry about table definitions and any...

JHB, that solved it nicely, thank you David

JHB, I'm using Access 2003 and can only get the graph to update by going to another tab (page) first. Judging by your screen shot, you are using a more recent version of Access, am I correct?

JHB, I have created a sample DB which behaves as described. If you open the main form and then select the Graph page and use the navigation buttons to go to the next record, the graph does not update whereas the other pages do.

JHB, thank you for the interest, but posting the database is not feasible as it links to a SQL server back end at Startup. I could try to create a stand alone version but that would take some time to put together. I'll see what I can do David

I have a graph inserted on a Page on a tab control. If I am on the main Page and select the graph page, the graph shows the correct data for that record, but if I remain on the graph page and use the naivigation buttons to move to next or previous, the graph just disappears and doesn't refresh...

why don't you write a function that will delete & reconnect the back tables as it opens, build in some error trapping when the path to the backend is not available. The path can be checked before trying to reconnect. This function can be run from the Autoexec David

one other aspect, if Me.txtmsg is a label, then you need to set the caption property Me.txtmsg.Caption = "Out Of Balance" David

so on which line does the code fail Also are [COUNT 7&8] + [COUNT 9] + [L_COUNT 10] ... etc are these fields on the form because should be referenced as Me.[COUNT 7&8] + Me.[COUNT 9] + Me.[L_COUNT 10] .. etc Finally your line If Wcnt <> Wchk Then Me.txtmsg = "Out Of Balance" MsgBox...

Kobus, sorry but you'll need to post the code ( or relevant snippet) that is failing, the error message you've posted could apply to many errors David

I guess people aren't familiar with running .bat files from Access. The .bat files I have ever run has always been from the Windows task scheduler, I've never tried to run one from Access David

When you start and application from another application, are you closing and killing off the instances correctly when you close the dashboard. Check in the task manager to see if there are multiple instances of applications running. David

Rather than running this query across linked tables, have you tried importing the source tables and then running this query. Might be worth investigating to see if the time taken to import + time to run the query is > or < the current method David

looks to me like you just need to add an extra line in the code that adds a new record to the recordset i.e.after the line rs.AddNew rs!UserName = Forms!frmLogin!cmbUserName This line should appear twice, firstly in the LogDocOpen function, and also in the LogDocClose function David