Search results

Couldn't work out where the problem was as there was no code on any of the form events. Just deleted & re-started the form and all is working fine. Thanks for the reply BL

Hi, Does anyone know how to get rid of this kind of error (see attached), because I don't know what it means & have never seen it before. It happens everytime I try to close a certain form (but only happens on this one form). any help would be appreciated.

Thanks, that did it :)

Im having a problem I have never experienced before in VB. When I start typing in code i.e. DoCmd. the text turns red (See attached image). The list of Properties/Methods also disappears (making it difficult to add code for a newbie) & every time I add a space it automatically goes back to...

What can I say? You're a Guru.....Thanks a million!

Hi, Im having a problem adding the date and time to a new record using a form. The 1st method i used was by inserting the default value set to Date() & Time() functions, this worked fine for over a year, but now on some computers on the network the following error pops up "function is not...

Hi, Im having a problem with one of my access forms, the above error is displayed only on some pc's on the network which access the same Database (all affected pc's are the older ones). The error occurs when a new record is created and access tries to add the Date & Time info for that record...

I had tried in both the Report & Page Footer, with the same result in both. Just created a sample to upload an it worked ok, so went back to original and it seems to be working fine now! Thanks for your help

It is not a calculated field & there are no other controls with the same name on the Report or Table. Thanks for your input

Hi Ken, Tried that, the same error message is produced. Thanks anyway

Hi, I am struggling to get a Textbox to calculate a total for one of my reports. Im currently using the following for the Control Source: =Sum([Amount]) It just produces "#Error" where the total should be. I have checked the data to make sure it is all the correct format & when i use the...