Search results for query: *

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...

Sorted it. For some reason it had added some deny policies on the share in the group policy. I removed them and once the AD had replicated itself, I could run the executables. Thanks anyway

We are setting up two new servers on a new domain. We have svr1 that was the 1st DC in the domain and has a share on the hard disk called support. The 2nd server svr2 is the 2nd DC and again appeared to be no immediate problems. However; when we create a mapped drive or browse the network to the...

I have coding that updates the Outlook calendar from an Access form and works fine in outlook 2003. In outlook 2007 it come up with the error "Object library feature not supported". I have looked at the VB references and it has changed the "Microsoft Outlook 11.0 Object Library" to "Microsoft...

Sorted - It was the key!!

I have set up a linked table to an table stored on our SQL Database via ODBC. I can open the table and edit the data directly in the table no problem. I then set up a query to query the linked table but cannot edit the data! Any ideas