Search results for query: *

Here's the skinny: I have a form (Orders) with a subform (OrderDetails). Order details subform Fields: Item, Quantity, UnitPrice, ExtPrice. There is a field called OrderTotal in the footer of the subform. I pick an Item from the list, have a DLookup get the UnitPrice from the table for that...

Not real sure how to describe this (I have a sample worksheet I can email) Excel worksheet, 2 tabs. 1 is an order entry form: r1 Order Category 1 r2 qty Description Price Extended r3 1 item 1 $5.00 $5.00 r4 2 item 2 $2.00 $4.00 r5 0 item 3 $7.00 r6 0 item...

New to Access security and am wading my way through. Have setup a database and used the security wizard to create some groups and users, assigned rights, etc. Seems to work the way I want so far ... first q: Using a switchboard to act as the front end menu. Is it possible to use multiple...

Tying to create a form that will count records in tblClientTracking where the year in the SubmitDate field is only the current year. This syntax is giving me #error and #headache! =DCount("[SubmitDate]","[tblClientTracking]","DatePart('yyyy',([SubmitDate]))")...

I have a form with a field that can contain one of three values; 0%, 40% or 50%. I have three subforms (one for each of the possible values). Is it possible to display the appropriate subform based on the value of this field? TIA - R. Fisher

Relatively a newbie to MS Access ... I am trying to develop a form that will have some statistical information. Table: CheckDetails Field: EstRefund Table: ClientTracking Field: InvoiceDate Column 1 on the form shows the total EstRefund (have this). Column 2 on the form s/b the total...