Search results

Looks like If CountriesFormPass = "pass" Then DoCmd.Close acForm, "Countries" End If

Actually I'm still missing something here. When the button is clicked to close the form the beforeupdate hasn't taken place so at this stage I don't know if there are any errors as the variable won't have been set. I told you I'm cracking up

D'oh!! Thanks.

I want to validate the fields on a form over and above the definitions that exist in the data definition (i.e. numeric, must be filled in etc). I thought all I needed to do was put a bunch of ifs and elses in the beforeupdate part of the form with a setfocus a cancel = true possible a me.undo...

I have a custom ribbon set up in usysribbons. The ribbon is so the user can navigate around his forms The ribbon contains some access commands that I've put on whilst I'm developing it I want to be able to dynamically alter the ribbon depending upon 1. whether or not it's me running it. if it...

I couldn't resist in trying this. I can concatenate my numbers in the query but can't separate them So if i put Expr1: [Units] & [totalwithtax] i get the righty figures but if I put Expr1: [Units] & " " & [totalwithtax] i get data mismatch

thanks to all replies. i'm holiday at the moment and will take a look soon!!

I'll keep this simple to begin with!! I have various tables but basically a list of items sold against a date. I want by month how many items were sold per month. here is one order per month To get this I've used the query wizard. I did a bit of research and it seemed I needed a crosstab. THis...

A long shot but the backstage comes after the ribbon thingywotsit i.e. </ribbon> <backstage> <tab idMso="TabPrint" visible="false"/> <button idMso="FileExit" visible="false"/> <tab idMso="TabOfficeFeedback" visible="false"/> </backstage> </customUI > Yes I do know you can bypass it all...

Don't know but I'm like a dog with a bone at times!! Anyway managed to get rid of it by using <tab idMso="TabOfficeFeedback" visible="false"/> Now all I need to know is how I can put a custom one in there which says "I told you it wasn't in use!"

Thanks for the replies. I'll look further into them but first an update I've just discovered the Allow Full Menus option in File/Options/Current Database which gets rid of most of the options under File. Some of my backstage options are now redundant and I can get rid of them (they produce...

I have a custom ribbon defined in USysRibbons and I want to get rid of the access File tab. Researching this I haven't found how to do this but found something that suggested using backstage to hide all the options under File tab. I've successfully hidden a few using <backstage>...

I don't particular like them but I've tested mine to death and all appears ok. There's a system message if they try and do anything stupid which I can live with (although I prefer to cater for it myself) I haven't the time at the moment to look at yours as I've spent far too long on this...

Got it working using an input mask and defining field as decimal to a scale of 2.

This works but you still need an input mask because you can still enter more than 2 decimal places but it ignores 3 decimal places onward

it works using scale of 2! i'm sure i'd tried currency along the way but still had weird results

I did try it but didn't realise what scale was. I assumed decimal places limited the number to the specified amount. I guess it means what it's rounded up to. I'll give it a go. What I have above with the input mask works in the main and the problems I can live with except for one!! I wonder...

That works to some extent but you can only enter 0.01 to 9.99 with no minus. If you put a space at the front it doesn't matter as it's accepted by access and is treated as a zero which you may want but you can put in 1. 2 as well instead of either 1.2 or 1.02 The input mask I have at the moment...

I had a quick go. Not sure what input mask I should have but I tried with 99999.99 but it looks like he then has to put in 00012.12 for example which will soon get on his nerves. It also displays that as something like _____.__ which looks naff. I think I can change that display but not explored...

I thought it was only dates that I couldn't fathom but now I'm stuck on numbers! I want to limit the user to 2 decimal places when input on a form. I can only get as far as displaying the rounded 2 decimal places but can't stop him putting in something like 231.1278364731. It will display as...