Search results

Hi All, Access 2003. I am trying to accomplish a particular search using three text boxes on my main form. I have three fields: "Project", "Task" and "Award". I would like to set up three text fields on my main form with a command button so that when a user fills in these three fields and...

Hi All, There is how to instructions for how to work around duplicate names in mail merge data : http://support.microsoft.com/kb/302665 Does anyone have instructions, or can give me a possible step by step for this same problem in Word 2003? OR maybe just show me the code? I have 3 fields...

Thanks SB!

Here is the updated DB. TY

I think this needs an IF statement of some sort.. so Start Date (Text 2) of the Search on the MainDashboard: 7/1/10 End Date (Text 4) of the Search on the MainDashboard: 7/1/11 Record 1: 7/1/09-7/1/20 Record 2: 7/3/09-7/3/15 Record 3: 7/5/09-7/5/10 IF (Text 2) >= Contract Start And (Text...

I just ran that search with the same Date search and no records were returned??

This isn't working like it should. If a user searches by Start and End date, if there is an active record who's dates fall within that search (even if it isn't the actual Contract Start and End date)...the record should be returned.... For example: I searched Start Date: 7/1/2010...

Can anyone help me with this query search?

For example: Records with dates entered: Start:----End: 1. 7/1/09---7/1/10 2. 8/1/09---8/1/10 Right now when we search between 8/1/09 and 8/20/09...the second record is returned because it looks at the start date. What I need help with is when this same search is done, both records...

I thought life was easy but I guess not. Now my boss wants me to modify this search to return all ACTIVE records between my date range. Right now we set it up to look at the "Contract Start" date but I also need to figure out a way to search for all records that are active within this searched...

Let me get this straight, I'm adding this new line of code to the end of my SQL code for my qryMain: SELECT tblMain.ConsultantName, tblMain.ConsultantStreetAddress, tblMain.City, tblMain.State, tblMain.Zip, tblMain.[Contract No], tblMain.ContractName, tblMain.Email, tblMain.[Contract Start]...

Scooter, That is returning all of the records without the date search factored in. Do I need to add this somewhere in the line of code: "stLinkCriteria"??

Thanks ScooterBug!...I will play around with it in a little.

No Problem!

No, I'm going through the manual steps...I dunno if you can have a button for that. The manual steps though aren't working for me. I should add, I'm not emailing it as I'm testing this, but it does automatically attach an excel file (.xls) that I'm opening to see if it's attaching what I want.

Sure thing...

Paul Got it! Thanks! Kryst, thank you for your help as well, if there was a way to get that "send to" to work that would be awesome because once a user conducts this search, since it's a datasheet, the user can't see what dates they searched by. Not a big deal, but it would be something nice...

Kryst, Regardless of what I click on or highlight or even in design view...the send two is just transfering over the Dates. For the 2nd part, I do have it set to datasheet and it still is coming up as a normal single record form. I'm wondering if I have to set up the code for my command...

Thanks Paul haha...but it is still opening up in a form and not a datasheet..how do I get that to work? Kryst, I really like your example and I would use it, BUT I need to do a File-Send To-Mail Receipiant in excel format and when I do that, it is just taking the Dates Data...is there a way to...

Hi Guys, Access 2003. I'm trying to set up a search on my dashboard that will locate all records within a date range. This date range will check all record's "Contract Start" date. I would like the information to show in a datasheet so I have a qryMain and I have a frmDateRangeSearch...