Search results

  1. I

    Fit to page

    By using the 'On Open' command in the report properties, I want code to make the report fit into the screen. Can anyone help!
  2. I

    Startup form

    I want to run a start up form that appears only when the data base starts for about 10 seconds, then closes, and opens a switch board. I no I could do this with code, but not sure how!!!!!
  3. I

    Date calulation

    I want to take a date, add a set amount of days, to give me a completion date not counting week end days. ie Date started Set days Completion date 17-01-02 5 24-01-02 Can anyone HELP!!!
  4. I

    Tab

    I have a form, with a subform, and a subform within the subform. I want to tab from the last subform to the second subform. I have tried Forms![sb Scanner activity]![Command43].setfocus in code but it does not recognise the location. Can any one help.
  5. I

    AutoNumber

    I have an existing data base which creates records with a autonumber. I want to have a facility which allows me to attach a additional unique number to a record automaticly, specific records only. Can anyone help!
  6. I

    Prompt in form

    I want a message to appear if no data is recorded in a field. The message is to appear when the field is out of focus. Can anyone help!
  7. I

    Tab

    By using the tab key, I want to move the focus from a field in a sub-form to a field in the main form. Currently the focus stays in the sub-form.
  8. I

    Mandatory fields

    I want to have a form that will not go to a new record unless specific data is inputed. i.e. if the date field has no data showing a message would inform user that data is required.
  9. I

    Time

    I am using the 24 hour clock to calculate time in a query, but access loops the total ie 25 hours would show as 1 hour. Can anyone advise me how to overcome this in a query!
  10. I

    Linking Module to a Query

    Can any one advise me on how to link a module to a query column
  11. I

    Difference between two dates

    I want to show the differnce between two dates in a query, but not count weekend dates ie 30-11-01 to 3-12-01 is two days. I have tried Datediff but with out success.
Back
Top Bottom