Recent content by auntielo

Thanks June7, (that's my birthday!) Where do I put it? I tried If IsDate(strField) Then before the select case - trying to cheat and not put in all the fields I got an error so I added another End If at the bottom. But now when I use the filter, nothing happens. So I bet that is wrong

Hi again, I have 2 combo boxes, one has the fields and the other has date options. So cbo1 has values like Closed Date, End Date, Start Date, Length and cbo2 has This Week, Next Week, 120 Days+, etc. I have tried various formulas that have worked in other objects, but because this one has...

Hi The Doc Man I am going to have to relook at this one in the morning. I can't quite get it. Love the idea though. And I am okay with the team editing it, as long as they are intending to, so the password might be perfect. I really just want to make it as user friendly as possible or it...

Hey ridders I have zero knowledge of macro, somehow vba made more sense. How would I add the function in my Autoexec macro? OpenForm Form Name Start Menu View Form Filter Name Where Condition Data Mode Window Mode Normal

:D Thanks to another google search, I GOT IT!!! Whew! I am so close to done. Or at least done enough. Here is what I ended up with (Gasman, I haven't changed it to the cleaner code yet, but it's on the list!) Private Sub cboReportField_AfterUpdate() Me.Filterby.RowSource = "SELECT...

Admin rights using VBA? https://www.access-programmers.co.uk/forums/showthread.php?t=165127

Thanks for the restraint ;) If I don't develop it, we won't have one. I have a huge spreadsheet (140 columns) and I need to manipulate data fast. I was complaining about it in February and someone suggested Access.... which I had never heard of before... I don't know if I want to go the...

Not quite yet. I have This Week, Next Week, Last Week all showing up in my StartDate and EndDate txt, but I can't figure out how to do before last week. I could probably just use last year, but where is the fun in that? Maybe I can just do that one from the filter? Speaking of which - it is...

Can you switch between admin and user rights? I only want admin rights when I am going in to edit something. Otherwise I just want to use it like a user. I have a Start Menu form with an Admin button. I was hoping to block/hide most things unless I clicked Admin. Trying to protect the...

Which one? The one you cleaned up or the mess I posted ;) You have no idea how hard that beast has been to move around to different forms as I add things to it. Surprisingly (surprised me anyways) what I posted worked all the way through. I haven't tried updating it to yours yet. I have...

hahaha, I was wondering how people do that! No criticism taken, it's a horrible way to do it. But now I am so far in I need to finish this before I can dig into VBA properly. I was complaining about my 140 column spreadsheet in February and someone pointed me to access. First I had ever...

Thanks! You can use Between for dates where the start and end are the same. So use the same syntax for your single dates Between Date-1 and Date-1 I would use StartDate and EndDate and set accordingly? What would that look like? I tried it multiple times and I always got an error. I will try...

New wrinkle. I was searching for a way to move all completed tasks to a different table and I see the best way is to filter. So I need to add a filter to only get records that are unchecked.

I don't know if that made sense, so I am making a second effort at explaining :) This form is really basic, the main form that takes you to is more complicated, but it was making me cross-eyed. cbo1: cboReportField cbo2: Filterby txt1: DateFilter cmd1: Command153 When I select a value for...

I have a Report with a RequestDate field. I am using a form to filter and it got a little complicated. I have two comboboxes, one to pick which field I want to filter, and one to choose the filter value. I (finally) got almost all of them working, but I am stuck on four: This Week, Next Week...