Update HELP

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi:

I run this SQL from a macro within a button/form but I
want to update just the current record not all of them?

UPDATE [DQ Issues] SET [DQ Issues].DateClosed = Now();

Thanks,

Dan
 
Dear Dan:

Then you must filter the query to update only the current record. For
this, there must be a definable way to specify which "record" that is.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
So how do i do this based on the incidentnumber field...

Thanks,

Dan
-----Original Message-----
Dear Dan:

Then you must filter the query to update only the current record. For
this, there must be a definable way to specify which "record" that is.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


Hi:

I run this SQL from a macro within a button/form but I
want to update just the current record not all of them?

UPDATE [DQ Issues] SET [DQ Issues].DateClosed = Now();

Thanks,

Dan
Click to expand...

.
Click to expand...
 
Dear Dan:

How does the incidentnumber tell you which row is the "current
record"?

Whatever that is, filter by it.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


So how do i do this based on the incidentnumber field...

Thanks,

Dan
-----Original Message-----
Dear Dan:

Then you must filter the query to update only the current record. For
this, there must be a definable way to specify which "record" that is.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


Hi:

I run this SQL from a macro within a button/form but I
want to update just the current record not all of them?

UPDATE [DQ Issues] SET [DQ Issues].DateClosed = Now();

Thanks,

Dan
Click to expand...

.
Click to expand...
Click to expand...
 
Is still asking me for update all records, not just the
current one????

-----Original Message-----
Dear Dan:

How does the incidentnumber tell you which row is the "current
record"?

Whatever that is, filter by it.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


So how do i do this based on the incidentnumber field...

Thanks,

Dan
-----Original Message-----
Dear Dan:

Then you must filter the query to update only the
Click to expand...
current
record. For
this, there must be a definable way to specify which "record" that is.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Mon, 27 Sep 2004 09:56:45 -0700, "Dan"

Hi:

I run this SQL from a macro within a button/form but I
want to update just the current record not all of them?

UPDATE [DQ Issues] SET [DQ Issues].DateClosed = Now();

Thanks,

Dan

.
Click to expand...
Click to expand...

.
Click to expand...
 
Dear Dan:

You have not posted the SQL of your query, nor sufficient details for
me to help. I recommend you do both.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


Is still asking me for update all records, not just the
current one????

-----Original Message-----
Dear Dan:

How does the incidentnumber tell you which row is the "current
record"?

Whatever that is, filter by it.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


So how do i do this based on the incidentnumber field...

Thanks,

Dan
-----Original Message-----
Dear Dan:

Then you must filter the query to update only the current
record. For
this, there must be a definable way to specify
which "record" that is.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Mon, 27 Sep 2004 09:56:45 -0700, "Dan"

Hi:

I run this SQL from a macro within a button/form but I
want to update just the current record not all of them?

UPDATE [DQ Issues] SET [DQ Issues].DateClosed = Now();

Thanks,

Dan

.
Click to expand...

.
Click to expand...
Click to expand...
 
Back
Top