Recent content by Abbos

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