I knew there had to be another operator to separate them I just had no idea how to go about it. Works perfect!!
Thanks a lot!!
Xtremlylost
Sometimes the view is perfect right where you are and sometimes falling is the only way to know it.
I have the following in a range of statements but the form isn't evaluating it correctly and is grabbing the wrong number. I am sure it is the way I am putting it together and would appreciate some help in getting it to work. The ranges should be clear of what I am looking for. The code...
Thanks. I looked it over and it has almost the exact structure. I just need to decipher how it is set up versus mine.
Thanks again for the input.
Sometimes the view is perfect right where you are and sometimes falling is the only way to know it.
Also, how would I tie this to the quotedetails table?
Xtremlylost
Sometimes the view is perfect right where you are and sometimes falling is the only way to know it.
I will give this a shot but there is one thing to consider. Each quote is set up to be considered as a single occurrence. The I had a one-many cust/quote and a one-many between the quote/quotedetails tables. I had heard this was called one-many-many. Just so we are on the same page...
In building a new database I have run into a form level problem that I just cannot figure out. The form has a subform for quote details in it and I am getting a quote record for every record in the details area. 3 details records; 3 quote records and all 3 quote records have the same detail...
Hey Randy700,
This worked finally. I couldn't put it in the first field because it still kicked the error out apparently because canceling the new record by arrowing back on the record selectors kicked the lost focus event and it still wanted to save the record. I ended up putting the default...
Thanks for opening.
I have a form with several controls set to default values when a new record is generated to help the users enter as little as possible. I believe this is what is causing the problem when a user "accidentally" hits the "Add record" button and then tries to go back to the...
Perfect. Works great. Just what I was looking for. Gave you a star for that one!
Thanks for the help.
Sometimes the view is perfect right where you are and sometimes falling is the only way to know it.
I will do some research in help on these. I have not used any of these functions before and wasn't sure where to start. The person I am creating this for has mentioned distributing it to other plants so I was wanting to make it look a little more professional than the typical toolbox approach I...
Perhaps. I was hoping for something simple like code that would check the calc field first for a valid number and if there wasn't one then simply show a null value, zero,or perhaps my own message.
Do you have something in mind?
Sometimes the view is perfect right where you are and sometimes...
I have a form with several calculated fields. Until information is entered around them they display these errors. I simply want these sweet little notes to hide until valid numbers are entered into the various fields of the form.
Any idea how?
Sometimes the view is perfect right where you are...
As you say, it is true that the numbers just do NOT compute. Over the past week I have worked on this issue and found that varying results can be found.
The details:
Productivity averages, calculated by lbs. produced/scheduled hours first by shifts, which there are three of them and the...
I have a report which calculates averages for productivity by shift for any date requested. This works fine but when trying to come up with a total average for the day the calculations come up to impossible numbers. I have tried various grouping levels and functions but cannot seem to get a...
I have a yearly attendance database built for our plant. Each year we put out a new clean copy and save the old ones for reference should we need them. I have a report that calculates an employees points for absences and credits for good attendance. The problem is each year we have to...
This works in part. Here is what is happening:
The --All Carriers-- is now showing up in the list. When selected however it does not show up in the combo box when the drop down closes. (Perhaps it is not supposed to?) It will however print All the carriers labels.
If, however, I choose a...
As Mikey69 said this was posted fairly recently. The answer in code was not supplied but I remember in the post that the person was pointed to the Microsoft Access 97 Developer's Handbook Chapter 9. The code could not be posted due to copyright reasons but if you can get ahold of this book I...
I have not designed the label report from a query since all the relevant info was in a single table. The fields in the label report are above and were not clearly marked. They are: The "=Trim" statement begins the field in the label with the "Attn" field being at the bottom...
I have a label printing form that includes two check boxes. If one box is checked it will disable the other check box, enable the Print button and print all the labels for all the Carriers in the Carrier table when the print button is clicked. The other check box when selected disables the...
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.