Search results

When the form opens and the filter isn't working, does the filter property look like it's set to the correct value? If so, perhaps it is being set too late? You could add a message box to the form's OnOpen event and check what it's being set to at that point.

I've just set up a business and need to buy a printer. The majority of the time, it'll be used for invoices and straightforward document printing. Occasionally, however, I'd like to be able to print colour documents or even decent quality photographs using it. All of the printers I've looked at...

Is the form's 'Allow Filters' property being reset when the form closes and reopens? Something similar happened to me and that was the cause of it.

Try DoCmd.OpenForm "pvcAirCmp1LoadCus", acFormPivotTable, "", "[qryAirComprs]![fldDATE] Between [Forms]![frmHome]![AirCmpStartDate] And [Forms]![frmHome]![AirCmpEndDate]", acNormal

In the field's OnLoseFocus or AfterUpdate event, or in the form's BeforeUpdate event, you could use the DCount() function to see if there is at least one record present. e.g. something like If DCount("JobNumber","JobTable","JobNumber = " & [Forms]![formname]![Job_No]) Then Msgbox "That Job...

You could set the table property to not allow duplicates in certain fields or you could perfom a search before saving any changes, to check if the data is already in the table?

I think Toronto's got 17 degrees forecast for later this week, so you have my sympathy. I doubt we'll get the ridiculous minus figures for a while, yet.

A little overcast? Does that include the fog that's so heavy I can't see the ground from the office window? :D

As long as I amuse, the day hasn't been a total waste.

I found this out a little while back - about the site, not your head - when my Mother sent me a link to the area containing a house of someone we know, only for us to find that it was just a field. There is still a picture of a house my parents moved out of back in 2001 and you can clearly see...

Peut-être c'est en raison du point-virgule ayant été omis ? SQL = "SELECT * FROM vehiculo;"

Random I can live with. As long as I have my reason, it doesn't need to make sense :D

Originally Posted by Bodisathva Always on Thursday...the last Thursday of November. Thanks, both. How did that day get decided upon? I understand the whole Easter Sunday thing, but us there some significance - religious or otherwise - to a Thursday in November?

Once again, keep your private life out of it. ;)

Is it always on a Thursday or is the day less important than the date?

I had a similar problem and got around it in the following way. str_SQL = "SELECT * FROM Table1" If Len(combobox1) > 0 Then str_Where = " WHERE Person = '" & combobox1 & "'" else str_Where = "" end if str_SQL = str_SQL & str_Where & ";" DoCmd.RunSQL str_SQL If a value is...