Search results

That is your problem then...The combo returns the numeric ID and you want to use that to filter the textual value. You need to include the OrderStatusID field in the form record source and modify the Else clause to use that instead of the OrderStatus: Me.Filter="OrderStatusID=" &...

So both the unbound search combo and the bound one you have in the form only have one field - the Order Status (text)?

Are you using lookup fields at the table level by any chance. If yes that might be the cause of the issue.

Try Me.FilterOn=False to turn it off and Me.FilterOn=True to turn it on. EDIT: here is your modified sub: Private Sub OrderStatusSearchBar_AfterUpdate() If IsNull(Me.OrderStatusSearchBar) Then Me.FilterOn = False Me.Filter = "" Else Me.Filter = "OrderStatus='" &...

Colin's link looks great and would probably give you what you want and much more! My idea was just a simplistic approach of using text boxes placed on top of the map image, having them bound to the coordinates for that map square and manipulating those. Cheers,

Why not just save the map as a jpg or png file and set it as the background image for a pop-up form; use Docmd.MoveSize to control its size and position in the open event and add text box controls bound to a table holding your coordinates (or even better combo boxes that can display your...

Yes, the switches apply to Word mail-merge fields (as implied by the OP in the first post). Cheers,

Look up Word mail merge switches: http://www.gmayor.com/formatting_word_fields.htm Here is the one you need in this specific case: https://answers.microsoft.com/en-us/msoffice/forum/all/apply-uppercase-format-to-merge-field-without/0626fb13-c3ab-4b2e-a302-aacd1f1815fd Cheers,

(y) :) You're very welcome!

You simply replace the original line with something like this: CITC = "[tStfDept] Like '*'" Showing your full code usually is the best way to get targeted help :). Cheers,

You need to use the Like operator with * instead of equal.

I also use a starter app similar to Colin's, here is a link to it: http://forestbyte.com/ms-access-utilities/fba-db-launcher/ Cheers,

This statement's attempt to open the form at the desired record: If Me.TranTypePK <= 2 Then DoCmd.OpenForm "frmTransactionsMain", , , "TransactionsPk=" & Me.TransactionsPK, , , "Receipt" End If is negated by this one in the target's form Open event (specifically the .RecordSource...

You are reseting the RecordSource property in the open event which forces a requery; comment out or remove all three .RecordSource = "SELECT *... statements.

Could it be that the form gets saved with some filter or order by properties, can you try to clear those in the open event of the form?

While the script does include backing up the original file I think it is missing a (very) important step; copying the original file first to the temp location (which should always be on a local drive) and actually compacting that not the original. Errors during compacting a large back-end...

http://forestbyte.com/ms-access-utilities/fba-ms-access-back-end-compacter/ Cheers,

You're very welcome, good luck with your project! :)

Please have a look at the attached updated file, should do what you want. While you are actively selecting a contact in the combo the rest of the records with a different denomination will look blank but they'll get reset when you exit the control. Another alternative is to us a hidden text box...

Maybe something like a custom chat message would work that pops up saying the treatment is available. Here is a sample:http://forestbyte.com/ms-access-utilities/fba-ms-access-custom-chat/ Cheers,