Search results

  1. S

    Form printing multiple pages, Access 2010

    Appologies, I didn't explain this very well! this is the event that is run to print the report on a button click. Does this make more sense? "DoCmd.OpenReport "rptMainCEVAReport", acViewPreview, , "[MainFormID]=" & Me.MainFormID, 0"
  2. S

    Form printing multiple pages, Access 2010

    Probably an easy fix, can somebody advise. I have a form with a subform, if the subform has more than one line item, the print output will print the number of copies that relate to the number of line items. All line items apprear on all the printouts, how can I just print one report?
  3. S

    Error returned

    I did but they weren't checked.
  4. S

    Error returned

    I've created a new database and all seems OK at the moment, fingers crossed. (y)
  5. S

    Error returned

    Unfortunately , I don't. :(
  6. S

    Error returned

    Thanks for this advice, really appreciate it. I’ll try what you say. again, thanks.
  7. S

    Error returned

    Yes, CAn I save the database to a lower version so they can run it?
  8. S

    Error returned

    Can anybody point me in the right direction, I've build a basic database and sent it to a few users to test & for suggestion, the users are getting the following error when trying to access the "Search" option on the Switchboard. All users have runtime 2013. any help would stop me getting any...
  9. S

    Combo box Requery

    Thanks for the tip.
  10. S

    Combo box Requery

    Hi Guys, Thanks to you all for your inputs, have now resolved the issue. I used Forms!frmMainForm!cboCustomerAddress.Requery on close, this seemed to work. Again thanks guys. :)
  11. S

    Combo box Requery

    Hi Guys, sorry if this is a dumb question, but here goes. I have a form with a Combobox which populates a customers address: Private Sub cboCustomerAddress_Change() Me.Address1.Value = Me.cboCustomerAddress.Column(2) Me.Address2.Value = Me.cboCustomerAddress.Column(3) Me.Town.Value =...
  12. S

    Date Range Search Criteria not returning expected dates

    Hi Guys, Thank you all for your help, really appreciated. Finally got this working with the following: Private Sub btnSearchDateFrom_Click() Dim date1 As Date Dim date2 As Date Dim filter As String date1 = Format(Me.txtSearchFrom, "mm/dd/yy") date2 = Format(Me.txtSearchTo...
  13. S

    Date Range Search Criteria not returning expected dates

    Hi, I can’t do this tonight but will get back to you tomorrow if that’s ok. Cheers. 😊
  14. S

    Date Range Search Criteria not returning expected dates

    Hi Minty, I'm in the UK and will check out the link you added above, thanks for that. I'll let you know how I get on. thanks
  15. S

    Date Range Search Criteria not returning expected dates

    Hi, Tried this and didn't work, am trying the other suggestions at the moment. thanks for your input,
  16. S

    Date Range Search Criteria not returning expected dates

    Hi tried removing the # and, unfortunately, it didn't work. Just working through the other suggestions. Thanks
  17. S

    Date Range Search Criteria not returning expected dates

    Hi Tried this and get an error Dim date1 As Date Dim date2 As Date Dim filter As String date1 = Format(txtdatefrom, "mm/dd/yy") date2 = Format(txtdateto, "mm/dd/yy") filter = "[dateofdelivery] between #" & date1 & "# AND #" & date2 & "#" Me.filter = filter Me.FilterOn = True Is this...
  18. S

    Date Range Search Criteria not returning expected dates

    Hi Guys, Could somebody help with an issue I have regarding a date range search. I have a form with two date picker field (Date From & Date To) which set the range to select from a query. Below is what I'm using to set the date range, the "To" date works but the "From" date also selects dates...
  19. S

    Form got focus all fields

    Thanks missinglinq
Top Bottom