Recent content by LeeJames75

And also. If all these come back stating the machine is clean, I would suggest when running the game, turning off Norton. Providing it isn't a online game. If it is an online game, then basically the machine will be slow. Also tell your friend to get rid of AOL as that uses alot of memory...

Hi. Personal choice here is yes ok Norton is ok, however I would use the following. AVG antivirus - Free Version and schedule daily updates and checks. And then install AVG Anti Spy - Free full use for 30 days, and basic use thereon after. These found more trojans etc than Adaware and...

Also you can download TWEAKUI POWERTOY off the MS Website and it allows you to relink and repair icons. It is an excellent tool. http://download.microsoft.com/download/f/c/a/fca6767b-9ed9-45a6-b352-839afb2a2679/TweakUiPowertoySetup.exe

Someone I work with had this problem on their laptop. Laptop booted up and only displayed the background. No desktop items or the windows start bar appeared. However they could do Ctl+Alt+Del to bring up the task manager. After looking around the net for possible solutions, I decided to copy...

You have a duplicate function name in your code.

Thank you Remou for the strong advice. Before my inital posting, I read this thread702-891878 and downloaded the example, then did some more searches and found that I can create a TYPE where I can assign the fields to a new table. Whereby adding a SAVE BUTTON on the form that displayed the...

Hi there. I have 2 tables. Patient and GP. My intention is to do a QBF of a GP and when the correct record is found, I have a tick box which is checked and then click on a button to write the data to a table containing the PAtient ID and fields of the GP details, which is then shown another...

It's ok, False Alarm, The length of the fields were reset to 50 chars.

ARRGGHHHH Just upgraded to Access 2003 and this code doesn't work. Not even when the default is set to 2000

Am I right in assuming that with Access 2003. I can copy/import Databases, or individual units of tables, SQL, Macros and Forms from 97 and 2000, work on them in terms of amendments, and resave them as 97 and 2000 formats. Regards Lee James England

This bit of code has helped me alot. Now I want to expand on this. Say for example I have my records, I scroll through them and the photo's appear. I introduce some more photos in the folder I am calling them from, but in the text field I spell the name wrong. Instead of Access coming to an...

This may sound like a dum answer. But check your references. When I was doing some DAO referencing. I moved DAO Objects to P3 in the List. And it stated that all my methods were not listed. I had to leave it at P7 in the List. Lee James England

The First command button accepted fine, When I hit the 2nd Command button the program kept breaking at .Movefirst I can now run all 4 command buttons. Regards Lee James England

I Solved my problem.... I referenced the DAO.RECORDSET And set rs = CurrentDb.OpenRecordset("qry_email", dbOpenSnapshot) I also took out the MoveFirst and used While Not .EOF instead of Do While Not .EOF. The processing time is quicker, and the memory useage is alot less than previous, very...

But I am reseting the Recordset. I have a new sub command for each query. I just copy the code, change the click number and then change to the query I am using.