Search results

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

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

do you know how to use conditional formatting in Excel? The Access CF works in a similar way. When you say: If the Target date exceeds then that records should be coloured "Red" and if todays date equals to Date then the record should be amber and if greater than Date but less than Target Date...

It look as if you are joining the tables on far too many fields, can you not join the tables as Galaxiom suggests using indexes and add all the necessay criteria in the criteria line for all data fields, I don't see how you can speed this because there is so much criteria. Your table names...

A simple way of doing this would be to create a combo or list box and the user can select which query to run and you create 3 separate queries and run whichever is chosen. Your combo or list box values could be the same as your 3 options above. Another more complex way would be to use what...

If you know beforehand how many times you want it to run or if this can be calculated, you can use a simple For Loop with a variable as the loop counter Dim i as Integer i = hard coded number or calculated value DoCmd.OpenQuery "qryCreate_1" For i = 1 to 3 DoCmd.OpenQuery...