Deleting a record on a form.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: mccloud (mccloud_at_discussions.microsoft.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 14:01:01 -0800

I have created a database that tracks bin location based on item numbers. We
have two types of bin locations. One is called Bulk and is stored in a
table "bulk bins" and a Primary "picking_seq" which is stored in our ERP
system.
I have a linked table "Macloa" to our ERP system which I use as a source on
a combo box for item numbers and Primary bin location. I'm storing the item,
bulk bin and entered date in a third table "bin Assignment"

I have several forms that query the data in differen't ways. The issue is
if I try to delete a record from a form. The form uses a query which is
joined by item number. I'm joining "Macola" and Bin Assignment" in the
query.

How can I allow the user to delete the record from the form? It worked
before the join!

Relevant Pages

  • Re: Multiple Locations
    ... I've tried a couple of times off and on to get the query ... which lists the part numbers and bins is called 'Bin Location Table'. ... Otherwise it's seeing Bin as one word, ... Try changing all instances of Bin Location Table in your query to [Bin ...
    (microsoft.public.access.gettingstarted)
  • Re: Update Query only works first time
    ... Parts and Supplies is not a query it is the table in which the Bin Locations ... Microsoft Access MVP 2006 ...
    (microsoft.public.access.queries)
  • count individuals of a certain sizes in one query
    ... My suggestion applies to the QBE grid view rather ... The bin name expressions I suggest would go into ... query, but will have no effect on your original data. ...
    (microsoft.public.access.queries)
  • Re: Update Query only works first time
    ... I will assume you have an autonumber field in your Parts and Supplies table that I will refer to as PartID. ... Rather than making 6 Bin fields in that table, what you should do is set up another table for Bins ... Microsoft Access MVP 2006 ... I don't know either -- but that is what you error message says -- perhaps you are not using an updateable recordset or records were locked by something else like a form or query ...
    (microsoft.public.access.queries)
  • count individuals of a certain sizes in one query
    ... My suggestion applies to the QBE grid view rather ... The bin name expressions I suggest would go into ... >query, but will have no effect on your original data. ... No need to apologize for lack of knowledge - we ...
    (microsoft.public.access.queries)