Search results

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

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

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

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

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?

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

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"?

Hi I have an inventory database main form and for each item on this another form can be opened via a button providing more detailed information. I have a "Warranty Period (Yrs)" field on this form which is just a "Number" data type field and a "Warranty Expiry" field which is a "Date/Time"...

Hi, I have a form which has a "filter on load" set to apply. This works fine however when further filtering the form after initially opening and then simply closing the database without clearing the latest filter and then opening the database again, the latest filter is applied instead. How...

Hi I have an inventory database with a main form that has a field called "Status". I simply want a check-box on this form that will filter out a specific status ie. "Dead" from view. Nice and simple yet I can't seem to find straight forward instructions on how to do something that should...

Hi I have searched through the forums and although found relevant threads, none have helped me out. Basically I have a form which has a field ("Status") that I've set as required from the sourcing table. This form has a button that makes various changes to the data shown and one of them...