Search:

Shareing the workbook so far is working graet.Thanks to all for your help.

Is there a way for a single workbook to be open AND editable by multiple users?The workbook we have is on a network drive. When one user opens the workbook, any other user can open it, but gets the...

Named Range worked. For some reason Access converter the following from "'Region 33'" & "!A1:T900" to 'Region 33'$A1:T900. Of course Excel could not find that range.

But named rangeds worked like...

I will try this and see how it goes.

Thanks Wendell.

I am having issues trying to find the correct syntax to import data from Excel. I have the TrasnferSpreadsheet down fine. What I would like to do is give the statement a data range in the workbook. ...

This is GREAT. Thank for your help.

Is there a way to use VBA code to query Access for the version?

I would like to create an If statement that will do one thing for Access 2010 and a different thing for Acess 2003.


Thank for...

Thanks to all for your help

Can you help with the syntax for using the PDF. I had come to the conclusion that was the way to go, just having a hard time figuring out the correct syntax.


Thanks for your help.

Is there a way in Access 2010 to use the Snapshot format in the following statement?

DoCmd.SendObject acSendReport, stDocName, "Snapshot Format", ...

I have found that in Access 2003 and Access...

Exactly what I was looking for. THANK YOU

Is there a free version or maybe a student version of the .NET suite that I coould use to lean with. I have done some VB and VBA prgramming, but would like to do some learning and testing in .NET.
...

If you have both version installed on the machine, you should be able to point your 2003 database back to the correct library. If you open the code window, look in the Tools menu for References...
...

Is there a way to read files names from a given directory and all it's sub directories into a table using VBA code.

I have some code that reads a single directory and dumps the files to a table,...

Try something like mid([Description], instr(1, [Description], "(" ) +1, 10) This assumes the Invoice number is always ten characters.

Can you post the results of the Debug.Print statement?

What you are looking for the Debug.Print statement to do is show you the full SQL statement before Access trys to produce the recordset. This will allow you to double check field and table names....

The compact and repair does run correctly in 2003. The db ends up about 175 meg. I did run the compact on the db in 2010 and it took the database from 325 meg down to about 225 meg, so it seem to be...

I am getting an error when trying to compact and Repair a 200 meg database using Access 2010.

The database was created and works fine in 2003. It seems to run fine in 2010, but it will not...

I am trying to find out if there is a program other than MS Outlook that can be used to open and view the contents of a PST file created with MS Outlook.


Thanks for any help with this search.

Is there a program other than MS Outlook that can open and read the contents of an Outlook PST file?


Thanks

I have discovered that if I "Activitate" the cell, then press Enter or Tab, that converts the data in the cell tp a number.


Thanks

Is there a way to programmatically control the options in the Smart Tags.

Example: Converting a text value to a number. I can click the smart tage and select the option to convert the text value...

Copying the MSG file seems to be working. My issues with the Enterprise Vault is the size limits imposed by our administrators.


Thanks to all for your help.

PST files are being replaced withsomething called eVaults. Managed folders that are part of the the Mailbox.