Recent content by mestst64

I have a combo box with 2 selections to choose from. Next to the cbo is a text box. Entries in both boxes will add a record to their respective control-source fields in the main table. If "selection1" is chosen in the cbo, I want the user's entry in the text box to be limited in format to a...

If / Then Error Message I have the following code in the After Update event of my combo box and the On Current event of my main form. If I try to open the main form, I get an error message that reads: "Compile error, Block If without End If" (it also highlights the End Sub in blue). If I...

John, Refering to your first reply in this string, 1) First, I want only one of the three subforms to become visible based on selection in combo box. 2) I want that subform to be in either add-only or edit-only mode when it opens (with all records shown). 3) I want to allow the viewer to be...

John, Yes, but your button allows both add and edit, and it's very important for my database that only one option is available at a time. Am still going to work on this however, and in the meantime, if you have any further suggestions, please post. Thanks!:)

John, Thanks again! Having the form open in one state and using the button to switch to another may cut my option group in half (great!). I'm new to code; how does AllowAdditions compare with acFormAdd. I was wondering if I could use acFormAdd and acFormEdit as my controls, but would that...

Thanks very much John - I will try this (had used this with option buttons in another section so it sounds like a good idea!). Any advice on how/if I can tell each subform to function in either "add" or "edit" mode? :)

Combo boxes cboTN and cboSB are on my main form. cboTN is a search combo box that updates combo box cboSB with one of 3 values (ID, IDC, or MC). I would like to do the following: 1: If the after-update value of cboSB is ID, subform sf1 will be visible. If the after-update value of cboSB is...

What I discovered works (although I'm still open to better solutions) is creating a command button on another form that opens the target form (with no adjustments to default settings) using the following On Click code: Private Sub cboEdit_Click() Dim stDocName As String Dim stLinkCriteria As...

I have a form with 4 combo boxes. Box 1 is linked to a unique indexed field of my main table and does not allow duplicates. Is there a way I can enter selections in the other 3 boxes and save only those 3? (these do not add data, but edit an existing row in the main table) Experimenting, I...

The form is set to Data Entry "Yes". If It's set to "No" it doesn't allow me to make any Edits. Is there another solution? The form's Record Source is my main table of data which has hundreds of entries. The Row Sources of the 3 combo boxes on the form are either queries or tables related to...

I set my form in Design view to Allow Edits but not Additions, and when I switch it to (or open it in) Form view, all the combo and text boxes and buttons disappear (the background color and header are all that's left). All I want to do is edit existing records through the combo boxes. How can...

RG, Thanks. Forgive me but I'm new to SQL, could you elaborate, or provide a brief example? much appreciated---

I have a query that brings up a job#, its start date (mm/dd/yyyy), and its priority status (Low, Medium, or High). Is there SQL I can use to make another query that will look at the start date, and if it is a week old, change the priority status to Medium, and if it's a month old, change the...

Solved with answer in another posting--- I simply added a '3' argument to the following portion of my code: DatePart("w",[MyDateField],2) so it now reads: DatePart("w",[MyDateField],2,3) Which eliminates week '53' and combines the totals for week 12/26/05 as week '52'

Got it figured out (with help :) ) DoCmd.OpenReport "MyReportName", A_PREVIEW