Search results

  1. M

    dateserial for BF?

    Hey everyone, I am looking around for a way to built a Bring Forward system for my access database. I have a Modified Date field and each first of the Month I would like to print a report of records where the month of the field is the month from now() but year(now())-1. Is that possible...
  2. M

    Text field as PK

    Hey everyone, I have a problem with the maximum number that we can insert in a numeric field. That field is the primary key of my table. Can I bypass that limitation by using a text field and entering a number in it as the PK? Sincerely,
  3. M

    How to test reliability?

    Hi everyone, I have a DB with a sample of 5 records. When running queries, the results are accurate. I know because there's only 5 records and I can check each records and proceed to the validation manually. How should I proceed with 100 records? How can we test the reliability of Access...
  4. M

    msgbox combo box value

    Hey everyone, Something really simple here that is giving me some hard time! I guess I just don't understand the way it works! I have 2 combo box on my form -cmbExp1 -cmbExp2 Now, I need to print with a msgbox the selected value of cmbExp1 and cmbExp2. It works if writing the code...
  5. M

    How to "fill" the in(value1, value2, etc)

    Hi, I would like to know if there's a way to "fill" the in() function with values with user's input? Basically, the user needs to search for candidates based on experience(min=1, max=6). To achieve that, the user runs a query and he's been asked how many experiences he's looking for...
  6. M

    How to retreive specific records?

    Hi, I am new here. I'm having a problem with a query in Access 2003. Actually since I'm a beginner, I think I just don't know how to build the query after all! I have a table named candidatesExperiences. For example, here's some data that appears in the table : idExp idCandidates 5...
Back
Top Bottom