Search results

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...

OK I think I know what I'm doing. There are multiple users but they look at their 'own' data so shouldn't be a proble.

OK understand the way this list box would work but don't think it fits in with the design I currently have. He'll have to do with the solution provided by MajP (thank you again). If he's not satisfied what I could do is add another yes/no field to the table. If he selects it then I can sum on...

I'll take a look but I'm still not sure what my form is going to look like!!

I can see a list box is a list of items. I can't see how to add that to my form. From my example on each row I have a sum, sum 1 sum 2 and sum3. Are you suggesting I have a list box on each row and the contents are sum 1,sum 2 and sum3? I may be a bit thick here but I don't get it!!

Thanks, I'll take a look. I know it's a pain as I've tried a few years ago and gave up. The user's current software has a real whizzy set up. As you scroll all controls change depending on their content. Looks really flash.

What I have is Row 1 sum 1 Row 2 sum 2 Row 3 sum 3 with MajP's original answer I can total rows 1 and 2, 2 and 3 but not 1 and 3. Not sure how a list box will help me here.