Search results

  1. O

    OpenArgs to open form

    HI thank you so much for your reply, I used the code you gave me but it stops on ' Me.NewRecord = True' with the error message cant assign to a read only?
  2. 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 ...
  3. O

    Using Inputbox date in Select statement

    Hi yes DBGuy I had it working but then I had to add another filter and which is when I started recieving the Syntax error again The link for the converter looks really good thankyou Minty. I will be working on this again on Tuesday, and hopefully I will be able to test the dates then. I...
  4. O

    Using Inputbox date in Select statement

    as sson as I have fixed the syntax error on the information below I will check the dates but I have changed the criteria slightly because the results I need have to be: Bookings that are courses, not with exam in the title, not with C as the status ref, and with a specific location, between...
  5. O

    Using Inputbox date in Select statement

    Hi Basically my function does a few different things and uses several tables as follows: Table A emptied Table B emptied Table C emptied Qry A created and appended to table A Qry B created and appended to table B Qry C created and appended to table C Contents of table A, B, C sent to Summary...
  6. O

    Using Inputbox date in Select statement

    Hi DBGuy I am assuming that I would look at these results in the immediate window as the report does not show the dates of the each result but I dont know how?
  7. O

    Using Inputbox date in Select statement

    Hi Thank you DBGuy, I thought I was just modifying what you suggested, can you tell me the difference in the date formats and which is the safest to use please? So far I have a button to run the code and placed the following at the end after the docmd.Openreport ...
  8. O

    Using Inputbox date in Select statement

    i think I have done this, I added this code at the bottom: DoCmd.OpenReport "RptSummary_Report", acViewReport Report_RptSummary_Report.txtStart_Date = FiltStartDate Report_RptSummary_Report.txtEnd_Date = FiltEndDate
  9. O

    Using Inputbox date in Select statement

    Hi I put the format line at the beginning so that I only used it once (the dates are used further down in the function too) STDate: sDate = InputBox("Start Date?") 'Error Catch If sDate = "" Then MsgBox "You have not suplied any information" Goto STDate End If If IsDate(sDate) Then...
  10. O

    Using Inputbox date in Select statement

    Hi all Thank you this is now working fine I am so greatfull!! One last question to finish it off....sorry :rolleyes: When the dates have been input by the user and the report figures generated the report is opened in preview. How do I pass the dates input by the user into a text box on...
  11. O

    Using Inputbox date in Select statement

    Hi All Thank you so much for your replies - they have all taught me more and helped me to understand what I am working with. I am using the where statement from Jiri because I also need to use those dates a little later on but I am getting a syntax error and I have tried all ways but it...
  12. O

    Using Inputbox date in Select statement

    Hi thedbGuy Thank you, this does look much better but when I run it it is still asking me for FlitStartDate when it reaches the 'Where' line even though the date is in FiltStartDate above.
  13. 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...
  14. 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...
  15. O

    Sequential numbers

    Hi Mark thank you for your answer. I am looking to add a ticket sale record only if the ticket is sold. I have attached a sample of the database in question, hopefully this will help. thank you
  16. O

    Sequential numbers

    Hi I have looked at the links below and none of them are answering my question. I only want the sequence to happen per event.
  17. O

    Round up issues on reports

    Hi I need £6.16 because the client is told that the cost is £18.50 per hour including VAT, but the invoice total for 2 hours is £17.01. Thank you
  18. O

    Sequential numbers

    Hi Thank you for your replies. The sub form is sorted into ticket number order and the user should then just type in the next number but somehow the have managed to skip numbers so I have been asked if I can make the next number fill in automatically. The ticket numbers are 1 - 100 for each...
  19. 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...
  20. O

    Round up issues on reports

    Hi does anyone have any advice on my previous question please?
Top Bottom