Search results

Doesn't look like it changes anything... The table has fileds now.Should I change the column names on the access table to F1, F2, F3, etc ? that's only way it seems to be working :--/ i'd rather not

Do I just change vbYES to vnNO ? that diesn;t work. Gives me an error 'doesn't exist' (??) Should i do a table with column names Fiels1, Filed2, etc, and import into that table ? 'X pathbgc = Path & "\X.xls" DoCmd.TransferSpreadsheet acImport, , "X", pathbgc, vbNo

How to reset OnError ? Can i have a separate on OnError for each statement ? '1 pathbgc = Path & "\1.xls" DoCmd.TransferSpreadsheet acImport, , "1", pathbgc, vbYes '2 pathMXR = Path & "\2.xls" DoCmd.TransferSpreadsheet acImport, , "2", pathMXR, vbYes '3pathPHX = Path & "\3.xls"...

i also WANTED it for a while, but never got around to look for it. MAtt - which one did you end up using ?

hey Keith i am afraid i don't know how with Conditional Formatting format cell other then the one(s) you looking at. i.e. If cell (c5) = NO, i'd like cells (C3:24) to become green.

hi i am transferring spreadsheet from Excel to Access table pathbgc = Path & "\X.xls" DoCmd.TransferSpreadsheet acImport, , "tableX", pathbgc, vbYes pathbgc = Path & "\Y.xls" DoCmd.TransferSpreadsheet acImport, , "tableY", pathbgc, vbYes This works fine as long as column names in Excel...

Hey I have access query opening in excel. After it opens i would like everywher where where is says "no", to make next 2 cells BLUE. The code below is doing it, but it's taking few minutes. is there any way to speed it up ? 'shading non-matching items With...

hey All I found this thing last night -- http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb Already implented it; its very useful, and like the warning sign that changes colors :)

get a error message "the expression you entered has an invalid date value"

does such exist ?

make a combination of Recond no. and Date to be a Primary Key ?

Hey Query is referencing date from a form This is what query has <=[Forms]![Form1_MAIN_FORM]![RUN_DATE] on a form Format is Short Date, Decimal Places - Auto I've changed General Date, workde once , second time didn't...

thanks Cat works. I was already afraid that i'll have to do 10 append queries...

can't seem to be able to do so..

this is the way i am importing -- 'Maxcor pathMXR = Path & "\maxcor.xls" DoCmd.TransferSpreadsheet acImport, , "Maxcor", pathMXR, vbYes 'Phoenix pathPHX = Path & "\Phoenix.xls" DoCmd.TransferSpreadsheet acImport, , "Phoenix", pathPHX, vbYes '1 pathRAFF = Path & "\1.xls"...

Hi I am transferring 10 spreadsheets from Excel to Access when button on a form is clicked. (using TransferSpreadseet) Depending on the day entered on a form different folders are selected. There are ten tables - 1,2,3,4,5,6,7,8,9,10 question -- If spreadsheet doesn't exist for a given day, I...

thanks, unfortunately it won't let me add to your reputation again :((

I see the problem; i was doing 'export' instead of 'import' changed; now it works

I am trying to transfer the contents of CSV file to a Table it doesn't do anything..., and no error message it did work in macro; but i need the name to contain a date field, so it needs to be done through VBA

thanks ! (mm/dd/yyyy) is even better