Search results

can anyone help at all with this?

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

Simon, Thanks for the pointer. It seems to have solved the problem but the issue it causes is that everytime the report is generated it attempts to "import" all of the images first. Although they are linked, it still takes a while and on some of the bigger reports it takes ages. Is there a way...

Found it by accident! Will give that a try now.

Different images do apply to each record on the report but I cannot seem to find the Detail Section On Format. Can you point me in the right direction please?

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

It's easy when you know how. Thank you very much Peter.

Thanks Peter, i'll give that a try.

I've tried that already but the problem I have is that I lose the record counter. I wrote some code to display a record counter and total number of records but I then have problems when I apply a Filter to the form. Dim TotRecords As Long Dim CurrentRec As Long Dim TotRecords1 As Long Dim...

Thanks Peter but I need to be able to create new records from the same form. Is this possible as it is proving quite difficult?

I would like to stop it from creating a new record when the end of the records are reached and the user clicks on the "Next Record" arrow.

can anyone help?

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

I read that thread but the records are displayed in a different way and the search is also limited to a number of fieldnames. I was hoping to find a snippet of code that I could use of the AfterUpdate event on each field on the form (textbox), so that as soon as a user starts to type something...

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

Gave up with this so went with the work around as you said Ions. Thanks,

Thanks but I can't seem to get this to work. Here is my code: Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer) If Me.Recordset.RecordCount = 0 Then MsgBox "no results" End If End Sub It runs when a filter is applied or removed. Everytime I apply a filter and this code...

Hi Bob, Thanks for the reply. I tried what you suggested but I'm still having problems. Here is a full copy of my code being used: MODULE Public MyFilter As String Public mynotes As Boolean Public mygalleryname As Boolean Public mycurrentvalue As Boolean Public mypurchase As Boolean Public...