Search results

One other thing. The form when opened, opens at the top of the screen regardless of the property "Auto Center" being set to "Yes". It's as if Access is still positioning this as if the form was the previous height yet the InsideHeight is restricting this size. Any ideas how I can get this to be...

@missinglinq: This is a kb database used by myself. The form is too long and the data that I want out of view is only used occaisionally. The important information will stay in view but that is all that's needed in view. It may be frowned upon by developers but is what I'm after regardless...

I've been asked to upload a stipped down version of a database before and thinking I had, I was told I hadn't done this properly....Felt a little naughty ;) Is there anything special I need to do to the database before I upload it? @Peter D: As mentioned the AutoResize property is already set...

Yes I have and looks to be what I want but the form I want to add this to doesn't have a subform with the relevant data displayed in datasheet format. I have all my specified fields layed out in the detail section on a Continuous Form rather than a subform. Is it a case that I can't do what I...

Sorry for being a little dumb but how do I loop through the controls collection of the form? Am I creating a macro for this button and setting the command from this?

The Auto ReSize Property has already been set to "no" and changing the height manually just springs back to the ful size when clicking off the property. Sorry should have been more specific. This is what I meant when I said I had changed a few properties already!

Single Form.

Can I not just add a text box and attach a macro to this which will apply the filter in real time? This appears to be how the Quicksearch box is constructed on the demo template I initially posted.

Hi I have done a search but can't find a thread relevant to my specific issue. I have a form which opens in a separate window centrally on the screen. The content of this form extends the full height of the screen but want to restrict the height to a fixed size yet when attempting to drag...

Good idea. Care to tell me the code for making highlighted text in any field on a form bold!? I've tried "Me.Selection.Font.Bold = TRUE" and variations of this but not joy!!

Many thanks for the reply. I'm aware that the ribbon replaces toolbars but was hoping it was still possible to add a toobar of some sort to a modal form that the ribbon can't be used on. Basically I want to add the format text options to the form rather than using the context menu that...

Hi Can someone tell me how I can add a toolbar ie. Format options, to a specific form in Access 2010. Is this actually possible?

Yes sorry you're right. I posted that before I actually tried however my form's already in place and so need something that can be simply added rather than a redesign which a listbox or a subform would require. On another note I have followed your instructions in the other thread and have...

This does look good although I'm more after an active search on the main form that will filter the rows as I type. The template that I mentioned in the first post does this but is on a tabular view rather than form. Is this even possible on a form?

Many thanks, I'll take a look at see how I get on.

Hi Looking at the "Access 2007 Assets Database template" I'd like to encorportate the search/filter box included in this into my own asset database. I've had a look at the properties for this text box to see what needs to be added to my form but so far haven't been able to add anything...

Many thanks. Works a treat :D

Hi A very straight forward question but am a little stumped at the moment. I have a conditional formatting rule: [StatID] Like "[4,6]" I would like to add the value "11" to this ie. [StatID] Like "[4,6,11]" but is read by Access as value "1". How do I force this to be read as "11"?

Got it "Me.refresh" Thanks again for all your help Missinlinq

Hold fire. I've added the code to both fields and is now working as expected. I thought you meant move it there!! Can I set this to auto-refresh the form as for some reason the "Warranty Expiry" field doesn't auto update when the "Date of Aqcuisition" is changed whereas it does when the...