Search results

  1. C

    Printing a table

    Hi, I have a form with some fields on it.. it's a subform. It has multiple rows. Is there any way I can print the rows as in a report. I Dont know how to pass the subforum values from the form to the printer? I tried the print table macro but it prints the whole table data and not just the...
  2. C

    LDB File problem

    Hi, I have a multi user Access 2000 DB on a network share.. the database has started to give me problems recently. Sometime when the first user access's the database, the LDB file is created.. allowing other users to enter the database too.. but 3 out of 5 times the first person who access the...
  3. C

    SUM querying

    Hi I'm having a bit of a problem with the sql query below SELECT [Table 1 Personal Details].Surname, Sum([Table 3 Daily Activity].[Public Holiday]) AS [SumOfPublic Holiday], [Table 3 Daily Activity].[Week Commencing], Sum([Table 3 Daily Activity].[Authorised Absence]) AS [SumOfAuthorised...
  4. C

    Next record event

    Hi, I require to be able to check whether or not a yes/no box has been selected, each time the database is navigated.. ie, next record , previous record. I cannot find the event in VB to allow me to perform this function. I see AfterUpdte and beforeUpdate events, but sometimes the data is...
Back
Top Bottom