Search results

  1. M

    Switchboard forms where are they?

    I created a Main Switchboard form by mistake. Deleted it. Then I came to create my switchboards using Switchboard Manager, but none are the forms appear in my database window. Or anywhere? But I click on the Switchboard Manager and they appear there. but not in my forms object. Any Clues?
  2. M

    How can I get a PK in another table, based on searching ...

    How can I get a PK in another table, based on searching for it based on 2 values. By searching with 2 values you will always get only 1 record. READ BELOW FOR SITUATION My Problem on my form: The user enters 2 values, after entering the 2nd value a Unbound combo box runs a query, which...
  3. M

    Limit the contents of a list box based on what's selected in a combo box

    :confused: What I want to do is select an option from a combo box, which changes the record source of a list box also on the same form, to an appropriate query. For instance: I have a combo box with 3 options to select from Record Source: "All";"Non Members";"Members" I have made 3 separate...
  4. M

    Calculating Age, storing Age, and keeping it up-to-date

    Ok, I have a table called MAIN which includes the 2 fields DOB and AGE. So far I can calculate Age field by running this Update Query: Field: Age Table:MAIN Update to: DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd")) Is there a way to have this Query run everytime...
  5. M

    Command Buttons to dictate the status of a form?

    Is there a way to have one Command button on a form, say called UnLock, which is active (enabled + unlocked), and make everything else on the form Read Only. When You press this UnLock Command button, it makes everything on the form that was Read Only, now editable. There would be a second...
  6. M

    Combo box option determines the subform on a form?

    Does anyone know how to do this. So you have a combo box on your main form with 4 options, depending on which option you select a related subform (1 out of the 4 pre-made forms) will appear on the main form. Any advice on this would be great
  7. M

    How do u determine a subfrom, from entering data on a main form?

    On a form, how do you make it so, that when u select data from a combo box, it displays an associated subform. Quickie, but I'm still new to it, with no useful reference for learning part from here.
  8. M

    How do you do Read-Only?

    Hey all, How do you do read-only for a subform on a form? Can u do this, I don't know how to make forms alone, read only, I've swear I saw read-only forms before. Basically I'm trying to make the textbox on the subform appear as a label to go ontop of a header strip I made. The textbox's...
  9. M

    Beginner's Problem with a Membership DB

    Whats the best way of doing this. I have a table called profiles for storing the usual personal info (Name,gender,Contact Info,Etc). One of my fields is called category. The user can enter 4 outcomes from a combo box: Non-Member Student Member Member Leader Heres the problem, each category...
Back
Top Bottom