Search results

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

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

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

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.

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

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

Bob, I attached it below

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.

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?

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?

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

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

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

I made a typo, thanks again.

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

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

I got it to work, thanks so much Paul

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

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

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