Search results

Assuming username is a string then try WHERE (([Table1]![Name]='" & username & "'))" Note the single quotes which will delimit your username variable, so if user name = Kevin the 'where' clause will read: WHERE (([Table1]![Name]='Kevin')) HTH Kevin

If you are using Office 2k there are two options that I know of : 1. roll back office to pre SP2 or, 2. use a utility like 'ClickYes'. See http://www.contextmagic.com/express-clickyes/ If using office > 2k then I think you can only use 2 but i may be wrong as I'm still on 2000. NB Using...

MStCyr, thanks for the reply, I should have added in the post that the db does compact and repair and compile to an MDE, the option of copying everything to a new db is a last resort as the db has over a hundred forms, I probably need to write some code that steps through each control and its...

Greetings, I have an Access 2000 db with a intermittent recurring error message on one form. The message reads: "can't find the macro '.'" I think this may be down to having a space allocated to an event procedure on one of the forms controls, but I cannot find it. My question is two fold: 1...

I use the dateserial and datepart functions in my queries to automatically filter the records for the current year using : > DateSerial(Datepart("YYYY",date()),1,1) Using datepart to aquire the year from todays date and dateserial to create the first day of the 1st month of the current year...