Search results for query: *

Ok - The problem here was that some values in the field TenderPrice were indeed null. However the type double does not accept null values. Wrote a very quick SQL Update query to fill each TenderPrice field (row) with a 0. Solved the problem.

Thanks, I had spotted the brackets that were missed and corrected. Still get #Error in ExpectedTC field of the qry when running it. All values are of type currency. Any ideas. Anyway, thanks for all you help.

Hmm... thanks for the help. Now I get the result #Error in the ExpectedTC field. How do I trap the error - or trace it?? cheers

I'm trying to refer to fields within query "qryCost" to evaluate the value of ETC. I have a field in qryCost ExpectedTC: ETC(). However when I run the query all it returns in the EpectedTC field is 0. Would appreciate any advice. Do I use DLookup... and if so how. cheers Function...

Works a charm. Thanks all

Thanks Are there any easier ways to do this - Select Case statement appropriate?? cheers

I have three fields in a form Budget, CostToDate, and TenderPrice, and one field "EstTotalCst" I am trying to "calculate" from these. Fields refer to fields in table tblCost. My If-Then-Else Statment placed in the AfterUpdate event of "EstTotalCst" is failing...

cheers. Text box is in form. Suggestions have both help in solving problem.

I am trying to use expression builder in Access2000 to provide a value in a text box. The control source of the text box {ExpectedTCost) is: =IIf(IsNull([Projects]![TenderPrice]),[NCSdata]![Budget],[Projects]![TenderPrice]) in other words - if there is no TenderPrice value provided, then...

This is what I came up with - it works for my situation Sub GS_1() ' ' GS_1 Macro ' Macro recorded 26/2/2002 ' ' Keyboard Shortcut: Ctrl+j ' ' Set cell X6 = 0 Dim bob As String Dim counter As Integer Range("$X$6").Select ' Select the cell in which we are pointing the Goal Seek...

Thanks for the followup's.

New to this - please don't give me too much of a hard time! Using Excel 97 I have a column of values (calculated values) G5:G3000 which range from 0 to 5. Their values are altered by changing cell A1 (which holds a formula) and various other caluclations. Using MS Goal Seek function I want to...

Cheers Will give it a go later and report back on the success. Sorry, but indeed I actually meant that i was using the "export and preview" routine in FW anyway.

I am exporting (via copy and paste) a menu (simple rollover buttons) into an editable region in my Dreamweaver built web page. However, when I paste the menu into the editable region, all references are relative to the root eg 'File/c:///mydocuments etc.' when in fact the menu images have been...

Josh - I'm also trying for hlp in the www.vbforums.com / databases area. You could post there??. Please let me know how you go (hugh.manson@sdc.govt.nz) and I'll do the same if you wish cheers

On stepping through the code it fails at Set db = Currentdb() - withe the result that it = nothing. Weird - what did i miss here??.

Oops, just got your msg happen609 after aI posted mine. I any trying to have access load and run the qry (qryBridgePhotos) after the users selected the bridge they want to look at from the combo box. eg. I'm trying to make sure that the qry referenced is loaded as the roecordsource of the...

Thanks for the advice. BridgeID is numeric (double). Still getting the error msg. cboBridgeID has a row source type of Table/Query, with the following Row SQL SELECT DISTINCT qryBridgePhotos.ID, qryBridgePhotos.BridgeID, qryBridgePhotos.RoadNo, qryBridgePhotos.Name FROM qryBridgePhotos...

Any advice appreciated. Having problems getting image to load in an unbound object frame, based on selction made in combo box. Tried this code in Combo UafterUpdate event: Private Sub cboBridgeID_AfterUpdate() Dim rs As DAO.Recordset Dim db As DAO.Recordset Dim strSQL As...

Thanks for the link. I've had a look. Could not find any appropriate articles. I am specifically looking for help with code that can load images into the image frame, after selecting an item in the combo box. More details????. Look forward to your comments. kw