Search results

HI dbDamo, it's working now, Thank you so much for your excellent support. This was my first time adding a topic (question) on this website. I'll definitely look more often and use this website. And I'll keep in touch I think with other topics to come ;-) With regards

HI dbDamo, it's working now, Thank you so much for your excellent support. This was my first time adding a topic (question) on this website. I'll definitely look more often and use this website. And I'll keep in touch I think with other topics to come ;-) With regards

Here you go.

By the way the macro is not uploading the empty rows anymore after editing the excel spreadsheet. Thanks for that

ok, I tried again from beginning with zip file you sent to me. After deleting the spreadsheet row 56-280 and changing the file name location on the Macro and running the macro I've a message like "A Value you entered for the spreadsheettype argument is invalid" "You used the...

field Invoicenr . Macro is also uploading a lot of empty fields on both columns.

Thanks a lot but I've problem with having it working properly. First I changed the File Name location on the Macro as you said and tried out running the macro (not using the command button on the form). When I look on the Table than the data is there available but with "wrong" format. Example...

Hi DbDamo, See attached test database with one TABLE and a FORM with a Command button ( not defined yet ). Also attached an excel file. The most important part is that the values on column A on excel having Text format. This is very important to have the upload to Access also like that...

Hi DbDamo an you help me with a macro? I'm not so expert. with regards

Thanks for your replies allready. The reason I don't use the table is that because the database is using a main form with different commands. I don't want people going to the tables or queries to update or change. I see there's also a possibility to create something on visual basic which makes...

Hi, I'm a new user of MS Access and would like to have support on the following. I saw some discussion related to use FORM and update TABLE but not as what I want which is to be available to paste more than one value ( a list ) into a FORM I would like to have on a "FORM" in Acces the...