Search results

Thank you! All sorted :-)

I was afraid someone would say that. Never mind, it was just a thought :-) Thanks

All sorted. Thanks everyone :-)

Hi, I have a form with several check boxes on it which, when selected, enable or disable highlighting rectangles to help users enter data where required. I can do this easily with the On Click event for each check box, but I wondering if I could consolidate these using an Event on the form...

I have been lloking across the web for some guidance on this, but I haven't found anything I can 'butcher' to do what I would like to do, but hopefully this will be my last question (for a dat or two, anyway :o) I would like to limit the vaalues of a second ComboBox to be based on the value of...

Erm, a little bit embarrassing this. I was speed-reading and missed some advice. Having used that advice, all the search criteria options work - all I have to do now is sort out a pesky combo box question, which will follow shortly... Thank you

Yep, I did that too, but I get the same error. In that instance the string is: strSearchString = "[Date of Application] Between #" & Format(dStart, "mm/dd/yyyy") & "# And #" & Format(dEnd, "mm/dd/yyyy") & "#" ...and the Immediate window shows this... [Date of Application] Between...

Well, I thought I was getting somewhere, but now I have a problem using two date fields to limit the records shown in the form :-( Using this string: strSearchString = "[Date of Application] Between '#" & Format(dStart, "mm/dd/yyyy") & "# And #" & Format(dEnd, "mm/dd/yyyy") & "'#" ...or this...

Woo hoo! Sorted :-) I simplified it with the following: strSearchString = "[Authority] = '" & strAuthority & "' AND [Town] = '" & strLocation & "'" How simple was that?

I'm trying to extend my knowledge with this in using several variable to open the new form. Thanks to The_Doc_Man for answering my query above, but I'm now trying to open the same form based on the value of two variables (and will extend this to three or four!). So, I have two String variables...

Bingo, that did it. Thanks The_Doc_Man Did you see the other bit about opening the form where two or more criteria can be used? Should I use And? Pete

I'll try the brackets, thanks...

Hello. Me again :o I have a form which is used as a 'launchpad' for users to search for records meeting specific criteria and it's working - with one exception! I would like to use a variable in the search string so that, for example, a Post Code search can be carried out on parts of it...

Thnaks, Linq. With a lot of controls, I was hoping there was an easier way, but I guess not. Thanks anyway.

I'm using Access 2007, and I normally use the Code Builder. Howwever, I was hoping to find an easier way of adding a new record without having to enable everything. Perhaps it's wishful thinknig :-(

Thanks, Paul, but could you be a bit more specific, please? I'm not currently using an Event, but relying on the default macro wizard. Pete

I've nearly got my form sorted and, for one reason or another, I've locked all the controls (except command buttons) to ensure users don't accidentally break anything. The trouble is, they will still need to add and edit records. I've got the edit bit sorted, by enabling those controls that...

YES I CAN! Gosh, I'm such a fibber Thank you :o

I have to bind them to a field in the table, because I'm using a query elsewhere for a report. Also, the data source is from Excel, and I've already had a nightmare in trying to prepare that data for Access! :banghead::banghead: Pete

They do apply to each record individually, but I can't find the form_on event!