Search results

Very true.

Thanks Brian, I can't believe I didn't try this as is obvious now. Working a treat :)

Thanks for the reply and can see that this would be what I'm after but how do I get it to prompt for the date? <DateAdd("yyyy", -5, #01/05/2015#) would obviously show me data before 01/05/2010 but I want this value to be entered at query run which is why I want the prompt.

Hi, I've found plenty of help in regards to querying a field for a number of days from today's date but not had a lot of luck finding how to query this from a date in the future. Currently I have as criteria for the relevant field: <[Period Start (dd/mm/yy - less 5 years from financial...

Hi, I'm looking to make a text box scrollable using the mouse wheel. I know this question is often asked and have found the response is usually "not easily" but I'm half-way there with the following code: If Count < 0 Then '~~> Replace Textxx with the name of your textbox If...

No, it's definitely a Text Box control. Not to worry though as is working fine at the moment. If it does start failing I'll look at re-adding it as you suggest. Thanks again.

Hi Paul, Yes it is a control as "Username" appears when completing the above however "user_name" also appeared and have tried this with success. Not sure where this has come from as the field doesn't have the underscore present anywhere I can see!! Thanks for the help regardless

Hi, I have a form with two Text box fields "Username" & "Password" I want to create a copy button next to each field that will copy the contents to the clipboard. The password field has the code: Private Sub Command228_Click() Me!Password.SetFocus DoCmd.RunCommand acCmdCopy End Sub...

Hi I have a form which has a field called "txtImageName" with a default value which will be a UNC path to a network folder. I want to append to this path a value that is entered in another field called "Username". How do I go about doing this? Also I'd like to be able to hide the network...

I've sorted this now thanks. I just had to change the Control source property of the Image frame to the txtImageName field and now shows as expected. Simples ;)

Hi I have a form which shows individual records for users and I want to link photos for each record from a network folder rather than embedding them in the database as good practice suggests. I've been using the database expample from http://www.databasedev.co.uk/image-form.html as a...

Hi I have an unbound text box that I'm using as a search box to filter the records on my form and appears to work well however can only get it to apply to text box fields on the form using the expression below [TempVars]![strFilter] & " OR ([Serial Number] Like ""*" & [TempVars]![strSearch] &...

Just had a thought of how I could have approached this without the need to resize the window....I could have just put the out of range section on a new tab!! Oh well at least I know how to resize and postition a form window now ;)

Ah super job. I'm actually using that command rather than the Me.InsideHeight code and works a treat. You are a star thanks.

Is this set in the OnOpen event?

Thanks. Initially I was trying to pull the quick search apart and apply it to my database but couldn't see what the search box was linked to as didn't seem to reference anything. The only thing that seemed relevant was the macro but this had multiple references to the filter box and couldn't...

Thanks for this. Think I'm going to leave this seeing as I'm after the full suite of formatting buttons which seems more hassle that it's worth when I can access these from the context menu that appears when highlighting text. Thanks for your help though.

It's positioned at the top of the screen but want this centered vertially. Auto Center is already set to "Yes" but as mentioned the height of the detail section is set to 25.894cm which is the actual height of the form when all content is in view but is different to what I've set with the...

Ok thanks. That's the first I've heard of twips!! Any idea on the positioning issue?

I'm setting it using the "me.insideheight..." method. I imagine this is at the top of the screen because the "Detail" section of the form still has a height of 26.362cm which I can't change and so regardless of the me.insideheight setting this is still taking precedence causing it to position at...