Search results

  1. M

    Convert day of year date/time format to number

    Hi all, I have an inherited database with years worth of julian dates stored as numbers (e.g. days 1-366 for a leap year). I also have some fields stored as short dates. I would like to run a series of parameterized queries on this data, some using the short data and some using the "julian...
  2. M

    Multiple Parameterized Queries Run Together

    Hi, I have a several parameterized queries that I would like to run using the same information, but don't want to make the user enter the same parameters over and over again. What I envision is the use clicking a button to run a macro that will run each query and then open a report with the...
  3. M

    Disable/enable fields on forms

    I am new to VBA and am having some problems turning several fields on a form off and then turning them. I was wondering if I might get some help with my code. I have a master form (frmSurveyType) with a combo box (cboSurveyType) with a tabbed sub form on it (sbfNestSurvey). When cboSurveyType...
  4. M

    Complex looping: set up time continuums

    Hi I need help creating a module in access but I know very little VB. The module will calculate time continuums that will be summed later to get total effort. Here’s the scenario: two or three people record start and stop times when observing a colony. There are many start and stop times in a...
Back
Top Bottom