Search results

That didn't work either. That's okay. I've got code for any changed data in the whole form that asks to the user if they want to save on close. I was just going to for a little bit more dummy proofing.

I put the code in the "before update" of the checkbox on the form. Is this the correct spot? When I put the code there and remove the check on the form I get the prompt. I click "no" to undo, but the check remains gone fromt he box.

I have a form with a checkbox for the field "active". By default the box is checked. I currently have code to prompt the user if they have added or removed the check and asks if they would like to undo the action however if you undo the action it doesn't undo anything. Here is my code...

I tried you code to see if it would work. The cancel still allows the cursor to move to the next field. I think i'm just going to put the code in the save button.

Thank you for the quick reply. At this point I think I may contact the main user of the database to see if they are okay with having the SSN field blank. Any search options I have that could include the SSN use IsNull or Like in the search so it won't matter if the field is blank. They may be...

I have a field for SSN that I would like a prompt to let the user know that hey haven't entered a SSN. This field isn't required, but can be very important. If I use validation text or requirements some users may get annoyed especially if they don't have the information. So, if the field is...

It may be helpful to know that the paragraphs that were entered in to access were copied and pasted from Word.

I currently have a report created in access 2007. It prints fine on my PC. I split the database and put it on another PC and ran it using Access Runtime 2007. One report has a list of items like 1. text paragraph 2. text paragraph etc. When I print this report on the other PC I get a character...

The data will not altered in the view. I currently have a form that is used to enter the contact name, title, phone numbers, etc. I have another form that is displaying the records in a continuous form. That form has a few buttons in buttons to change the orderby of the form so there are...

I've added an address book to my current database and I was wondering if there was a way to view the records tiled similar to that of Outlooks adderss book. So far the best solution I have come up with is to just use a continuouse form, but that still just gives me the records vertically. I...

Thank you soooo much. That worked. I was trying different If functions and everything else. I guess sometimes we overlook the simplest solution. Again, thank you.

I currently have a query that I use to search records by firstname, midname, lastname. The criteria is entered on another form. The query pulls the data from the form to fill the criteria. For example, the query has the field "Firstname" and the criteria is - Like "*" &...

After plenty of searching I found the answer to my problem. This solution uses a module, 3 images for the button (up, down, and highlighted), and a cmd button. The module is long so here is a link to the site http://www.tek-tips.com/faqs.cfm?fid=5307

I was wondering if there is a way to layer images for the use of buttons, for example, have the first image for the button, the second image for the button highlight on mouseover, and the third image for button clicked. I've tried to use mousemove, on click, with variations of image.visible =...

Well I believe I've found the issue. Because I'm importing from Excel which has the social security numbers with the dashes in them the mask does me no good. The mask has the dashes in between the numbers, but the query is not reading those as characters that match. If I actually enter the...

Actually, here is the criteria from the query, copied and pasted. Like "*" & [Forms]![SSN Search]![SSN] & "*" What I don't understand is I just run the query, I get a box that opens saying enter parameter value Forms!SSN Search!SSN, and I can enter a SSN and the query finds the person no...

Right now I have a table that has "FirstName", "MidName", "LastName", "SSN", and "DOB". To help make searching easier to find data I have a form based off a query that pulls all of the above data, but the "SSN" criteria is base on Like [Forms]![FormName]![SSN]. This way the user can open a...

Thank you.

That worked perfectly. I was looking at a few count options. I've never used count, dcount, lookup, etc in a report. With no matches I get a result of "0 matches found" now.

I have a report based on a duplicate query. If there are no duplicate reults I would like for the reports to say "0 matches Found". Actually, another good idea might just to be have the report count the matches so it says "2 matches found" or "6 matches found" etc. Any idea on how to do this?