Search results for query: *

It's possible that it was running too slowly. The dialog box asking if you want to send mail will still appear, but you shouldn't need to respond to it. The sendkeys statements should take care of it. You might want to try shortening the sleep time. If it still doesn't work, I'm afraid I'm...

If you are using Outlook 2002, you can use the "run a script option" in the rules wizard. Otherwise, you can use the NewMail event, but, according to Sue Mosher's Outlook Programming book, this is dicey. You may find an add-in or other suggestions at her website, www.slipstick.com.

Sorry, I didn't read carefully enough. The code I posted is for use without Redemption.

Try this code: 'automatically answers "yes" to the dialog security box in Outlook Set fso = CreateObject("Scripting.FileSystemObject") Set fsofile = fso.CreateTextFile("ByPass.vbs") fsofile.writeline "set fso =...

Another way would be to display a form with a listbox that has its Multiselect property set to yes. The query parameter would reference the ItemsSelected property of the listbox. I didn't try this out, but I am sure you can use either the ListIndex property or the ItemsSelected property to...

Hopefully, this will get you started. It yields the correct result, but doesn't automatically recalculate, even with the Application.Volatile statement. I tried using Application.Calculate in the SheetChange event, but hiding and unhiding columns did not make that event fire. I'm sure there's...

Set the CanShrink property of the fields that may not have data to Yes. If your report data is laid out as you described, without labels, this will work. If, however, you have labels on those rows, or other fields, the field you wish to shrink will only shrink to the height of the label and/or...

You'll find the MOS certification details here: http://www.microsoft.com/traincert/mcp/officespecialist/default.asp. Be sure to print out the exam objectives for the exams you wish to take. If you are going to take the Word and/or Excel expert level exams, print out a copy of both the core...

Can you provide a little more information about the structure and contents of the query?

Ctrl-Enter will give you a new line.

Point well taken, danvlas. A permanent date table wouldn't take up that much room anyway. mike1975, you could create the date table in Excel in a matter of minutes and export it to Access.

I think you will need another table that includes all possible order/delivery dates. Then join it to your orders table, including all records from the Date table. The date table doesn't necessarily have to be a permanent table. You could create it "on the fly" from a make-table...

The easiest way is to create an Access query in design view, then select View > SQL View. You can then modify the SQL statement, or cut and paste it into the Visual Basic Editor if you want to use it there.

I haven't done this before, so I don't have any code at hand to pass on to you, but I do know that the Value property of the Parameter object will return the value you are looking for. Check Access Help under QueryDef and/or Parameters and/or Parameter Object. HTH get you started..

Can you give a little more detail about what you are trying to accomplish? e.g., Have you established relationships between the tables? Is your form's primary purpose for data entry, to display existing records, or both?