Search results for query: *

kaht, I needed to hide some inputs (answers) from some calculations until the answers were calculated. I used your code for hiding / showing the information (in a table). I used the calculate button to turn on the answers (show) and the reset button to turn off (hide). This is worth a star...

By jove I think you got it kaht. Both methods work, but I think I'll go with the eval route. That way when someone else comes along and tries to figure out what I was doing, it might be easier to understand. I think the –0 and multiplying by -1 and then subtracting could lead someone to wonder...

I agree with everything you and stormbind say, absolutely, no problem, but parseInt is applied to an existing integer…the number 8. Then has 3 added to it, thus 11. I don’t see how you can apply parseInt to an expression. My values do not exist until the “Calculate” button is clicked. The value...

stormbind, thanks for the suggestion but I tried everything concerning ParseInt and all I got in return was NaN. kaht, you were right about the code. It was wrong when I posted the question but I had already fixed it, but it did not solve the problem. You did make a good catch on the eval. They...

Below is the HTML code for doing some calculations (this has been whittled down to the bear necessities). The form requires two inputs, then “Calculates” the remaining four values. Everything runs fine using the expression f.M.value = eval (f.OD.value * 3); but this is not the correct...

I use this a lot. You will need three (3) images. Here I am using img_one, img_two, and img_three. When all the coding is complete, stack these one on top of the other. From your Form Load, this initially sets img_one visible and img_two & img_three not visible. Private Sub Form_Load()...

GOT IT!! In case anyone wonders how I solved my problem… FIX: To the button that closes DB2 On Click… ”DoCmd.Quit”, I just added a Hyperlink Address… ..\database\DB1.mdb back to DB1. DB2 closes and DB1 maximizes. I don't know why DB1 minimizes to begin with and this may not be the...

Thanks PH, Problem solved on Problem 2. Have a star for the help. Unfortunately on Problem 1 I have tried AppActivate and all it does is start a new session of Access. I need DB1 to re-maximize while DB2 is closing. Just in case, here is the sequence of events: DB1 is opened and used. From a...

Opening 2nd database and Word doc problems FIRST: Thanks to all who help on this web site. All of you have been a great help. I really appreciate it. Have: Access 97 Database 1 Database 2 ******Problem 1****** DB1, when open and maximized has a Cmd button that opens DB2 by way...

My thanks to Darrylles and CajunCenturion for their prompt and insightful comments. Interesting. This reinforces my point of view; code it if possible. To those how wish to use Access to its best potential, learn some VB/VBA. I think you will like what you can do with it. But as Dennis Miller...

Two of us at work use Access a lot. From tracking vacations and sick leave, to a lubrication database, work order tracking and so on. I learned Visual Basic (self taught) several years ago and as a result when I need to open a report, close a form or perform just about any other action, I code...

I use a form to run a number of reports (Access 97). Some reports are mailing labels using queried information. I have one button that runs a custom mailing label with prompted input information from functions that are stored in text boxes. This allows the user to create a custom mailing label...

I got my sub reports to total. If anyone is interested you can download my example database at http://members.socket.net/~oakoak/report/

I got each row to finally sum by using the below calculation in the main report, placed in the wo footer, in a text box, in the control source… =([labor].[Report]![labor_costs])+([material].[Report]![material_costs])+([po].[Report]![po_costs]) Works…but the next error is: If the query returns...

I have a main report that contains three (3) subreports…labor, material, PO. My main report has three (3) Headers & Footers that allow grouping and sorting…supervisor, asset. wo. Each subreport is successfully returning a calculated sum value of labor, material and PO value respectfully for each...