Search results

Hey gang, I figured it out. While looking through the data, I found that some one had entered an estimated time of B.E. (Break Even) So this is why I could not get it to sum the field. Thanks for everyone that helped in this matter. Great Forum. God Bless. Pujo from the Bayou Banks Of Louisiana

I can not get the file small enough to get on this site, but I found another problem that may be linked to the original problem. Ok, So I have a report based from a query, There is a name criteria, then date criteria. So when this report is ran, it asked for "Name", the "beginning date" and...

I will try, but not sure how to break it down so that you will still have what it needs. I will try another way today. What about a file host site. That may work I'll see what I can do.

If anyone wants to try and help me figure things out with this. I will be glad to send you the file. The file is 1.24 megs. and too large to add to this site. So if you are feeling up to it and want to give this a try, send email to knormand@wqaccuratela.com and I will reply with the file...

I Checked the "Data type" and the "Format" of "Estimated Time" field. Everything is the same for both fields. I tried putting the expression on the Page footer instead of the Report Footer, and all it shows when the report is ran is ERROR in the area where the sum should be. Go Figure. Please...

I hope I put this in the right place, but I have a problem. I made a report from a Query, and in the report footer I have a unbound text box with this expression. =Sum([Estimated Time]) I run the report and this is the error I get. "The expression is typed incorrectly, or its to complex to be...

Hey Gang, I haven't looked in the forum yet, this is just an idea that popped into the air. Is there a way to auto insert a text of my choice into a field on a form. Example: I am constantly typing "No Supervisor Signature on Weldment" along with a few other phrases. It is not as simple as...

I don't know the first thing about Access, but I was able to make a database that kinda works for me, but not really. My calculations are being stored in the form and not the table. I know I should not do this, but I can't figure out how to get it to store the calculations in the table, even...

Hey gang, Is there a way to click on the find record button and have it automaticly search from a specific field? The only way I know how to search a field in a form is to select the field and then click on search. I just wanted it to automaticly select a field. Thanks gang, have a great...

I am having trouble with this. I keep getting an error, error is as followed. Public Sub PutInData() Dim sql As String Dim f As Form Dim db As DOA.Database (error with DOA) Dim rs As DOA.Recordset (error with DOA) Dim mynum Dim i As Integer Set f =...

You guys are great!!!!! Work like a charm. Have a great weekend. God Bless, Pujo "On The Bayou"

In my db, I have a form set to open on start. Is there anyway to set this to auto resize Maximize? (if you know what I mean) Thanks again, Pujo "On The Bayou"

I have been trying to find a calendar that I can put on a form to set up reminders, notes, and other things. I have had no luck finding such a thing. I tried using Calendar Control 9.0, but that will not work for my needs. If anyone knows where I can get a calendar like this, or if there is...

OK, What am I missing? Doesn't work, and what do you mean about "make sure you use your names"? I hope I don't sound too stupid. But thanks for the quick reply. Pujo "On The Bayou"

Great forum, lots of smarts here. I want to add 90 days to a date field, and have the new date in another field. This is what I have on the form. (feild 1) Previous PM Date (man. entered date) (Feild 2) Next PM Date (I want this to auto update when a date is entered in (field 1) I hope you...

But what if ? Ok, I see where you are going, but I tried to use the code on my form, but no go. This is what I have in the form. Previous PM Date (date field) Next Due Date (text field) All I wanted to do was add 90 days to the (previous PM date) and have the new date entered in the (Next Due...