Re: Stock Allocation

Random thoughts as I don't know what level of Access expertise you have
Am I correct in assuming that you already have car and customer details set
up?
An Input box is for inputting information into a single field. Use a Combo
Box or List box to find information that already exists.
As I remarked earlier, the Tyre table should contain amongst the other
information, Physical stock & Allocated stock. The Free stock is Physical -
Allocated.
When you create your initial invoice line to allocate the stock, you
obviously increment the AllocatedStock in the Tyre table. When you fit the
tyres and convert the invoice line into a genuine invoice, you decrease the
physical stock and the Allocated stock.

I still think you are going round things the wrong way. Because you are
surrounded by tyres, your approach seems to be "Here is a 165/65 14R tyre.
Which customer and car will this fit?" My approach would be "Hello Mr Ross
can I have your registration? Ah I see you need 225/35 R 18 tyres. I can
offer you the following Dulop @ £55.40 ....."

Can't give any more help without knowing specifically where you are stuck

Phil

"BobbyDazzler" <david.a.mitchell@xxxxxxxxx> wrote in message
news:37c86a68-f548-4233-b268-6e654c1a60b5@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Phil,

Just realised most of my code is missing!

should read

air code -

Private Sub cmdallocate_Click()

msgbox "allocate " & tyrecode(from listbox) "?"
if yes then
use inputbox to get customer name vehicle registration and quantity
of tyres
using this info create a new record in tblinvoice (customer name,
vehicle registration) and corresponding record in tblinvoicedetail
(product code, quantity)
else
end if

End Sub

What this means is that when the customer arrives at some future time
I still have their tyres in stock and can use this info to
automatically convert their "allocation" into an invoice.

If I am unable to do this, there is always the possibility that I
could book someone in for a weeks time to get 2 specific tyres and
then inadvertently sell them as they would still show on my stock!

I hope this is clear as your earlier responses, whilst much
appreciated, do not directly address this issue

Many thanks


.

Relevant Pages

  • RE: embeded forms
    ... Use your FindSerialNo Combo Box to open the Stock ... Form to the record you need and the Customer subform should display all ... subform and a master form to be syncronized ...
    (microsoft.public.access.gettingstarted)
  • RE: embeded forms
    ... trying to acheive is to open the Main Form (that is based on the Customer ... up an Unbound Box called FindSerialNo and allow the user to search the Stock ... After that you can then link the subform to the main form using the ... subform and a master form to be syncronized ...
    (microsoft.public.access.gettingstarted)
  • RE: embeded forms
    ... Whan a customer buys a stock, how do you know stock the customer bought? ... After that you can then link the subform to the main form using the ... subform and a master form to be syncronized ...
    (microsoft.public.access.gettingstarted)
  • Re: Aspid-export - A little bit about us
    ... Regarding stock indicator is to complicated for us. ... It is impossible to manage our stock and their stock. ... > I did raise a separate post as I could not find a single customer ... > feedback on your site or on any forum. ...
    (sci.geo.satellite-nav)
  • Re: Embeded Forms
    ... AFAIK code can not tell the difference between a table and a query in this ... Customer Table and my Embeded Sub Form has a Query as it's data source and ... the query is linked to the Stock Table. ... tables are linked by a Contract number. ...
    (microsoft.public.access.gettingstarted)
Loading