Recent content by OnlyTD

  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
See more
Top Bottom