I found this great write-up on Linked Servers here.  After reading it, and thinking that where it is asking for the path to the database, I could put any...

Perry, could you explain, even briefly, how to write a view on SQL Server from a table in an Access database.

Thanks!

Paul,

I don't believe you can work directly with the form's recordset as you have tried.  I believe you can only work with a RecordSetClone.  Then find the record you want...

Paul, I have no idea why you are experiencing this behavior, but a workaround would be to save the bookmark, then return to that bookmark after the report has run.

Hope...

This is just an idea, because I don't know anything about what you are doing.  But if I were trying to get an XML file into SQL Server, I think...

Lucky, the "*" does not seem to make any difference while running the query in Access.  I do think Russel hit on it though, as the table that does not...

When I have a situation like this, that is something happens that I can see can not happen, I do a "Debug.Print pk12_date, current_timestamp, DateDiff("d", pk12_date, current_timestamp)"  This will print...

Be sure you are in the VBA editor before using Help.  Within Help, using the Answer Wizard tab, type "PrtMip" and you will see the explanation on how to use...

It would be good to know exactly what that error message is.  I'm going to assume that the error message said something about the Forms!Form Name!Combo Box could not be...

Annie,

The dd in your datediff code, what is it?  Is it a variable that contains the value "d"?  Or are you trying to pass a "d" to datediff with the...

I have no idea what the .pc. format is.  Could you explain that better?  Also, have you looked on the Microsoft web site to see if they have any help...

Sorry, but I can't say "Yes."  Although Access offers "Data Access Pages" which allow you to create a web based "page" rather than an Access based "form," it is intended...

Will, here is the SQL for the first query (Name it Query15 for this example):

SELECT Table4.Name, Max(Table4.Amount) AS Amount

FROM Table4

GROUP BY Table4.Name;

Then the second query uses the first query (Query15)...

Post a message letting the user know the computer is still working.  That way the user will know that there is a little more time to wait.

You will need to format those cells (or columns) within Excel.  I know of no way to export the format.  What I have done is to format those cells with...