Search results

Thanks John for the quick reply. This looks OK but is a bit complicated for me also I need to be able to select the xls to append to table. Can't this be done with some import vba code and just add records to table. Evan

Thanks John for the quick reply. This looks OK but is a bit complicated for me also I need to be able to select the xls to append to table. Can't this be done with some import vba code and just add records to table. Evan

Hi All I have searched the forums and can not find anything that suits my needs. What these are as follows. I need a command button on a form that will allow me to chose an .xls from a directory and add to the existing data in an access .mdb table to an access mdb file. I am using access...

Hi All Hope you had a great festive season. I have searched the web for an answer to my problem to no avail so I hope someone out there can help. My problem is that I have created a query for my register table and have set in the criteria for the reg_no field the following code. Like "*"...

Thanks for the reply I will try it. But how do I word the expression to allow user input with the 4 digit name required. Evan

Hi All My problem is this. I have a Table that I need to query. The field I need to query by is a combination of two fields in another table selected at time of data input. It contains job number and model type. I need to query it by job number only and I need user input to select the job...