Recent content by Neil_Pattison

  1. N

    Using Working Days in a search criteria

    Would something like =Iif(Weekday(Date()=6,Date()+3,Date()+1) work?
  2. N

    Using Working Days in a search criteria

    I have a query where I use the search criteria of =Date()+1. However I really need this to add on a working day (i.e. excluding weekends). Is there an easy way to do this?
  3. N

    Open a form if a date field is passed

    Thanks for you help on this, I'll just put a message box in the on current event
  4. N

    Open a form if a date field is passed

    I could use a message box if it is simpler. It is possible that the form when opened will have more than one record so I would need it to be able to notify the user that there is a date in the past on any of the records
  5. N

    Open a form if a date field is passed

    Thanks for your reply. I'm wanting it to open as well as the original form. The second form will only act as a warning to alert the user that the date is in the past. The user can change the date field, but it would only be changed to a date in the future, and not the past, so this should...
  6. N

    Open a form if a date field is passed

    I have a form with numerous fields on it, with the one I'm concerned about being a date field. I want a different form to open automatically if the above date field is in the past (this will act as a warning to the user). I've created the warning form as a pop-up view but just want to know the...
  7. N

    Problems after Update Query

    Thanks for your reply, however I have now sorted this. I thought the issue was more complicated than it actually was. The issue was actually in the source data coming from the excel spreadsheet, so my database was working correctly all the time.
  8. N

    Problems after Update Query

    I have a problem with a database I'm maintaining after I have carried out an update query. I have a macro that imports data from an excel spreadsheet onto a temporary table, which then runs the update query to my main table. This all works fine and the data is updated correctly. The problem...
  9. N

    Using Option Groups to run macros

    Thanks for looking but I've now figured this out. Its been a long day
  10. N

    Using Option Groups to run macros

    Hi all. I have an option group set up on a form with two options. I want the user to be able to select an option and then click on a command button to run 1 of 2 macros. I thought the code behind the cmdbutton would be simple but i keep getting the runtime error 2502. The code I have used is...
  11. N

    Does Not Include

    I have a table in MS Access (I've attached a few records for your info in excel format) where I need to exclude certain records. Each record has a number attached to it in the first column (the example shows 1 to 14). In the final column it shows either "Initial Visit" or "Maintenance". The...
  12. N

    Run-time error 2448; You can't assign a value to this object

    Yeah I can see why that would be confusing. Using me.filter = strFilter me.FilterOn = True still brings up the same run time error though
  13. N

    Run-time error 2448; You can't assign a value to this object

    The form does have 2 subforms on it but the filter is only in regard to the parent form
  14. N

    Run-time error 2448; You can't assign a value to this object

    thanks for your reply Ken. I've tried that but still come up with the same run-time error
  15. N

    Run-time error 2448; You can't assign a value to this object

    Hi all, I have a form that runs from a query which combines data from 2 tables. I am trying to set up a filter on the form using a number of combo boxes and text boxes and a command button to fire it but I keep getting the above error (on the .Filter = strFilter line) and I can't see what the...
See more
Back
Top Bottom