Search results
-
B
Count number of columns in a table
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...- Bart2013
- Thread
- Replies: 3
- Forum: Modules & VBA
-
B
Questionnaire result (Record to row)
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...- Bart2013
- Thread
- Replies: 10
- Forum: Modules & VBA
-
B
Split string in to multiple records
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...- Bart2013
- Thread
- Replies: 9
- Forum: Modules & VBA