Recent content by Danielle17

I FIGURED IT OUT! I was soooooo blind....I thought that the dates were wrong but actually there are no dates for feb or jan...so by getting the dec. dates and back it was correct...the next date after 12/22/00 is 3/5/01...which in 3 weeks will be 6 months back and then will be on the...

Glad to help :-)

If I use either one of them they don't work...I haven't been able to pull up the correct dates...It has to be something with the DateAdd("m".....thing....even if I use the Date() thing in the query it pulls up dates that are not from 6 months and before...the "-" pulls up all...

I don't believe you have to do anything with the bound column. I was just making reference to why my application wasn't working before I put the text box on there.... Have you tired it yet with the code? Do you get the right person??

I DON'T need the dates from, let's say today back to 2/15/01...only the dates before that.... The ((([Customer and Lead Listing].[Date Entered])=[Date Entered]) had already been deleted...so it looks like this: SELECT [Customer and Lead Listing].CustomerID, [Customer and Lead...

I'm not sure if my post will be more helpful than any of the others but here goes... I, too, have a form that when an Employee is chosen from a combo box a report for that Employee will pop up when the command button is clicked...Here's the code that is on the On Click event... Dim...

I'm not sure if my post will be more helpful than any of the others but here goes... I, too, have a form that when an Employee is chosen from a combo box a report for that Employee will pop up when the command button is clicked...Here's the code that is on the On Click event... Dim...

I would like it to read the Date() so that the user doesn't have to enter a date...they just have to click the command button and it will automatically read the current date... I just added a textbox that is not visible onto the form that will automatically read the current date...So the new...

I posted a while back and got a couple different suggestions on what to do but they only solved part of the problem....I have to be able to pull up a report based on 2 things...One: is that the "Status" field must say "Registered Lead", Second: is that the "Date...

Oh, wait...I just noticed that it brings up all records that have "Registered Lead" in the status column....I still need it to do that but it has to just pull up the records 6 months back and further with RL in that column....now what?

THANK YOU! It worked perfect...

I need some help on writing a bit of code for a command button...I need it pop up a report based on some criteria...First one of the fields has to say "Registered Lead"...I've got that part figured out...The next criteria is that the field "Date Entered" has to be equal to 6...

Okay I got it to change the date but I put it on the LostFocus event so that it doesn't pop-up a "Null" error....the only problem is that I need the CalDue date to stay the same even if the user puts the cursor back into one of the other records showing in the subform....What it does...

Thanks for reading my explanation and answering...actually it sort of helps :-)

On one of my forms there is a subform where the user can add a new entry to an existing record, for example the date....The main form (where the subform is located) and subform are related by the GageNumber-There are 2 tables in my database- one for the basic info for a piece of equipment, This...