Search results

It seems that whenever I use a continuous form there is always one entry with empty controls at the end. Is there a way to get rid of this line?

I like -2147483633 for my backcolor. For my current (and first real) app I'm using that for my backcolor and 128 for shapes and text box bg's. I like text boxes with drop shadow, 128 for the backcolor, and white font color in Tahoma 10px bold. (For secion labels, not field labels).

Yeah, I may just be better off using filter by form. I haven't played with it too much, and it seems to do what I want for the most part. Except in some of my lookup fields, it gives me data type mismatch errors when I type in a value, it doesn't seem to have a large level of control. But I've...

Looks much, much nicer. 7/10. stardusty made some great suggestions. "What are you looking for" should be a little bigger, this way you can make "Access Database Repair" in bold and it will make visual sense. I don't agree with moving the keyboard picture left though, I think the colors are...

Yes I actually played around with it a little bit this weekend! Not really what I'm looking for though, as I would like the search facility to be part of the form, and be used on any form. I want any form's fields to be used as the search fields based on the current mode of operation.

I'm relatively new to VBA, and Access in general. I recently designed a DB for entering, processing and analysing chargebacks on our companies merchant account. I have a basic search form which uses a continuous subform to display results, with a detail button to pull up the record. It works...

Sheesh. I wasn't particularly fond of this book in the first place, but this is grounds for a burning.. I had just finished the chapter on databsae sharing, which covered record locking, and explicitly says that the default record locking setting does not apply to forms. I suggest that everyone...

I could be wrong, but I actually referred to the Access 2000 complete reference just to double check. I'm not sure how the recordlocks property is associated with the default record lock specified in Access Options though, can you please explain this for me?

The default record lock you choose in Options only applies to datasheet views of tables and queries, and to dynasets. If you want record locking on forms and reports, set the Record Locks property in the data tab of the object's properties box.

There are two methods you can use to keep data current in a form: refresh and requery. Refresh does a quick update of data on the current record, and requery completely rebuilds the underlying recordset by running the query again. You might try something like Forms![frmFishEnter].Refresh in...

Here is the table structure in the above DB

Hi SharonC, I'm no guru myself, but if I had to tackle that I would try to normalize your tables further. The first thing I noticed is that your complaint types are stored individually in the complaint table as fieldnames. You can make it easier to maintain those types and use them in other...