Recent content by richardhorne

  1. R

    Solved Building a query in code - escaped characters being process as operators

    That solved it, thank you. :D It makes little sense to me that it should have worked, but somehow it did.
  2. R

    Solved Building a query in code - escaped characters being process as operators

    Morning everyone. I have a complex query that's being generated by code in VBA. It contains various fields that are supposed to be output to show progress, for example: Despatched: 50/50 Delivered: 50/50 Approved: 40/50 The problem is, and even though I'm escaping the characters, the slashes...
  3. R

    Solved Trigger a control's datepicker with a separate button

    Oh as simple as that. I'd already set focus, didn't realise that's all I needed to do. Thanks arnelgp :D
  4. R

    Solved Trigger a control's datepicker with a separate button

    Is it possible to have a control - formatted as a date - have its datepicker popup when a separate button is pressed? Basically I want to put a date field on a form with a calendar icon next to it. When the calendar icon/button is clicked I want the datepicker to appear. I know you can just...
  5. R

    Query returning a NULL date - how to check for this null

    As the recordsource is a complex query (sales_order_status) made up of 4 other queries, it's not directly editable. To combat this I made txt_so_promised_date an unbound text field that AfterUpdate manually updates the appropriate record and the form is then requeried to pull in the...
  6. R

    Query returning a NULL date - how to check for this null

    See the screen capture below which hopefully demonstrates what I'm trying to describe a bit better. Capture As you can see, when I select record 28605 where promised_date has a date saved, the form queries just fine. When I try 29299 which has NULL in promised_date I get the error. Then when...
  7. R

    Query returning a NULL date - how to check for this null

    If I try me.txt_so_promised_date = Me.promised_date The problem is that when promised_date is Null I get a generic error. I was trying to trap for Nulls to prevent this error which led me here in the first place. When me.promised_date has a date everything works fine. I'm not even doing...
  8. R

    Query returning a NULL date - how to check for this null

    Yeah sorry I realised my logic was flawed and have since corrected the original code but it makes no difference. Should have been If Not IsNull. Me.txt_so_promised_date isn't bound.
  9. R

    Query returning a NULL date - how to check for this null

    If me.promised_date Is Null Then Gives me an Object Required error. If nz(me.promised_date,0)=0 then Gives me the same original error. What's weird is if you look at the image below, I have simplifed the query by just using SELECT *, and stepping through my code, the yellow highlight is where...
  10. R

    Query returning a NULL date - how to check for this null

    I ommited most of the code because it's very specific to my form/query but see below: Private Sub main_form_requery() str_sales_order_item_qry = " AND sales_order_status.Sales_Order_Detail_ID = " & Me.cbo_sales_order_item_id_filter Dim str_main_form_qry As String str_main_form_qry = "SELECT...
  11. R

    Query returning a NULL date - how to check for this null

    I have a form whose recordsource is updated on the AfterUpdate event of a control on the form. A query is built according to the value chosen in the form and the form's recordsource requeried accordingly. One of the fields returned by the query is a date field (promised_date). A bound control...
  12. R

    MDB Database in Access 365 - forms deleting/corrupting

    That was my initial suspicion but in between this happening the last time and recurring today we've gone about 4 weeks with 5-10 people using it simultaenously daily for about 4 weeks.
  13. R

    MDB Database in Access 365 - forms deleting/corrupting

    The forms/reports are definitely getting deleted as they're no longer in the forms/reports list when I try to view them. But another user connected to the same front-end can still see them. The error message is a generic Access message - see image below. main_menu_login is our main menu form...
  14. R

    MDB Database in Access 365 - forms deleting/corrupting

    Each user logs into their own instance of a virtual machine/remote connection and opens the same front-end. This issue can affect one user but not another. I say locked stated because if they actually tried to edit or delete a form manually they would recieve an error saying they don't have...
  15. R

    MDB Database in Access 365 - forms deleting/corrupting

    Nobody is editing any forms or reports, they just enter data. Only I do any form of editing. The database is split as I mentioned above, MDB Front-end connected to MySQL back-end. Forms are just randomly disappearing mid session. The users open the database in a locked state so couldn't even...
Top Bottom