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 Mike Lewis 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: sub5
  • Order by date
  1. sub5

    poor quality png

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

    include line breaks when writing in a memo field

    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?
  3. sub5

    Pivot table data source

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

    format Union query with dynamic columns

    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]
  5. sub5

    format Union query with dynamic columns

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

    Pivot table data source

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

    Pivot table data source

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

    error 3048 and custom collections

    ps End seems to help but kills all my variables.
  9. sub5

    error 3048 and custom collections

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

    user defined function as source for combobox

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

    user defined function as source for combobox

    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?
  12. sub5

    user defined function as source for combobox

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

    user defined function as source for combobox

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

    debug step into code, docmd.gotocontrol in the way

    search and replace here I go, cheers majp.
  15. sub5

    user defined function as source for combobox

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

    debug step into code, docmd.gotocontrol in the way

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

    debug step into code, docmd.gotocontrol in the way

    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?
  18. sub5

    user defined function as source for combobox

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

    user defined function as source for combobox

    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.

Part and Inventory Search

Back
Top