Recent content by tmarsh

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?