Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by NC1977

  1. NC1977

    How to set focus on a field list

    It is a command button...Would you this in the Afterupdate property of my field list??? Thanks
  2. NC1977

    How to set focus on a field list

    I have a form with a field list. Once the user selects from that list, he can then proceed to another form to enter additional information. I would like for it to be impossible to continue to the other form without having selected from my field list. How can I do this?? Thank you
  3. NC1977

    Error Handlers on a form

    Hello, Here is my script to handle a few errors on my form before the user can print: If De > A Then Msgbox "Your FROM date cannot be bigger than your TO date" ElseIf IsNull(Mandat) Then Msgbox "Please enter the file number!" ElseIf IsNull(De) Then...
  4. NC1977

    Subject line of an email message through code

    Last question, I'm trying to set the output format to Rich text format... How do I put it in my code?? I've tried RTF, Richtextformat, rtf, this doesn't work...any ideas??? Thanks
  5. NC1977

    Subject line of an email message through code

    Remou it worked! Thank you thank you! wonderful!
  6. NC1977

    Subject line of an email message through code

    Actually the subject line reads Forms![Requete Lawson]![Mandat]....But I think what Remou said is correct, I should save the record first however, half of my form is bound and the other isn't...I'm not sure how to save my record to a new table and then run the email code all in one command button???
  7. NC1977

    Subject line of an email message through code

    Good morning, I have a form, with a command button that once clicked sends my report directly to the users email so that he or she can email this report. The following is my code: DoCmd.SendObject acSendReport, "Requete Lawson", , "xxxx.xxxx@lakdsjfl.com", , , Forms![Requete...
  8. NC1977

    Field selection on a form for a report

    I've got OnOpen OnClose OnActivate OnDeactivate On No data OnPage and OnError...That's it. I do have the OnLoad for the form and I did put the statement in a form to test.. This is my code for the onclick event: Dim strSQL As String strSQL = "SELECT " & Me.Combo359 & ", " & Me.Combo361 & "...
  9. NC1977

    Field selection on a form for a report

    Ok, I did what you said except for the onload event as their isnt' one for reports so I put it in the onactive property.. I'm still getting the same error..I tried putting the results in a form so that I could try the onload but it doesn't work. Could it be the Me part of me.RecordSource=strSQL???
  10. NC1977

    Field selection on a form for a report

    Hello Again! Ok, this worked...except for one thing, I've got my statement running and opening in a report. The field list for the report doesn't contain any of the fields requested??? The field list box's title is my sql statement??? I'm soooo close I can almost taste this! I'm very excited
  11. NC1977

    Field selection on a form for a report

    I'm sorry, I'm not being very clear am i? ok here it is: I have a table with about 45 columns. Not sure how to attach a spreadsheet to my email...I'll try to explain: Col: Division - Group - Region - Trend - EBIT - Safety Trend - etc..(45 columns of this) Rows: Fairlfield - Book - USA - 1...
  12. NC1977

    Field selection on a form for a report

    Ok, this works except for one thing, I believe I need to create some kind of relationship between my field lists in my combo box and my table..when I run the report I get the columns I have selected but like this: LEGAL ISSUES TREND SAFETY TEST UNION LEGAL ISSUES TREND SAFETY TEST UNION LEGAL...
  13. NC1977

    Field selection on a form for a report

    Hi Bob, I've created a table with the list of all 30 columns. Then added 5 combo boxes to my form. I really don't know however how to formulate a sql statement? I know how to select fields etc, but only if I name them...how do I pass the argument of " take the field listed in each combo...
  14. NC1977

    Field selection on a form for a report

    Hi! I've got a form, where the user can select a division or Group or region and it runs my query "Pivot Table by Division" with these parameters. Now I have 30 columns in my QRY and I want the user to be able to select up to 5 of these colums (the capital ones, I only put 3 as an example)...
  15. NC1977

    Picture to change on report depending on the query

    ok, I've linked my table with the picture names to my query. I've found the on format so that I can add code. I now don't know what code to put??
See more

Part and Inventory Search

Back
Top