Search results

  1. C

    Delete a record if certain text is not found

    Sorry it should be DELETE * from yourTable WHERE (((YourField) Like "*HGIO*"));
  2. C

    Delete a record if certain text is not found

    Probably easier to create a delete query. DELETE yourTable WHERE (((YourField) Like "*HGIO*"));
  3. C

    Email generated by check box

    Your very welcome. I come to this forum normally because I'm bored with my current project, and this gives me something different to do, and keeps me sharp. Also, I remember not so long ago when I struggled with Access and this forum was invaluable to me. I'm just giving back.
  4. C

    Email generated by check box

    In the click event of the check box, use the following code dim strMessage as string strMessage="Clearsky24" & Chr(13) & "1920 Abrams Pkwy #318" & chr(13) & "Dallas, TX 75214 " & chr(13) & "800 895 6360" & chr(13) & "info@clearsky24.com" & chr(13) & chr(13) & "Customer Name: " &...
  5. C

    Email generated by check box

    First, you'll have to design a form for this. You can't fire an event (make something happen) from a table. When you get the form setup, you can use the click event for the checkbox to send the email with the DoCmd.SendObject command. Let's take this in baby steps. First create the form to...
  6. C

    help with yes/no feature

    In the click event of the check box dim strLinkCriteria If checkbox=false then strLinkCriteria="[YourID]=" & me!YourID DoCmd.Openform "yourformname", ,strLinkCriteria endif the strLinkCriteria filters the new form to only display the current record from the form you are unticking the checkbox...
  7. C

    make form from a query

    Create your parameter query, for example Select * from tblYourTable where YourDate Between [enter start date] and [enter end date] Save the query, then set the recordsource property for the form to the parameter query you just made.
  8. C

    Adding data to beginnig of field

    Ah, now we have found the source of the problem! If Combo22= "A" Then open the form and fill in Now, as far as the comments field, if the name of the form is frmComments and the name of the comments field is txtComments, after you open the form in your code use...
  9. C

    Adding data to beginnig of field

    That's why your code isn't working. AcceptReject doesn't equal A or R. Let's back up. What is your combo box's name?
  10. C

    Adding data to beginnig of field

    No it doesn't change anything, put the message box command before the code that opens the form.
  11. C

    Adding data to beginnig of field

    in the afterupdate event of the combobox, enter this command MsgBox AcceptReject Then change the value of the dropdown from A to R then back to A again. What pops up in the message box when you do this?
  12. C

    Set Date Value

    You need to store the date in a field in the table, and make sure the textbox you are setting to the current data has the Control Source property set to the date field in the table.
  13. C

    Database is in unexpected state

    Create a new db and import all of the objects from the corrupted db.
  14. C

    Add memo field to form

    Make sure you set the Control Source property for the memo field on your form to the actual field in the table.
  15. C

    Jumping to a specific record using gotorecord

    Normally the best way to jump to a specified record matching a criteria, you set the form's bookmark property. I know you say that your VB isn't too good, but it's never too late to learn. in the onclick event of your command button, use this code Dim rst as recordset Set...
  16. C

    2 column combo ?

    if you are looking for the value of the first column, you need [Forms]![frmSearch]![ReportMonth].Column(0)
  17. C

    2 column combo ?

    =[Forms]![frmSearch]![ReportMonth].Column(1) ?
  18. C

    Multiple records displayed in one mail merge page

    In MSWord, try making a custom label. Size it so that two labels (invitations) will fit on page. I've done this very thing for printing IRS 1099s (3records per page) from an Access database. When you create a custom label, you can access the label height, width properties, as well as the space...
  19. C

    Find record in table and populate fields on form

    You're always so much better at explanations, Pat!!
  20. C

    Find record in table and populate fields on form

    Ummmm...I think you are making it a little more difficult than it needs to be. Also, you can't set a form's bookmark = to a recordset bookmark based on a table (it needs to be a recordset based on the form's recordsetclone). I don't even know if I understand what you want, but let me take a...
Back
Top Bottom