Search results

Hi SJ, Thanks for the solution and other suggestion, looks very goods to me. Appreciate y0our help. J

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

Hi Kevin, Thanks and appreciate your feedback. John

Hi Ken, Works fine, thanks again! :) John.

How can I insert the contents of this "txtMessageBox" into a Table (Tbl_Text) for tracking? ;)

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

Hi Ken, It works fine, thanks. Any ideas how the VBA would be if I would do it from Excel to Acces, meaning if I would create VBA in Excel and transfer the files to Access? Instead of importing the files, I export the files from Excel to Access. I just want to know for my knowledge. Thanks in...

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

Thanks for the hints!!

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

Thanks Ken, works fine ....

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.

Thanks Wayne !

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

Thanks Mile, so I assume that there is nothing I can do about it ..... :mad:

Hi Mile, Yes, the Cbo_products has a great number of records. If the value of the Cbo_Products appears on the form, the =[Cbo_Products].Column(0) takes ca. 20 seconds before it shows on the form.

Hi Pat, I solved this issue using: Docmd. runSQL "UPDATE Tbl_Customer SET [Address]=(Addr) WHERE [CustID]=[Cust_ID]" John.

Without the quotes

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