Search results

only if I comment out the line in the AfterUpdate event: ' .FindFirst "[question_id] = " & Me.question_list The results are: Listbox value is : 371 Type Name: Combobox

SORRY ITS LATE HERE...bit tired the database compiles fine. With Me.question_list .AddItem Item:=CInt(rs4!question_id) & ";" & rs4!config_ID End With is where I am at after changing the integer back to string for the array. with the above still get the error...

same error with a blank database

Running access 2010.. getting the complaint now strArray = Split(strArrayValue, ",") Runtime error 13 Type mismatch I have changed all references to strArray to Integer as well

I have tried adding the Microsoft DAO 3.6 Object Library and I get "Error Loading DLL" and it doesn't stay ticked.

the field name is [question_id] and is an integer... getting runtime error 3464 - data type mismatch. The new line reads .FindFirst "[question_id] = " & Me.question_list on hover over the question_id is being passed... eg "332" is being visible in the VBA debug window.

Hi again. The listbox is just a standalone element that I put in place because I could not get the next/prev working. The goal is to use the listbox as a secondary navigation, where a user can select a question directly. Like I mentioned before the listbox as it running works and I have a...

The array of numbers is merely to group them to each Testcard. The listbox is functioning correctly. Each item in the listbox is working from the array list, and pulling the correct config_id from the table. So the form gets the correct question_id, the listbox gets the correct...

well that is just the way it was passed. The array is from a previous form that gets array of numbers from another table. so further back there is a Test Card. Each TC has an array in the table. This array is the question_id number. So then it gets passed to my OP.

I have just done the query this way so I have full control of it in vba. I thought that would be the better way. IRT "I'm also struggling to understand the above. If you selected 6 why should it move to 18? I thought the record would move to 6? " This example was to show each question_id in...

The recordset extracts the information from the q_question_list table based on question_id from the array. Basically the form is a questionnaire. Does this help?

the array comes from a form that passes the full array in the format [number,number,number,number, etc] then from that array the array is broken up with: Dim strArrayValue As Variant Dim strArray() As String strArrayValue = Me.q_array_list.Value strArray = Split(strArrayValue, ",")...

hi again, yes I did... I have only started working with arrays. thanks for your responses. I am just trying to find an easy answer to my questions... lol I understand loops, but because of just moving into arrays I am having a hard time to find a solution to use both :banghead...

thanks for the reply, the above code I have made is just on the limits of what I know in access. When you mentioned: "Loop through the array and find the position of that item, save the index in a variable and use this as your start position" This is getting a bit above what I know...

Hi all, Long time follower, first time poster. I have a drama finding information that will help me with arrays and looping. I have a sql query based on an array of question_ids from a previous form. So basically I will pass the array eg 3,4,5,6,7 etc to a SQL query. This query will return...