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

Many thanks that worked a treat Regards Rob:)

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

Thanks for your response "I'd test the account number table every time a new account number is added. When it reaches some level, trigger the email". any ideas on the script you could use to carry this out?

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

Thanks col for your response Where should i put this condition? Thanks Rob

Good idea but no date ranges any other thoughts? Regards ROb

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

Not sure if anyone is interested but after playing around i have found the solution Schedule 2 date: Mid([scheduled date],6,2) & "/" & Mid([scheduled date],4,2) & "/" & Mid([scheduled date],2,2) Thanks to those of you who have looked at this Post Wonderer

Okay i have sorted it so i can have Mid([scheduled date],2,7) this gives 021001 How with out creating 4 colums in a query then concatinating the collums can i get round this????

102 no its not a typo is the data as comes out of an AS400 database: 102 = 2002 seems strange i know but that's why i have been having problems with it. I really want to use a substring but not sure what the function is in Access normally in Business Objects i would use: =SubStr(<Date> ,1 ,2)...

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

Absolutly Excellent that's really great It works really well.. Although one little change i would like to make which is that in the the short code code be like this 7878 787895 Obviously this would this duplicate the result in the join if say table B had 78789568 Thanks again for your...

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