Search results

Hi there, I've had a search around but can't find an adequate solution to this problem. I've set up a workgroup but when in users account it is not possible to update or create a query using the db.querydefs or db.createquerydef code. The message is as follows: I have attempted to grant...

I think that happened when he altered the display of the code. I'm pretty sure that the problem is the dates - The reason there are no # signs around the dates was that it was included in the fnDate function ie. "#" & .... and then entered as string, but I've changed this anyway now. I've...

Yeh, thanks for your time - will do that.

Tried that aswell - wouldn't that produce a type mismatch error anyway?

Tried it but didn't make a difference.

Hi there, I've gone blind looking for the syntax error in the code below. Can anyone help me spot it? Sorry if it looks messy - I haven't posted code on the site before. :) Thanks, Richard 'This is the code to ensure UK dates run through the fnDate function myDateEntered =...

It seems that restarting the computer and leaving it over the weekend has done the trick.

Hi, as you can see I'm up early trying to sort this one. I created a database on my PC (Access 2003) on one network, then converted it on my PC and transferred it via CD to another (PC and network, Access 2000). Due to problems I wanted to create a new database on the new machine and take all...

Hi there, I have been tearing my hair out with this problem aswell. I created my database on my network in 2002 then converted it to 2000 to take to a different network which all seemed fine. I have played around with the references and recreating the database etc. but the error keeps...