Recent content by drewdrewdrew

Hi All, I want to lock down and unlock the full menu based on a password.. For instance upon load of the database I would like it stripped down when a general user logs in... but if a admin logins in then they get all menus... so based on the user type will dictate the menus...

hey mate.... all good, I understand you offer plenty of advice across many topics. the combobox - Me.cboQuestionList is populated from an array list, passed from a previous form. I have this working fine. with this form, if you remember I have a gumpy way of passing the...

So finally got a chance to get back into it... I have the code below working on the next button. Private Sub btnNextQuestion_Click() Dim rst As DAO.Recordset Set rst = Me.RecordsetClone Dim str6 As Integer ' Question ID from cboQuestionList Dim str7 As Integer ' Test Card ID Dim str8 As...

more than putting more bandaids... I am rebuilding the dataflow to adapt all that we have discussed... and a few things I have learnt since starting the project. I will fire them questions soon.

in order to accommodate for my mess of a form, applying just the filter to it wont work in the first instance (however not discarding). In how the form works I pass the question_id from the question_list (array combobox) to a temp form which merely opens/closes .... passing those integer back to...

thanks vbaInet... I will progress with that recommendation and also look into the dictionary option. just cant get the above combobox to stay on the selected question. Am I to believe my next button relies on the combobox box having the question selected to provide a reference point to go +...

slowly slowly piecing this together.... from the below list how would I select the record that a user selected..? right now it lists all the questions I want in the array however when a question is selected and the person clicks a command button associated with it... the combobox just defaults...

all the information passed is from initial SQL queries based on a user id. so information that I currently retain in the textboxes (which are session based) are: question_id (current question id) question_type (type of question) testcard_id (testcard linked to question) array_list...

on a side note.. is it better to pass all the variables to global variable and change them when needed vice putting all the values into hidden textboxes? or is there another way to handle variable/values passed from one form to another? cheers

what code would be in the btn_next_OnClick() command be.. I am understanding how to lock on the current question_id from the array... I still cant visualise the "next" button..... in my mind I thought it would be something like .next or +1... but obviously well above me skill wise

from this ... where were you moving to once this was working without error?

Typename : Long

So am I passing the full array from the first form as a string ? eg "3,4,5,6,7,8" After the string is dissected with strArray = Split(strArrayValue, ",") convert to integer? or pass the whole array as integer?

apologies for the lack of finesse with the whole setup, I approached it wrong in where I was looking at fine tuning these little niggly field type things at the end vice doing on initial plan which was rushed. It is not a majorly complex solution required. I have updated all the number...

yeah I saw that.... I have pm'ed you the link and brief flow of how it works.