Recent content by johnb19

Have created a form to display/change table info in Datasheet View and added the form to a switchboard. Problem: When selected from switchboard, it displays a single record. When executed from the Forms (objects), it displays in Datasheet view. ??? How can I get it to display in Datasheet...

My wife (Oracle DBA) said the statement looked unusual to her as well. To add a little more confusion: Make table and Append table queries work fine...just didn't want to give in.

A file imported from an IBM i Series (contains Sales & Expense data).

Hope this helps...Thanks for the reply. SELECT QUERY SELECT tblBudget.GBYR, tblBudget.GBLOC, tblBudget.[GBGL#], tblBudget.GLDESC, tblBudget.TOTAL, tblLoc.YtdSls, [TOTAL]/[YtdSls] AS Pct FROM tblLoc INNER JOIN tblBudget ON tblLoc.Loc = tblBudget.GBLOC; UPDATE QRY UPDATE tblLoc INNER JOIN...

Confused...trying to create an update query to Budget table using the Access Design View: Field: PctSls (in tblBudget) Update to: [Expense] / [Sales]. The update query always returns 0. However, if I create a Select query using the same calculation, the correct results is displayed...

To pbaldy...respectfully, is there anyone there who does use Macros? Some of us do not use VBC.

Sorry, I should have mentioned I am using Access 2002 and not familiar with VB. When I open Macros in Design View, the display shows Command and Comments...would like the first Command to present the Yes/No condition and then End the macro if No is selected. It goes without saying, I a...

My year-end macro consists of several clear and rebuild tables. How do I present a "Do you want to continue?" Yes/No message and Cancel the whole macro if No is selected.

Hello from another 'old timer'. It has been a while since I last used Access...still consider myself a novice.