Search results

Apologies, it's difficult to get the wording right sometimes when it could be taken two ways and the other way is more commonly asked, When i said "Making a Task Scheduler in Access 2010" I literally meant from scratch using VBA - instead of - windows task scheduler :)

I think I didn't word my question brilliantly, I basically want a query to identify which lines in a table are due based on some fields of like day, hour, repetition

There are some reports/queries I need to export and email at certain times, I've got the email part sorted but my "Certain Times" code needs significant improvement, I'd like to select specific times/reoccurances for each "report" and store them in a table like Windows Task Scheduler / Linux's...

Yea something like that, and the kinda alternative half of each one but yea, that's the kind of thing, So I guess my question is for working stuff out like this in future is there some way to write an IIF in a truth table or how do I do algebra with something like this to explain

I've got a query that's evolved over the years, the field in question has an IIF statement resulting in in one of two dates (A & B) and the criteria I now need to apply to it is an IIF that also results in one of two dates (D & E), C and F are a boolean field I need to check as that affects...

sorry, it's a little complicated, basically the IIF using table sndplanvactual that is in the Where clause you're looking at is for a field on the query, That field contains an identical IIF using table sndplan and I only want the records where the result of one IIF <> the other IIF

Sorry that's the subtlety i'm talking about, it's not as simple as all the records that Pat's statement found, it's only where those records match records in a previous snapshot (copy of the same data with some changes) but where the matching records, using the above logic, result in a different...

Through some trial and error, I ended up with some repetition in where where clause where I had a less and more restrictive version of the same statement so reduced it down to the bare minimum and got: SELECT...

I'm looking at converting the IIFs into multiple query criteria but it's fairly tricky, the whole statement, logically is: (IIf([sndplanvactual].[shipdate]>1,IIf([sndplanvactual].[shipdate]>[sndplanvactual].[cldate] Or...

We've had one occurrence before where a totals query GroupBy on a field caleld DueDate gets changed to: DueDate as an "Expression" total With a groupby of the IIF with "Show" unticked along to the right The icing on the cake? it then errors when you try to save saying "Syntax Error" So...

dynamictiger, thanks but the logic works, it's how Access is interpreting it into SQL and back Pat Thanks for the breakdown but the logic is not as simple as the Where you've written, also the logic works with the IIF when I set the SQL and press "RUN" but when I save access screws the logic up...

I try to set the criteria of this field: CurrentShipDate: (IIf([sndplan].[shipdate]>1,IIf([sndplan].[shipdate]>[sndplan].[cldate] Or [sndplan].[shipearly],[sndplan].[shipdate],[sndplan].[cldate]),Null)) To be this statement...

Doy! In the past I have ended up making a sub/function in a regular module which I always felt was a faff as you can't use "me.object" etc For some reason it never even crossed my mind I could just make a custom function in the form module :) Thanks

I have a form with a number of fields and sections which change visibility based on the data entered in other fields, The fields have an "on update" event to check the content of the field and make the appropriate changes, I've changed this form to be able to edit records instead of "Data...

Yea, I'd just started to worry about how to manage multi user issues and it was seeming complicated so I've started redoing the unbound form as a subform, This also makes it easier to use the Fault creation form as a Fault editing form, however I have a number of objects that change visibility...

Haha! Access has shot a hell of a lot of puppies in my book! edit: But yea, I take your point on "use the tools that are there", I'll knock up a subform, My only question then is what's the recommended solution for handling when Access tries to update when it loses the focus?

its just the neatest way I've seen to quickly populate a number of unbound fields, edit: would you suggest swapping it to a subform?

So I'm making a "simple" Fault and Solution system, When I made the form to add Faults I just put some unbound fields and list boxes onto a form bound to the Parent table and used SQL to insert records into the Child table, Later when I made the Solution form I used a subform bound to a...

Re: Access 2010 - simple update query gives "Operation must use an updateable query" the dlookup route has sorted it, and as there's only a few hundred records and its an admin level user data refresh its not a problem :)

Re: Access 2010 - simple update query gives "Operation must use an updateable query" frustrating :(