Search results

I've looked all morning for the solution and the second that I post the question, I found it by myself - again! If Me.OrderByOn then With Reports("rpt_PtNoBeginsWith") .OrderBy = Me.OrderBy .OrderByOn = True End With End If

thanks, Paul. It does work and it's cleaner. I did just notice however, that it's only preserving the filters from the reports, but not the sorting order (which makes sense, given there's no mention of sorting in the code.) How can I include the sort order from the form on the report?

i actually found the solution on a previous post (similar problem - same solution) Thank you "Sergeant"! DoCmd.OpenReport "MyReportName", acPreview If Me.FilterOn Then With Reports![MyReportName] .Filter = Me.Filter 'Use the filter from the calling form. .FilterOn = True End...

Good afternoon/evening! I have formatted form based on a query, that allows users to double-click some of the form headers, and access the Quick Filter menus, tailoring (and sorting) the form for their specific needs. I also have a report based on this form - same information in a...

Hi! thanks for the quick response! FilterOnLoad - "no"

Hi! I have a form that's been working just fine for months - until today. There are a total of 1015 records. I can see all of these records until I switch to Design View to make a change (formatting, etc) then when I change the view back to Form, the navigation counter still says 1015 but I...

Perfect! Super simple solution. Thanks!

Hi all! I'm trying to convert a well-used (and well-loved) Excel spreadsheet to a better-suited Access form and so far, so good. There is one feature from Excel, however, that I can't seem to duplicate in Access, and it's an important feature for my co-worker. He's become very dependent upon...

Thanks! Worked perfectly!

Hi! I have a form that has approximately 100 controls but I only need 10 tab stops. Is there anyway to set the tab stop setting to "no" in the property sheet, en masse, and then add it back in to the 10 controls? Thank you!

thank you, Minty, for the visual. I (think) that I understand what I need to do now. I'll work on it this weekend, and hopefully I'll be able to make my issue clear enough for resolution! Have a great weekend! Brandi

thank you so much for your time and patience. I actually figured out a way to do it by creating a query and then a Filter macro based on that query. I then made a button based on the macro. :) Have a great weekend!

Thank you! This an example of the expression that changes the formatting to RED ([PROMDATE]<Date()) And ([NOTE1] Not Like "*STOCK*") As you can see, it's not a complete expression because the Conditional Formatting drop-down menu takes care of some details "behind the scenes", I think. I...

I don't know how else I can explain it but thank you for time. Have a nice weekend.

tbl_SalesOrderDetail SONumber , IncomingPO S823859, E21595 tbl_OpenPO. PO, PODueDate, Vendor, POQty, Type, Size, Width E21595, 8/20/17, Acme, 10,000, 718, .030, 36 Would like to see additional POs that meet identical Type, Size, Width criterial

Thanks for the quick reply! My conditions have already been set and seem to be working great. What I can't figure out, is how I can copy these conditions as expressions (presumably "nested iifs") into the controls of a button so that the one "click" will apply the filters of 5 conditions all...

thank you for the quick response. Unfortunately, I don't know how to post forms/tables/queries. Query: tbl_SalesOrderDetail.IncomingPONumber >>>>tbl_OpenPO.PO returns tbl_SalesOrderDetail.SONumber AND tbl_OpenPO - [VendorName], [POQty], [PODueDate], [type], [size], [width] What I would like...

Good morning, I have a form that uses conditional formatting to color code an [OpenOrder] date field. There are currently 5 different conditions that result in four different colors for the field. The intended users of the form are not super familiar with Access so I'd like to create a button...

Good morning all, I'm not new to Access but I've been on Access hiatus for several years and I'm realizing that building databases isn't exactly like riding a bike; I've forgotten a few of the basics. I know this request is super elementary but I can't figure it out: I have a query...