Search results

Thanks eblieb, I am not very familiar with vba, so I don't know what to do with that line op code... How do I get the number of the count in a form or query?

Hi Guys, I am importing data from Excel into 3 different tables. I want to make sure that all columns are imported so I want to count them. Does anybody know how to do that? (Or a link to an existing thread) So not a record count, but a column count. I need a query or a msgBox that only tells...

Thanks guys! I find it really amazing what you can do with VBA. It is working perfect! Thanks for your help! Kind regards, Bart

Thanks Pat, I think I better hope for a solution in code. A few union queries and a few append queries will do the trick, but sometimes Access starts complaining that these are to complex. So I don't trust that very much... Bart

Hi all, Hopefully somebody can help me with a solution or a link to an existing threat. I get results in from a 164 question questionnaire looking like so: ID A1 A2 A3 and so on up to A164 (Answer 164) 1001 5 6 2 1002 2 1 4 I need to transfer it into an Access...

Thanks all, its working fine!

Thanks All! but sorry, this is all like Hungarian to me... I did the following: - I have made a test table called "destination" - I have made the query [ID] [FGRP] on table "source" - I have made a form which shows these fields based on this query - I have made a button on the record in the...

Thanks David, Maybe I can figure that out, but how do I get the results in an new row? Bart

Hi Guys, Can anybody help me with a script, of help to to an existing threat. I know very little about VBA so I need something to copy / paste.... Probably very simple but not for me: With a query I select the following (example) fields from a table: [ID] [FGRP] X1 5,8 (This string is in...