Search results for query: *

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...

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

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

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

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...

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

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...

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

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...

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...

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

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

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...

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

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

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...

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

Sorry and Thank you I got it to work

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

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