Search results

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

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

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

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

I have a form with 2 subforms. Both subforms include charges (quantity * unit amount). I want to get a grand total of the 2 subforms and store it in the main form’s underlying table. I was going to use SetValue, but can’t seem to get it worded right. I know I shouldn’t be storing a calculated...

I'm getting this message when trying to do an update query: You tried to execute a query that doesn’t include the specified expression ‘tblRental]![PickupDate’ as part of an aggregate function. Can someone suggest what my problem might be?? Thanks

When I enter data in a form, I would like to add some of the info in a second table. What is the best way to do this? The tables have a one-to-one relationship. Thanks, BB

I need to create a report that simply has account names (and numbers) and the total amount charged for the month. Some accounts won't have any charges. (I have an account table.) The major problem is the charges must be calculated from many tables (such as CreditCardStatement, Rental...

I am trying to print invoice reports between certain dates and only for accounts that have charges. The report has account info (from the Account table) at the beginning of each account group, then several subreports each with a different type of charge, and at the end of the account group is...