Search results for query: *

Okay, I'll try it first thing in the morning AceMan. Right now I'm soo tired. Thanks, and I'll get back to this thread tomorrow. Al

Okay, but which control? The combo box or the option group? If you would like, I have a 'sanitized' copy of my database without sensitive information. It is a zipped file, about 200Kb.

AceMan, I checked, double-checked, and triple-checked the "Back Style(s)" of both the combo box control and the option group control. All are set to 'Normal'. I even changed the "Back Color" to be the same (white) as the combo box. Still nothing triggering. However, I can set the "After...

RoyVidar, Yeah, I already figured that out and set the BackStyle to 'Normal'. I thought I had it fixed, but this still didn't yield the results I wanted. Do you have another way that I could make this happen on the 'After Update' event for this combobox? Al

I have been working with the "After Update" Event Procedure on a particular control. I've got it worked out to where my "IF" statements are doing what I need them to do, with one exception...the one where I want to BackGround to change color, doesn't. Here is my code: Private Sub...

Golom, Thanks. Before I was able to copy and paste your SQL code, I manually tried to do it (again) in the Query design grid. For whatever reason, it worked! However, you can bet that I took your build of my information and saved it as a 'How to' document. I've learned to 'journalize' all...

Lilliabeth, no, an APPEND query would just 'add' records to the end of the table, right? I only want to add the information contained in the fields from one table, into newly-created fields in the Main table...you know, filling in the blanks. For example, let's say my Primary Field is...

So, you're saying that I will have to plug in my table names (bracketed...because there are spaces?) and ALL of the fields from both tables? Or just the pertinent fields that will be integrated into the Main table?

I have two databases where there is redundant information. In other words, instead of just creating new/additional fields, the user created a new database with a table containing several fields from the previous Main table, and the new 'additional' fields. Since the tables contain many of...

Okay, I finally figured it out. Here is the final code...but with a problem at the end; Private Sub cboCountryPage2_AfterUpdate() If Me.cboCountryPage2.Column(3) = 1 Then Me.optgrpSIRCountryPage2.Value = 1 Else Me.optgrpSIRCountryPage2.Value = 2 End If If...

No, the values are the same (YES and NO responses...). Yes = 1 and No = 2. The only difference is that column three is the "Special Interest Country" and column four is the "Other Than Mexican" response. This is why it is puzzling. I thought that if would simply be a change in the column...

This post relates to my previous post (thread702-1148781) where I needed to cause an 'option group' to return a YES or NO response depending on what value was selected in a combo box. I figured it out with the help of Xiciana, but now I've realized that this combo box should also trigger...

Remou, I kept searching through this forum (archives) and I found the following code...THAT WORKS (for me)! Private Sub cmdFindFirstNamePage4_Click() On Error GoTo Err_cmdFindFirstNamePage4_Click ' Screen.PreviousControl.SetFocus <-- Comment this line out...

Oops. Maybe the above code ISN'T what I need...then. How I have this set up is that every pertinent field (possible field that would be used to search for a record) has a command button on it. I used a little bit of code that calls a MACRO from a macro group. Since this database is becoming...

...As Recordset Dim strSearchName As String Set rst = Me.RecordsetClone strSearchName = Me.txtSearch rst.FindFirst "PolInsured Like '*" & Nz(strSearchName, "") & "*'" If rst.NoMatch Then MsgBox "Record not found" Else Me.Bookmark =...

rubbernilly, I finally got my code to work (with the help of a few other Access experts...and looking in books, web, etc.). Here is the final product; Private Sub cboCountryPage2_AfterUpdate() If Me.cboCountryPage2.Column(3) = 1 Then Me.optgrpSIRCountryPage2.Value = 1 Else...

Xciana, I finally got it to work. Here is the final code, used on the 'combo box' After Update event; Private Sub cboCountryPage2_AfterUpdate() If Me.cboCountryPage2.Column(3) = 1 Then Me.optgrpSIRCountryPage2.Value = 1 Else Me.optgrpSIRCountryPage2.Value = 2 End If End Sub...

Xicana, I tried to use what you gave me...and it almost worked (I think); but it hung up on the first statement after the 'Else' operator; Private Sub cboCountryPage2_AfterUpdate() If Me!cboCountryPage2.Column(4) = True Then Me!optSirCountryYESPage2 = True...

Okay....let me repost this in a more (hopefully) understandable read: ===================================================== I have a combo box that is based on a table (tbl DACS Country Code Table) for the values. This table contains all of the possible country codes that we use in our office...

Well, I tried the following (and various others) but it's like threading a needle in the dark! I am putting it on the 'After Update' Event Procedure of the "txtCountryTableTextPage2" text field: Private Sub txtCountryTableTextPage2_AfterUpdate() If Me!txtCountryTableTextPage2.Value = 1 Then...