Recent content by DavidWRouse

Hi, I wondered if anyone had any pointers to help me write some code to take over the mouse. I want to write an app that can control another 3rd party package and automatically do stuff. Ideally I would also like the code to take snapshots of the screen so that I can use the graphics.

Thanks, Yes I thought of that, but it's not a one off. I will be using the Options form in many macros. It just makes the inplementation more complicated every time. Although Thinking about it, I could encompas the different macro withitn the same macro, just under Different names.

Within a macro I have opened a form with buttons on for the user to selct an option. When an option have been chosen i then want to continue running the macro an act on the results. e.g. (Macro) Open Form (With Options on) [Forms]![frm_DB_DialogueBox]![DB_YN].Value = 1 StopMacro...

No I wasn't aware of that, I have just checked it out in the debugger. That might solve some of my weird things that happen. Thanks

Yes, i always save code before running it. Just incase it locks up. Although code does not need to be saved before it's run. It's like a Variable name has been stored in memory, and if I then change the type etc. I cannot provide any Code samples at the Moment. When this happens again I will...

You have forgot to put an "End If" With rst .MoveFirst Do While Not rst.EOF If .Fields("dblSupQty") = 0 Then .Delete .MoveNext End If <<<<<<<HERE Loop End With

Random Bug?, can i refresh all code I have been doing a lot of vb in the last few days and have have several weird bugs. And code doesn't work. But if i delete the routine. And re type it, It works. This is how i am declaring Vars etc at begining of my routine. Dim i, intMeterLevel As...

I have seen thos done before but cant work out how its done. I have a drop box that selects a location from a table, A report is then produced that filters for the selected location. I want the drop box to have "---ALL Locations---" as the 1st item on the drop box... 1) How do I achieve...

Thanks for the feedback. That was just the answers i was hoping to get. I will try to get hold of Access Developer

I am planning on creating a package that i plan to sell via adverts in specialist magazines. I would like to create the Package in Access and distribute it as a stand alone item to people who do not have access. 1) Is this feasable? 2)Will i have to pay MicroSoft 3)WIll i need Access Developer...

Thanks guys Will give them a look and try .

I want to add a varying number of days to a date. using DateAdd. But when it crosses Feb 29 on a leap year I want to Add Another Day. Date = 2/feb/00 + 40 days = 13 Mar 00 If it passed Feb 29 Then add extra Day. Making it 14 Mar 00 Not sure how to best test if my date has passed Feb 29...

From a date i want to caluculate what week of the year it is i.e 7 apr 03 = week 15 I cannot find a function to obtain this, Does anybody know of one, or of an easy way to program my own function

Thanks Alan, Did not think of that.

Been to MZ tools, Looks Good, Thanks will give it a go