...inside of it with Row Source:
SELECT (Format([Test_Date],"MMM 'YY")),Sum([Weight]) AS [SumOfWeight] FROM [Query1] GROUP BY (Year([Test_Date])*12 + Month([Test_Date])-1),(Format([Test_Date],"MMM 'YY"));
When I try to link master and child fields it says "Can't build a link between 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...
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 -...
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...
In your subform data tab properties, do you show a link child and a link master common field? I have several DB's that have a form & subform and when I call up the master form both forms come up ready for data entry, but you can also go back to edit and view the previous entries & they come up...
Your textboxes in your form should be "bound textboxes".
They become bound when you specify in each of their control properties on the form, their "Control Source", which is the field name in the "destination table" The table field names should drop down when...
Sorry to be so "unknowing" but what does AIM mean? Sure, you can E-mail me. You might be able to AIM me too, once I know what it means. :>) My e-mail is clmiller1@home.com.
Would you be able to zip your database and e-mail it to me or something similar?
OK! - doing great so far. . . Now does your "Form" have the "destination table" as its control source, and do your fields in the form have the appropriate destination table field names as their "Contorl Source?"
I created dummy tables and a form according to my instructions and it works perfectly! May I ask you the name of your ComboBox, and while you're at it, the names of the 4 fields? You will find the names in the properties under Other and Name.
I'm thinking that possibly in your code you used...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.