Search results

Thanks so far, but... Hi Colin, Thanks for that but i'm already doing that and just wanted to trim the code down by a few lines. It seems strange that you can't use "BETWEEN" in VBA to find out if a value is between two others? Here's what i'm using so far... Set rstSageData =...

Hi there, this is just a quickie i'm sure. I have used "Between" to indicate if a value is between two other values in queries for ages, and i know that i can use it with "WHERE" in an SQL string, BUT When i just want to use it in an "If" statement Access doesn't want to play? If *** BETWEEN...

That's the bit i've been trying to get round. I am trying to base a listbox, on a recordset, based on a recordset. I am using Access 2000 and reckon that pen and paper can't be beat! lol Thanks Vince

Sounds goo to me Phil. I'll give that a bash! Thanks Vince

Is there anyway of using an SQL statement to build a recordset in memory and then work with it, THEN basing another SQL statement on the temporary recordset? I always seem to get the message “cannot find the query or table”. Does an SQL statement have to be based on a query/table? OR could I...

Hi there, Anyone got any good ideas for how to aim a print job at a specific printer when automating printing from within access. I want to re-direct jobs to specific printers according to what code is being run at the time, resetting back to the default printer at the end of each routine if...

Thanks for that, For a change something that looks easy! I'll give it a bash, so appologies in advance if i set off the American's strategic strike command responce, but knowing me either word will quit, or it'll be World War III :o)

Hello, Opening word and using it from within access is all well and good, but does anyone know how you then properly terminate the current word application successfully? Word always seems to be left open after i have opened it from within access. Thanks, Vince

Thank you for your effort. The problem is that if i am going to convert the current queries (which work very but very slowly) to code then i have to create one recordset from the other and then set the row source to a string based on the second recordset. It just seems to me at the moment that...

Help! I posted this problem last week without the code behind my question, so i am trying again with an example this week. I am trying to use an SQL statement that builds a recordset in memory, then perform various lookups etc to either update that recordset or build another, then use another...

Hello everyone. Just a quickie, if you happen to know the answer that is! I am creating a mail item in outlook 2000 from Access 2000 and can't seem to be able to access the "Do not archive this item" property which is available if you open the properties page for a mail item in outlook Does...

The problem that i am having is that i am trying to convert convetional access queires to code because they involve using a few "IIf" statements in each and they are so slow i might die before they finish running! Using conventional queires it is just about impossible to extract and manipulate...