[mso] Re: Access
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 7 Feb 2005 08:09:06 -0500
Because the rest of the process looks for it in the Master and won't
process any record contained therein.
-----Original Message-----
From: Green [mailto:1z@xxxxxxxxxxxxxx]=20
Sent: Saturday, February 05, 2005 8:30 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access
Hi Glenda,
Why does the record need to be deleted from the master table?
In one of my applications I use a list box with text boxes at the top of
the columns. The text boxes act as filters so as I type the sql
retrieving the data is altered and the list changes. Over a couple of
thousand records there is neglible time in repainting the listbox. This
means I can have sort of multiple criteria like all records begining
with M in the name field over a date range referencing a specific
printer.
Is that something like what you are looking for?
Lisa
> Need and idea/direction.
> I do a data retrieval every day but I only want to work with records=20
> received since the last retrieval. In an update macro I append=20
> yesterday's records to a master table. My download looks as data in=20
> the master and only imports records not already contained in the=20
> master (unmatched query).
>
> Occasionally though, we need to work with a ready in the master.
>
> What I'd like is a form in which we could enter the UID or name=20
> information of the record we need to retrieve which would necessitate
> DELETING that record from the master. The record could conceivable
> exist in the master more than once so some kind of loop is needed.
>
> After deleting the record(s) from the master, the rest of
> the process we
> run normally will bring us NEW records as well as the old record we=20
> specified.
>
> Any thoughts appreciated. /glenda
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
