Search results

hmmm... ok that's an interesting point. thanks - I'll re-consider the approach Scube

Hi All Apologies, my access is more query based that VBA - but I'm trying to change that! I have a yes/no box in a table that I wish to perform an 'IF' transaction around but for the life of me can't work out how to access it. e.g., I 'd like code to do somethig like: If tbl_alpha.yesBox =...

Hi Guys my database is essentially a questionnaire of around 200 questions. I'm trying to add a 'light' version to it. I've added a 'include in light verion' tick-box to all the questions and a 'light analysis' tick box on the registration page. The questions are all genertated via queries...

Hi All I need to be able to import a table (tbl1A) from database A to a table (tbl2B) in database B. The problem is that database A and B are different versions of the same database - and therefore the tables are the same, just with different data. I need to update the data in tbl2B with the...

knocking back the problems Hi To solve the not populating problem you need to populate the row source control at runtime something like: Me.cbo_importance.RowSource = "XL_TEST" articulating the problems seems to be helping - hope it helps someone else too! Thanks Scube

Update Afraid my glee at getting the combo box to populate was premature. Unfortunatly what happens now is that the combo box doe not update date when a new record is cycled through the form. The form displays one record at a time and you cycle through them using the habitual grey cursor...

Problem Solved! Hi All *****EDIT THIS ONLY SOLVED ONE PART OF THE PROBLEM - PLEASE SEE BELOW thanks to those who looked. The problem was in the SQL query it was looking for two return field where I only had one should have read strSQL1 = "SELECT tbl_importanceLevels.importanceLevel...

Hi All I've done a search on historical posts and have not found a releveant thread. Apologies if there is one - my search criteria must be off. I'm updating a combo box using the results of previous data - don't believe cascading boxes is the answer. The code below works in the sense that...