Search results

DSum accounts for NULL values already (doesn't it? - Does in my tests) Or are you trying to allow for [AssessmentNo] being Null? What error are you getting?

coryt: The Allow Zero Length property is in the Table properties, not the form.

Creating your own buttons - Too much work ;) If you don't mind your subform receiving the focus, you could add this line to the start of your code Me.Subzoeken.SetFocus That way you can continue to use your label. Brad.

2 options come to mind: (perhaps) 1) Possible to use a label? 2) Set properties of text box to: - Enabled: No - Locked: Yes - Then alter appearance as required. HTH Brad.

The Null or Zero Length String error is occuring as your table has the Allow Zero Length property set to NO for the offending fields. Set this property to YES (As you have some data without Address2 etc) and you will not get the error.

This Null error occurs because I removed you IsNull test. Also worth noting. Your keyword does not update until you move the focus off the keyword field. If your cursor is still in the keyword field, then the SQL criteria still uses the old keyword. This "focus" issue is caused by using a...

JvM Try changing your code to: Private Sub Bijschrift5_Click() ' declare variables. Dim Keywords As String Dim fieldToSearch As String Dim Criteria As String Dim SQL As String ' remove leading and trailing spaces, if any, from user input. Keywords =...

To have "NewData" appear in your combo, you will need to requery the combo (not the form). Me.Combo0.requery (Or you could refresh the form - Me.FrmTest.refresh ) I think the combo requery is preferable. Brad.

Use the Where clause: DoCmd.OpenReport "RptName", , , "RecordOnReportID =" & Me.RecordOnFormID Brad

Ah, Fizzio cracks it again. Good work.

Perhaps I am just a bit old fashioned. I never really understand why you would permit a user to have any interaction with a primary key. This only causes more background work for us poor programmers. Then introduce the multi-user scenario, and you start playing with before update events and...

Try: DoCmd.OpenForm "Your2ndFormsName", , , "[NewRecordID]=" & Me![CurrentRecordID] You will need to alter the NewRecordID & CurrentRecordID to suit your needs. Brad.

A: See http://support.microsoft.com/default.aspx?scid=kb;en-us;209966 B: (I Prefer this method) : Check out: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40119&highlight=word+automation (Particularly good demo posted by Jon K.) Brad

No, Sorry Beef. By "Why beef?", I meant: Why the name "beef"? Sorry, my fault, I should say what I mean. :) It is good to see a few more Aussie's on this forum though. Cheers Brad.

Is there a need to have the 2nd two NHA's as combos ?? If not (ie: you are only using them to display Column(x)) then I would change them to TxtBoxes. Hmm, office fridge is looking empty. Might have to go home. But wife is at home????? And PUB is closer. . . . . Dilema number 63 for...

Why Beef?

Caleb, Access does all this work for you. You need to create a main form that uses your Tbl_Orders and the recordsource, and a subform that uses Tbl_Orders_Products as it's recordsource. If you create the correct Master / Child relationship, Access will create the OrderID in each table as...

No, It's OK, I have just been to the fridge. Restocked and ready to go. I assume you have adjusted my code to allow for the fact that my fields were disabled (enabled = false initially. Becomes enabled = true on Not In List event) (You of course will need to change the enabled = true to...

Ahhhh, That was the last of your beer Len. Now, who else's beer can I drink????

You will need to "Group by" in your rowsource to avoid multiple listings. You may want to check out Beef's examples here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49333 Brad