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!

  • Congratulations TouchToneTommy 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: *

  • Users: DIRENE
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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
  4. 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...
  5. 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
  6. DIRENE

    multiple listbox value printing on report

    I have a form with a listbox(simple) and a command button on it. That on the click button I have the code: Dim strWhere strWhere = "" Dim intI As Integer With Me!lstSupChoice For intI = 0 To .ListCount - 1 If .Selected(intI) Then If strWhere = "" Then...
  7. DIRENE

    Value of list box to print in a report

    Hi, I have a form that has 2 listboxes on it when I click on something in the first list box it moves it to the second listboxes. Can anyone tell me a easy way to print a report of all the value in the second list boxes. Thank you, Irene
  8. DIRENE

    Dear Sir if letter is going to a Company

    I have a report rptFirstLetter that has a textbox for full name that pulls off a query that FullName: StrConv([FIRSTName] & " " & [LASTName] & " " & [companyname],3) On the report I have a textbox that has a control source of ="Dear" & &quot...
  9. DIRENE

    Is there a way to get Text Box in proper case on a report?

    I have a report named rptLetter on the report I pull customer information from a query. Every thing in my database is typed in caps. Is there a way to get them to pull in my report like Irene not IRENE. Thank you, Irene
  10. DIRENE

    Opening a word off of a query using a form

    I need to sent customer letter when the purchase a new vehicle from us. What I need to do is have a form with option goup on it 1month, 2month ect. and a button that if option 1month is select that word opens with a letter named :one month making a letter from each person that matches the query...
  11. DIRENE

    MERGE ACCESS TO WORD

    I have see this Public Function CreateWordLetter a number of time and it seem to be really simple to use. But I can not get it to work maybe someone can help me I have the function name createWordletter I have a form with a command button it that on click I have: Private Sub Command45_Click()...

Part and Inventory Search

Back
Top