Recent content by andrewfly

The table is generated dynamically each time the database is run. This application should be a standalone visual basic application, however it was handed to me as is...it is more of an application than a database. I've done what modest suggested, and load the table into a temporary recordset...

Just change the order of records in a table based on the data in the CTSort column...a simple sort via vba (or sql).

Doc, One quick question for you. I have added the sort field, and all works well. However, out of curiosity, I was wonderinf if you had any suggestions to remove a step from my code. I've learned that you can not execute an SQL statement on a table unless it somehow physically changes the...

So i guess what this says is that I can, as Newman suggested, add some numeric value into this new field, and then have an appropriate orderby criteria on the form to force these records to the end. Thanks boblarson

Interesting solution...never thought of that...I'll give that a go, but, is there any way you know of to actually move the record to the end...essentially, lets say... Im sifting through records A-Z, I come to record D, but it is dependent upon a calculation that is performed in record R...

Simple problem, I think...just never had to do anything like this... Essentially, if the text in the field [HSTemp] starts with CT, I would like to move this record to the end of recordset (making it the last record). Once I find the CT flag, I can't seem to get the record to move to the end...

Well, you can stop helping me now if youd like....i've got everything pieced together such that it seems to me like it should work....however it forever freezes access. this is what i got... Sub CalcPSA() Dim dbs As Database Dim PSATable As Recordset Dim JA As Double, JC As Double, CA As...

im from the us in the northeast, but lived in brussels for the past year...just got back a month or 2 ago

where are you located btw? UK, US...etc??

I suppose the issue that I am having is this...will the parser youve started me off with still leave the mathematical functions in place? ie, the + - * / signs? Lastly, should the <first variable name> be replaced with the actual source of the variable; ie, result = result & PSATable!JA I...

Workmad...thanks a million...that should help a lot...i owe you one.

Workmad...thanks once again...I've tried the second scenario you discussed to no success...your first suggestion is interesting, and it should work. However, I'm having a bit of trouble piecing together your outline code. My experience with string parsing is quite limited.

Does the EvaluateExpression() function even know what those variables are? I've got Sub CalcPSA() Dim dbs As Database Dim PSATable As Recordset Dim JA As Double, JC As Double, CA As Double, cs As Double, AmbT As Double, HSnkT As Double, Va As Double, Vb As Double, Vc As Double, Vd As Double...

Alright...I am almost there with the parsing. Ive got everything up and running in the Immediate window in VB, however when I try to run the function in Access, I still get the type mismatch error. The function EvaluateExpression() is looking at my string which would be an equation, for...

See, Im an engineer...notice the differences between and engineer and a computer science guy?