Search results for query: *

I need to extend my ODBC timeout for connections due to extended queries. Can I do that from Access?

I am looking for a utility similar to the upgrade wizard that will work on SQL Server 2005. The current wizard only works on SQL Server 2000.

Does anyone know of a utility to upgrade MS Access tables to SQL Server Express (2005). The built in Access utility does not work.

I am trying to create a summary table from a table in Access that is 5,000,000 records and uses 800,000,000 of disk space. When I run the make table query, I get an 'out of temporary disk space' error message. Is there a way to increase my temporary disk space to successfully complete the build?

Try using this insted of your current repaint command: docmd.RepaintObject acForm "MyForm

Isn't it also included with Access 2003 extensions in the MSDN CD's?

I have been hunting through MSDN trying to find the Excel properties and methods to use with VBA. I can do formulas and values but would also like to do the following: Set Column width Set Row height Set Font Set Background color Set Borders See nothing much. :)

What are you trying to accomplish?

If it is a timed function why not just schedule the next start up?

...Object, XL As Object Dim DB Dim RS Dim X X = 0 Set DB = CurrentDb() Set RS = DB.OpenRecordset("Select * from qrySelectReqReportOpen_ALL ORDER BY [Area Leader], [Req#]", dbOpenDynaset, dbReadOnly) Set XL = CreateObject("Excel.Application")...

Just use the shell command.

...Object, XL As Object Dim DB Dim RS Dim X X = 0 Set DB = CurrentDb() Set RS = DB.OpenRecordset("Select * from qrySelectReqReportOpen WHERE DIVISIONID=3 ORDER BY RECRUITORS, DEPARTMENT, POSITION", dbOpenDynaset, dbReadOnly) Set XL =...

Every piece helps. The null character will probably work with Outlook 2000, but I can't test it. Thanks

I am running Outlook 2003. :P That being said I did find a solution Set myItem = MyOlApp.CreateItem(olMailItem) myItem.To = TMail myItem.Subject = "Weekly Open Requisition Report" myItem.Body = "Attached is your open requisition report. Please note this includes all lines of...

Yeah that makes me feel better...... Now how about a fix MS?

My biggest problem is that I need a message and the attachment to go out. Is there a solution for that? Do you think doing body ahead of attachment would work? is there a way to force text mode when generating the email.

When the email arrives the attachment cannot be opened. It says the file format is wrong for this (Excel) application.

Hvae you tried using a global variable or linking your reports sql command to the form itself?

I am having difficulty with this one module. It is supposed to attach a spreadsheet and then allow the user to finish filling out the Outlook form before sending it. The problem seems to be that the attachment is arriving corrupted. Does anyone have any answers? Private Sub Form_Open(Cancel...

That was perfect. Thank You