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...

Not really because the frontend is held all over the place at different organisations ranging from 50 people using it to around 3/4 people using it so i wouldnt be able to request that drives are defragged for charms. As another note, i also tried to do the subdatasheet stuff that i read on...

Hi Rural guy, yes i've tried all those things, it's so annoying. The only one left to try is importing everything into a new database file and seeing if that helps at all. Thanks.

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...

Only problem with autocompact is that it can get annoying if it compacts every time you close. So as you can see from the code above that if the database exceeds a certain size then it will compact it.

strDB = "D:\RoutineBackupData.mdb" ' Create new instance of Microsoft Access. Set Appaccess = CreateObject("Access.Application") ' Open database in Microsoft Access window. Appaccess.OpenCurrentDatabase strDB 'import the two tables into the backup mdb, so that...

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...

Lol i have done exactly that since i wrote that post. For anyone else who was wondering the same thing. I simply scheduled a task in windows and then used the On_Open event of the form to trigger the routine and then at the end of the routine closed the program.

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...

Could be something as simple as references. But going from 97 to 2000 is quite a big jump and i would expect problems.

Or yeah as Vassago said there are a lot of people on this forum who would help for which ever problem you come across within VB, VBA, Access and then if your using an SQL backend you can also find help for that.

Could i ask where u are from? The company that i work for already have bespoke systems setup and the one you'd be looking for is called Asset. We provide a lot of software to the public sector and because they are bespoke it means the prices are not so high. You could have a look at Asset and...

Write a simple IIF statement on the criteria for number of fish caught =IIF(IsNull(fieldfishcaught), 0) i think you can just enter a true value, but just search for IIF statements in the help. But what you are looking for is if that field IsNull, which means if there is no value in the field...

thought about opening up a recordset and doing a recordcount on the recordset? Such a small number of rows would not really effect speed in which the routine takes to run. Just remember to close the recordset once you have finished with it.

You could possibly do it that way, but the normal is to have each member have a UserType ID (numeric) and then relate that ID to a table that has a list of all user types, then you dont have to stick to allowed and not allowed. If your program develops then you may want more than 2 user types...

Hehe, what he means mate is do your query inside of Access on the tables and data you want, and settings up the relationships etc. But then at the top click the SQL button and it will give you the source code, which u can then copy and paste into your code, sometimes with a few minor changes...

you could of just used a date variable though, seems strange to be using string? But yeah the way to format the date to english is Format(VARIABLE, "dd/mm/yyyy") as the bloke said above, read into different date formats mmm and yy etc

normalization is something that is taught in all database courses etc, its the industry standard at getting all the fields you will be using and splitting them into dependancies on one another, the steps are quite detailed and most are fairly obvious. Your database will prob be functioning...