Search results

Thanks Neil, but unfortnately no luck. I'm thinking the problem is with my initial condition of IsNull([Forms]![F Search]![days for renewal]). Anyone any ideas? Thanks

Hi all, I wonder if anyone can help me? What I am trying to do is relativley simple but I am just having a problem executing the expression. I have a search form which returns the list of results in a subform, in the search form (attached), there is a field which is to bring back results for...

I have a very old paradox database (I thnk), where the designer is no longer available to contact. I have located the tables, which have a file extension of .DB However when trying to import the data files, Access comes up with the message "EXTERNAL DATA IS NOT IN THE EXPECTED FORMAT". Does...

Opening a database with Access 2000 (also created in 2000). The database has a password. After the password has been entered the following error appears: THE DATABASE .MDB NEEDS TO BE REPAIRED OR ISNT A DATABASE FILE. YOU OR ANOTHER USER MAY HAVE UNEXPECTEDLY QUIT MICROSOFT ACCESS WHILE A...

Cheers Rob I'm not really familiar with VBA and didnt want to go down that route if possible. I know there is a MsgBox action in the Macro builer. Does anyone have any ideas? Thanks

Hi All This is probably very simple, but have not yet worked it out. I have a query which takes is data from a linked table, it can take up to 2 minutes to get all of the data due to the size of the linked tables. I want to use the basic macro command to display a message box stating to the...

Perfecto!! Thanks Jatfill, much appreciated.

Within Data validation I am trying to validate data so that only multiples of a number can only be entered into a table (5,10,15,20 etc) I realise I can use the Or operator to create this as 5 or 10 or 15 etc, however this is time consuming for should the DB involve large numbers. There MUST...