Search results

How to write VBA to link Excel spreadsheets: A.xls, B.xls, C.xls .... n.xls to respective tables Tbl_1, Tbl_2, Tbl_3 .... Tbl_n and then create an Union Query on all this tables. The number of Excel files is a variable, so the number of linked tables are variable as well. Excel File A.xls will...

How can I create a column in a query that reflects automatically the table name? Example: Table_ABC. has fields: ID, Material, Qty. I want to create automatically a column/field in the Qy_ABC with "ID", "Material" and "QTY", and in additon into it, next to "Qty" a filed/column is called "Name"...

How can open Outlook for a new email and automatically insert auto-signature (including the logo) using VBA from Excel (Excel 2000). Thank you.

I have found an example of database which I can use in my application, but what I want to know is how I can de-select my selections. In this example, I am using the "Form3" example and want to de-select the selected items in "List10" after the button "Add items" has been pushed. Thanks.

I have a query which has 8 criteria fields, meaning that I will need 128 grid rows to build complete conditions with OR and AND functions to cover all the possible conditions from the selection criteria fields. How many query grid rows I can use without exceeding the maximum rows. I have tried...

I try to run a query from a customer table which output only double records and filter out unique single records. So, ONLY the same customers with different home addresses will appear on the query result. Thanks.

I have a Tbl_Product (4000 items) and want to run a query which exclude a list of products (223 items), I put the list as a table Tbl_Excl. How can I do this in an easy way? I am using Access 2000 and quite familiar with SQL. Thanks in advance, John

Hi, I try and need badly to save or attaching emails from Outlook, capturing at least the "From", "Sent Date", "Subject" and "Message Contents" fileds into a table in Access 2000. Could you give me some suggestions or a way to do it using VBA? Thanks in advance. John :mad:

I have sometimes ImportErrors during the import of Excel file to my Access table and using: Domd.DeleteObject acTable, "File1$_ImportErrors" to delete the errors. But if there is no error occured, I will get an error message saying that Access cannot find the Object ImportErrors and stop doing...

I have an Append Query (Qy_Ship), inserting data into a table (Tbl_Devry), the number of lines vary daily from 300 to 1000. Is someone can show me how to create a variable Progress Indicator ActiveX to see the progress of the inserting process and how the procedure has to be written in VBA as I...

I am transfering Excel files File_1, File_2, File_3 ... File_n into a table, these files have the same format but different data. Fm_Transfer has a button to do the automatic transfer with following code: Dim n As Integer Dim cntBook As String Dim vPath As String Dim vFile As String n = 1...

1) How can I capture the sheet name or spreadsheet name of an Excel file in a Access table? And how can I write a number (10) in a Excel cell (Product.xls, sheet1, range 2) "B1")from Access using a combo-box in a form? Tx

How can I delete an excel spreadsheet in C:\Folder from Access database using VBA. I am using MS Access 2000. Thanks in advance :D

Hi, Is there anyway to open my MS Access Data Entry Form through Website, so people can update the table through the Website? If yes, how can I do it? Thanks.

I am using following command to send my email using a button: DoCmd.SendObject acSendNoObject,,,[Email],,,"Subject","Message",True If the Outlook is not open at the time that I want to send the email, my database is blocked. How can I check if Outlook is open or not, and if not, open the...

On of a fields in my FORM has a control source "=Cbo_Product.Column(0)", how come that this field needs time to show its value?, how can I speed up? John

I have two tables Tbl_A and Tbl_B they have the same columns, but Tbl_A has an ActID with autonumber and Tbl_B (ActID = numeric). I have a form "Data Entry" to populate "Tbl_A", how can I do using only 1 command button: SAVED the last input data to Tbl_A and insert (append) the last input data...

I want to filter out the numbers in a text string in a query, how can I do this? Example: 12a34d36wk11 to adwk John.

How can I visualize a long text from a table (memo field) in a query?

How can I calculate what date will be (weekends and holidays excluded) looking to the future?. Example what will be the date, if I add 22nd January 2004 by 20 days (excluding Saturday, Sunday and public holidays). Let's assumed that January, 28th and February, 3rd are public holidays. Thanks, John.