Search results for query: *

I have been given a database and they are asking to have the capability of filtering data for all items in the Retired box that are checked. How can I make this happen? Thanks for any/all help.

Good Morning - I have a database that I am creating, moving it from Excel to Access. Need to be able to do conditional formatting in cell for Status which includes: On-Track (Green), Concerns (Yellow) and At Risk (Red). Is there a way to do this in Access? Any help would be appreciated...

I already have a new record button, but unfortunately some users are not using that all the time. I just thought that maybe there is a way to make the field blank so even though they put the information in and when asked to add to list it wouldn't override the other SSN.

That works but the problem still when you say edit and you type in a SSN that is not in the database it saves a new SSN but it is not making the rest of the form blank. It is keeping whatever information that was in there there and overriding the other SSN. For example: In database have SSN...

How do you make a form uneditable?

The user found a problem with the code listed below. If they happen to type in the SSN in the form where another document was already opened. When it ask if they want to add to the current list it overrides the SSN that was originally there and put the new number in place of the data. Is...

Thank you Paul that works. Thank you so much for helping me with this.

Hello PHV, Did your code and it gave me a Run-time error '3426': This action was cancelled by an associated object. Hello Paul, Tried your code also and it brought me to the first record as my code is doing now.

Hello PHV, When I put the code in after it says "This SSN already exists." The field goes blank and doesn't bring up the information.

missinglinq, I tried as listed below and it still doesn't work. Private Sub SSN_BeforeUpdate(Cancel As Integer) If Not IsNull(DLookup("[SSN]", "Security", "[SSN]= '" & Me![SSN] & "'")) Then MsgBox "This SSN already exists." Cancel = True Me.Undo DoCmd.GoToRecord , , acFirst...

Hello AceMan, If the SSN exist I want the record to open up.

Right now if I type in a SSN for example:111-11-1111 and it says it already exists. Instead of opening that SSN with the information, it opens the first record (totally different SSN). Is there something else I need to add to the code listed below? Private Sub SSN_BeforeUpdate(Cancel As...

Can someone please help me with this. I just don't know why it keeps going to the first record instead of opening the record with the SSN that was put in.

Thank you pwise - works perfectly.

Is there a way that I can: 1. Set a function that a person cannot put in a wrong date in the TO DATE. For example: FROM DATE 1/29/2007 TO DATE 1/30/2006. Want to not allow that to happen. 2. Do not want in TO DATE to go over 365 days from the FROM DATE.

Right now if I type in a SSN for example:111-11-1111 and it says it already exists. Instead of opening that SSN it opens the first record. Is there something else I need to add to the code listed below? Private Sub SSN_BeforeUpdate(Cancel As Integer) If Not IsNull(DLookup("[SSN]"...

Hello Paul, I did what you said, see below but I am getting the following error. The expression AfterUdate you entered as the event property setting produced the following error: Ambiguous name detected: SelectOne_AfterUdate Private Sub SelectOne_AfterUpdate() Me.SelectOne = 0 End Sub...

Thanks so much for your help with this.

It is number 2. How would I go about bounding the field in the RecordSource?

Paul - when I do it through the toolbar; when I go out of the database and come back in the option I selected was no longer there.