Search results

  1. B

    Add Text Box with Sum Function to Report

    Beetle, Thanks for the post. I was able to do it in the report footer using the Report Layout Sum tool.
  2. B

    Add Text Box with Sum Function to Report

    I am trying to add a text box with a SUM function to provide totals at the bottom of a report. The function I am using is below: =Sum([SummarybyChannelType-LessThan60.SumofAssetCost]) SummarybyChannelType-LessThan60 is a Query SumofAssetCost is a field derived in that query When I added...
  3. B

    Deselecting ActiveX Option Buttons

    I have developed a form in Excel that is being used as an Order Form. On the form I have a series of groups of Option Buttons set up so the user can only select one from each group. The issue I am having is that once the user chooses one of the options, they cannot deselect them all, they...
  4. B

    Picking only one Checkbox

    Thanks Bob, Now I get it, I was just missing the obvious. One follow up, is there a way to format the box itself so the borders and text ("Group Box 62") are not visible. And can I edit the font of the text for the Option buttons that I add in to the box.
  5. B

    Picking only one Checkbox

    Bob, I am sorry if I am being dense or missing something obvious, but my problem is creating there groups. I can create the buttons but not group them together. I do not know the steps to follow. Can you possible help me out by walking through one, like for Order Type which you were...
  6. B

    Picking only one Checkbox

    Bob, I follow you but how to I store the Option Numbers to set up multiple groups. I cannot seem to create multiples.
  7. B

    Picking only one Checkbox

    Bob, I attached it below
  8. B

    Picking only one Checkbox

    Bob, I beleive that you posted the incorrect link. Here is my form. There are I think 7 groups of checkboxes that should have only one choice picked.
  9. B

    Picking only one Checkbox

    I am creating a new order form and there are areas on the form where the user needs to check a box (Order Type for example) but I want the user to only be able to choose one. How do I create this?
  10. B

    Date within last two weeks

    I have a table and I am trying to identify certain records that have been processed within the past two weeks. I am have trouble writing the argument to generate this. Can someone help me out?
  11. B

    Type Mismatch Error

    Ted, The line of code that is erroring is this one below: oApp1.Selection.Text = Forms![New Entry Form]![DealerName]
  12. B

    Type Mismatch Error

    I am writing scripts for a database I maitain. I have Word documents which I want to open a populate with two fields form the Access form if the user chooses certain products. When I am testing the code I am getting an error: "Run Time Error 13. Type Mismatch." This occurs on the code below...
  13. B

    Adding Sub-Totals in Report Footer

    Paul, I just tried the same thing on the count function and it gave me the total count for all 3 status. Will this not work for Count. =Count(IIf([Status]="New",[Date Received],0))
  14. B

    Adding Sub-Totals in Report Footer

    I made a typo, thanks again.
  15. B

    Adding Sub-Totals in Report Footer

    Paul, I just tried that and when I viewed the report Access asked me for a parameter value for Old Hardsale.
  16. B

    Adding Sub-Totals in Report Footer

    I currently am designing a report that has for a report footer a count of records and a sum of the $ for the records. =Count([Date Received]) =Sum([Old Hardsales]) I want to created subtotals on each of these field by the status of the records: NEW, PENDING, CLOSED. Right now the report is...
  17. B

    How to Query if Date is Current Month

    I got it to work, thanks so much Paul
  18. B

    How to Query if Date is Current Month

    I got a syntax error, "You may have entered a comma without a preceding value or identifier."
  19. B

    How to Query if Date is Current Month

    Paul, I entered this string in my criteria expression on the query builder and when I tried to view the results Access asked me for a parameter value, can you tell me what I did incorrectly? Date Processed between [myDate1 = Day(DateSerial(Year(dte), Month(dte), 1))] and [myDate2 =...
  20. B

    Displaying "Current Month" on Report Header

    Can I add year by adding "yyyy" to the textbox?
Back
Top Bottom