Search results for query: *

I copied and pasted this sql statement from the design view of an Access query into the code for a report. In the report I get a sintax error on the FROM clause?? This the qry statement from the datasheet query: SELECT A.Code, A.Title, A.Wage, A.Year FROM Positions AS A INNER JOIN [SELECT...

I am using Access 2002 and I am trying to create a query that selects the most current version of each code. Here is the data: Code Title Wage Year AC Account Clerk 1 2001 AL Advanced Lifeguard 9.56 2001 AM Assistant Manager 10.94 2001 BB Buddy Bear 1.00 2001 CA...

How does one go about setting the hidden property for a linked table using program code? (microsoft help is no help!) Thanks, Dan

I have an application that collects employee application info. When a new record is saved, it prints an envelope with the applicant's name and address and a code based on certain criterion. The problem is, when the report preview (of the envelope) comes up and the user presses PRINT icon, a...

I have a form with a Tab Control consisting of 4 pages. All of the controls are on the pages. There are no controls on the form itself. And I suppose that's why this makes sense: Testing for ME.DIRTY is always false. And trying to test for ME!PAGE2.DIRTY triggers an error. How do I test...

I've got an invoicing application with a Main form containing Subtotal, Tax, Freight and Total. The subform contains the detail info; Item, Qty, Price and Extension. I've got it all working fine with the usual calculations as discribed elsewhere in these forums, such as...