Search results

  1. C

    linking combo box to tab controls

    I'm not usually slow but I'm not sure if I understood the question. My combo box has only one column - just the values. Are you referring to the record in my table (i.e. the columns names)? If so, they are too many to list. There are more than 30 columns and each one has a long name...
  2. C

    linking combo box to tab controls

    sorry didn't understand the question. Are you referring to the patient ID fields or the "Condition" field? Condition combo box contains: Pregnant, PreTerm Labour, Pre Eclampsia, On Route delivery and PPH. I want the user's selection (in Condition), drive which Tab page comes to the fore, or...
  3. C

    linking combo box to tab controls

    The condition is a field on the Obstetrics table. It is also a control on my form. When I select from the value list, I want the corresponding Tab form to open up. As for the subform, I clicked it on the tab page but it covered what was already on it . When I pasted the other controls on it...
  4. C

    linking combo box to tab controls

    so actually it is Obstetrics.[Condition] not Table.[Condition]. I'll try and attach it again
  5. C

    linking combo box to tab controls

    no my table is called Obstetrics. I have tried to attach a screen shot. my project is to create a database with Access that will contain historical data which will be analysed from time to time. When the user clicks on condition field on the form, I want the corresponding tab to be 'opened'.
  6. C

    linking combo box to tab controls

    Hi vbaInet. Thanks for your feedback. I have only one Table. My combo box has Table.[condition] as its row source. So in the drop down menu, the values are Pregnant, PreTerm Labour, Pre Eclampsia, On Route delivery and PPH. I tried to add a subform (with "raised" effect) to the Tab but it...
  7. C

    linking combo box to tab controls

    Hi there, sorry my VB skills are not strong and I need some help on how to go about this. :confused: On my data entry Form, I have a Combo Box [Condition] and five tab controls. Each tab has as many as 10 controls on it. The purpose of the Form is to populate a table. My questions are: 1) Do I...
  8. C

    Grouping controls - Forms

    Hiya, thanks much to everyone who's responded to my posts thus far. In my detail section, I have five tab forms and a Combo Box [Condition] with five values. [Condition] is bound to a field in my table. I want the value of [condition] to bring up (or load...?) the corresponding tab form. I...
  9. C

    Grouping controls - Forms

    yes I was but tis good now. Thanks.
  10. C

    Grouping controls - Forms

    oops! never mind, I figured it out. It had opened as read-only.
  11. C

    Grouping controls - Forms

    Hi guys, I need to change the data type for some columns in my table from Yes/No to Text but it is locked. Not sure how that happened :confused: I changed it for some of the others but these won't budge. I have removed any reference to these columns in the associated Form. Could someone please...
  12. C

    Grouping controls - Forms

    My skills are a little above beginner. I guess the Tab Control will make the Form look more classy but some of the groups have only two controls on them. however many thanks for your tips pr2-Eugin & Cotty42:)
  13. C

    Grouping controls - Forms

    Hello, I am creating a Form on which I have many controls. I need to place them in groups, on the Form. I can't find the control command to do that. Could someone please advise me on what to do please? Thanks much in advance
  14. C

    Table Validation is not working

    Roger that. I figured as much:) I'm very glad I discovered this group. Many thanks SparklyPrincess6969 and vbaInet
  15. C

    Table Validation is not working

    Okay. I'll look it up when I get to the Forms. Many thanks!
  16. C

    Table Validation is not working

    Hey BlueIshDan, thanks for your input. Are you referring to controls on the Form or the table?
  17. C

    Table Validation is not working

    I haven't gotten to creating the Forms yet so I guess I'll just trudge on until then. Many thanks for your advise.
  18. C

    Table Validation is not working

    Hi, thank you for responding. Prior to now, I only did simple queries. I am now wading into the programming pool so I apologise for my ignorance. Although it is still in the early stages of DB creation, I want to put this control directly in the table i.e. when I select a value from my list in...
  19. C

    Table Validation is not working

    aargh! help me please. I am creating a database with Access 2010. The table in question has as many as 20 columns but the List box selection in Col1 should allow ONLY certain columns to be updated and the other columns disabled for the same row. I am going round and round and have managed to...
  20. C

    Hi from Canada

    Hello Everyone:), I'm Cindy and from Canada. My Access level of expertise is between beginner and intermediate. However I want to learn more! I have read some of the threads in this forum and am excited to be a part of the team. Regards
Back
Top Bottom