Search results

How can I do something like this in code? Sum(price*quantity) Thanks(very new to access/VBA)

Is there any chance I can get a copy of the demo in 97 also? I tried to do this also and didn't have any luck. I found a different approach, but would really appreciate learning something new. Tnanks, BB

I was doing this calculation =[Gallons][UnitAmt] and was having trouble with it not rounding correctly. UnitAmt is Currency; Gallons is Double(fixed, 1 decimal place). To correct the problem, I think, I changed it to =CCur(NZ ([Gallons]*[UnitAmt])). I don't really understand why CCur is...

Well, I don't think that is quite it. I must be missing something and/or I didn't explain completely. I want to require that at least one record is added to the subform. A request for a vehicle must include at least one driver. (This info is going into my intersection table. A request may have...

I have a combo box (LastName) on a subform (driver infomation). (The main form is the vehicle rental request.) The user picks a last name (or types it in). The SSN is what is stored. How do I make it required that the user must enter at least one driver? What am I missing? Thanks, (new to...

Sorry that I didn't mention that I do want it required. Thanks

I am getting the following message when entering data in a rental form. I get the message when I enter the VehicleNumber(combobox). The PickupDate is further down on the form and yes it is required. It will allow me to continue entering. "The field tblRental.PickupDate cannot contain a NULL...

Can I use IN in an if statement? If so, how?? How would be the best way to do the following? If Me!VehicleNumber.Column(5) IN ("820", "822", "824") And [EndMileage] - [BeginMileage] < 1000 Then Form!fsubPerMileCharge.Form![Quantity] = 1000 Else...

I am trying to create a report that shows the acct to be charged, the acct that receives the revenue, and the amount, so I'm dealing with AcctNumber, RevenueAcctNumber, and ChargedAmount. The user wants it broken down by RevenueAcctNumber(there only 2), by AcctNumber (all accts starting with...

When I try to open my WorkOrder form, I get a message that the macro 'WorkOrder Menu' can't be found. It was OK until, I think, I deleted a macro and replaced it with an event procedure. I had a macro(OnOpen) - GoToNewWO ( Maximize, Go to Record (Form, frmWorkOrder, New)). Then I deleted the...

A newbie question: I know you can query a query, but how many levels of queries can you do?? For example, can I do a union query on several queries, which some of them may be based on a query, and then do a query on the union query? Thanks for any comments!

I am doing a summary report. The acct#, acct name, etc, and total are in the acct# footer. I need to group by the first number of the acct#. Is there some way to do this? Thanks

I am doing a summary report. In an Account footer I have an AcctNumber, AcctName, etc, and a calculated total. Actually, I want to include only those accounts with a negative total. I am able to put code in the OnFormat or OnPrint event (not sure which one to use) and get a row(positive totals)...

I have a report with several subreports. In the footer I total the subreports. Is there some way I can just print those totals that are positive (or negative)? Thanks, NewToAccess

I have a summary report that lists accounts with total charges. (These charges are calculated from several subreports of the different types of charges.) In the account footer, I calculate the total for each account. I really need to group the negative totals from the positives. Can I do this...

I need to print a "44" (earnings code) in a report if the AccountNumber starts with a 2; otherwise, I need to print "45". I am dealing with account numbers 0-00000 to 9-99999. I think the account numbers are stored without the hyphen. (I am using an input mask, 0\-00000.) I think the following...

I have a form where the user enters BeginMileage and EndMileage. After the EndMileage is entered, the difference is calculated and entered in a subform control. How should I handle the fact that the user may change the BeginMileage. In other words, if the BeginMileage is changed, I need the...

I would like to put a default date in because most of the time that will be the date needed, but not always. The user needs to be able to change it. After the date is updated, I need to copy it to another field. However, if the user goes with the default date, it doesn't get updated to the other...

But the user does have the option of changing the date to something other than the default date?

I am trying to use the following: Private Sub AdjustmentDate_AfterUpdate() Me!TransactionDate = Me!AdjustmentDate End Sub I would like to have today’s date as the default for AdjustmentDate; however, if the default is used, the TransactionDate doesn’t get updated. Is there a solution to my...