Recent content by carlp69

Thanks Remou that works fine.

The references appear to be ok. The code halts on simple lines like :- [CancelledForm] = false or Me!EmployeeID = RS!EmployeeID Like i said if i take of SP3 and go back to SP2 the code works fine.

I have a DB thats working fine on Access 2003 SP2. I have installed Access 2003 SP3 on a couple of machines and now i get the runtime error 2448. i'm sure the same problem occurs in Access 2007. Any ideas without going into details? Cheers in advance.

Yes it is referenced in this project.

Microsoft DAO 3.6 Object Library" is installed

I have a project created in Access 2003, when I try to use it in Access 2007 I get the above errors. The code is fairly simple, so I can't understand why it works fine in 2003 but not 2007. A couple of examples of the code Are :- Me!EmployeeID = RS!EmployeeID Me![CancelledForm] = False Any...

I have executed the same query from both the 2000 and the 2005 servers. the dates have the following results :- 2000 Server - 24/08/1998 2005 Server - 24/08/1998 00:00:00 Why is the 2005 server returning the time, I think this is behind the problem.

I have another VBA error "Invalid Input Parameter Values, Check th status values for details" I cannot seem to find where to set the date format in SQL 2005 Express Edition? But the query in access appears to pull the dates through in the correct format.

I have detached a datbase from an SQL 2000 Server, moved the files to a new server and attached it to a SQL 2005 Server. We have an Access 2003 Application that accesses the database, I have changed the connection to the new server but one of the forms returns the following error from the VBA...

Installed KMS on 2003 Server and activated it no problem. No errors where reported on the install and the licence state is active. On the Vista Clients an error comes up the event log "Publishing the Key Management Service (KMS) to DNS in the '<Domain Name>' domain failed.". On checked the DNS...

On Vista Machines we have a database. When I copy an updated version of the file to the local machine and execute it, it comes up with the previous version! If i run a compress and repair on the file it then loads the correct version. If I reboot the machine it then loads the correct version...

Amendment to above :- The script key may read "\\svr1\data\script.bat" OR SOMETHING SIMILAR (not exact wording!)

Had same problem, manage to sort it for us here. BEWARE OF EDITING YOUR REGISTRY, I TAKE NO RESPONSABILITY FOR ANY UNDESIRABLE RESULTS!!!! Log onto machine as Admin, run regedit, search for the mapped drive, if say Q was mapped to \\svr1\data search for svr1\data. see if any keys come up with...

We are installing a new exchange server and want to know if there is any way, either through group policy or scripts, to change the Exchange Server in the account setting of Outlook. I don't want to have to go around to each machine a change it manually! Thanks

I have a problem that if a computer gets and IP address from one DHCP server the internet works and if the address is issued from the other it doesn't, comes up with Spoofed Source Address on FB! I am trying to migrate our network from one domain to the other and shut down the old domain and...