Search results

Fantastic !!! Thank you

Thank you all, I understand the principle and should be ok from here. Again, your help is very much appreciated :)

Hi, I have a Cost field & and a calculated Price field generating a sell price ( calculation *1.16 / .75 ) How do I add to the expression [Cost]*1.16/0.75 to round UP to the nearest 50 E.G. - My cost is 1119.35 generating a sell price of 1731.26. I want this to be 1750 I hope this makes...

Thanks MajP. I think this is the source of the problem. Appreciate your help

That's what I thought, but I get a Syntax Error.

Hi, I' trying to add todays date to a field on double click. I've tried the =Now() function, which works, but also gives me the time. What is the function to show the date without time. Thanks in advance :)

Solved For any others requiring this function Created a txtbox(Text14) in the subform footer - =Count(IIf([Ordered]=False,0)) On the main for txtbox - =[SQteTbl subform]![Text14] Big thanks to Mike Krailo, massive help :)

Noob Question. I have this control source in a text box; =([Enquirymaster100 subform].[Form]![REF NO]) When the result is blank I get an #Error message. How can I say if blank return blank?

Mike, Thank you so much, that's exactly what I'm looking for. Very Much appreciated !!

I cant supply the DB as it contains 'sensative' info. I have a subform - SQteTbl When we quote customers a new line is added, so SQteTbl can have many rows. When they order, the row remains but is ticked as ordered. I want to conditional format a text box orange when there are un-ticked rows...

Thank you for your replies. I'll battle on, I'm sure I'll get there :) (Hopefully)

Hi GPGeorge, almost . . . definitely closer. Only problem is when there is no record (blank subform) its it acting like its a false, so highlighting oragnge. I need to use the Excel formula - If "","",

Hi, I hope you can help. I have a Subform (SQteTbl) on my 'Heatmaster' main page which shows customers quotes we've sent SQteTbl has a True/False field, 'Ordered' - This is ticked when a customer places his order (so some records may have e.g 3 ticked, two unticked). I want a conditional...

Hi Pat, Thanks for your reply. The Windows folders keep correspondence sent by the customer (H1402 - Jacks Bakery). It contains email correspondence, jpg's , safety sheets etc. I have a hyperlink to open the 'Customer' folder - \\SERVER\Works\Customers - then scroll down to the one im...

I have a db with around 3000 records, numbered H1 to H3000. I also have folders on the system where I keep photos relating to the customer, again numbered H1 to H3000 but with the customer names next to them; Like H1402 - Jacks Bakery. Is it possible to have a custom button that would look at...

Thanks Plog, I dont really need to disable anything, users can still make changes, but i want them to know they're on stop. The staff are good enough that they wont offer assistance until any debts are paid Ideally, I want to open / close a PNG picture using a toggle button. Is this possible?

Hi, I have a list of customer accounts, some of which don't pay and I want to put their account on stop. I have tried a text box with conditional formatting (red), but it looks a bit naff I'm looking at putting an "On Stop" button on a form, which then displays 'On Stop' across the entire...

Awesome, Thank you!

Hi, Can anyone tell me what these symbols mean? & Why would I have 2 types?

Does any have a U valve / heat loss calculator in Access I could have? I have one in Excel, written many years ago by someone else and very long winded. There are plenty on the internet but I'm looking for an access standalone program I can incorporate into our database system. I know its a...