Search results

I want to populate a field based on what the user has entered into a field on the same form. I'm familiar with subforms but in this case I want to filter the data submitted to extract only the 3rd, 4th, 5th, and 6th digits from a 7 digit charge code. I have created a query that does this...

Nevermind Nevermind...I started playing around and realized that in table design mode you can select both fields and click the primary key button to designate both as pKeys. I had been trying to do it in the indexes dialog box.

This is probably an easy one for most of you, but I've never done it before and the help file is not very helpful. I want to combine two field in a table to create my primary key. The particular table is a junction table I've created to take care of a many to many relationship. I've tried...

Thanks! That's been bugging me for quite a while.

GoToControl worked perfectly! Thanks so much.

I have a data entry form with a clear/cancel button that runs a macro to delete current data in the form. I'm having a problem when there is no data in the form and the delete button is clicked(the macro throws an error). Can anyone suggest an easy way to solve this problem? Thanks for your...

Does anyone know how to make font bold w/in a Yes/No message box? My message box code is as follows: If MsgBox("Are you sure you want to quit?", vbYesNo + vbQuestion, "Run Macro?") = vbYes Then DoCmd.RunMacro "mcr-CloseEdit" Thanks

I am having a problem with a form I created that I'm sure has a simple solution. I put a command button in my form to insert a new record or go to the next record in my DB. Unfortunately, when the blank record appears the focus stays on the "next" button and I want it to go to the first tab...

I am including a message box at the beginning of my macro to ask if my user is sure he wants to run the macro. My problem is the message box available in Access gives several types of message boxes (ie. warning, critical, information, etc.) but none that let the user say no. I want my user to...