Search results

I found the following bit of code on the following website http://support.microsoft.com/kb/196652/EN-US/ Function AsymArith(ByVal X As Double, _ Optional ByVal Factor As Double = 1) As Double AsymArith = Int(X * Factor + 0.5) / Factor End Function When I use it as...

Not quite there it seems to round down NOT up, here's my code Me.TxtCost = Round(Me![Billable Hours] * Me![TxtRate], 2) Billable Hours(1.5) * TxtRate(10.39) gives 15.58 instead of 15.59

Thanks I thought it must be easy

I have a problem with rounding. I wish the field TxtCost to contain the rounded up result (2 Decimal Places) of Billable Hours * TxtRate. It appears correctly on the screen but it stores the unrounded figure in the table. Here's my VBA code. Private Sub Billable_Hours_AfterUpdate()...

That's just perfect. Thanks

I want two versions of the same form. First one allows updates the second one is view only. Is there a quick way of doing this ??

Sorted it now thanks. Apparently you can do conditional formatting one field based on results of another. Should have tried this before. Thanks

Its Access 2007, what options should I use ??

I have tried the following code just to try and make these fields invisible and I still cant. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.[TxtOut].Visible = False Me.[TxtStage].Visible = False End Sub Is it to do with putting the code within 'On Format' on the...

I have created a text box now with some text in it and I've got the following bit of code in ON FORMAT of the Report. Basically if field 'Outstanding' is Zero then I dont want to show the 2 text fields, TxtOut and TxtStage Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If...

Is it possible to do conditional formatting on a Label within a report, I know I get the option on the Control Source but what about the label attached to it. Basically if the value of the field is zero I don't want to show either the Control Source or the label ??

I have created a Form which has 5 fields in it. One of the fields (Rate) is based on a DLookup from data in a Combo Box which is Field 1. When I open up the form to enter a new record i get #Error in the field (Rate) because it obviously has got no value in the Combo Box. How do I stop this...

Seems to have sorted it. Thanks

Whats wrong with the following syntax:- =DLookup("[Billing Rate]", "Employees", "[ID] = ""cboEmployee.(column(2)") which is the Control Source for a field on my current sub-form. I am trying to lookup the value of 'Billing Rate' in 'Employees'(Table) where 'ID" = the current entry in column 2...

Sorry about this but I'm still struggling with this problem. I attach a copy of the objects, any help would be appreciated

Did as you say got 2 columns within the combo box, and put the code in 'after update'. How do I get it to populate my field called NewRate on my display form ??

Yes it was that simple with a drag and drop Thanks

I have a form which has a Combo Box-Table/Query which retrieves a list of employee names (fieldname 'Employee') syntax as follows :- SELECT [Employees Extended].ID, [Employees Extended].[Employee Name] FROM [Employees Extended]; I wish to select another field (Rate) from this file (Employees...

I wish to print a document with all the normal headers and then 2 sub-reports. Can I align the sub-reports side-by-side on a landscape document rather than one on top of the other ???

Just what I wanted. Cheers