Search results for query: *

Thanks for the great tip. CGI-Central did the trick. Just exactly what I wanted and easy to use. Thanks again!

Thanks, My server can handle PHP... any ideas where to look for such a script?

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...

Thanks GingerR. Works great

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...

Yes the form is open and I have a text field displaying the ticket number on the screen. Steve

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...

Hi Ken, You helped me before... Thanks again Steve Tucson, AZ

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...

Jeremy, Thanks Jeremy. I think I have the idea now.

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...

Ken, Just a note to you... it wasn't that bad. Made the form and it worked fine. Thanks for the direction. Steve Tucson, AZ

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...