Re: Still need help - on form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi babs,

babs wrote:
>I think the command button for the append query may work. A few things
>though my invoice # in the invoice table is not assigned until the report it
>is based off of the date the report is printed out.

which means that the record is not saved until printed?

>My primary keys for the
>invoice are Clientid and ticket# together. Plus when you are at the quote
>pt. not sure if there will ever be an invoice generated for that quote.

If an invoice won't be generated from the quote, what is the quote for? So
many differences in how we run our different businesses I can see that I need
to get this simple;)

>
>Back to the append query. Not sure how to set that up. Do I make the
>command button in design view of form(no wizard for this?)

yes, you will learn more without the wizard

> - go to the event
>procedure of the on Click- Think I can just make the append query in the
>query area- how do I Call it????is that the right word???

You can create a macro or use code, I would suggest code. Create the append
query, right click in the criteria row of the query of whatever field needs
to point to the quote form where the command button is and select 'build'.
Use the builder to find the control on the form to filter by.

Create a command button on the query form - bypass the wizard. In the
properties click event for the command button type [ and Access will fill in
the rest = [Event Procedure], click the build button to the right.

In the code behind forms screen enter this code to run your query

DoCmd.OpenQuery "YourQueriesName"

>
>The user origanlly asked me to give them a drop down with quoteid so they
>could pick it and it would fill in the fields- sounds like it should work but
>not sure how????

Combo box, use the row source to defiine the table, query or SQL entered in
the Row Source. Make sure to define the column widths, column count and
bound column properties.

>Maybe they would get a list of quotes for the quote guy or the customer
>would have their quoteid that they are actually now going through with and
>they can pick it from the drop down. Would rather prefer doing it this way
>if at all possible???????

Sure, if it is up to the customer to give their quote id if they want to
implement the quote - or it is up to the customer to say 'I want to use my
quote' - then you could use a list box or combo box.

It sounds like a quote may be a 'pending order' more than a quote. We do
this for sales where the customer is in the process of finalizing what they
want by having in our invoice with these invoice fields:

CreateDate = Date invoice created
OrderDate = Only filed in when the invoice becomes a real order

Quotes are for quotes, not a sale at all that when printed has verbage as to
when the quote expires and such ...

I can see that this implementation may not work for you with the invoice
record being a compound key and not saved until printed, but you could save
it beore printing and enter the OrderDate when printed - just some thoughts

Roger

>Thanks again for your input.
>
>> As an added thought, how does the user know whethter to look in the drop down
>> list for quotes or not?
>[quoted text clipped - 8 lines]
>>
>> Roger

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • RE: Query stopped working after entry 615 in table
    ... Macro Name: Find Jenish Invoice ... Table Name: Previous Invoices For Tracking ... How many records does Jenish Invoice Query pull? ...
    (microsoft.public.access.queries)
  • RE: Saving Form
    ... If it is a query, ... You HAVE the computer record of the invoice that you want. ... > everything we need to know about our inventory ex. ... >> would execute a report for the current record. ...
    (microsoft.public.access.forms)
  • RE: Saving Form
    ... ok well the form is bound to a query where the only thing in it is the "in ... You HAVE the computer record of the invoice that you want. ... >> everything we need to know about our inventory ex. ... >>> would execute a report for the current record. ...
    (microsoft.public.access.forms)
  • RE: Saving Form
    ... There would be no need to print an extra hard copy of each invoice ... would execute a report for the current record. ... an Update query is simply a type of query that changes data in ... Show the InvoiceItems and the Inventory tables. ...
    (microsoft.public.access.forms)
  • Re: msimatch error 13- someone posted a question as an answer - repost
    ... > It includes the cost of the matl shipped the quantity, client id, client ... > a step previous to this where some companies are receiving a quote based ... > like the existing form (Invoice Entry) to have a drop down for a QuoteID ... Not all of the Invoice Entry ...
    (microsoft.public.access.forms)