Search results

I have a query that has its conditions feed by 4 list boxs degree of detaiul getting larger from the left to right. I requery each time a list box is activated but i seem to find that the list box remebers where it has been and and when you go to a different slection and want to leave 2 or 3 of...

List box is used to run Query however if the list box is not selected then the query uses "" ...i need it to use * or ISNOTNULL i have been trying the following but having no luck can anyone guide me in the correct way IIf(IsNull([Forms]![Menu]![List4]),"*",[Forms]![Menu]![List4]) Thanks in...

Hi All, I was hoping someone could help i have my script to trigger an e-mail but i have always used a button. However i have a table which is populated with account number however i have to enterthem in as there is no specific rule assoiated with the numebrs. When however i have used all the...

Wondering if anyone can help... I have checked the search but no joy.. I have a simple macro that opens table and selects all then delets the contense as i need to keep the table struture however this table has roughly 106,000 records i need to delet them all regularly. But get errors as i am...

I have a data extract which i need to import into a database however the date field is unregonisable i.e date = 1021121 this date format for access needs to be 21/11/2002 The data is already in a table how can i change the date? Answers on postcard......No please any help would be...

Help!!! Can any one help i am using the follwoing query to match codes which can be anything from 4-6 digits(table A) against 7 digits(Table B) There can be many 4-6 codes which one discription "South Korean Customers" i then when i select "South Korea" want to pull all digits from table B...

Hi All, Was hoping someone could help with a simple question I have two tables related bty a code however the code in table A is a varying number and so is the code in table B However Table B always has a number bigger than A For Example Table A Table B 01456 01456789...

I have used some of the previous text in past topics to create automatic e-mail linked to a table ... However i really want to include the results of the query in the message box understand theat the argument is broken by ,,,,,, for the CC BCC Subject etc but have tried but can't get the...