Recent content by JCorreia

Ah, of course Trevor, should have thought of that. I keep forgetting KISS. Thank you very much.

Hi, This summer I worked on a pretty extensive database for my internship and I'd like to be able to show recruiters the database as an example of my work (to get an interview, etc.). Of course, I can't just show them a copy of the database with all of the private information on it, so I'd like...

Ok, so no way to do it with the same print button that I already have on the form?

Unfortunately my primary key is the file number (because I didn't want anybody making files without a file number), and the file number is displayed on the form.

But I'd need to have some sort of text in some of the controls, since Access deletes any trailing spaces, right?

Hi, in Access 2007 I'm trying to print out a blank form so users can fill in rough notes while on the phone with a client, etc. I currently have a print macro button on the form, but the entire page shows up blank (titles, everything) when I try to print a an empty form. A possible solution I've...

Thanks Uncle Gizmo, that actually did give me some inspiration! I ended up creating an hidden text box and made the After Update event of the Date of Accident make the value of the box the string value of the date. That way, I have the text box the user types in as a Date format, which can be...

:/ Waiting for the administrator to let me in to the site to watch the video. dpelizzari, I think the problem lies with how I read the value to display it in a separate field (the report), not how I compare it to the values in the table. That being said, if there was a way to reliably compare a...

In order to perform conflict searches in my Access 2007 database, you enter a bunch of information and then receive a report of cases with similar information in order to avoid any conflicts of interest. One of the fields is "Date of Accident". Currently I have its format set as yyyy/mm/dd...

I have a combo box in my form called "Contact ID" with an input mask of LLL-L-LLL-0. However, adding this input mask prevents the combo box from AutoCompleting . I've tried fooling around with the field's AfterChange property and the like, but I can't seem to find a solution. Can somebody...

Since I have an input mask on my dates, it turns out I didn't need the #'s. But I think I finally solved it, for each of the criteria I put (Like "*" & [Forms]![frmConflictSearch]![Date of Accident] & "*") AND ([Forms]![frmConflictSearch]![Date of Accident] Is Not Null) Thanks a lot for...

Actually, I think I've identified the problem. I think it's my use of wildcards. Whenever I use wildcards (ie. Like "*" & [field] & "*"), it returns any occurrence of the pattern I'm looking for, which is what I want, but if I leave that field blank, it returns every record, which is what I...

But if I want it to return records that match any of the three fields, wouldn't that require me to use OR? (Ie. WHERE field1.form = field1.record OR field2.form = field2.record OR field3.form = field3.record)

I seem to still be a bit stuck. What I have currently are three text boxes, each of which the user may or may not input text into. Upon clicking a button, I run a query on a separate form which filters based on criteria such as Like "*" & [Forms]![frmConflictSearch]![Date of Accident] & "*" for...

Thanks! I managed to work something out using that code you gave for the query.