Search results

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

Trouble is, I needed the form. I will probably have to update it as I learn more, but I got it working so it loads clean, lets me choose an account, auto fills the team info and has combo boxes for all of the trial data. I added a clear button and a Do you want to save message, (had to put...

They aren't really in as Team1 Team2. I just thought it would be easier than the role titles which are like Account Manager, Sales Executive, Account Representative, etc. I have been having trouble figuring out how to normalize this data without having 30 tables. The only thing they will...

Well. I have one table that has all the accounts and the 30 or so people associated with those accounts. Figuring out who belongs to which account has always been the worst part of data entry. So I need Account Account number Start Date End Date Project Type Project Description Notes...

The closest I have found so far is this but I haven't gotten it to work yet. It won't let me post a link but it is from 1038924, post 3 Private Sub EnterPNcmd_Click() Dim SQL_Text As String SQL_Text = "INSERT INTO costingresultstbl (enditemnumber,PN,Enditemcustomer,comments,current...

Hi there Disclaimer: I am very new and still struggling with .... just about everything! Long Story Short: I have a form, I want the data to save to a new table when I click submit. Long Story: The table the form is based on is to help me auto fill some of the data, all the people connected...