hi
i create an image with text in it and then i save it as a png and when i try to use it in a web page the quality of the text is very poor, not sharp. I have tried creating the image the same size as the final button and also larger, then scale it down beofre saving it as a png but there is...
Hi,
I am typing directly into a table field (memo format) I want to include (and appear with) line breaks ie
Text
appears in
this
type of format
NOT LIKE THIS:
Text appears in this type of format
any ideas on how I achieve the paragraph like format?
Bingo! worked your usual magic again PHV cheers!
ps didn't know about that Nz function either - v useful.
ps for anyone else reading thread - add another bracket in ie:
TRANSFORM CLng(Nz(Sum(qry02_05_CashReportCheck.[Converted to £]),0)) AS [The Value]
Hello All,
I have a union query based on two crosstab queries. I have formated both xtabs' fields The Value and Total as Standard with 0 decimal places. However in the union all the decimals come back. How do I set the formating in the union to 0 decimals (Please note the number and titles of...
Hi PHV, thanks for your reply, yea tried that and I get a 438 error object doesn't support method/property. RowSource returns blank (which I would expect from looking at the properties tab)
(nb - also want to auto refresh the pivot table from the form, basically when the form opens - I've...
Hi all,
stupid question...
I've searched high and low, a few times to avoid accusations of a "man-look"...
but how to I id what query/table/sql is providing data to a pivot table on a form?!
Thanks in advance.
Hi all,
Is using this code enough to clear a collection (the same rst.close and set rst = nothing)?
set cln1 = nothing
Why I ask:
I have stripped out a load of temptables and replaced them with custom collections. Complicated SQL's were used to populate combo boxes and list boxes. Now user...
Hi MajP,
apologies for my late response, I've been away. Apologies also because I have posted the code incorrectly.
it should be:
dim inst as new clsprocess
inst.mstrengid = ctl1.column(1)
inst.mstrcontractid = ctl2.column(1)
clnIDs.add inst
set inst = nothing
Can a user defined function like this be put in an independant module and be referenced from a controls rowsourcetype property, or does the code have to be in the forms module?
Hi PH,
This is the general principle (don't have the specific code to hand)
I have a class module clsProcess.
In it I have these statements:
Public mstrEngID as string
Public mstrContractID as string
On a form I have a tab control.
On the first tab there are two unbound controls. One selects...
I don't know how to do that?
Do I just declare:
public column as string?
What then...how do I set it when I'm adding instances to the collection...sorry for my ignorance...this is all pretty new to me and I'm having trouble visualising it
What is in clnCDetlRateList:
a collection of any number of rows, but on average below ten. Three columns of seperate data. All strings as defined in a class module.
Hi,
as I'm debugging in Access97, when I step into the code whenever I come to a line docmd.gotocontrol xyz the message command not available appears and I have to end the code.
Is there a way to step over this line or do something so I don't loose the flow of stepping through?
Hi guys,
I've tried PH's code and got runtime error 438; Object doesn't support this property or method and debugger goes to this line:
ReturnVal = clnCDetlRateList.Column(col, row)
I tried
ReturnVal = clnCDetlRateList(col, row)
and got compile error, wrong number of arguments or invalid...
Hi guys, unfortuneatly i am using 97 so i'm bound by the 2048. I like the look of your code though PH, I'll give that a shot tomorrow. Thanks again for your input.
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.