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

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

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...

I have to export an attachment from outlook e-mail to a folder on my drive. How could I accomplish it. I like this to be done automatically everynight. The attachment file name and name of the sender would stay the same. Thanks a lot in advance. J

I have to export an attachment from outlook e-mail to a folder on my drive. How could I accomplish it. I like this to be done automatically everynight. The attachment file name and name of the sender would stay the same. Thanks a lot in advance. J

How could I select all items in a list box automatically by using the "Select All" command button. Thanks in advance J

I have a table that I make. But I like to change the field size of a particular field to Double after my table is made. I also like to change the format to Fixed and Decimal Places to 1. How Could I do this in VBA. Thanks in advance for your help. J

I am using a recordset in my code and I filter on it using: rst.Filter = ............... How could I remove the filter later in my VBA code. Thanks for your help in advance. J

I like to automatically import text file into an access table without going through the manual process. I also need to select advance spec when I do the import process automatically. How could I do it using VBA. Thanks for your help in advance. J

I have a text file that is not comma delimited and it has bunch of fields in it. When I try to export it into access it puts data for all the fields under one field "Field1" ... I guess bcz the file is not comma delimited. How could I import it into access corectly. Thanks for help in advance. J

I have a table that has two fields: LName and FName I am trying to concatenate both fileds like: Name: [FName] & [FName] in a query. However, the expression Name comes back with spaces like Heather Brooks How could I get rid of the spaces so that my query shows me Heather Brooks...