Search results

Okay - I FINALLY got this functioning for us! YIPPEE! HOWEVER, I have a formatting issue....the labor is calculated in the query like this: =IIf([FlexTime]>1,[FlexTime],[EstTime]/60*[Quantity]*[LaborRate]+[ExtServ]*[Upcharge]+[ExtService]) This is working GREAT! The problem is the output...

I tried to re-do the form based on a query that does the calculations and it looked like it worked until I tried to enter data. (See frmJobDetailMain). How come it won't let me enter data but I can change what it there? I attached a zip file of the db.

How do I fix that problem? I am trying to do the calculations in the frmJobDetailSub form.

Okay - I'm confused.....should I be running the form from a query that does the calculations or from the table?

P.S. I tried getting it to calculate and store in a query and it was calculating okay but then the combo boxes on the form quit working. *sniff*

I'm not sure...still new here. Does this help? http://www.montgomerygirlscouts.org/GATX.zip

Hmmm...what I need to do is have a from that allows me to key in the time, materials, outside services and if need, a flex time amount. The labor needs to calculate as time /60 * current labor rate plus outside services times 10%. The material is the material cost * 40% upcharge. I need the...

Yes it was. Hmmmm.....what I need to do is get a labor total in that field which is calculates so I can pass it to an append query and then export it ina text format to pull into a customers system. I also need material totals, etc. If it won't pass a calculated total to the table...how do...

Okay - I have it calculating okay however, for some reason now... a) the calculated value is not passing to the table b) when I try to calculate the total labor =Sum([Labor]), I am getting an error

I am still learning and I have 2 questions. First...I have a table called company rates which will be used to calculate time and materials. In the material field, I need to enter .10 for 10 percent. When I enter .10 the field changes back to zero. I have it set to long interger. Is this...

P.S. Also Wayne, where do I try that code? In the table or the query?

Wayne, I can try to figure that one out. I assume I need to list all 30 something fields? Di

Huh? I'm green behind the ears here. Where do I set what parameter? The query is all alone and not tied to a form. It has approx. 35 fields that neext to export to a 500 character text string.

Well, we may be getting closer. If I right click on the query in the database window, it doesn't ask me which job number to do. If I open the query and select all the records, the export wizard runs, however I get an error that says: Export Text Wizard: Too few parameters. Expected 1. Is...

Mine won't let me export a query to a text file. Am I looking in the wrong place?

I am not sure how to word this or how to search the forums for an answer and am getting frusterated. I need to create a table that pulls data from other tables based on a job number and a check box (true or false). I have to export the data from the table to a text file and set a fixed with...

Well...now it's getting trickier....that WORKED! WOHOO!!!!! However, it pops up everytime I switch records. I only need it to run after I enter a car number on the main form when creating a new record and the query reloads....not every time the form loads. Sorry if I didn't realize that before.

I have it setup so that when the car number field is populated in the main form the subform does a search for any records with that same car number and returns their data. I added a count control also so basically I just need to popup a message or form is the count in the text box is >1.

I FINALLY have some more time to play with this. Where should I put that control? In the form properties? In the departure date properties? I've tried several and can't seem to get it. No errors...just nothing.

I have a form that we use to enter our workorders (jobs) into the database. The bottom of the form runs a query and returns record information if a car has been in our facility before. I would like to program it so that if the query does in fact find a previous record it pops up a window or...