Search results for query: *

I have table called "North Central Table". This table has around 30,000 records. When I try to output this table to MS Excel, I get the following error: No records limit exceeded. DoCmd.OutputTo acOutputTable, "North Central Table", acFormatXLS, "C:\Documents North Central.xls", False I know...

The code below is driving me nuts. It's a simple and used to work on my machine but now all of a suddent it's not working properly: Dim strFolderName As String strFolderName = Dir$("G:\QuoteSheets\*QuoteSheet*") If strFolderName = "" Then Exit Function End If My directory...

I have an excel file that has two tabs: i.e. two worksheets A and B. I only want to import worksheet B into excel table. How could I do that. I tried using the following command but it tries to import both sheets into the access table. DoCmd.TransferSpreadsheet acImport, , "AppendQuotes"...

How do I copy file from one location to another in VBA for Access. I have a file that resides on one paritcular folder on the network drive. I would like to move it to a different folder on the same drive. Any thoughts about the code syntax. Thanks, J

I have an excel spreadsheet (.xls). I like to convert it to (.csv) format automatically. Not sure what would be the code in Excel VBA to do so. Any ideas, thoughts would be appreciated. Thanks. J

I have a table and I would like to change its field names automatically using VBA. I know I have to use the table definition object in access but don't know how I could write the code (syntax) to do it. Any ideas/thoughts will be highly appreciated. J

thanks ..... it works

In outlook, how can I forward a particular incoming e-mail to 2 differet people automatically. Thanks a lot in advance. J

Thanks a bunch and sorry for bothering you over and over again. Comma has taken care of the above error.

I was using the worng path. Kill command would work. How ever, the command below DoCmd.TransferSpreadsheet acImport, "DummyTable", "G:\VAPA\VAPAMailFolder\" & strFolderName doesn't work. It gives me the following error: "External Table is not in the expected format" DummyTable has the...

Thanks. Yes it is now referring to the right file name. How can I delete the file using VBA after it gets imported to access. Kill FileName command doesn't seem to work. J

Pete, Thanks a lot for your quick reponse. In your code below: ****** Do Until strFolderName = "" 'import DoCmd.TransferText 'your stuff here 'get the next file strFolderName = Dir$ Loop ****** How can I kill the file after I import it. What's the VBA...

I have a folder on my C:\ drive that has bunch of excel spread sheets. I want to move through each of the spreadsheets and see if a certain portion of the name of spreasheet matches with my string criteria. If it macthes, I like to export that file into access table automatically and then I...

Is there a way my access database could get updated automatically at night without me opening up the database and hitting the update command button. I know Access has a scheduler that could do it but I don't know exactly how to use it. Thanks J

I have the VB code that could reference to my default Inbox folder: Dim ns As NameSpace Dim Inbox As MAPIFolder Dim Item As Object Dim Atmt As Attachment Dim FileName As String Dim myRecipient Set ns = GetNamespace("MAPI") Set Inbox = ns.GetDefaultFolder(olFolderInbox) I have another mailbox...

I have the VB code that could reference to my default Inbox folder: Dim ns As NameSpace Dim Inbox As MAPIFolder Dim Item As Object Dim Atmt As Attachment Dim FileName As String Dim myRecipient Set ns = GetNamespace("MAPI") Set Inbox = ns.GetDefaultFolder(olFolderInbox) I have another mailbox...

Is there a way in VBA that would open up the most recent e-mail from a particular sender in outlook. The following code works fine but it only works if I have the e-mail open (Set myItem = myOlApp.ActiveInspector.CurrentItem). ' ########## Set myOlApp = CreateObject("Outlook.Application") Set...

Thanks a bunch. Now the code works. But there is one problem. I have to open the e-mail before it running the code in order for it to work. Is there a way that an e-mail from a particular sender is opened first automatically before running the code below: Set myOlApp =...

Thanks for your help. Now I am getting the error that variable "myOlApp" is undefined: Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.ActiveInspector.CurrentItem Set myAttachments = myItem.Attachments myAttachments.Item(1).SaveAsFile "C:\My Documents\" & _...

It refers to name of the first attachment in the outlook e-mail. I get the following error everytime I try to run the sub procedure in outlook: "The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros."...