Search results

For the first part, create a hidden "other Reason" text box. Create some code in the after update method of the combo box that checks to see if the value is other, if so unhide the other reason text box. For the query use iif... IIF(nz(CannedReason, '') = '', FreeFormReason, CannedReason) As Reason

Here is another way to accomplish this, but at runtime. This will auto resize the columns when you set the record set of the list box. http://www.mistahmilla.com/2011/10/resizing-columns-in-ms-access-list-boxes/

Not 100% sure what you're asking, but, try updating the table for the pre-existing values to change to the code instead of the description.

You could put some code in the before update method that checks to see if the thing that is about to be added is already in the table. You could also try adding a unique constraint to the table. That will not allow users to add duplicate values. You can add the unique index across multiple fields.

You can always view the design of the linked table to see what datatype access thinks the field contains. Anything that is not of that datatype will give you an error.

If you are going to use reserved words as names for fields or tables you might want to consider throwing a T_ in front of the table names.

In order to accomplish this I think you'll need to add another field that keeps track of what action number it is. Access does not have a ranking function, otherwise you could accomplish what you are trying to accomplish without an extra field. Once you have the extra field it is simple...

Try something like WHERE (Param1 IS NULL or Table.Field = Param1)

I don't think there is any other way to do it.

Northwind is the only sample database I know about.

What are the dll's that are missing? Are they windows dlls?

Sounds like you have two users trying to modify the same record at the same time. Make sure your application is closing the record that it is on before it moves to the next.