tinmanjo

i tried to pdf and image formats and the pc rises to 100% each time, also that isnt a good solution because the output for any graphc takes ages to produce.

Hi, someone showed me a while ago but ive totally forgotten how to do it, a student had over 16000 cells of analysis data with data set ranging from -0.002-5.0066 ... and so on, the problem was getting the data in a graph, it displayed ok but nearly killed the printer spooler trying to print it due to sheer amount of samples it had to plot. Some one showed me how to sort by taking a 10th of each data set using some integer based sorting routine which would in the end display the graph exactly how it would with 16000 samples, but i cant remember exactly how he did it. Does anyone know how to print a table of value 16000 items without the data looking different on the graph of reducing accuracy.

Cheers for that, it worked, saves a heck of a lot of scrolling, this student had like 15000 rows to fill. Thanks.

Hi, I have want to create 2 columns of data which extend over thousands of cells, to simplify say i want to create a formula which is:- Cell A1A =1 Cell B1A=A1A+1 how do i replicate this formula down to thousands of cells without having to drag the selection box down forever. Is there a way to specify a reference grid to copy formulas to i.e: A1A:A16000

Ah damnit, i just realised the default enter key setting was set to create new line. solved.

Yes Ive tried -1,-2 ,3 gives error, im not sure if somehow the textbox changes focus after the change of Vbcrlf. the cursor suddenly jumps and creates a CR when i haven't added one.

Hi, Im strugling with an old hat problem with multiline textboxes, im programming in VBA and i want to create an emulated console for doing script like querying, however ive tried:- text1.text=text1.text & vbcrlf & ">" text1.selstart=len(text1.text) but the damn cursor moves to the next line after the ">" eve though i havent made an extra carriage return, any ideas why this is happening?

Its on the catridge when you pull a tag/strip out of the side to prevent toner leakage, sometimes if this is blocked it prevents the toner from transfering. its basically like leaving the strip in which gives you a blank page.

try reseting Lamp hours to 0, this gets a bit of extra juice out of DP's, but im not sure if this is on your model, ours are panasonic and sanyo etc..

Its possible you have got a bad batch of Magentas, if not try and run a cleaning page, also check the that the toner inlet isn't block.

From what I can remember we found it to be caused by either an adobe addon or Endnote (Cite while you write), one of these was causing problems so the Save As dialog wouldnt appear. If not try and delete the default template .dot file because this could be corrupt which can cause a whole load of problems.

I have a sub form which I want to place in a precise place on the desktop using the mouse coordinates but the form ends up in the wrong place, basically i want to place the subform near the mouse when i double click on a list item. here is the subform code, the problem is it ends up loading in the wrong place, i think it may be that access stores the mouse position differently Private Declare Function GetCursorPos Lib "user32" (lpPoint As _ POINTAPI) As Long Private Type POINTAPI x As Long y As Long End Type Dim a As POINTAPI Dim b As Long Dim c As Long Private Sub Form_Close() Form_frmMain.List0.Requery End Sub Private Sub Form_Load() ret = GetCursorPos(a) With Me .Move a.x, a.y End With End Sub /edit: hmm i think i know what i might be, the coords need to be converted to twips/pix instead of pixels ?

Cheers for that, works brilliantly!

I think you mean Now(), this gives the current system time and date.

This is an old hat solution that seems to work with some corrupt docs, open it within Open office, and then try and save is as a new file. This works with a lot of so called corrupted docs.