Recent content by randle

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?