Search results

:D Smeghead your a star, Thank you. I just hope A2007 doesn’t throw up any more anomalies.

Brilliant!!!! With what you have told me I started to check through my DB. It would appear that all the forms I have Identified as showing blank have the fade in / fade out code in the 'On Open' event whereas the forms that work have the code in the 'On load' event. If it's not too much...

Hi Smeghead Thank for looking at this for me. The "" are just remnants from when the db was being designed, but point taken I will take care with my house keeping. The code that you pointed out is for fading forms in and out (cosmetic effect), I have this code on most of my forms and...

OK I have now stripped it down.(without linked tables:) If anyone tests this can they let me know if the 'Local Settings' form opens from the main form or if it is blank. Garry

Dave Allthought I have not checked it the criteria for the record source is identical to the working machine. If I switch the shortcut back to Office 11 it works fine, switch it back to office 12 the same form of the same db is blank!!! Dont figure?

Hi Missingling The forms are completely empty, no text boxes, labels etc Just for info the forms are designed without headers or footers. Absolutely!... I didn't check the record source but it is using the same criteria as the PC that does work. This is on my list of things for the next...

I really appreciate your help. Garry

Yep....Thats where I first started checking when I had problems. I will try to strip my db down tomorrow to post on here to see if anyone would be kind enough to test it with Access 2007 and let me know if what results they get. Thanx for posting so quick, did you see the Additional on the...

Hey All I have a problem that I hope someone can help me with. I visited a client today who is running my database (Access 2003 .mde) in a multi user environment (around 15 users). Each PC has their own FE and runs on Access 2003 runtime on XP machines. All is good. They have just added 3...

You could try replacing with You might also be interested in an alternative method I recently posted http://www.access-programmers.co.uk/forums/showthread.php?t=186183

You dont need to use code. Goto Tools> Startup> Display form/page. Set the form that you want to open in there.

If DoCmd.GoToRecord , , acNext does not work can you post your db so we can have a look and identify a solution for you.

Try using Response = acDataErrContinue I would also endorse bcds comments that you should check for next record before move.

I use vbsendmail its free but you will have to download and register the dll and drop some code into your app. http://www.freevbcode.com/ShowCode.Asp?ID=109

Works a treat even with Shift Key Bypass disabled. Garry

Hi Simon I'm not sure if this link will help you. http://www.cpearson.com/excel/KeyTest.aspx I have just found it and have only done brief tests but it seems to work (not tested with the Shift Bypass Disabled). The reason I was looking for this is that my app has a lot of startup code that I...

Have look at 'Update' query

Spike Here is an example for you to have a look at.

Spike 1. Borrelia (Lyme's) 2. HSV Type Specific Ab's 3. HTLV PCR on CSF's 4. JC/BK PCR (CSF's) 5. JC/BK PCR (Urine) 6. HBV DNA for eAg neg HCW's 7. Respiratory Serology (CFT's NOT Atypical) If you look carefully the difference between these and the ones that work are use are you are using an...

Which ones don't work?