Search results

Mile-o-Phile I just tried that and it threw up an error message saying that the array was already defined. Help says that you can only ReDim a dynamic array . I tried making it dynamic by substituting the Dim strRecTo(1 To 5) with Dim strRecTo(n) so that I could reset it later on but the...

Thanks mate, the code that I got it from has a sender name as well as address so i'm assuming thats where the second dimention in the array comes from. I'll clear it. Thanks for your help.... With the amount of e-mails my DB just sent out i expect i'll get a call from the MyDoom investigation...

Hi, i've written some code to automatically send out reports by e-mail (using Groupwise). Each report sends to a specific group of recipients which varies in number. The code below works but there is a problem. When defining the strRecTo variable I have to set the number of instances and that...

thanks, schoolboy error!!!

Hi, I have a form that shows data from 3 different queries using subforms. It takes the DB a few seconds to refresh each query if a user chooses a different filter criteria from the form. What I want to do is make the subforms invisible whilst they are refreshing then make them visible again...

I've had the same problem using the sendobject command twice consecutively. I thought it may be due to the Vv "tripping over" itself so i added a short pause in the code between commands and that helped. If that doesn't fix the problem completely if you're using Outlook you can create a mail...

Cool, that msg is really annoying, I didn't know how to pick up attachments using VB either so that will be handy... if you were in my office, id buy you a beer! Thanks a lot...

Yeah that's a wicked idea... unfortunately were on 2k here and it comes up with a message saying "this program is trying to send an e-mail on your behalf do you want to accept?" Still at least it would do the job, if i don't manage to sort it any other way it's a good alternative Cheers...

Yeah it could well be a windows issue, i'll keep you informed, nice one mate, Tom

IMO thanks for that, the timer is prety cool... has given me some ideas of stuff to put in my own DB. Your example doesn't get round the problem that i've got though. Your "Times Up" message pops up over the top of the timer but if I'm working in Excel etc and it goes off, i won't know about it...

Thanks IMO but that didn't work either. If i'm in another app when the reminder pops up you don't notice the Access window minimise because it is already minimised. If you are in access the focus just switches to another app. If you could dig that eg out for me it'd be much appreciated, thanks, Tom.

Thanks, But it dosn't work.

Hi, I have a reminder DB that runs on a forms timer to check to see if tasks are overdue. The problem that I have is that when a task pops up the form containing it opens but only in the access application so users don't know it's overdue unless they keep checking the reminder DB. Is there any...

Ok i'll do it that way, thanks again.

Oops I meant True- I have that in my code just typo in the post!

Sorry mate, didn't think that was important cause the loop is just... Do While Action = False Do Events Loop thanks, Tom.

Hi I've set up a global variable "Action" using a module to track whether a user has clicked on a button on a form that i'm using as a message box. I put "Dim Action As Boolean" in the declerations and defined it as False in a Public Sub. The sub contains a Do While Action = False statement...

Thanks Mile-O-Phile, I had exactly the same in my db as yours but for some reason mine spat the dummy out... In the end I copied the field containing text (that worked) changed the format to date and it worked even though if I selected a new text box from the toolbox it wouldn't work. Strange...

yeah that's what i've done but it only works with a text field not a date or numeric field, thanks, Tom.

HI, I have a form that triggers an append query to a table. The query works fine but along with the data I want a field in the table to be populated by a date on the form. For some reason the date doesn't pull through when I reference it using [Forms]![formName]!FieldName] I tried it with a...