I have a form that gathers information and then submitted to my email...I get all the fields and all the info just fine. Problem is that I want the sender to also get an email to confirm his information. The sender fills out a field with his email address, so I do have it in my email. Just...
I'm trying to get a text box in a report to read a query result. I use the expression builder for the Control Source to find the query and then the field within the query. It looks like this:
= [DCASH_After_Layaway_Inventory]![SumOfTotal]
This seems all correct but then I get "#Name?" error...
I have Windows XP Home and use Outlook Express. Emails work fine. However, when in Access 2000 I preview a report and right click it and rather than see the message, "Mail Recipient...", I get "Email not configured properly..." and it stops before getting the create email...
I have Windows XP Home and use Outlook Express. Emails work fine. However, when in Access 2000 I preview a report and right click it and rather than see the message, "Mail Recipient...", I get "Email not configured properly..." and it stops before getting the create email...
Alright... Plan B
I've got a database with many fields, only two fields are needed here ...TicketNumber and Cost. I need to add up the cost(could be 1 or several) for a given TicketNumber and store this number as a variable called varCost. I then will use this variable in various calculations...
Ken,
Hope you drop by this question again.
There is still a small problem. What you gave me works fine in my query. There are 2 fields - TicketNumber and Cost. If I use a number such as 730 for my criteria in the TicketNumber field everything is fine. I get a sumation of cost for all the...
I have a Select Query that sums a field [COST]. I need to use this "answer" as a variable in several places within a routine. How do I capture the answer of SumOfCOST?
Ok.............
I'm changing my login name so nobody will ever associate these questions with me, then moving to Australia to raise Kangaroos.
Thanks for making me see the forest for the trees. I've tried it, it works perfect, made a deployable to test... it also works. Adding "Advanced...
Thanks again. After reading and trying new code, this last message from Jeremy put a big piece in the puzzle.
If there is one last thing it would be "what to do with all the empty fields?" You see, I have 50+ fields and the user will realistically use any 3 he wants to get the...
Alright, I'm lost. I can build combo boxes all day, but how the choice enters into the SQL and how the SQL goes to the query is evading me. I've looked at the web site's Developers section and I just don't get it.
Could you show me a brief example or point me to some source for help?
Thanks...
I have a form the captures user input in text boxes. These parameters are then fed to a query using this format:
[forms]![NameOfForm]![NameOfTextBox]
Works fine. However, I would like to allow the user to select through check boxes the "greater than" or "less than", etc...
Thanks Ken.
At least I know where the problem is now. I feared this might result with your answer. Now, what an undertaking. There are in excess of 50 fields that the user needs to query on. Agreed, not all the fields will have criteria, but the possibility of several of ANY of the fields...
I posted this in Applications Deployment Forum also but thought someone here has seen this too.
I use Access XP and a need to package my application. The program includes queries that the user changes criteria using Query Design. I have included "Query Design" in a customized ToolBar...
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.