Search results

further: running MsgBox Application.COMAddIns.Item("AccessPW.14").Description shows the description as "Microsoft Access Package Solution Wizard 2010 com addin" Anyhow, I'll be reading up on the ComAddin method today to try and get a better handle on this. Still can't understand why the...

Thanks for the reply, I don't have any add-in registered according to the Add-In Manager. however when running It says my add-in is AccessPW.14 so I suppose would do the trick. Where's the best place to put this, perhaps in a startup form? or does it have to run before that? Many thanks...

I’m using the following custom ribbon for print previews on reports (no add-ins tab). However, if I use the /runtime switch at startup the Add-ins tab appears and I don’t understand why. I’m struggling with Ribbons as it is as I don’t fully know how they work, I got the code from someone else...

Here you are

Make sure 'field1' is checked then either right click or in the ribbon select the format tab and then click conditional formatting. When the conditional formatting form opens click 'New Rule'. You'll want 'Expression is" in the first (leftmost) dropbox then use the wizard to set the expression...

Look at conditional formatting.

Thanks for the extra bit. In fact I've got an Admin form where I set a number of database startup options, and indeed the Allow shiftByPass is one of them. Of course looking at the example you've sent I'll be adding another option to change the default Ribbon to Null to accommodate the...

Brilliant, just brilliant. Exactly what I was looking for. Many Thanks SmallTime

Many thanks, worked beautifully. Saved me hours of repetitive stuff. In case anyone else wants to do the same thing here's how I ran Dave's code My regards to Gemma SmallTime

Fantastic, I'll play around with it in a while (just need to do homework with the kids first). Grateful thanks SmallTime

Glad to help. SmallTime

Is it working OK? Take a look at conditional formatting, In design view right click the text box and select Conditional Formatting to see how it works. You can't use code to change individual fields in a continuous form. Take Care SmallTime

Thanks Dave. It's a start and should make the changes a less time consuming Ta SmallTime

Here's the working file It's a continuous form for you have to use conditional formatting. SmallTime

Copy ONLY the relevant forms\tables\queries into a new database and post that. Also, I take it the textbox in question is named 'ServicePack' and not something like 'textbox1' SmallTime

Hi Using 2010 32 bit I need to change the following form properties to false for a large number of forms and was wondering if anyone knew how to do this through code and iterate through all forms in the database. I have a bout 7 databases each with about 100 forms so want to avoid doing it...

Ari, I give up can't get to grips with HML. Would you be kind enough to post the example when you have time. I want the print preview tab available, but with the backstage options disabled. Many thanks SmallTime

Hi, You could create the BE in pre-2007 (mdb) version with a secure MDW file and use the built-in user security\permissions, don't forget to remove all permissions from 'admin' and 'user' groups top prevent users from opening the BE by d.clicking it. SmallTime

Thanks Ari I'm going have a go myself and see how I get along, might learn a new trick or two, of course without doubt an example of how to disable the backstage and show the print preview ribbon would be most welcome. Regards SmallTime

Thanks for the reply. I'll start playing with your suggestion in a while to see how I can implement it. Must admit I'm fairly new HTML coding and only just starting playing because I had to make a ribbon but ended up coping most (ok all) of the code from http://www.accessribbon.de/. A very...