Search results

Updates - this looks at the Before Update event

Per our discussion

Well, I'm very glad to hear that. It's always nice when something works :)

Create a separate table for each selection (Soldermask, Legend, Carbon, and Scoring) then leave the Control Source and Row Source blank for the comboboxes. Use a case statement for the AFTERUPDATE event of the Checkboxes. (you can search the forum for more on that). Then depending on the case...

You need to add a textbox to your form (visible or not) it's up to you - that has its control source set to the bookingID. Then change the SQL to: AND ([BookingID] <> Forms!yourform!txtBookingID) txtbookingID will be the name you gave the control that holds the value for the field BookingID...

If you don't have a PK then you need to add one. You can call it BookingNumber. Make it autonumber and designate it as a primary key. Once you save the changes, the table will update and assign a record number to each record. After that, the query will work. As far as VBA, there is little...

Well, someone else might have a better idea, but I would think in order to exclude the current booking you would have to have a way to discriminate it from anything else. Otherwise I don't think a query would be able to be written in such a way as to exclude it. You could add a visible but not...

On the coast near Savannah

You can include an additional qualifier for the query like dates between AND [booking number] <> current booking number. That way it won't include the current booking. You will have to work out the specific code because I don't know what your db fields are. But I presume you have some unique...

I think a query would probably work well in this situation. A simple example would be something like: WHERE Bookingdatefromtable Between Forms!yourformname!yourdatecontrolStartDate and Forms!yourformname!yourdatecontrolEndDate ORDER BY Bookingdate This would list all the booking dates...

Unfortunately, that is the "quick fix". Access is a great program, but it has some noted limitations.

I have included a small program here that has the non-active X calendar in it. I added a Survey Date to the form to show you how it would work. to Use the calendar as an imput tool, double-Click in the Date textbox (the calendar will pop up) then choose the date and double-click on it. It...

I wish I could help, but I don't use calendars that rely on Active X controls. :)

As long as you had a table that had all the possible login names for environ (UserName), then the method would be the same. You would use the Environ(UserName) and assign it to the USER public variable. That would then be matched to the Name and AccessID level in the table. Because the...

The level of access is AccessID. (but you could call that field anything you want) Then have a simple login screen to validate the login user. Assign that login name to a public variable (I called it USER) and use it as a match against the table. When the user activates that form, it will load...

Yes, you could create separate data tables for the combobox and use the Onload or OnOpen event to populate it based on the Username/level. Something like: If User.AccessID = 1 Then Forms![frmYourForm]![frmCombo].RecordSource = "tblOne" Elseif User.AccessID = 2 Then...

You're welcome. And your query looks like it will work just fine. Personally, I like this style of query because you can filter as much or as little as you want using the combos.

No, The search form is supplying the information to the query. The query looks at the search form and filters according to what is selected in the combo boxes. If nothing is selected, it will return all the records - if one or more combos are not null - it will filter according to those...

Attached is a small example of a form that does a search and then a report based on that search. If you want to add a date range, just use two unbound textboxes (named something like txtBeginDate and txtEndDate) and add the following to the WHERE statement in the query that runs the Search Form...

Try putting the below code in the event that you want to load the date. I put this in the double-Click event of the textbox that holds the date on my form. That way, the user has to double-click the date on the calendar to get it to transfer to the textbox on the form. So, they would...