Search results

  1. G

    Passing combo box control to procedure

    Using Filter By Form where the combo box values are held in a linked table can produce unpredictable results. Loading the values at form OnLoad means that there are less linked tables. I have a form with 90 fields of which 25 are combo box dropdown lists. I have more control this way and anyway...
  2. G

    Passing combo box control to procedure

    Sometimes you need to edit the available values in the combo box. If you have lots of combo boxes where the values are held in a table on another database back-end for instance. You would have lots of linked tables which is untidy.
  3. G

    Passing combo box control to procedure

    :)I found out this is how it should be done calling procedure Private Sub Form_Load() On Error GoTo Form_Load_Error Call PopulateCombo(cmbSex, "tblSex") Call PopulateCombo(cmbMaritalStatus, "tblMaritalStatus") Call PopulateCombo(cmbEthnicity, "tblEthnicity") ............ called procedure...
  4. G

    Passing combo box control to procedure

    On my form I have a combo box where the user can select the sex of a person. I had set the row source of the combo to a table, tblSex and this works fine. Now I want to programatically add the table entries ( simply male or female) to the row source, having set the combobox to value list. I...
  5. G

    Turn off insert subdatasheet dialog. 2007

    Hi RuralGuy Thanks for your interest. I have 4 tables. tblHousehold . tblPeople (in a household). tblGroups (some people are scheduled to attend a focus group on a particular day). tblProjectPeople links the people to the focus groups and has 2 fields, the personkey and the groupkey. I have 3...
  6. G

    Turn off insert subdatasheet dialog. 2007

    Is there any way to do this ?
  7. G

    Insert subdatsheet message 2007

    Hi all I'm redesigning my db and using 2007. I have a main form frmHousehold which has a subform frmPeople ( all the people in that household) and the subform frmPeople has a tab control in it with 7 tabs. One of the tabs has another subform on it showing e.g what type of cakes this person...
  8. G

    UNION query with WHERE clause

    Thanks for your interest in this guys. Now the UNION query works fine when I hard code it. Next step is to pass the value of the txtPersonKey on my form into the query and I'm having a whole lot of rigmarole with syntax and quotes and single quotes etc. This statement is the row source for a...
  9. G

    UNION query with WHERE clause

    Thank you for that, it was a bit vague. Union query is now sorted and all I have to do is remember how to pass back the value of the txtPersonKey in my form to the query. I find I have to work it out from first principles every time . I dont do it often enough for it to become second nature !So...
  10. G

    UNION query with WHERE clause

    I have a table including a personkey, emailaddress1 and emailaddress2. On my form I wish to have a combo box where I can select which email address to use. I would like to build a union query as the row source for the combo box. So far I have SELECT tblPeople.PersonalEmail1 FROM tblPeople...
  11. G

    Hi Thanks so much for your advice regarding my two linked tables and subforms. It worked and now...

    Hi Thanks so much for your advice regarding my two linked tables and subforms. It worked and now I can move on to the next feature . Yippee! You must be quite well organized to be able to help out like this and its much appreciated. Regards
  12. G

    Question So simple it's difficult

    I have two tables, people and households. One household can have several people living there. We cant have any person who does not have a household to belong to , i.e he or she has to have an address. My people table has four fields FirstName, LastName, personkey (autonumber unique key)...
  13. G

    Help !! Table disappeared completely

    Hi I've begun to accept that I wont get the data back. I'm puzzled though as to how it happened. None of our users has the knowledge to delete a table. The database froze though while 5 people were working in it. It seems Access is not so good at multi user.
  14. G

    Help !! Table disappeared completely

    I have a database of 7000 records. It is split into front and back end. There are 3 users. Today a table vanished completely. The filesize in Windows explorer is 1mb though a backup from a few days ago was 3mb. Has anyone had this experience before and is there anything I can do to get the table...
Top Bottom