Search results

  1. O

    OpenArgs to open form

    HI I have a form with a button that when clicked I want it to create a new record in the first table then open the next form and create a corresponding record in the related table. I used the following which worked at first but now it doesnt: Private Sub Command62_Click() DoCmd.GoToRecord ...
  2. O

    Using Inputbox date in Select statement

    Hi I have a module where I want to filter the results based on dates input by the user but the variable is not recognised can you tell me what I am doing wrong please? Basically Dim FiltStartDate As String FiltStartDate = InputBox("Start Date?") ‘Error catch If FiltStartDate = "" Then MsgBox...
  3. O

    Uique Values

    Hi please help I am creating a report to show all the students a member of staff has enrolled at any particular time. I need the student information to be unique so the report is based on a query using the student information table and the enrolment table which records the date enrolled and...
  4. O

    Sequential numbers

    Hi I have a form for booking tickets for events. I have a table of Events, a table of Attendees and a link table of Event-Bookings which uses the Event_ID and the Attendee_ID to records the quantity, type of ticket and ticket number etc. My main form is based on the table of events and the...
  5. O

    IS Null Fields

    Hi I have an input form that collects attendee details and need to make sure that each field is filled in. I have used the code below on the before update event of the form but when I try to close the form, the message box works and when I click ok I have the you cannot save this record at...
  6. O

    Round up issues on reports

    Hi I have created a database to record the room hire at our centre. I have an input form based on a query using only the booking table, where the user enters the details of the booking, dates times number of bookings etc and calculated fields work out the sub total, discount, Vat net total, vat...
  7. O

    Hello everyone

    Hi I am an access user from the UK. A couple of years ago I created a database to record courses and enrolments at the centre where I work. this has now developed into Event tickets and room hire as well. It is not fantastic, I am not great but I have managed to add to the database over time...
Top Bottom