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.

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

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.

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.

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.

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

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.

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

How would I code in excel marco in order to read the value of a form (Form!Ult!DY) in access?

I have about 10 pivot tables in Excel application. Only one pivot table does not refresh after I run the macro. However, if I put a stop in the marco, and run it manually...all pivot tables get updated. I've tried many times but I could not figure it out how this is possible. All the field...

My pivot table does not refresh after I run the macro. However, if I put a stop in the marco, and run it manually..the pivot table get updated. I've tried many times but I could not figure it out how this is possible. ...... Sheets("Sheet1").select...

I have a table(TrFac) in access with 20 cols as F1, F2...., F20 and some ID fields. The # of rows (Range("TrCounter") is varied by state. I create a listbox in userform so that the user can input their changes for these fields. Range("TrChck").value is the total number of Fs changed by the...

I get this error "Run-time Error 2950 Reserved Error" when I try to use Dlookup to retrieve a value from a table in access. ------- Set dbl = OpenDatabase(GetDataBase()) wsTable.range("A1") = DLookup("AYRQ", "[State and Year Table]") -------- It works fine if I use the following: STR = "...