Search results

What needs to be changed to get this code to work? No error message, just doesn't filter the record on the form I want to filter for just those records with the tickle date between today and 10 days from now... Thanks, Dave DoCmd.ApplyFilter , "[tickle date]= between today() and today + 10"

They are bound, and the query did the trick. Thanks, as always, Bob.

I am trying to clear the checkboxes [one for each record] when I close a form so it opens next time with none of them selected. I have tried 5 or 6 different ways to do this. =0 =Null ="" =false =no The most recent, below, doesn't work, either. No errors, just does not clear them. Private Sub...

I am down to my last 10 paydays... Finally !

That works! I can now figure out the different options my users need. Thank you both for your help. Dave

Doesn't like that, either :) rTime error 5 Invalid procedure / call

I forgot to attach it- sorry :) If Frame33 = 1 Then DoCmd.ApplyFilter , "[casestatus]='closed' AND [Assignedto]= Environ(UserName)" Thanks, Dave

What I am doing is selecting the case status by whatever user is logged in to the computer. The 'and' works great but it doesn't like the environs....

My code for an option group [below] works fine. I now need to to another option group that checks both CaseStatus and assignedto. Some help with the if statement to require both matches? Thanks, Dave Private Sub Frame22_AfterUpdate() Frame33 = Null If Frame22 = 1 Then DoCmd.ApplyFilter ...

I think you understood the question. Now I will go to work and see if I understood your answer :) Thanks, Dave

I just finished a customer demo of a new application. My customers asked me to build another form reached by clicking a command button on the main form. The two forms (and underlying tables) are tied via a tracking number (autonumber) field. They are planning on generating notes on this...

Thanks for your help again, Bob :)

Using Access 2007 I have two tables/forms that are linked by the field 'trackingnumber.' When I have the main form open I call up the second form via command button and need to have it open the record that matches the main form. Thanks, Dave

Thanks, Bob- perfect!

The record from form1 is just a user supplied ID- there is no table just the form. The record for form2 is from a table that contains the IDs that I need to match. Just one table and two forms with IDs- I want the second form to open to the record that matches the ID on the first form

Everything I have tried so far just changes the ID of the record on form 2... I just want the matching record :) Thanks

I thought I saw a 'display calendar for date fields' command and now can't find it. I have tons of date fields and would prefer not turning them on all over in the database. Where is this hiding from me? Thanks, Dave

I needed this info also- found it using search. Won't allow me to add to reputation again :), but the code is great! Thanks :)

Thanks, Bob. It runs perfectly :)

I have a select query that works perfectly. If the query is empty I want a messagebox that tells the user there is no matching record. I can't seem to get the code to do this. I have been working with the NZ() function but can't make it work... Can someone get me started? Thanks, Dave