Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cogivina2004

    Error: 429 ActiveX component can not create object

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

    Line count from the dropdown box in Form

    Thanks, I did not realize it is based 0.
  3. Cogivina2004

    Line count from the dropdown box in Form

    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 =...
  4. Cogivina2004

    Trying to save excel gives msg about RESUME.XLS

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

    Trying to save excel gives msg about RESUME.XLS

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

    Trying to save excel gives msg about RESUME.XLS

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

    Trying to save excel gives msg about RESUME.XLS

    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,
  8. Cogivina2004

    Link table from a spreadsheet in Excel to access

    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?
  9. Cogivina2004

    Link table from a spreadsheet in Excel to 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, ""
  10. Cogivina2004

    Link table from a spreadsheet in Excel to access

    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, ""...
  11. Cogivina2004

    Link table from a spreadsheet in Excel to access

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

    Copy & PasteSpecial in VBA

    Thanks
  13. Cogivina2004

    Copy & PasteSpecial in VBA

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

    How to close Access from Excel?

    That's it. Thanks.
  15. Cogivina2004

    How to close Access from Excel?

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

    Can I run a macro or query in Access from Excel?

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

    Can I run a macro or query in Access from Excel?

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

    How to duplicate a table in access

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

    How to duplicate a table in access

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

    How can I get the value from a form in Access to Excel?

    We can always count on you. Thanks, PH.

Part and Inventory Search

Back
Top