Search results

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

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?

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

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

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...

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...

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.

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...

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

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...

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...

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

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

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

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...

Thanks a lot

Is there a way i can use a command button on a form to clear the contents of a yes/no column in a table. I can do this via an update query but I would prefer it if I could do it without getting any propmts warning of the update. Any help would be greatly appreciated

I need to create a query so that I can run a report that will show records entered between certain dates. For instance lets say tblTMS has fields IDNo, DateReceived, Name, Address tblWeeks has fields StartDate, EndDate, WeekNo (all dates are in the format dd/mm/yyyy). I want the user to be...

The table I want to run the query on has a date in the format of dd/mm/yyyy. I want to be able to run a query so that the user can type in a month and all records with dates in that month will be shown. I have done this before many years ago but now have a mental block and cant figure it out...

Thanks for your reply. The problem I've got is that it is a number of different spreadsheets and new ones will continue to come in daily so I can't just use a link