Recent content by ddevil

No visible properties just sorts going on. Any other ideas?

I have a form with three tab controls on it. Each tab control holds a different form, which runs a different query. There is no data to display on the first and second tab, but there is data on the third tab, but all I get is a blank page. The different tabs aren't showing up. If even one...

I have the following date comparison: If stStat2 = "Open" And Year(stSchedDate) > Today Then do something..... What I really want is if the stSchedDate > the beginning of the month prior to the month we are in. If the stSchedDate was 11/24/2008 then this statement would be true...

Ok, light bulb is on now. That's what I needed. Thanks!

OK, so I have one table called Event_Detail with a field called EventNo. The second table is Events_to_Exclude and a field called EventNo. If I join on the two fields where the EventNo = EventNo, then I only get the records I want to exclude. What I want is to get all the records in...

How do you do that with the graphical tool in Access? I get three choices for joining. Where the fields equal. All from one and only those that equal form the other (either way). I'm sorry this tool confuses me. I get the SQL.

I have a table which contains records that I want to exclude from a query, but I don't see an option in the join criteria to give me all the records in one table except the records that equal from the table with the records I want to exclude. I was thinking I could do a not in in the criteria...

Great exactly what I needed. Thank you!

That is correct the form is not open. I have never done what you are suggesting before, can show me some sample code?

Now I get an error that says Run-time error '2450': Microsoft Office Access can't find the form 'frm_Consultant_Updates' referred to in a macro expression or Visual Basic code. This is the correct name of the form, I doubled checked. Any other ideas, help was no help?

I want to be able to set the allow edits property on a different form when a button is selected on the current form. The code is below and it runs without error, but when I open the form I'm trying to set, the allow edits property is Yes and not No. Any ideas would be great. Thanks! Private...

Darn ,'s. Thanks!

I have another problem with email, please look at the code below. How would I write the in statement for the record set. I just want those with the roleid of 18 and 6 to be emailed, I'm obviously not doing it correctly. Thanks! Private Sub NotifyAM_Click() Dim answer As Integer Dim EmailText...

That was just too easy, I'm always making it harder that I has to be! Thank you!

Ok, I created the record set as below, but how do I populate the ToReceiver to send and email to everyone at once, instead of sending individually. So in the TO field I want name@email; name@email;, etc.? My code is below, thanks for your help! Private Sub UpdatesStillNeeded_Click() Dim answer...