Search results

ok i think i may have left a key part out. on the service info form there is a subform which is where the time comes from. so the control source of the total cost on the form is =[Text44]+[PartsPurchased]. text 44 is the control that gets the total time from the subform. Please help. Im still...

Ok, I really need some help here. I have a table called tblServiceInfo and a form called frmServiceInfo. On both there is a field called Total Cost. What I have is a calculation on the form that figures out the total cost based on time and parts. what I need to do is get the total cost that...

Well I figured out how to get "Pattern to be" on my report without adding it to each value. I used the IIF function.

I have a form that contains a combo box that gets its values from a table. Im trying to create a prefix for the values in the list automatically without having to always type "Pattern to be" on each value that I have to add. Any suggestions would be greatly appreciated!!

hi, I have a split database that is in fe be format. I just moved this database onto a new workstation. Now that i have done this a piece of the code is not working. the code is function OpenRowSnap (strTable as String) as Recordset set dbsUniversal=Currentdb Set OpenRowSnap=...

thanks for the help.

ok i got everything taken care of except now when i try to open the system on the new workstation it says cannot find language dll. and when i try to run access 97 by itself i get the same error. Anybody know how to fix that?

Hi Gemma, I'm sorry but im really new to this part and I was wondering if you could explain a little more about how to do that?

Hi, I have a lawncare database that is split into front end back end and im not the person who designed it. My problem is I have to copy the server's front end and paste it onto all the other workstations. I also then have to get each copy to view the back end on the server. Im sure this is...

That did work. As long as the user hits enter it clears it out. Thanks so much

bob, Thanks so much that did it! :D however I was also curious as to whether or not i could get the combo box to not show anything after the record is found?

Hi, I'm really new to vba so any help with this would be great. I Have a form used to enter information about equipment. on the form i have the ID that our company uses called LCUID and what i would like to be able to do is add an unbound text box to the form so that the user can type in the...

glad u figured it out!

I see. when you open the subform on the menubar do you see the old name or the new one? if you see the old one then maybe that is why it didnt use your new name in the equation. I really dont know. sorry.

If you renamed your subform then i think you may have misunderstood the site. you needed to only name the subforms summation control. well either way as long as its working now Im glad you found what you needed.

Hey Murph, Im so glad that it helped! it actually was the exact help i needed too. :rolleyes:

Found the answer here! Here is where i Found the solution to my problem. Hope this helps. http://www.databasedev.co.uk/subform-total.html

Nevermind.... I found the help that I needed.

Hi, I have a form called service info with a subform within it called service times. On the subform I have the field TotalTime which is calculated from the timein timeout fields. I need to get the sum of TotalTime and then be able to calculate it on the main form to figure out the total cost of...

Thanks. I thought thats what i had been doing all day but maybe I had the wrong format. But its working great now. I really appreciate it.