Recent content by odrozd

I am running access 2007 on a Vista Home Premium 64 bit I keep getting the following error: Declare PtrSafe Sub SetWindowPos Lib "User32" (ByVal hWnd&, _ ByVal hWndInsertAfter&, _ ByVal X&, ByVal Y&, ByVal cX&, _...

Paul, I would like to take a look at the Time Entry, I am running windows 7, 64 bit. I get the following message: Missing or Broken Ref Acc32bitAppServer57.tbl Can you help me resolve this problem. Thanks Otto Drozd

I am trying to populate a txtBox on the SubForm of a Form, Using a Set Value Function = DlookUp function. The DlookUp Function searches for a value in the table and compares it to a value of another txtBox of the subform . The problem is: Using the Left Switch on Mouse works fine, txtBox is...

On the box that asks for the data Go to properties. Go to after update. Create macro to requery Hope it helps

Try to requery the list on update

Thanks Guys you are right, it does not pay to take short cuts. The Final query is as follows ans it works fine. SELECT Products.ItemCode, Products.BarCode, Products.VendorCode, [Orders Totals Query].ProductDesc, [Orders Totals Query].OrdersTot, [Sales Total Query].SalesTot...

The Amounts on the tables are numeric. If the table shows: Purchase Product-A, PQty 12 Product-B, PQty 12 Product-A, PQty 13 Product-B, PQty 10 Sales Product-A, SQty 10 Product-B, SQty 10 Product-A, SQty 10...

I have two tables, Orders and Sales. Product Description is common to both tables. I am running the following query; SELECT DISTINCTROW Orders.ProductDesc, Sum(Orders.quantity) AS OTotal, Sum(sales.Quantity) AS STotal FROM Orders INNER JOIN sales ON Orders.ProductDesc = sales.ProductDesc GROUP...

I am a new member, not experienced in acces. I am 76 Years Old and trying to learn something about Access. I spent must of my proffessional life designing Automac Machinnery for different types of industry. Well familiar with Auto Cad, Inventor, and LISP programing, some knowledge of Basic, VB...