Search results

One way (and probably not the best) is to determine the maximum number of features that could be on a cart. Then in your table have that number of fields available (i.e. Feat1, Feat2, Feat3, etc.) Then on your form have a section with the text boxes so that the features can be entered. Then...

set the criteria of the query to the fields that want as criteria. For each field of the query that you are search on use the following - = [forms]![form1]![textbox] if you need to trap for spelling errors you can wildcard your search to LIKE "*" & [forms]![form1]![textbox] & "*" -HTH

I must be a knucklehead, but I couldn't get it to work. I follwed the directions (exactly) and placed the control on the form and embedded an animated gif in the box. When I went to form view - nothing showed. Any suggestions?

I've put a couple of these things together and they can really be a challenge (as I'm sure your finding out). Fuga is right in that you will need to create a qurey or SQL string that uses an unbound text box as the criteria in the WHERE clause. You can either build a query or code a recordset...

OK! let's solve this bad boy - you need three search strings. one that looks at tbl.AGENCY, one that looks at tbl.SET and the third is the combination SELECT * FROM TABLE WHERE tbl.AGENCY = S1 SELECT * FROM TABLE WHERE tbl.SET = S2 SELECT * FROM TABLE WHERE "tbl.AGENCY = S1" AND "tbl.SET...

sometimes I've had these borders to make room for scroll bars. It seems like Access wants to anticapate the scrolll bars and leaves room on the form for them. turning scroll bars off sometimes helps. Don't ask why......

If I understand correctly - the first search criteria (S1) should find all the records in table.AGENC = "DIA" regardless of what is in table.SET the second search criteria (S2) should find all the records in table.SET = "ARGENTINA" regardless of what is in table.AGENC the third criteria (S1...

This looks like your working with a two-dimensional array. You might want to put you recordset into an array and then you will have an easier time referencing specific row,col values. for example array(1,2) would be 2nd row, 3rd value. Arrays are zero based when referencing rows and columns...

I hope that can help clarify..I think you need to group you criteria in your WHERE clause, i.e. SELECT fields FROM tables WHERE "table.field = S1" AND/OR "Table.field = S2" AND/OR "Table.field = S1 AND S2" I hope this doesn't confuse the issue further. -Al

you can lock the record by using "pessimistic" record locking. I don't know if it prevents viewing of the form. Go to HELP -> INDEX keyword RecordLock and it will tell you all about setting the property. HTH -Al

I used the link tables method on the application I developed. Sorry if I gave you bum advice about the ADO connection.

Have you tried makeing it an OR statement, i.e IF txt.string = "E" OR "EJ" or "J" Then ..... ElseIF txt.string = "A" OR "string" Then .... Else ...... End If -Al

Yes, you should be able to remove the copies of the search form. There are several steps you need to take: 1. identify which of copies you will use as the "one" search form and also the underlying query. 2. on the target forms change the "copy of search form" reference to the "search form...

I've never had any luck doing that. I hope someone out there has a way to do it. I think it's one of those Access limitations.

Dave's solution is much better than mine. Thanks Dave. I will file that away in my little box of tricks.

I just finished a similar exercise recently. I have a form with four unbound text boxes the user can enter criteria in. I had to use 13 SQL strings to cover all the bases in order to run the search. This probably wasn't the most efficient way, but it did work in the end. The basis for my...

Cool. I'll file this one away myself. Probably save me a lot of heartache in the future!

Tab controls are a pain in the rear. I've only experienced them working if you place the controls directly on the tab and plan the application design to use tab controls. Backfitting a form onto a tab usually doesn't work. The tabs want to act like the parent of a parent/child relationship...

An add on to Pat's comment. You can save just the name field from the excel file as a comma delimited text file. That will split the field. Then use the import wizard to import to two fields in a temp table and then append just the last name field to the data table.

I've had go the other way before (take from several dbs and put on one form) so I assume it is possible to go from one form to two dbs. I need to look up a couple things and I'll get back to you. My first route would be to create a workspace, Dim the databases as objects and create ADO...