Recent content by sub5

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]

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.

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.