Search results

Hi, For the life of me i can't think why my breakpoints have stopped working? I have just moved to a new piece of software at work and attempted to debug the code but the breakpoints will not pause the execution! Anyone know if this is a stupid setting hidden away somewhere? Or some code that...

Hi Guys, I've been searching for an answer for a long time, but i have a database with approx 100 forms, 100 tables (most linked to SQL Server) only a small proportion are front end tables, 50 or so queries, 20 or so modules. Anyway the problem is, is that the database is slow, to open and to...

Hi Guys, I'm having a small problem. I am trying to insert the data for the report from a table, instead of having the text already on the report, as i want to allow the user to be able to edit it on another form and thus change the content of the report. The only problem i'm having is when...

Hi Guys, Got something which has been bugging me like mad for weeks now; We have a MS Access Database on a Citrix server and a local copy is downloaded to the clients directory when they log on. When they actually double click and load the database(frontend) it loads for approx 4/5mins before...

Hi Guys, For some reason i've had a brain fart this afternoon and for the life of me can't remember how to code a is not null section into a SQL statement. "SELECT * FROM Qsel_WorkstepHours WHERE ((Qsel_WorkstepHours.ClientID)=" & ID & ") And ((Qsel_WorkstepHours.JobStart) is not null) ORDER...

Hi, I was wondering is it possible to schedule in windows somewhere to open up my syncfrontend.mdb and then run a routine that i have written inside of that mdb. The routine is a huge database syncronisation task that needs running every hour, it's all there ready to be run but just need a way...

Hi, I have recently been doing a lot of work on this area. Im able to export to where i want to and run macros through the VBA code inside of Access to edit the spreadsheets. This is ok if your making a new excel workbook/worksheet. But what im stuck on is exporting to a so called template in...