Another method if you are spooked by using a subquery is to create a query which returns all records which have a Yes. Then join that query to the...

That appears essentially correct - the general syntax for referencing a control on a subform is:

Forms![main form name]![subform control name].Form![control name]

and having the subform control in a tab control...

That's a common problem in trying to nest tab controls. The usual way around it is to put a subform on the tab where you want to put the...

An Access crosstab query will do some of what you are after, but it won't produce the format you are after as it only allows one column header. The...

First of all you should be working with an ADP (Addess Data Project), and not an ACCDB or MDB file. Second, you should know that effective with Access 2013,...

As a matter of fact, DENY had be put on the public role. I won't have an opportunity to test it until Tuesday, but I suspect that was the...

This is actually a linked table with a Microsoft Access front-end using ODBC, and in typical ODBC fashion, it gives an obscure error code that indicates the user does not...

I don't pretend to be even a novice at using attachments - we've never actually used them. From reading about them, I believe the attachments field type actually stores...

The usual solution (aside from the attachment field in .accdb/e Access front-ends - where you don't really want to store that info if the front-end is deployed to the user...

If you want to display the content of the combo box control, then you need to use the syntax that chooses the correct column in the combo box row properties....

One important thing that is missing in the description of your issue is the version of Access that you are using, and the format of your Access front-end database. ...

Sean is absolutely correct - there is no easy way to do that in Access, and in general you shouldn't need to. Access treats autonumber fields as something the...

There should not be any difference based on SQL Server version or Access version. This technique is dependant only on SQL Server, and we have similar tables that work...

There are several advantages to that approach - it works whether the record is created using a form or added at the table level. It also uses the system...

kwoznica (7/17/2013)

---

Thanks for the suggestions but I have not been successful.

I used Environ("UserName"), suser_sname(), and select system_user to populate the value in the text box on the form.

I...