Search results for query: *

perfect..thanks for the help. Have a great day

This may sound stupid..but where would I put the query.I already have a query that gives me the results for the report. I have over 70 fields on the report..would I need a query for each field Thanks so much for your help so far. GlenMacK

it just says "#error" instead of the value..almost like I called the cotnrol Source?? But I double checked, I have the correct Control Source

I tried that.but I get an error..

I have a report that shows a time sheet for a weekly period. I have each field set to a default = 0.. I need this "0" to show in the form used for entry, but not on the report. Is there anyway I can have the fields not show on the report if they equal "0". There is about 50 fields on the...

Can anybody help me figure this out. I have five unbound fields on a form, and when I click a btn, I have code written that takes the values from these fields and fills in the corresponding fields on the subform for a later calculation. The problem I am having is that if the users enters more...

Thanks, I guess I should have thought of doing that myself...quess I was just looking for a quick fix..ha ha I did what you suggested and it worked great.. Have a great day Glen

Hi I have recently been given the responsibility to fix and enhance a database that someone else developed here at work. That person is no longer working with us. I want to change the database properties but when I try using "File/Database Properties" I can make changes, but then I get a...

I have a time card query that calclulates time and then multiplies it by a rate. It works great, except for when there is a rate increase. If I have two or three records multiplied by one rate, I get the correct sum total, but if I have a new record that has a new rate, it only calculates the...

I have a time card query that calclulates time and then multiplies it by a rate. It works great, except for when there is a rate increase. If I have two or three records multiplied by one rate, I get the correct sum total, but if I have a new record that has a new rate, it only calculates the...

So what you are saying is instead of having the calculations performed in the query for the subform, have a command button perform the calculations. I will try that , thanks..I think one problem I may with that is...my query for the subform is made of two other querys..probably bad programming...

I have form with a couple of subforms. One of them is taking a long time to calculate, which means it is taking a long time to move between records. Is there any way that I could have the subform showing on the form, but not have it calculate until a command button is pushed. This way a user...

Thanks Roy...The information worked perfect....

Can anyone send me in the right direction how to update multiple records at one time. I have form that brings up WorkOrders that have not been printed. I have a button on the form that when clicked it prints all the new work orders, but I want to have all the records updated for the...

Tried that STeve..no luck...thanks for the suggestion. I have never seen a error message like this one before

I am getting a error message when I try to load a form that says there is a control on the form that the Database doesn't recognize and will ignore, when I click Ok..the form will not open. I can't open it in any type of view?? Any ideas?? Glen MacK