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...
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...
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...
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
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...
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
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" & "...
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
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...
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()...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.