DoCmdGotoRecord...I think

  • Thread starter Thread starter hw
  • Start date Start date
H

hw

I have a database that manages three types of maintenance
messages [Technical Reports], [Safety Messages], and
[Modification Instructions]. These messages can
occasionally supersede themselves or another type of
message.

I have generated a form for each type of message and
included three combo boxes that indicate what messages
have been superseded by the current message on display.
Next to the combo box, I have placed a command button that
goes to the message that was superseded.

If one type of message supersedes another type, everything
works great. The Access Wizard does a marvelous job.
Opening another form that has a relationship to the
current form is easy.

If a message supersedes another record from the same
table, I get lost. There is no wizard for this and my
attempts at VB have been useless.

I'm assuming I need a DoCmd.GoToRecord where the
superseded message field equals the actual record of the
message that was superseded.

Is there a simple statement I can make to get the command
button to go to the record that is displayed in superseded
box?

I hope this makes sense.
 
What do you mean by a record "superseding" another record? Is it replacing,
erasing, moving up or down, what are you saying?

Al
 
Sometimes a document replaces an older one. A newer
Technical Report can replace an older Safety message.

When a newer Technical Report replaces another Technical
Report, I can not get the command button to go to the
Report that was replaced.

If a message replaces one from another table, it works fine
-----Original Message-----
What do you mean by a record "superseding" another record? Is it replacing,
erasing, moving up or down, what are you saying?

Al

I have a database that manages three types of maintenance
messages [Technical Reports], [Safety Messages], and
[Modification Instructions]. These messages can
occasionally supersede themselves or another type of
message.

I have generated a form for each type of message and
included three combo boxes that indicate what messages
have been superseded by the current message on display.
Next to the combo box, I have placed a command button that
goes to the message that was superseded.

If one type of message supersedes another type, everything
works great. The Access Wizard does a marvelous job.
Opening another form that has a relationship to the
current form is easy.

If a message supersedes another record from the same
table, I get lost. There is no wizard for this and my
attempts at VB have been useless.

I'm assuming I need a DoCmd.GoToRecord where the
superseded message field equals the actual record of the
message that was superseded.

Is there a simple statement I can make to get the command
button to go to the record that is displayed in superseded
box?

I hope this makes sense.
Click to expand...


.
Click to expand...
 
Hmmm...

Still don't know what you are doing here. Are these technical reports
records in a table? Are they Word documents that you are trying to find via
a hyperlink? If the former, if they share a key field value, then you should
be able to find the record in any lookup protocol. If the latter, you can
have a hyperlink lookup documents on your hard drive and list findings in a
hyperlink field column.

Regards,
Al

Sometimes a document replaces an older one. A newer
Technical Report can replace an older Safety message.

When a newer Technical Report replaces another Technical
Report, I can not get the command button to go to the
Report that was replaced.

If a message replaces one from another table, it works fine
-----Original Message-----
What do you mean by a record "superseding" another record? Is it replacing,
erasing, moving up or down, what are you saying?

Al

I have a database that manages three types of maintenance
messages [Technical Reports], [Safety Messages], and
[Modification Instructions]. These messages can
occasionally supersede themselves or another type of
message.

I have generated a form for each type of message and
included three combo boxes that indicate what messages
have been superseded by the current message on display.
Next to the combo box, I have placed a command button that
goes to the message that was superseded.

If one type of message supersedes another type, everything
works great. The Access Wizard does a marvelous job.
Opening another form that has a relationship to the
current form is easy.

If a message supersedes another record from the same
table, I get lost. There is no wizard for this and my
attempts at VB have been useless.

I'm assuming I need a DoCmd.GoToRecord where the
superseded message field equals the actual record of the
message that was superseded.

Is there a simple statement I can make to get the command
button to go to the record that is displayed in superseded
box?

I hope this makes sense.
Click to expand...


.
Click to expand...
Click to expand...
 
I'm trying to get a command button to compare what is in
one field that lists a message that has been superseded
and go to the actual record that lists the specific
information on the message.

Somehow I can't get a form to look at one field and go to
the record that it represents.

If it's in a different table, then I can do it, but it
just doesn't seem to work when it's referencing the same
table.

-----Original Message-----
Hmmm...

Still don't know what you are doing here. Are these technical reports
records in a table? Are they Word documents that you are trying to find via
a hyperlink? If the former, if they share a key field value, then you should
be able to find the record in any lookup protocol. If the latter, you can
have a hyperlink lookup documents on your hard drive and list findings in a
hyperlink field column.

Regards,
Al

Sometimes a document replaces an older one. A newer
Technical Report can replace an older Safety message.

When a newer Technical Report replaces another Technical
Report, I can not get the command button to go to the
Report that was replaced.

If a message replaces one from another table, it works fine
-----Original Message-----
What do you mean by a record "superseding" another record? Is it replacing,
erasing, moving up or down, what are you saying?

Al


I have a database that manages three types of maintenance
messages [Technical Reports], [Safety Messages], and
[Modification Instructions]. These messages can
occasionally supersede themselves or another type of
message.

I have generated a form for each type of message and
included three combo boxes that indicate what messages
have been superseded by the current message on display.
Next to the combo box, I have placed a command button that
goes to the message that was superseded.

If one type of message supersedes another type, everything
works great. The Access Wizard does a marvelous job.
Opening another form that has a relationship to the
current form is easy.

If a message supersedes another record from the same
table, I get lost. There is no wizard for this and my
attempts at VB have been useless.

I'm assuming I need a DoCmd.GoToRecord where the
superseded message field equals the actual record of the
message that was superseded.

Is there a simple statement I can make to get the command
button to go to the record that is displayed in superseded
box?

I hope this makes sense.



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


.
Click to expand...
 
Back
Top