You don't want to create a query at all. This is simply a form and subform example.

The subform is based on table2 and the main form is based on table1....

You need to talk to your sysadmin about this.

What we do here if to a series of Windows groups mapped to database roles. They've all got fancy names like MIS1,...

iif in Access is CASE in T SQL e.g.

iif([field1]<29,x,y) becomes

CASE [field1]

WHEN <29 THEN x

ELSE y

END

When you have multiple (or nested conditions) then the CASE method looks a lot neater...

I would try and do it in easy stages i.e. step 2 and then 3. SQL Server/ Access and then consider SQL Server/Web.

It all depends on the amount of code...

ERDs etc can be done in Visio. OK it's pricey but does the job.

Table schemas and form fields to database fields can be done in documentor. Not the prettiest thing,...

OK A startup form is any old form that is run at startup.  So create a blank form, save it as e.g. fStartUp. Go to tools, startup and in the...

Use a pass through query and export that. You need to add code something like this:

    Dim db As DAO.Database
    Dim qdf As DAO.QueryDef
    
    Set db = CurrentDb
    Set...

Um! Why? Provided you've got your SQL groups and Windows security set up properly, there are good reasons to allow this e.g. for a mail merge or possibly for a...

Definitely not true.

Linked views are updatable a) if they are updatable in SQL server b) if Access can work out a unique indentifier for the table.

If you have a multi-table...

Access can get a little picky if it can't see a primary key / unique index. A simple way to check is to create a query in Access and add...

Depends on your physical set up and business logic. Change in inventory over a period is the sum of orders received and/or production less goods delivered. Alternately, if you are...

Basically, no.

You either need to set the macro security to Low ( NOT recommended) so that all programs will run without checking or you need a digital signature.

Simplest way is...

I presume you have a table linking ShipTo, Person and EmailAddress - tRecipients.

It is then a simple matter to open this table in code and to step through it selecting the...

As somebody who works in education, I use this type of construct on a regular basis. It would be nice to see an example with real numbers rather than integers....

Two part method. Create a stored procedure in SQL Server like

CREATE   PROCEDURE dbo.ProcWho

@Who varchar(30) = "Not Known" OUTPUT

AS

SET @who = SUSER_SNAME()

RETURN

GO

Then in Access write bit of code to run this...