Search results

  1. B

    Union Query Design Best Practice for Speed and Performance

    Hello, I have 4 tables in which I plan to join with a union query and be able to query information based off of text boxes in a form. The form will have 5 Text boxes that I can use to limit my queries. Is it best practice to: 1) Have 4 separate select queries (one for each table) that will...
  2. B

    Group overnight time together for one date

    Hello. I am collecting data every hour on the hour and I would like to group this data according to Shift (A, B and C) by Date. The only problem I am having is- how can I keep the overnight shift together as one date? 10pm – 6am I was able to do a simple query where I was able to assign an A...
  3. B

    Can't delete record in an unmatched query

    Hello, Access 2010 I created 3 find unmatched queries from the query wizard. The first one works great. I can delete a record in the query and it deletes the record in the main table. The second one allows me to delete a record and gives me the pop up box that says " you are about to...
  4. B

    Best Practice Question for Calculations on a Report or Query

    Is it more efficent (Best Practice) to do calculations and if then statments on a reprot or form than it would be to include on a query? I have alot of records that will require a few calculations of fields followed by a nested if then statements I am not sure if I should just wait and do them...
  5. B

    vallidation rule on table stops macro on a form.

    Hello. Short version- I have a validation rule at the table level that stops a macro on a command button on a form that sets a few tempvars and goes to a new record. Since the validation rule gives me the pop up with the validation text explanation it stops the macro and the user sees the...
  6. B

    Basic DCount Qestion to Check for Duplicates

    Hello, I am having trouble with the syntax for a DCount function for an If then Statement to prevent duplicate data. I have searched the forum and the web but the more I look, the more confused I get. :banghead: However I am a lot closer..... I have a text box on a form to input a text...
  7. B

    Simple combo boxes causes objects to flicker

    Hello. I am building a simple form with a few Combo Boxes, text boxes and a picture. When two out of the three Combo boxes updates a few text boxes, labels but not all and the picture flikers/blink. I do have one other combo box that does not cause anything to flicker once it updates. This...
  8. B

    Hello

    Hello Everyone. Been searching this site for over a year now and wanted to say Hello and Thank You before I posted for help.:D This site had helped me MANY Times in my Learning Process. Bdaviskar
Back
Top Bottom