Search results

Midge You forgot to attach the .mdb! shay

Midge Had you not assigned the calculation to your Age field/text-box? Do you still have a problem? shay

Let's take a step back. The "yyyy" is the interval argument for the Datediff function. It tells the function to work out the difference between the dates in years (rather than in months or days etc). Therefore, as I understand it, it has nothing to do with the way you state the dates when...

One solution is to have an integer field CourseNo in your 'many' table with validation rule '<=5'. However, if the 'no more than 5 courses' rule only applies to some students, you'll probably need to use code to do what you want. hth shay :cool:

What does the error message say? I'm running Access97 here and the code I sent works for me. shay

Try... strCriteria = "[NewProp] = True And [FinCoID] = 'MyBank'" hth shay :cool:

This should do it ... DateDiff("yyyy", Me.DateofBirth, #9/1/02#) - IIf((Month(Me.DateofBirth) >= 9 And Day(Me.DateofBirth) > 1), 1, 0) hth shay :cool:

Hi Subspaid is a Yes/No field not a Text field so it will never equal the text string "No". This is what you want... SELECT managersname,team,fullname,address,telephoneno,sub spaid FROM Players WHERE managersname="Joe Bloggs" AND subspaid=No; hth shay :cool:

If you just want to subtract the total expenses from the sales total, this should do it... NetTotal = DSum("[Sales]", "Gross Sales") - DSum("[Expenses]", "Deductions") shay :cool:

Not sure I understand why you want to do this but the following code should do it for you. It assumes the text is being written to BoxLocation in table "Check box info tbl". Private Sub chkTL_Click() CheckText = "Top Left" ProcessInfo chkTL, CheckText End Sub Private Sub...

I'm not sure that the PCs regional setting is important. I would recommend using an input mask so users are clear how they should input the date and then format your dates to US format for all date functions. I'm sure someone will correct me if I'm wrong! shay :cool:

That's fine - you don't have to display the extra info in the combo box. Just make the width of the additional columns zero. Then all the user will see is the customer ID but the customer name and address will be there available for you to use. shay :cool:

Not sure that I fully understand how you plan to implement your scheme but this might help ... Me.NumFullPallets = Int(Me.ReqdQuantity/ Me.MaxPerPallet) Me.NumOnLastPallet= Me.ReqdQuantity- (Me.NumFullPallets* Me.MaxPerPallet) shay :cool:

Hi You could include the customers name and details with the ID in a combo box. After a selection is made set me.txtCustomer = "You are " & me.cmbCustomer(1) & " from " me.cmbCustomer(2) & "." In this example, the customer name is in column 2 of the combo box and the address is in column 3...

When using date functions, format your dd/mm/yy date like this format(YourDate, "mm/dd/yy") shay

Possible solution.. Run a query to do the calcs and then refresh the form to show the calculated values. hth shay

Hi Can you explain a bit more about table 2. What's col1, col2, col3, col4? shay

Yes you can! Put your option buttons into an option group and set the option group's control source to the field you want to store its value in. hth shay :cool:

Hi Not sure from your post if the date and time are being set automatically. If not set the date & time fields as follows: If IsNull(Me.txtDate) Then Me.txtDate= Date If IsNull(Me.txtTime) Then Me.txtTime= Time Code could go in the form's OnCurrent event. hth shay :cool:

Your Inquiries table needs a field to store the associated Payment number and the text box that will display the assigned payment number must be bound to this field. Then the line Me.txtPaymentNo = DFirst("[PaymentNo]", "Payment Numbers tbl", "[Assigned]=No") will do what you want ie "give...