I have a form in an ADP connected to a SQL Server 2005 backend, with a
record source that is a view that includes two joins but is still
updateable.
The form has a list box control in the header section that is supposed

I would like to make the default value for a field the current logged in
username so that on inserts it captures the creator.
How would I update a "last modified by" field on edits?
Using SQL 2000 w/ Windows Authentication

Here is the typical code pattern (after inserting a record into a table
with identity column, the code tries to retrieve identifier of that
record; the identity column is called "ID"):
   Set rs = New Recordset

has any one encounted this problem??  When I try to modify the row source of
a form element I get this message.
This version of Microsoft Office Access dosen't support design changes with
the version of Microsoft SQL server you Access project is conneted to.  

I have a access project which monitors invoices payment received. Each style
is a new record and 4-5 such records make up one invoice. i have grouped
these on a query to get a combined invoice total.
My question :

I have a Table that I am inner joining with a View.  However, the inner
join is not returning records for which the joined columns both contain
a NULL.  The Table column is typed as nvarchar(50).  The column in the
View is populated with NULL as a literal (e.g., SELECT NULL As ...

I have a SP qOrders (orders of clients).
I have a form FClients and I want to create a button to execute this SP and
view the orders of the loaded client in FClients.
Any help is appreciated.

hmm ,this lack of temp tables makes things a bit trickier!
There's 3 tables I'm working with. I'll just give the simplified versions
here
Renewal - RenewID, RenewYear, RenewClientID

Our office uses Access 2000 as a front end to a SQL
server 2000 database.
Each client has it's own copy of the access .mdb file on
their computer.

We have a product we developed in AccessXP - an adp (ade for end users)
which connects to SQL Server 2000.
Some clients are using it at the moment and are experiencing intermittant
freezes while typing text into text boxes on bound forms. ie not while moving

If I have a TSQL script to create a table (for example), is there some way I
can can I run it against a SQL Server database from Access?
I assumed I could just paste it into a Query window, but I can't get it to
work that way.

i have one table in my adp that will not show newly added records.
also some of the columns are not visible.
anyone experience this?

I have SQL 2000 back end and Access 2003 front. I am able to update the tbl
via the Combo Box if it's created in Access with primary key as Autonumber
see code below. I cannot update the Combo Box if the tbl is created in SQL.
What code must I include to achieve this ?

Forgive my ignorance about this, I may not even be asking the right questions.
Through the remote connection program shipped with Windows XP I am able to
log into the machine holding the SQL Server and execute queries on the
database.

=Iif([SHIPTERM]="LDP",Round([INVQTY]*[LDPPRICE],2),Round([INVQTY]*[FOBPRICE],
2))
Please help me frame this in a Access project data base. i get error
validating formula. Help Help