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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DIRENE

    Clear all controls on form at once

    Randy, I put me.lstSupChoice.requery on the click event on my command button. And I change the listbox row source to a query name tblOption query. And when I click the button nothing happens. Let me try to explain again what I'm trying to do. The form I made is to make stock cards. The top...
  2. DIRENE

    Clear all controls on form at once

    This gaves me a error that row source type should be a value list. And my listboxe is a table/query Irene
  3. DIRENE

    Clear all controls on form at once

    Randy700, Thank you but I asked for the wrong thing. I don't want the listbox to blank out. I just what the ones that where selected. To be deselected by a command button. Irene
  4. DIRENE

    Clear all controls on form at once

    Vie, I Change your code to clear a listbox. Do you know how to change the code to clear a simple listbox. Irene
  5. DIRENE

    Print a textbox in two columns

    Well I'm stick again. Can anyone tell me if there is a way to have a textbox preview or print in two columns I have a unbound text on my report that on detail format I have Text23 = Forms!frmO!Label1.Caption Which works but I need it to make two columns if there are more then 5 lines . like...
  6. DIRENE

    Split table field

    Thank you so much Bob. That work really great and it was so easy.
  7. DIRENE

    Split table field

    Help, I see a lot of split field threads but I'm not getting now to did it. I have a table with fields name, firstname and lastname. This is the field I would like to split to two other field name: davis, Irene I want firstname: Irene lastName: Davis Then I can do away with the name...
  8. DIRENE

    Using Microsoft Access to create an email merge

    I got it. The error in outlook was because our cable company change our outgoing address and did not tell us. Thanks for all your help. Irene
  9. DIRENE

    Using Microsoft Access to create an email merge

    That worked but I'm now getting an error message in outlook. The message is: Your message did not reach some or all of the intended recipients. Subject: Test Access Sent: 4/14/2004 8:15 AM The following recipient(s) could not be reached: 'ID1900@AOL.COM' on 4/14/2004 8:15...
  10. DIRENE

    Using Microsoft Access to create an email merge

    I would like to sent email to customer I set up your function and change myquery to qrycustomer (name of my query . I have a form with a command button on it on click =sendEmail. I'm getting a 424 object reguired error message when I click the button. Can you Please tell me what I'm doing...
  11. DIRENE

    DONT PRINT BLANK REPORT

    Thank you both for the help. The one that worked for me was the FAQ703-1594. Thanks again Irene
  12. DIRENE

    DONT PRINT BLANK REPORT

    Ok I have a letter builded in a report that pull some info from a query. But if the query is null. The report with still print the letter. The question is how do I get the report not to print if the infor in the query is null. Thank you for any help!!!!! irene
  13. DIRENE

    COMMAND BUTTON TO RUN MORE THE ONE REPORT

    I have a form that has a opition group on it that if you check one month the command button runs the one month report. If you click the 2 in the option group the command button runs the 2 month Is there a way that I can get the command button to run all the different reports base on the...
  14. DIRENE

    Print the value of a Form Label on a report

    I'm sorry about that meant to tell you that infomation. But I have no idea how to start write some real code to do this. Thanks Irene
  15. DIRENE

    Print the value of a Form Label on a report

    I add this line in the detail on format: intRowcount = ( calc no. of rows) Select Case intRowcount Case Is < 5 Text23.FontSize = 12 Case Is < 10 Text23.FontSize = 10 Case Else Text23.FontSize = 8 EndSelect And I,m getting a compile error syntax error thanks irene
  16. DIRENE

    Print the value of a Form Label on a report

    Sorry I again I fooled around with my code and got this to work. The reason for only wanting one set is. I'm trying to do away with hand typing stock cards. We end up type the same thing over a dozen of time for different stock numbers. So I made a form that I type the stock number, vin ect...
  17. DIRENE

    Print the value of a Form Label on a report

    I seem to have one problem still, If I select two thing in my listbox I get two set of information If I select three I get three ect. Any ideas to just get one set
  18. DIRENE

    Print the value of a Form Label on a report

    Sorry and Thank you I got it to work
  19. DIRENE

    Print the value of a Form Label on a report

    It's really a label and when I put on format on the report detail area: LABEL1= Forms!frmO!LABEL1.Caption If I run the report I get a error access can not find the marco LABEL1= Forms!frmO!LABEL1.Caption Irene
  20. DIRENE

    Print the value of a Form Label on a report

    Hi All, I have a form that has a simple Multiselect ListBoxes on it that pulls the ones I select to a label on the form. Now I would like the report to pull the value of the label to the report so that everything I select is in one group. Like: blue 4dr xlt trim Thanks for you help. Irene

Part and Inventory Search

Back
Top