Search results

store your SQL as text, and block out your "parameters" within the string using a pipe delimiter along with identifying text. Use the Replace function to replace place holders with appropriate variable data. strSQL = "SELECT * FROM table1 WHERE field1 = |targetF1| AND _...

Nick Searcy -- The Fugitive The guy is fish food! Fine...go get a cane pole, catch the fish that ate 'im.

Michael Ironside -- Total Recall

Dim qdf as QueryDef dim strSQL as String Set qdf = CurrentDb.QueryDefs("YOURQUERYNAME") strSQL = qdf.SQL

look at the help file for DoCmd.OutputTo. use the output to command to create the file, then open it with the shell command.

this thread discusses how to open an external file.

...did you remember that in A97, you don't set the value of .hide, just Form.Hide and Form.Show? I remember having to get used to setting the .Visible switch when Access was "upgraded" and there is this article: http://support.microsoft.com/kb/121899

(FIRST & " " & LAST) what I don't get, is that Left(FIRST,1) & " " & LAST AS Expr1 should NOT produce James Jones :confused: EDIT: never mind...neileg beat me to it

Sonny Landham -- Action Jackson :eek: Love that movie...a guilty pleasure of the 80's action flicks

set the tag property of the checkboxes to something distinct like "countThis" now, cycle throught the controls selection and count: Dim i as integer Dim ctrlIDX as integer i=0 For ctrlIDX = 0 to Me.Controls.Count If Me.Controls(i).Tag = "countThis" AND me.Controls(i) Then i=i+1 next...

OK...so we're starting from scratch. Instead of a text field, make the field an auto number and primary key. With each new record, the number will increment.: 1 ....... 2....... 3......... Now in the format property of the field, enter 000000 and that will force the number to be displayed...

OK, before I go off on a tangent... Do you actually have this key field established (INCLUDING how to increment the number)?

either or. You can use it in a query, you can change the field definition in the table, or you can simply format your text box to show the proper format without changing your table or the underlying data

use Integers with the format statement instead of text: Format(YOURNUMBERHERE, "000000")

record count in this particular DB is counted in trillions and the SQL string alone is 1600 chars long. While the heavy lifting is normally done in SAS or TSA, this particular app is just some "light" reporting work with an Access front end.

without getting too specific, no. I have several data loads which requre anywhere between an hour and an hour and a half to load. My failsafe point is a 10 hour timeout.

OK...so I can't get back to Krull from that one...new tactic;) : Ursula Andress -- Dr. No

I actually prefer building them in VBA to the query painter...but then I also consider the query painter something akin to the spawn of Satan:D anyway, the below should point you in the right direction: Dim conn As New ADODB.Connection Dim rec As ADODB.Recordset Dim rawData As...

it will pass you the coordinates of the click, so technically if you know the column widths, you can extrapolate the column clicked. I was unable (in my admittedly brief search) to find a way to locate the highlighted column in datasheet view.

the new limited edition DVD is great... I...can't...stop....:D Freddie Jones -- KRULL