Re: move record...

Tech-Archive recommends: Speed Up your PC by fixing your registry

Douglas,

How would you set up the DB table for the invoices? Would you have one
invoice table for Sold and One for Consignment?

For the message box, can it be set up so that if the user selects the
record that is already in a consignment invoice then the message box would
popup and ask the user to delete the record from the consignment invoice?

Thanks for your help...

When I set this up, I thought it would hav been the easiest way, but am
open for changes before I get too far along in the db design..

Brook

"Douglas J. Steele" wrote:

> I'm not sure I'd have structured the database like that, but it's your
> database, and if that's how you want to do it...
>
> I showed you below how to react to the user's response to the Message Box.
>
> Within that structure, you can delete a row from a table using:
>
> CurrentDb.Execute "DELETE FROM MyTable WHERE MyId = " & Me.txtId,
> dbFailOnError
>
> You can add a row to a table using:
>
> CurrentDb.Execute "INSERT INTO MyTable(Field1, Field2) " & _
> "VALUES(" & Me.txtId, & ", " & Me.txtFIeld2 & ")", dbFailOnError
>
>
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Brook" <Brook@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:697EE802-1C9D-4C3F-B8A2-CAB477EACD29@xxxxxxxxxxxxxxxx
> > Douglas,
> >
> > I only have one table that holds two types of invoices Sold and
> > Consignment. And so if i have an inventory item on a consignment invoice
> > or
> > marked in my table as consignment I have to go into my consignment invoice
> > delete it from the invoice and then create a new sold invoice and add the
> > inventory item to the sold invoice in which it will be marked in the
> > invoices
> > table as sold.
> >
> > So right now, I have it set up so that there are no duplicates allow for
> > my orders on my invoices since each of my inventory items are unique. I
> > don't
> > have any item with the same serial number.
> >
> > So if I have an item on my consignment invoice and it sells, and I create
> > a sold invoice. If I try to add that item to the sold invoice, it tells me
> > that no duplicates are allow, so again, I have to delete it from the
> > consignment invoice.
> >
> > Yes I would like to have some type of message box to be able to "move" or
> > add the record to the sold invoice and remove it from the consignment
> > invoice.
> >
> > does this clear anything up?
> >
> > Thanks,
> >
> > Brook
> >
> > "Douglas J. Steele" wrote:
> >
> >> Are you saying that you have multiple tables: one for each type of
> >> invoice?
> >>
> >> Why not just have a single table with a flag in it indicating which type
> >> of
> >> invoice it is?
> >>
> >> Is your question how to use the response to a message box to trigger
> >> further
> >> actions?
> >>
> >> If MsgBox("Mark this invoice as sold?", vbYesNo) = vbYes Then
> >> ' do whatever you have to do to mark it as sold
> >> Else
> >> ' do nothing: the user responded No
> >> End If
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Brook" <Brook@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:9D8FE5D2-B11A-4625-8E38-96B839482F37@xxxxxxxxxxxxxxxx
> >> > good day,
> >> >
> >> > I currently have a frminvoices that I use to record both consignment
> >> > and
> >> > sold invoices.
> >> >
> >> > when I create an invoice, all of my records are unique so therefore no
> >> > one
> >> > record / or serial number can appear on another invoice.
> >> >
> >> > Right now, I have it set up so that on my frminvoicedetails subform I
> >> > don't allow for duplicates so that only one item can be on any one
> >> > invoice...
> >> >
> >> > The problem that I am having is that when I have a consignment invoice
> >> > and
> >> > once of the items sells, and I have to create a sold invoice, I have to
> >> > go
> >> > to
> >> > the specified consignment invoice delete the item then be able to
> >> > create
> >> > my
> >> > sold invoice.
> >> >
> >> > Is there a way that I can add it to a sold invoice via a message box
> >> > confirmation? or if anyone else has any suggestions i'm open for
> >> > anything...
> >> >
> >> > Thanks in advance...
> >> >
> >> > Brook
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Pass an invoice form field to a inventory table?
    ... tblinventory -- contains all the inventory that I have, including Sold, ... on a sold invoice and only consignment invoices go on a consignment invoice. ...
    (microsoft.public.access.formscoding)
  • Re: Pass an invoice form field to a inventory table?
    ... I now understand that each record in the tblinventory table is a distinct object. ... And that it is appropriate for the status of each piece (sold, consigned) to be recorded in this table. ... it is now a question for me whether this sold/consigned data is really a property of the invoice. ... Well, if you want an invoice to be recorded as an invoicetype Sold or Consignment, and then have this value assigned to the invoiced items, this can be done via an Update Query. ...
    (microsoft.public.access.formscoding)
  • Re: move record...
    ... mark it as no longer available and add the CustomerID for an invoice (which ... so that you can generate an invoice. ... recordsource of the form so that you don't display already sold items. ... > the specified consignment invoice delete the item then be able to create ...
    (microsoft.public.access.formscoding)
  • Re: move record...
    ... marked in my table as consignment I have to go into my consignment invoice ... delete it from the invoice and then create a new sold invoice and add the ... inventory item to the sold invoice in which it will be marked in the invoices ...
    (microsoft.public.access.formscoding)
  • Re: Pass an invoice form field to a inventory table?
    ... The point I was trying to make in my previous reply was that my feeling is that the Sold/Consignment/Warehouse status belongs to the Inventory items, not to the Invoice. ... "sold" & "consignment" are properties of my frminvoice. ... If an item from a consignment invoice is sold, I want to have it "removed" from the consignment invoice and I will add it as a Sold Invoice. ... from that point the user goes to the order entry subform, and selects the item serialnumber from a dropdown/lookup on my tblinventory. ...
    (microsoft.public.access.formscoding)