Search results

This is something of a shot in the dark, but try forcing a repaint after you requery: If blnClassInfo_Open Then Forms("frmClassInfo").Visible = True Forms("frmClassInfo")!cboJudge.Requery Forms("frmClassInfo")!cboJudge.Repaint End If --Guessing Mac

Seeing as how you can export queries just as easily as you can export tables, I would leave the "888" fields blank in YOUR db (just because someone else does something the wrong way doesn't mean you have to), then create queries that rework the empty fields into 888's and do whatever other...

RG's code also gives you the important option of NOT setting certain controls to 888, such as the control that holds the Autonumber PK of your table, which you wouldn't be allowed to change (which is the factor that earlier stopped me from suggesting a for..next that loops through every...

I understand why you don't want to use a default value, per RG's suggestion. However, if you want to set a bunch of values without using defaults, you're going to have to do that somehow, i.e., "an if statement for every field". I would probably go with a statement in the BeforeUpdate event of...

Search the forum archives on "cascading combo". This has been covered many times. --Archival Mac

Check Access help on the "format" command, which you can use as an expression in your query on the date field in question. Or, if you are creating a form for the dislpay, you can change the format property of the text box to display "short date", leaving the actual data unchanged. I'm not that...

Not to mention WorkMad's idea (as I understand it) requires knowing ahead of time how many phases the delivery will be split into. IF I understand what you're doing, there is an underlying fallacy in your structure. Devlieries are not split into phases. You are either delivering something or...

There are several discussion threads on a similar problem, people wanting to generate incrementing numbers but, for one reason or another, not wanting to use autonumber. Read MS Access help on the DMax function and search the archives here. --Maximum Mac

Also, check the relationships to see if "cascade delete" is checked. --Cascading Mac

in VBA, include the statement docmd.setwarnings falsebefore you run the query. More info on this topic in MS Access help. --Warning Mac

You should be able to refer to the contents of a control on a loaded form in your report header. Create a text box in the header of the report and set the data source to something like: ="Report up to and including:" & Forms!frmMyForm!txtMyControl Make sure the form is open when the report is...

Did you read this thread? --Curious Mac

May not be normal? Based on your description, it sounds like you might want to break the investigation info out into its own table. tblInvestigations would have a field fkAccidentID linking it to the accident record in tblAccidents. Just an idea... RG, what do you think? --Pondering Mac

If I understand you correctly, you can use IIF statements in your query design to look for checkboxes on your search form that are True (checked). In the criteria for that field in your query: = (iif(Forms![frmMyForm]![chkMyControl] = True,"XX","*")) Where "XX" is the two-letter string you are...

Duplicate Post Please don't post the same question multiple times.

Nz - Your Friend Not entirely sure I understand your question, but it sounds like you want to have a query that includes criteria for multiple fields (defined via multiple controls) which allows the user to leave any number of the controls empty without breaking the query. Yes? You need to...

Again??!??!! Did you search the forum archives before posting this? I'm guessing not, because this topic has been discussed in HUNDREDS of posts, including this one. If you are using them as intended, gaps in autonumber sequences mean nothing. If not having blanks is important, then you...

Awful, just awful... The standard ActiveX Calendar Control is a UI mess and has far too many problems. Check out this thread for a more useful control courtesy of guru Mile-O-Phile. If you search the archives you'll find a number of discussions on this topic. --Suggestive Mac

The Details... Expanding on Rural Guy's correct suggestion, Access was giving you exactly what you asked for. If your query searches for "*son*", then: "Good Son" "Son of Sam" "Samson" "Dry White Season" are all valid results because they all contain the characters "s", "o", and "n" in...

You can use just about any object as a button by making use of the OnClick event. You could make a button that looks exactly how you want by creating a graphic image in Photoshop/Gimp/Paint/whatever, placing it on your form, and using the OnClick event to make it behave as a button. Note...