Search results for query: *

Hi, I get this error "Error: 429 ActiveX component can not create object" in Excel when I hit the F9 key to calculate. I've checked to make sure all referneces in VBA were connected. Thanks for your help.

Thanks, I did not realize it is based 0.

I have a dropdown box in the form in access. It lists all the state names. If I select CT, my State = CT and my StateNum = 2. How do I write code to get the index of the state that I selected? Thanks 1 AL 2 CT 3 NY Sub Enter_click State = MyForm.State StateNum =...

Thanks for your quick response. I replaced objExcel.Save with objWorkbook.Save. It also works. Is it the same thing as objExcel.ActiveWorkbook.Save?

I have a button named "Update_Excel" in access. The button is set On Click called [Event Procedure]. For testing purposes, I left out all the functions. It still gives me the RESUME.xlw warning message. Thanks. Here is my codes: ------------------------------- Private Sub...

Hi, "A file named RESUME.XLW already exists, do you want to replace it?" Is there a way to stop the above message appearing even though I have the codes "DoCmd.SetWarnings False" and "Application.DisplayAlerts = wdAlertsNone " in my macro? Thanks.

A file named RESUME.XLW already exists, do you want to replace it" Is there a way to stop the message appearing even though I have the codes "DoCmd.SetWarnings False" and "Application.DisplayAlerts = wdAlertsNone " in the program? Thanks,

In the Excel MyFile.xls spreadsheets, I have several tabs (MyTable1, MyTable2,..). I'd like to use the same names in access after they are linked. Can I link multi tables within a spreadsheet in access?

How do I get the two tables from Excel linked to access? It seems like it works for the spreadsheet with only one table. DoCmd.TransferSpreadsheet acLink,8, "MyTable1", "C:\Myfile.xls", True, "" DoCmd.TransferSpreadsheet acLink,8, "MyTable2", "C:\Myfile.xls", True, ""

Thanks, SuicidEd. I have two tables, MyTable1 and MyTable2, in the spreadsheet. The link works for both but the problem is the MyTable2 link is the same as MyTable1. On MyTabl2 link, it contains all the MyTable1 value. DoCmd.TransferSpreadsheet acLink,8, "MyTable1", "C:\Myfile.xls", True, ""...

I use this code to import the table from Excel to access: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "MyTable", "C:\MyFile.xls", True How do I write code to link the MyTable to access instead? Thanks.

Thanks

I saw the following copy/paste was done in one line code in this post: Range("A1").Select Selection.Copy Range("B1").Select Selection.Paste --------------------------------- Range("A1").copy range("B1") Can it work for PasteSpecial - value? Thanks.

That's it. Thanks.

I use this code from this forum to open my access database from Excel. The macro "CombineData" is called to update its table. It works fine but the problem I have is the database does not close after it completes. When I am in access, it said the database is locked. I have to close out the...

I found the thread in: http://www.tek-tips.com/viewthread.cfm?qid=987919&page=12

My normal process is to input the data in excel and run a macro in access to update series of tables. I would like to write code to run this macro or query from excel instead. It should eliminate time to open and reopen between excel and access. Thanks.

Hi, DoCmd.CopyObject, StDocName2, acTable, StDocName1 I used this code but it did not work for me because I did not have the comma (,) between the CopyObject and StDocName2. Why don't we need the comma for the rename command? DoCmd.Rename StDocName2, acTable, StDocName1 Again, thanks for...

I would like to duplicate Table1 using the similar code below: StDocName1 = "Table1" StDocName2 = "New Table" DoCmd.Rename StDocName2, acTable, StDocName1 Thanks.

We can always count on you. Thanks, PH.