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

    Application.Match issue in Access VBA Module

    PHV - Thank you for your help! Do you know what the correct code would be to transform this line that works in Excel to Access VBA? Columns("C:C").Select Selection.Cut Columns("B:B").Select Selection.Insert Shift:=xlToRight I currently have the following but it does not work...
  2. BigFish69

    Application.Match issue in Access VBA Module

    PH - I see the appropriate values in the first two lines for X and Y. The values are 8 and 12. But something must not quite be right in the 3rd line as it produces an application or object defined error. I have both x and y dim as long, is this what I should be using for the dim? Thanks for...
  3. BigFish69

    Application.Match issue in Access VBA Module

    The code below works fine in a XL VBA module but when I add it to my Access VBA module it produces an error. I suspect it needs to be modified but am unsure what to change. Can someone point me in the right direction? x = objWorkbook.Worksheets(lngCount).Application.Match("[All Markets]"...
  4. BigFish69

    Import Multiple Workbooks & Worksheets based on Worksheets Name

    I just noticed the table name was actually "ChildPT" and "ChildST" instead of "childPT" and "childST". When I changed the lower case "c" to "C" all worked perfectly! My mistake! Thanks guys for all your AWESOME support!
  5. BigFish69

    Import Multiple Workbooks & Worksheets based on Worksheets Name

    I guess it can't be done! I'll have to link in all the worksheet names to the db and create a union query to pull them all together to make my child table. Thanks for trying!!
  6. BigFish69

    Import Multiple Workbooks & Worksheets based on Worksheets Name

    Sorry Guys! Had a water pipe bust on me last night. The code does run but I can't seem to get this piece to work correctly. I have a couple of worksheets in the workbook called "childPT" and "childST" but they are not being added to the worksheets collection. No matter what the worksheet is...
  7. BigFish69

    Import Multiple Workbooks & Worksheets based on Worksheets Name

    PHV - I replaced the line with they one you posted and still get the object not supported message, it compile in the module fine. Any thoughts?
  8. BigFish69

    Import Multiple Workbooks & Worksheets based on Worksheets Name

    I changed the worksheet name to a known name and reference it and still get the error message. Any ideas?
  9. BigFish69

    Import Multiple Workbooks & Worksheets based on Worksheets Name

    I am trying to modify the following code from "Ken's Examples for Importing from EXCEL Workbook Files" in an Access 2007 database. I need to cycle thru all the workbooks in c:\temp , open them and determine if any worksheets are name *child* "look for the word child which will have chars before...

Part and Inventory Search

Back
Top