Search results

  1. C

    Problem converting date stored as text to data/time format

    Same Problem I have the same problem as gddrew. I don't quite understand how to implement the code above. What is the MID for and what are the "random" numbers on the back end for? Please clarify. Thanks, CB
  2. C

    Conditional Formatting Dates

    Looking for some help. I have added an attachment. Any help would be appreciated.
  3. C

    Conditional Formatting Dates

    In my report I have date fields that span over 5 years with different pull dates ex. 3, 6, 9,12,24,36,48 and 60 months. I have successfully formatted these fields using the conditional format by: Expression Is Date()<[9 Month] and Date()>[6 Month] for the 9 month field and so forth for each...
  4. C

    onformat for report make visible/invisible

    I want my fields on the report to show up if there is data to show and to disappear if no data is avaliable. Also, will the fields format together or will they still stay apart? I need them closer together for the report. Here we go. In the report are months 1, 2 and 3 as well as the label box...
  5. C

    Query with criteria on two existing queries.

    Well, all that got mushed together, yuck! Anyway, when 1 and 2 mth is checked for Lot X and when 1 and 3 mth is checked for Lot Y. So then Query 3 only shows the dates for the checked boxes.
  6. C

    Query with criteria on two existing queries.

    Hi, I am in need of help to sort out some records. I have tow existing queries I would like to combine and get one final set of records out of. They go like this: Query 1. (unique #) Lot Protocol Sample # 1 mth 2 mth 3 mth X ABC 1...
  7. C

    coding on the form to select a specific query

    I am not sure I understand. I am new to programming and am not familiar with the codes you listed. How will I distinguish between the different queries? Do I choose Me.RecordSource = "Query 1" Me.RecordSource = "Query 2" and then tell it Me.RecordSource = Me.YourComboBox and it will select...
  8. C

    coding on the form to select a specific query

    I am needing help with the code to select different queries based on different conditions. The database is to be set up so that I can pull studies at different time points based on if they are under long term, accelerated or stressed conditions. When this condition is selected there are only...
Back
Top Bottom