Search results

Stephanie I think you are right about the query. Create a select query, with your table info in it. Add the fields you need, including; [Quantity], [CasePrice] and [Discount] In a new column enter something like this in the 'field' line AmountDiscounted: ([Quantity]*[CasePrice])*[Discount]...

Stephanie Access can't sum calculated fields. The calculation has to be done in actual input fields. Although you can calculate a sum field. On your sub form detail, add a text box called say, 'Sum'. In the 'Control Source' enter =Sum([Quantity]*[CasePrice])-[AmountDiscounted] To total...

You have to let access know that you are doing a requery on the subform and not the form. Enter something like this; [Forms]![MainFormName]![SubFormName].[Form]![ControlName].Requery

Hi I have a Form, 'StockTake' It has 3 fields, 'Date' , 'Employee' and 'StockTakeID' (when a stock take is done it is to tell us when and by whom) Imbeded on the Form is a Sub Form, 'StockTakeSub' The Sub Form is set to 'Data Sheet' It has several Rows to show the stock data. ('StockNo' ...

Barb I take it that your form's default view is set to 'Continous Forms'. You could filter the data on your form to show one NameID and have a Sum. Or maybe a Report would work for you, as all NameIDs could be grouped with a Sum. As far as grouping on a form, with a group total... I don't...

Barb If I understand what you are trying to do, you could put an unbound textbox on your form. Name it something like 'SumAmountPaid' in the Control Source enter this code; =Sum[AmountPaid] Hope that helps Tom

Mike You could try Opening the 'Sorting and Grouping' window found in your 'View' menu. You should be able to set all your sorting needs there.

Liam Here is one scenario that may work for you. 1. In <Tools> <Database Utilities> <Databse Splitter> split your database. This puts your tables in a db of its own, called the back end. Your original db called the front is linked to the back end. 2. Now you can simply copy and paste the...

David You could also combine tableA and tableB into a query. Use the query as your forms record source and put only tableA fields on TabA and only tableB fields on TabB. Tom

Hi I make a form with a date and a version field. I imbed a subform with an update field (continous form). I use this to document all updates that I do. It seem time consuming to enter every move, but it helps me to know where I'm at. I hope that helps. Tom

I am struggling with one. I think what I want to do is record the stocktake in the Inventory table. I do want to keep a record of the last stocktake as well. When adjustments are made I would like to know; when, who made them and what the old and new stocktake number is. Tom

Hi I am trying to manage my inventory. When doing a stocktake I want to; 1. view all of my inventory items on my Inventory form 2. then I want to add the actual inventory to each line Each line has the stock item's info eg. 'Part no.' 'Description' 'Price' 'Last Stocktake' and 'Actual...

Teriffic, it works great. Thanks everyone! Tom

Oops! I have a 'Label' at the top of my form that I want to blink. I'll see if I can work this code into the label. Thanks Tom

How can I make a textbox blink? I want the title of my form to blink off and on, so as to draw attention to itself. Thanks Tom

Mesci Would a 'Dlookup' function do the job? Tom

Cat I do most all my fromulas in the 'Control Source' properties box. eg. =[textbox1]+[textbox2] If it gets really complicated then I run an 'Event Procedure' using visual basic. Personally I find the expresion builder hard to use. Good Luck Tom

Hellfire I like to charge about $35.00 an hour (Canadian). Keep in mind that would have to be peak performance hours. If I have to go to a book or a help file, I stop the clock. Also it doesn't hurt to put in some protection to the programing. I put a little code in the autoexec macro that...

I have read about a function StrConv (textboxname,vbProperCase) This is supposed to force the first letter uppercase in all words. (which is what I want) But I don't know how to use it. Tom

Phredd Don't be discouraged!!! Access can become your friend, and very usefull. Usually the 'print form' isn't used. A report is made that takes its information from the form. But in answer to your question, try opening the 'Page Setup' from the 'File' menu. Set it to print 'Landscape' That...