Search results

Thanks for the help all. Got it working just right last week.

Still making progress.... There 4 check boxes named (CHKfp, CHKv, CHKrf, CHKid) that indicate something called "webtype". Only one of them can be selected per record, but I need to be able to return results that are not limited by which box is checked. Does anyone know of a wildcard that...

I am looking to be able to search more than one field. I'm looking for some help on the SEARCH statement.

I'm slowly making progress on this question using your suggestions and my own ideas. Here's where I'm at: I have the following on a form: 5 text boxes named (TXTFname, TXTonwer, TXTprodsrv, TXTdevsrv, & TXTstatus) 4 check boxes named (CHKfp, CHKv, CHKrf, CHKid) A query uses what is entered...

I was unable to download the .exe file. Something appeared to be wrong with the server.

Could you just elaborate a little bit in some more detail about how to do what you describe below. I think I get it, but I'm not completely sure. "Then whatever the user types into the textbox in your form will be used as criteria for the query. If you want to have one form for searching and...

Ok. I got the query to execute, but it now list the search criteria as a record in the table. How can avoid this?

I think I understand what you're saying, but could you elaborate a bit more on how the query will run from the form. Going on what you said I created a form with the necessary fields bound to the query and populated the query criteria fields with the LIKE statement. I'm just not sure how I can...

I've tried a few different methods (namely applying a filter), but have had no luck in creating code that actually works the way I want it to. I'm trying to use a form (I'm not sure if it should be bound to the table I'm using or not) to allow the user to enter search criteria. I want to allow...

I can't seem to figure out the code to enable a button while in the filter by form view. I want to use the button to apply the filter that has been entered by the user. Access disables all of the command buttons when it opens the FBF view.

I would like to place code behind a button that will open the filter by form page. I don't want to have the user click on the Access buttons to get to this page, i.e. I would like to use command buttons on the form to open the FBF page and apply whatever filter is entered by the user. The...

Thanks for the help. I might have mis-stated my question, but I got it to work with your suggestions nonetheless. The user was not actually specifying how to store data (the check boxes are actually how the data for each status is stored), they were merely asking for a field (for display...

I have form that is bound to a table. Data is entered through the form. On the form there are 4 check boxes (not an option group b/c more than one can be selected), however the user has requested that the values checked should be displayed in the table in a new column or field as "1, 2, 3" or...

I can't seem to figure out how to write code to change the numeric values assigned to option buttons in an option group to a text value to be placed in a table. The numeric values have no value to the user, they need to see text values.

I have a database that acts as the "main DB", for lack of a better term, where the user can perform certain actions such as creating a new DB from a template, etc. I can't seem to figure out how to code opening one of these new DB's from the "main DB" in a new instance of Access and close the...