Search results

Working now. I had pasted the code in and thought the green was commented out bits! Thanks again.

Oops! Will do, thanks.

It is SearchResults and I've just noticed I hadn't named it that. Done so now and getting runtime error 2465 - can't find the field '|1' Option Compare Database Private Sub SearchFor_Change() 'Create a string (text) variable Dim vSearchString As String 'Populate the string variable...

Should have said the 2 unbound text boxes used are SearchFor, and SrchText with SrchText's Visible property to No.

Thanks. This is in the search for text box in On Change: 'Create a string (text) variable Dim vSearchString As String 'Populate the string variable with the text entered in the Text Box SearchFor vSearchString = SearchFor.Text 'Pass the value contained in the string variable to the...

Getting method or data member not found error on a list box in a search form. I have 2 unbound text boxes linked to a list box to search fields in a query. It's failing at Me.SearchResults.Requery. I don't have a lot of experience of VBA, I followed a tutorial to get the search form. Any...

That's done the trick. Thanks very much.

I'm trying to base a report on a query that will pick up records with a review date within a year, that is, within the next year from today's date. I have a date of assessment field in a table and I use a calculated control on a form to see the due date (date of assessment + 1 year) in whatever...

Good enough. Thanks.

Works OK except when I enter the field B is displayed but I need it to be BC and then enter either A or B.

Thanks, that works a treat. i should have said though that I have a space between the letters and numbers. Is that do-able?

I have an input mask on a field in a form >\B>\C>"C "0000;;_"" which gives me BCC and alows a 4-digit entry, that is, BCC appears on entry and I manually enter the numbers. I am trying to change the BCC bit to allow me to have BC with an option to have the last C as an A. Tricky to explain...

Thanks. I was using the standard command button. I'll give it a try. When I tried to add the control it says the OLE server isn't registered and as my PC is restricted on a network I'll have to wait for IT here to do it. Seems to be something to do with a dll not registered.

I don't know! I copied code to the on-click event in the button. Do I need a module?

I have a form with an image control that changes for each record from a table, images linked not stored. I can't get the code to work in a command button to open the Office File Open dialog. I want to be able to change the picture from the form. Using in the on-click of the command button I...

How to place an image on a report that changes for each record in the report. I have it working on a form but I don't know what to link the image frame to in a report.

I am trying to display an image for each record in a report. I have a form based on a table (basically pinched from Northwind) that works OK but I can't figure how to make it work in a report. I'm not storing the images in the table, they are linked.

I'm trying to construct a database to track church funds. I posted before and was given a link to a suitable schema but it was too comnplicated for me! Basically I need to track money given to a church through weekly transactions - money is given weekly through a numbered envelope. Each...

Thanks for that. I'm getting an invalid use of property on my como box.