Search results

And it was that simple! Thanks Bob!!!!

I guess I'm not getting it. In the query I have one field called joiningDate. In the related search form I have created 2 unbound text boxes. The box labeled Joining Date Range Start Date is showing up as 12/30/1899 when I want it to automatically pre-populate each time as 5/1/2010. The data...

Bob, In the underlying query I had already set the format for both date fields as Short Date yet I am still getting the result of 12/30/1899 in the search form.

Using Access 2010, I have a search form that includes both a start date and end date that must be entered each time a user searches. Both of these are unbound text boxes. For the end date I want it to automatically use the most current date so I entered a default value of =Date(). The...

I will give it a shot, thanks.

I was unable to do a link table function for the tables I got from a password protected server but I was able to import the tables I needed & create a parameter query and subsequent search form from that. However each month I need to be able to go back and refresh the data from the server; since...

CORRECTION: This is all of the code: Private Sub cmdrptSearch_Click() On Error GoTo Err_cmdrptSearch_Click Dim stDocName As String stDocName = "rptCACommunitySelfServe" DoCmd.OpenReport stDocName, acPreview Exit_cmdrptSearch_Click: Exit Sub Err_cmdrptSearch_Click: MsgBox...

Access 2010 - I have a search form where end users enter parameters. I used the command wizard and created a preview report command button so the report tab comes up in preview mode just fine. I also created a Clear Entry command button that works. However if I leave the report open in preview...

Now on to posting it on a Sharepoint site so that hundreds of users can view it and create their own reports. Something tells me I'll be back.

Trevor: I thought I did follow your instructions but clearly I missed some things so I deserve that rap on the wrist. Many thanks (I don't know how to mark this issue as RESOLVED.)

I understand Trevor. I'm certainly not frustrated with you--just the fact that I'm not seeing the answer. vbaInet: I am looking at that link now, thx

This is so frustrating! I've taken so many things out of the database that I THINK would prevent the db from converting down to 2003, but it's still not allowing it. I removed the macro, checked the fields in the table, and even removed the parameter expressions in the query but no dice...

I have loaded my db with test data and attached it. The query and report both work fine. But for some reason the form does not. When I put in any set of parameters, all of the results come back instead of the parameterized ones. Trevor: I have studied every part of the design of your...

As is evident I am no Access 2010 expert so thank you for instruction, plog!

How can I create a custom date field that shows the quarter based on a fiscal year that runs April-March? Q1 April - June Q2 July - Sept, etc

You're right. These dates were entered manually by many different indivuduals so when I filtered on the date field, some only put 2012, 2011 etc. while others put an actual date like 3/31/2013, then others put N/A, n/a. The cell format is *m/dd/yyyy. Guess I have some clean-up to do.

I have tried many ways that I found on the web to solve this issue: when I import my Excel 2010 spreadsheet to Access 2010, the date field is coming back with type conversion failure on the date field. The spreadsheet has 59,000 rows. How can I quickly resolve this problem? I have tried...

The field Name doesn't show up in the drop down list--it shows up only as what I renamed it to which is Community. I wish I could upload a copy to get more of your expert advice but it is proprietary data I pulled from our server.

That sample db was extremely helpful! Thanks. I am very close now. For some reason the parameters work fine when I run the query but when I run the report there's an additional parameter dialog box that shows up called "Name". I read somewhere that you shouldn't use a field called "Name" but...

Trevor G I built the form using the same 3 fields that are in the query ie. I added the 3 textboxes to the form design grid and used the corresponding fields in the query as the data source. Here is my dilemma: the query has 72,000 rows in it and when I preview the form, the fields do not come...