Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: huv123
  • Content: Threads
  • Order by date
  1. huv123

    DLookup and updating query/calculated fields

    THis is probably a simple question but I cant seem to get everything coordinated. I have a form that collects information about participant's in a study including height, weight etc. I need to automatically calculate BMI once a person has placed the information in to the form so I created a...
  2. huv123

    Printing Multiple Reports issue

    ve have seen a number of threads on this but I cant seem to get my button going. Basically the structure of my forms/database is that there is a switchboard on which there are two buttons, ones to a form called "Data Entry View" each of which has a button for each form that when clicked opens a...
  3. huv123

    CheckBox Nightmare Part 2 (referencing thread702-14)

    There you go.
  4. huv123

    Table organization

    Hi I have created a database that is meant to collect data about a study I am doing. It contains 2 main tables - 1 table regarding the staff that is working on the study and 2. Details about the participants and all their data (derived from a number of different forms/questionnaire). Initially...
  5. huv123

    Calculating duration (time) - help with if statements

    Hi - I was wondering if someone could help me I need to calculate a person's sleep duration but since we ask about "usual" sleep times there is no date component although in my case there are four possibilities 1. THey go to sleep before 12am and wakeup after 12am but before twelve pm...
  6. huv123

    Running a form from a query issues...

    Sorry I posted this in the Access Other forum but should have been posted here. Okay I set up a form whose record source is a query. When the participant attempts to open the form they are asked to produce their ID. This was done when creating the query. Under the column Participant ID, I...
  7. huv123

    Running a form from a query

    Okay I set up a form whose record source is a query. When the participant attempts to open the form they are asked to produce their ID. This was done when creating the query. Under the column Participant ID, I put the statement "Please enter the last three digits of your participant ID" under...
  8. huv123

    Checkboxes nightmare

    I am trying to build a form for a question. It asked people about preferences about which hand they use to perform during a number of tasks. Vertically are the tasks i.e. writing, using a spoon etc.. Horizontally are 2 columns (Left and Right) each of which contains two check boxes. In this...
  9. huv123

    Conditional Display of Text Box/Label in Report

    I have a database that is used by participants in my study to fill out questionnaires. I am in the midst of producing reports for each of the questionnaire. So far I have created it so that a dialog box pop-up when I click on the button to the open the report for Questionnaire 1 allowing me to...
  10. huv123

    Filtering sub-form based on combobox in main form issues

    Okay I created a database that I am going to use to collect data about a study we are doing. When a participant is added to the database on the main (Participation Details form), it automatically generates an ID and creates a record in a second table/form - a questionnaire (i.e. Athens...
  11. huv123

    Search Sting & Message Box replies

    I have a code for a free text search form which will return records in another window when the search button is clicked. Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then MsgBox "You must select a field to search."...
  12. huv123

    Running a docmd.showallrecords command

    Hi! Ive create a form (lets called it "OriginalForm") which has a popup menu which has a option that causes a search form ("SearchForm") to popup. {* Each option on the popup menu has a code attached to it so it can carry out some action). When the search button on the search form is clicked...

Part and Inventory Search

Back
Top