Recent content by clem

I built a simplified version with the following: Table1 with Product, Test_Date, and Weight (no key) Query1 with Product (criteria = [What Product]), Test_Date, and Weight Report1 with record source Query1 and a chart inside of it with Row Source: SELECT (Format([Test_Date],"MMM...

I have been trying that. The graph is still unbound.

Thanks. I think you have hit on the heart of my problem. I don't have a product table. I know that this isn't normalized, but didn't think it would be a problem in such an easy report requirement. Do I have to add a product master and tie the field in the main table to it? Or can I just...

When I tried this, I get an error "Can't build a link between unbound forms"

I am having trouble making a line chart report with the criteria on top of the chart. I am basing it on a query that includes: Product, Date-Time, Min-value, Max-value, and Actual_value I can easily make a graph of Min, Act, and Max by date-time, but can't figure out how to put the product name...

Use the format property on the format tab - change the control to whatever type of number you need from the dropdown list (fixed - standard, etc.) and then right underneath, you can state how many decimal places you want. HTH Carol

It happened to me some time ago. I had to use Now() instead of Date() and it worked fine. Later investigating found the explanation that the problem is usually caused by a missing library reference. Check to see if you have any library references marked "Missing" HTH Carol

Hi JJOHNS! Firstly, thank you so much for responding to my post. I really appreciate you taking the time to help. I'm going to need a little further help, if I could be a bother to you. Firstly, these entries won't be entered in "real time". They will probably be entered as the...

I have been struggling with this for over 24 hours now. No one has yet answered my first post - I'm not complaining, just desperate at this point. Is there ANYONE who can give me direction? I would be very grateful. Please see the following: Is it possible to have the FIRST value (default on...

I have been struggling with this for over 24 hours now. No one has yet answered my first post - I'm not complaining, just desperate at this point. Is there ANYONE who can give me direction? I would be very grateful. Please see the following: Is it possible to have the FIRST value (default on...

Is it possible to have the FIRST value (default on first entry only)in a control on a form be different than the rest of the values that will be entered for the same control? This part of the form is a sub-form and linked with with the main form with an autonumber. The mainform has Autonumber -...

Never mind about the backslashes - they showed up OK in the post but in this section it showed up like a Y with two lines through it. Sorry!

I'm not sure why your input mask doesn't work. I tried it and it doesn't work for me either. I got the same message you did. I am using Access 2000. But anyway, this one DOES work. . . NOTE: the \'s are supposed to be the left backslash - but my keyboard prints these (\)instead. I don't...

"The Section Width in Greater Than The Page Width" means your page width dimensions are too much. As I said, if your margins are 1" on left and right and your page width is 10, then you are at 12" (1/2" over). Either make your margins smaller (say .5 each) or slide the...

I don't know if I am understanding you correctly but here is what I think you are saying. If your page is landscape, then there is only 11 1/2" BEFORE your margins, and if EACH?? of your margins are 1" and your page is 10",then you are 1/2" off. Make your left and right...