Recent content by antonyx

hi gemma, i have implemented the registry changes on the article link you provided and they have made dramatic differences. one form which previously took 20+ seconds to load now loads fully in 3 seconds.. it is wonderful news. thank you so much. those adjustments really were crucial

that is very interesting, maybe i am not giving my database enough credit and the slowdown issues are actually os/network based let me have a look through this and see what i can do..

Hi gemma, the actual backend file is only 14.5mb at the moment (is that too big for a db with only 20-30 thousand records?), The database is not too bad in terms of normalisation. I would say it is atleast 75% normalised but a big issue is repetitive data as mentioned in my previous post. and...

hi, thanks for the response.. i have compacted and repaired the backend.. still the same issue is there.. with regards to normalizing the db that could be a problem.. mainly because of all the data that is already there. in two months we are changing our system all together so a huge re-design...

Hello all, I have a problem with my database which I foresaw 2 years ago.. Here is my situation, I have 3 terminals in my office: MAIN (vista ultimate) SECONDARY1 (xp professional) SECONDARY2 (xp professional) I have a microsoft access 2003 database which has been split using the traditional...

hi, that is great, very straightforward. what i would prefer however is if any fields get changed (or attempt to be changed) a message alert appears. i know the format for creating a message alert, but what event would it be under.. is there a form wide on change (ie if anything on the form...

so what code should i place in the Form's OnCurrent event? does it allow you to select something or would i need to hard write the code, sorry i cant try, i dont have access to the database for the next hour or two

hello everyone, it has been a while, hope you are all keeping well and sticking to your new year's resolutions (get your ass down the gym!) i want to lock all records in my job table that have a date value (in my JobDate field) before 2009 (ie 2008, 2007. 2006 etc), i want them to be view...

hi there.. i was just using this as an example.. i will most definately normalise the data. i just wanted some info as to if and how a date record could be linked to outlook?

hi, i have a database with a single table.. DRIVER TABLE the driver table has several fields such as Insurance No. Insurance Start Date Insurance End Date MOT No. MOT Start Date MOT End Date etc.. there are about 50 drivers in the database. i want my outlook calendar to notify me when any...

for the moment i have just pasted the excel values into a separate table and made a query from that.. it appears my first request is no longer needed.

i have a column of reference numbers in an excel spreadsheet and i want to use them as the records in a report. i can set up the query using the fields i want (and the report) but how can i set the query to use the spreadsheet values?

hi, is there a quick way to allow a single database file to be opened and used by two different computers (over a basic windows network) without splitting the fe and be? quick solution needed (short term) thanks

great, thanks a lot

hi that is great, i used redneckgeek's method and it is working (i dont need the passenger name and i havent included the passenger table in the query). here is my sql at the moment. SELECT fkPassengerID FROM tblJob GROUP BY fkPassengerID ORDER BY COUNT(JobRef) DESC the query produces a...