Microsoft Access | Forum profile

I might avoid the Filters command (these never work very well with odd characters). Or don't use it as a variable name! (I'd call it perhaps vFilter or something like that). MSAccess 'might' get confused on the reserved Filter word with Filters. I think what you're trying to do can be done much easier but I'm hoping this is what you're trying to do. A typical opening of a report might be like this (I'm...

also I'd suggest you read, re read, and the read again the Access security FAQ from MSDN Microsoft Access Security FAQ available in the Download Center amd whilst you are at it make sure to you take backups before makig any security changes, its easy to screw things up, and without a backup your are royally screwed

Do I need to redo the box? I don't think it's working when I click on a qry in the list.

"MS Access will not let me use query fields in my form" ....this is a fundamental error or misunderstanding A form is sourced on a record set. The record set can be a table or a query. Use the design wizard to create a form and source it on the query. If you need the form sourced on the table and also need columns/fields from a query then you make a main form sourced on one, and a subform sourced on the other....

No problem. Maybe this thread will someone in the future as well.

To point you in the right direction, look at the InStr() function to find the first ^, the InStrRev() function to find the second. With those, a little math and the Mid() function, you have your name.

Funny, it was because I was relying on the assumptions Excel makes about the data, that my import was working for Excel. The problem was fixed by setting the incoming data to whatever format the field was looking for. Basically the API I was getting data from was sending numbers over in a text format, but only sometimes.

hmm, was playing around and thought I'd change the bound column. Apparently if I Bind to Column 0, it binds to the index, and binding to column 1 uses the first column, my ID field. Strange, as if I do [cmbProperty].[Column](1), I get the second column! Isnt this a bit misleading?

As stated previously, you're really not very clear as to exactly what you're doing here, or how these "chunks of text" are being selected and inserted. Obviously, Access has to be told what text to place the symbol after. More details are needed.

Thanks pkstormy! Those are helping me alot! But the real nuts of the problem is after i have searched and found what i want... how do i send that info back to the form that opened the search form?