Recent content by rjf3123

Can't thank you enough ... works perfectly! R. Fisher

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...

Thanks for the reply. Thinking I am going to have to do some programming to get this to work right (I am not going to be the end user here). Any tips on the programming side of this? I am sure it can be done but I am very green when it comes to VBA. Thanks

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...

Thanks tons Jim - I knew I was on the right track, at least with 3 wheels. I am posting the correct function here for future seekers ... =DCount("[SubmitDate]","[ClientTracking]","DatePart('yyyy',([SubmitDate])) = DatePart('yyyy',date())") This works great! R...

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...