Search results

Hi, I have a form with a number of tick boxes and a textbox which allows the user to select a tick box which may be name as an example and then type a name to match in the search box. My code on the search button is: Private Sub Command85_Click() Dim strWhere As String Dim bSelected As...

Hi, I have a database whereby from the main DB, users can filter records and view reports of the results. I have everything working except the the first image for the first record displayed on the report. The code I currently have attached to the On Page event for the report is: If Not...

Hi, Is it possible to disable the "Next Record" navigation button on a form toolbar when the end of the records is detected?

Hi, I have a form that is based on a query with many fields. As an example there is a field called "Medium" which contains values such as "Oil on canvas", "Oil on wood" etc. At the moment I have a filter which works fine but this doesn't allow me to search all records which have the word "Oil"...

Hey, I'm having a issue where by I can't seem to sort my filter results on a Form. By default the form shows records according to a name field being in ASC order. On the same form a user can apply a filter (using a button). I wish for the Filtered results to be sorted by a Ref field in DESC...

Hi, I have a database where by users can input images. The database then copies the selected image into the current working directory\images (c:\db\images as an exmaple) the it keeps a reference to the path in a table. When users then browse the records on the form I have an ImageFrame which...

Hi, I have 6 public variables as strings and just below where they are defined I have the following code: Sub SetVariables() pass1 = "one" pass2 = "two" pass3 = "three" pass4 = "four" pass5 = "five" pass6 = "six" End Sub All works fine however I am trying to create a small Admin form which...

Hi, On a form I have a button that allows me to FilterByForm. Although it works fine I don't have any checking in place, so when a field is filtered and a certain value is selected where there are no records in the table that match it currently just shows the same form but with all fields and...

Hi, I'm fairly new to VBA programming although not new to programming in general. I think my problem is with my syntax but would appriate any help. Private Sub Command7_Click() Dim strInput As String Dim strMsg As String Dim stDocName As String Dim stLinkCriteria As String...

Hi there, I have a number of forms which I wish to password protect. Currently I have done this but the password is hard coded. I need to change this so that I can create a smaller like control panel form that allows some to change the different passwords. My current problem is changing the...

Hi there, I have a form which allows a user to click a button, select a image file and it then references that path instead of embedding it. At the same time I would like to write some code that will copy the image from wherever it is located and copy it into the application path\images folder...

Hi there, I have a simple database with a form that displays the contents of a table called Products. I want to be able to delete items from Products but these should be move into ProductsArchive table and I will then create a seperate form to view Products that have now been removed but were...

I have a form with one checkbox on at the moment. Depending on whether it is checked or not I want to choose to display or not display a field on a form. I have the following code below but whether the checkbox is ticked or not it doesn't affect the report. If Check4 = True Then...

Hi Everyone, I'm trying to pass a variable called MyFilter between forms but am having problems. I have created a Module and declared MyFilter as a public string. The original code in my first form is: Private Sub Command65_Click() Dim MyFilter As String If Me.Filter = "" Then MsgBox...

Hi, I have read through a few posts but none seem to resolve the issue I am experiencing. I have a form with a FilterByForm button. This works fine. I also have a button that is supposed to display the results of the filter on a report. Everytime I click this button it prompts me to enter a...

Hi, I have a basic form which currently displays different information such as name, date, country etc. At the moment if I type anything into the fields it edits the data (allow edits is on). Is it possible that if can type in a name and it will find the pieces of work by that named person...

Morning all, I have created a report which is generated from a form. It displays all the fields relating to that specific record apart from the single image. I am using a linked image frame to a field which holds the path of the image. I have exactly the same on the form which works fine but...

Hi everyone, I'm having an issue with a query I created. When run the query requests an Artist Name. I enter this and it returns one result. However in actual table ther are two results for that artist. The only difference is that for the record that doesnt appear the field labelled "Gallery"...

Afternoon, I'm having a problem with a form used to display table records as well as create a new record entry. The form has 2 combo boxes and the rest are fields. Combo1: Artist Combo2: Gallery I would like it so that when the form opens and displays the first record it will also populate...

Afternoon, I have been reading many threads but can't seem to find an example that works in my scenario, perhaps I am wrong? I have a Form with a Subform. I would like to disable the mouse scrolling option on the Form but not the Subform. I have tried several things including the Cycle option...