Search results

  1. R

    requiring a field in a form

    missinglinq, The user can't ignore the combo293 because it is the first field when the form opens. So trying to move from that field will fire the lostfocus event. I think I figured out the Before Update: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Combo293) Then MsgBox...
  2. R

    requiring a field in a form

    So I have a form for entering a new client to our database. The table (tblClient) is connected (1tomany) to tblHouseholds. The field in the form for adding to households is a combo box. When closing the form if data has been entered and nothing has been entered in the households field an error...
  3. R

    Possible Crosstab query Address Labels?

    Thank you! I had to change the code a little to get the last names to show up but this ended up getting exactly what I needed. SELECT T1.FirstOfClientID AS ClientID, T1.HouseHoldID, T1.[FirstOfPrefix] AS Prefix1, T1.[FirstOfFirstName] AS [First Name1], (SELECT TOP 1 Prefix FROM ClientTbl WHERE...
  4. R

    Possible Crosstab query Address Labels?

    I have created a database for my company to track a various amount of things. I am now struggling to produce a Mailing list for sending out letters to our clients. A simplified version of my clients table looks like this: Clients Table ClientID HouseholdID Prefix First Name Last Name...
Back
Top Bottom