Search results

Thank you for input but that's the format I have for order input from the office & it just doesn't work on the tablet...

Would that automatically see the selected record?

But Tried that but it's not that great tbh - more responsive to fingers - cheap tablet with generic screen protector (only one available) & not very responsive... & they'd loose the stylus :-)))

The one at a time method of entering products helps with having space for product notes (each item is prepared to order), questions, the search function (they have a lot of products), the kg to lb button, still leaving space for the pop up keyboard on the tablet (no space for attached keyboard...

Main order form ;-)

Thanks Gasman :-) but probably better using a button - butchers have fat fingers :-) and it's for use on a tablet. How do you refer to the currently selected record in vba? Sorry I'm a zilch coding wise :-/

Hi, I have a main form for creating/editing an order, a pop up subform for adding a product to the order and from there a pop up form to search part of the product name if they're not sure what Prod Type to use to filter to the appropriate product - the Search Part pop up is of necessity in...

Thank you - useful!

Hi @arnelgp Could I use that code on an unbound combo box with horribly messy row source: SELECT DISTINCT TypesAll.TypesAllID, [Type] & " " & [SubType] AS FullType FROM (TSub INNER JOIN (T1 INNER JOIN TypesAll ON T1.TypeID = TypesAll.TypeID) ON TSub.ID = TypesAll.SubID) INNER JOIN Product ON...

Useful thread - thank you!

A wee update on this - decided to subscribe to Microsoft 365 and delete all old programs & magically everything started working.... order numbers in subject lines, customer emails inserted no problem & confirmations sending fine :))))

In absolutely the same manner - I've tried refreshing/saving/closing my eyes ;) before sending a new order confirmation but each time on the second confirmation access crashes. I'm thinking I'll give in and ask them to use the snipping tool :-/

I don't seem to be able to be able to change the current network profile on the laptop Windows 10 v1607 to private - which it needs to be to enable printer sharing.

Sorry I'm punching well above my weight here... I can email an order confirmation once but if I try a 2nd confirmation Access crashes - seems to be a known problem. So as a work around (...that I understand :-/) I decided to export it to a file and email from there - didn't work either - get the...

Can you/how do you refer to the email address in the record of the filtered Report you want to send or is this better done in VBA?

Thanks :)

Deleted it all in frustration :) There has to be a sensible way to highlight the button that has focus - or do you need to use the labels?

Hi can anyone tell me a simple way of highlighting buttons on a form when got focus - tried changing the background colour but the decimal colour values are giving unexpected results.

Thank you :)