Jim - thanks for responding. My source data file
1. source file does have the first row as column headings
2. However there is not 100% match between the source file and the Database. A couple of columns in the database table are to be populated thru another update query. IS this the problem... does there need to be a 100% match between source and destination ????? i thought or assumed that any column headings present in the...
msbs48
Last Activity: Aug 1 '07, 07:14 PM
Joined: Oct 10 '06
Location:
-
Problem with TransferText
Hi All very new to Access... having a problem with TransferText
I am getting the message "Field 'NoName' doesn't exist in destination table" i saw a previous answer to this but it does not seem to apply
here is my code
DoCmd.TransferT ext acImportDelim, , "dbo_CUST_GS_PL ", TargetDir + aFileSpec, -1
here is a snipet from the source file it is a csv file( i Know it is not... -
Answer
I found out about the attached label... so i was able to change the text
this is access 2003
the chk box came from the tool box... but at run time the box does NOT flip from chk to uncheck ??? almost as if it were disabled...Leave a comment:
-
A stupid Question from a 1st day Access Programmer chkbox
chkbox
1. i pasted in on the form.. there does not seem to be a caption property.. i saw a couple of examples setting the caption in the from load.. The methods/Events window in the code does not show a caption property
2. when i ran the form. i could not check the check box
help !!
thanks
ben
No activity results to display
Leave a comment: