recommendation on the folowing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Afternoon folks. I was hopeing to run this by you folks and see what you
think would be the best way to accomplish this.

Currently, I have a quert that polls ym database and shows me those certain
records that have not shipped. The query shows me the ID, Customer name,
phone number, location it is shipping to and serial number of the item being
shipped.

Currently, I print this out, and go through and go to each record and
manually update the "date out" field.

I was thinking about putting the result of this query into a list box on a
form, and then I could possibly select each record through that list box and
update the date out, which saves some time instead of finding each record.
Or, maybe go even one step farther and after running the query, somehow have
it so these records are automatically updated with today's date.

I was wondering if anyone has run across doing somethnig like this and what
they would suggest. I am by far no expert to say the least. So, please keep
that in mind when adding in your 2 cents <G>
Thanks in advance all!
Richard
 
Anything (well, most things anyway) is possible Richard. It really depends
on what you're trying to achieve. For example, your requirement to update
all the records in the query with today's date is, in fact, a piece of cake.

Create a copy of your query (not really necessary, just for insurance)
Open it up in design view.
From the Query menu, choose Update Query. (...where update queries update
the records returned to whatever you specify.)
On the 'Update to' row, you could just enter a specific date and all of the
records that meet any criteria you have specified will be updated. Better
(I think, in your case) would be to enter date() on that row. The date
function will always return today's date.

You could always extend that idea by either...

Turning it into a parameter query by entering..
[Please enter the new date you want]
....on the 'Update to' row. This will then ask you what date you want each
time you run the query.

....or...
Doing a similar thing but linking it back to a control on a form. So if you
had a form called MyForm containing a control called NewDate then you could
enter...
forms![MyForm]![NewDate]
onto the 'Update to' row.
 
Rob,

thanks a bunch. I appreciate the info. I played with that as you suggested,
and think that will work fine. The way I got it to work now, is I print a
"packing list" which I verify everything first before manualy updating. But
this way, I can just run the update query. And since I only print the packing
list on the day I ship, I just used the Date () parameter.

thanks a bunch for the help!
Richard

Rob Oldfield said:
Anything (well, most things anyway) is possible Richard. It really depends
on what you're trying to achieve. For example, your requirement to update
all the records in the query with today's date is, in fact, a piece of cake.

Create a copy of your query (not really necessary, just for insurance)
Open it up in design view.
From the Query menu, choose Update Query. (...where update queries update
the records returned to whatever you specify.)
On the 'Update to' row, you could just enter a specific date and all of the
records that meet any criteria you have specified will be updated. Better
(I think, in your case) would be to enter date() on that row. The date
function will always return today's date.

You could always extend that idea by either...

Turning it into a parameter query by entering..
[Please enter the new date you want]
....on the 'Update to' row. This will then ask you what date you want each
time you run the query.

....or...
Doing a similar thing but linking it back to a control on a form. So if you
had a form called MyForm containing a control called NewDate then you could
enter...
forms![MyForm]![NewDate]
onto the 'Update to' row.




Richard said:
Afternoon folks. I was hopeing to run this by you folks and see what you
think would be the best way to accomplish this.

Currently, I have a quert that polls ym database and shows me those certain
records that have not shipped. The query shows me the ID, Customer name,
phone number, location it is shipping to and serial number of the item being
shipped.

Currently, I print this out, and go through and go to each record and
manually update the "date out" field.

I was thinking about putting the result of this query into a list box on a
form, and then I could possibly select each record through that list box and
update the date out, which saves some time instead of finding each record.
Or, maybe go even one step farther and after running the query, somehow have
it so these records are automatically updated with today's date.

I was wondering if anyone has run across doing somethnig like this and what
they would suggest. I am by far no expert to say the least. So, please keep
that in mind when adding in your 2 cents <G>
Thanks in advance all!
Richard
Click to expand...
Click to expand...
 
Back
Top