Replies

Hi Rory

First of all, thank you for your prompt reply. I can see from your post that i am trying to over-complicate matters and understand exactly what you are getting at.

I’ve modified my code to suit (exactly as your suggestion) using an If…Then statement inserting the End If just before the Loop statement.

If the file exists, it gets copied as planned, and the code loops through to the next line in the table, but if the file does not exist, it loops but does not advance one lie putting me into an endless loop. Any ideas????????

Rory

Thanks agian, i’ve now got it working exactly as i want it. My probem was that i was not sure how to get Access to a)retrieve and b)sequence through the listbox values.

Rory,

Thanks for your help, i’ve now got it going 🙂

Now, one problem or if you like, enhancement. If a user picks 5 people to send a report to, this will send 5 separate e-mails. What i really, really want is to send one e-mail to 5 people, which means that the .To value needs to consist of all the values in lstSelected…….

Thanks for your comments Rory. Firstly, i’ve taken your advice and changed the listbox name.

Secondly, i’m OKish on For-Next loops, but how do i refer to the data in column 1 of my listbox. All i seem to be able to do is retrieve the first value?

Sorry if i’m appearing a bit dense today…… 🙂

Hi

I worked in a call centre where i imported data directly from 4 Unison diallers for analysis. Each of the four tables contained around 15,000 records, and each day i appended them to a “master” table just for backup. This continued for each quarter.

I had no problems, except for speed.

Hi Jols

Don’t know whether i can help, but i have a similar situation where i have open orders in one table, and once closed, they are moved to another table.

What i do is use two queries which run invisibly to the user. The first runs an append query (to the closed orders table) picking up the order number from the user’s form, and then i close the form, display a “record archived” message, and then run a delete query on the open table.

Hope this helps………………

Peter

Hi Roy

Thank for your advice. Between us, i got it, but it took your post to get my brain to be thinking a little wider!

Here’s what worked:

Forms!OutofHours!(“txtQuery” & strRegion & “Start”).Visible = True
Forms!OutofHours!(“txtQuery” & strRegion & “Start”).Text = Now()

For some reason, it didn’t like the Me.Controls bit, but the syntax for the field name was spot on. Cheers!!!!!

PS. Didn’t spot the .text error in the second line…..