I've always preferred to use views rather than tables for most of the grunt work so I end up with business logic in the view triggers and auditing in the...

OK What you need is a bit of DAO code to do the job. I'm working in 32 bit 2010 on W7 x64 against SQL 2008 R2 on windows...

One possiblity - not for 64 bit though - is to use a linked server based on the Access database.

Decidedly mucky. You need to be able to put the .mdb...

Yes it is. Typical of databases! They do what they want not what you expect them to do.

I was looking at the login time rather than the timestamp.

Thanks.

BTW Neat the way you're time stamp is before the question was posted.

Weird. Just checked my account.

I have 103 posts - looks OK.

On question of the day I also get 103 but the breakdown shows 111.

The total is then 206 not 214.

Richard Bradford (8/7/2009)

---

.... As a result most of the overtime that I've done has almost always been TOIL and you come to an "arrangement" with the manager to take informal...

As you have noted, many users per front end leads to bloat and corruption.

Don't do it.

One user per front end also leads to bloat and corruption - it's a fact...

Basically, you are along the right lines.

You should create a stored procedure

CREATE PROCEDURE ProcMaxDate

(@ItemName NVARCHAR(70) )

AS

select max(rundate)as maxrundate from runlog where itemname= @ItemName

GO

Create a Pass Through query directly in Access...

INSERT INTO existingtable

SELECT * FROM OtherTable

WHERE OtherTable.Datefield = some condition

Should do the job.

In Access query design, look for an append query. that will do the job for you.

Read the post about table valued functions

You need to convert your stored procedure into either a view or a table valued function so that you can use the data it contains in another stored procedure.

In the...

It's not Access that's the problem!

It's having two different versions of Office on the same machine.

Why not just run the Office 2003 Database in Access 2007 with only Office 2007...

I'm using this code in an Access 2003 application

Dim olApp As Outlook.Application

Dim objMail As Outlook.MailItem

Dim objAttach As Outlook.Attachments

Set olApp = Outlook.Application

'Create e-mail item

Set objMail = olApp.CreateItem(olMailItem)

objMail.To = Generated in code

objMail.Subject...

Look at the visible property. I do this when we are doing data entry.

Simplest thing is to open the form set the focus to a suitable control on page1 then

page2.visible...