Search results

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...

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...

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...

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...

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...

I have the following expression which works nicely to group all of my dates into their respective weeks of the year, by week dates beginning Mondays: WeekStart: ([MyDateField]+1)-DatePart("w",[MyDateField],2) However, since the week beginning 12/26/05 crosses over both '05 and '06 (as week 53...

I created a combo box that runs a parameter query based on the name entered in the box. Is there some way to return the results as a report instead of in datasheet view? I'm wondering if inserting some sort of code into the event procedure of the "OK" button (which launches the query) would...

I have Datein and Dateout fields with many rows of dates beneath each. I used DatePart in a query to convert each date to a week number; but now need to count, and total, how many times each week number occurs under each field. I'm sure this can be done easily, but I'm new to expressions...