Search results for query: *

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

perfect, thankyou

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?

Hi PHV, I am still falling over this, I just wondered if you had any other ideas. No problem if you don't. Thanks sub5.

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]

...ON (qry02_05_CashReportCheck.Week = tpcsWeek.Week) AND (qry02_05_CashReportCheck.AP = tpcsWeek.AP) GROUP BY qry02_05_CashReportCheck.RRCAELAllocation PIVOT qry02_05_CashReportCheck.Project; Union query SQL SELECT * FROM qry02_10_CashReportCheck UNION ALL SELECT * FROM...

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.

ps End seems to help but kills all my variables.

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

search and replace here I go, cheers majp.

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.

Yea, that's what I had been doing, just got tired of the faf!

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.