Search results for query: *

These two fields will get data from another table later.

Thanks! I created a new database and created a new importing specification, I can manually import the data with this newly-created specification, it worked fine. but when I used the specification in my VBA codes, it's still not working. Strange! By the way, I added two more fields at the end in...

In my VBA codes I used the saved specification to import text file which worked fine, but after I edited specification manually, it doesn't import data into Access database any more. Could you please tell me how to fix the problem? Thanks in advance!

Wonderful explanation, George! Thanks!

Thanks again! Have a great holiday!

Thank you so much---It worked! One thing I don't understand is your statement line4 From Table1, if skipping this line, it didn't work. How come?

I have two tables (table1 and table2). Both have common fields such as LName, FName and ssn. LName and FName in table1 are blank. Now I need to insert FName and LName from Table2 into Table1 (where table1.ssn=table2.ssn). How can I accomplish this? Thank you in advance

Thanks for pointing me to the right direction. Happy holidays to you all...

I tried your code(has to open the form first). I got a msg saying Can't go to the specific record..

I have a form that is linked to a query. The query is created based on the tables which are linked to SQL server. I have set the form’s data entry property to true. But somehow, when the form opens, it is still filled with the data. I have tried: Docmd.openform “formName”,,,, acformAdd, and it...

I have encounter 2 problems while doing the mail merge. 1. when the doc opens from Access form, it only contains ONE record from my user's machine(should be more records showing on the different pages). 2. If the date filed is blank in the source table, the doc will show...

I found a way out. The textbox is still bounded to the field. Instead of using iif() function, I did the following On the form_Load event If IsNull(Me.dtDate) Then Me.dtDate = Date End If

I tried all the tricks, it just refused to work. Thanks to you all!

I did it like this---iif(NZ([dtDate]), Now(),[dtDate]) but it doesn't work? Thanks!

Both are not working, Thanks anyway!

I have a field called dtDate in the table, when there's no dates in the field at all, it shows a blank on the form. I'd rather to assign a value to it, as below, but it doesn't work. Can you help me with this? IIf([dtDate] is null,Now(),[dtDate]) Thanks!

Perfect! Both worked! Thank you so much! But I might have to give up using dlookup(), because it only shows one record at a time.

You're always right, PHV. I should have used the keyword like. Thank you so much.

I tried to find records by using last 4 digits of ssn in dlookup() function, but somehow it didn't work. Can I use the function for partial searching? Thanks for your advice! strLName = DLookup("lname", "MyTable", "[SSN] ='" & "*" & Forms![FindForm]![txtPartialSSN] & "'") If IsNull(strLName)...

Thanks, Remou! It worked I skipped o in order to leave it blank when its value is N