Gina Whipp said:Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Jim08 said:Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still get a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
Gina Whipp said:Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Gina Whipp said:Jim,
No I have never seen a hypertext field updated that way but that doesn't
mean much... I get surprised here everyday. When you get the Syntax Error
does the cursor move to a specific spot OR perhaps show you something to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still get a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
Gina Whipp said:Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Jim08 said:Gina,
I get no help with the error and the cursor goes to the open paren.
Thanks
Jim
Gina Whipp said:Jim,
No I have never seen a hypertext field updated that way but that doesn't
mean much... I get surprised here everyday. When you get the Syntax
Error
does the cursor move to a specific spot OR perhaps show you something to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still get a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
:
Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Gina Whipp said:Jim,
RE-copy/paste what you are using now...
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Gina,
I get no help with the error and the cursor goes to the open paren.
Thanks
Jim
Gina Whipp said:Jim,
No I have never seen a hypertext field updated that way but that doesn't
mean much... I get surprised here everyday. When you get the Syntax
Error
does the cursor move to a specific spot OR perhaps show you something to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still get a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
:
Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Jim08 said:Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity")
Thanks so much for your time
Jim
Gina Whipp said:Jim,
RE-copy/paste what you are using now...
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Gina,
I get no help with the error and the cursor goes to the open paren.
Thanks
Jim
:
Jim,
No I have never seen a hypertext field updated that way but that
doesn't
mean much... I get surprised here everyday. When you get the Syntax
Error
does the cursor move to a specific spot OR perhaps show you something
to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still get
a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
:
Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Gina Whipp said:Ji,
You still had too few parenthesis'. Remember for every opening OR closing
you MUST have one that corresponds.
Hyperlinkpart([table4].[hype],0)=Replace((Hyperlinkpart([table4].[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity")
Thanks so much for your time
Jim
Gina Whipp said:Jim,
RE-copy/paste what you are using now...
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
I get no help with the error and the cursor goes to the open paren.
Thanks
Jim
:
Jim,
No I have never seen a hypertext field updated that way but that
doesn't
mean much... I get surprised here everyday. When you get the Syntax
Error
does the cursor move to a specific spot OR perhaps show you something
to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still get
a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
:
Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Jim08 said:Sorry the last paren got clipped in the copy paste
Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity"))
is what is in the SQL
would you consider creating a table with one field table4.hype and try it?
thanks
Jim
Gina Whipp said:Ji,
You still had too few parenthesis'. Remember for every opening OR
closing
you MUST have one that corresponds.
Hyperlinkpart([table4].[hype],0)=Replace((Hyperlinkpart([table4].[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity")
Thanks so much for your time
Jim
:
Jim,
RE-copy/paste what you are using now...
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
I get no help with the error and the cursor goes to the open paren.
Thanks
Jim
:
Jim,
No I have never seen a hypertext field updated that way but that
doesn't
mean much... I get surprised here everyday. When you get the
Syntax
Error
does the cursor move to a specific spot OR perhaps show you
something
to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still
get
a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
:
Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Gina Whipp said:Jim,
Was think that was my next step... Please tell Access version, and field
data types so mine can match yours.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Sorry the last paren got clipped in the copy paste
Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity"))
is what is in the SQL
would you consider creating a table with one field table4.hype and try it?
thanks
Jim
Gina Whipp said:Ji,
You still had too few parenthesis'. Remember for every opening OR
closing
you MUST have one that corresponds.
Hyperlinkpart([table4].[hype],0)=Replace((Hyperlinkpart([table4].[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity")
Thanks so much for your time
Jim
:
Jim,
RE-copy/paste what you are using now...
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
I get no help with the error and the cursor goes to the open paren.
Thanks
Jim
:
Jim,
No I have never seen a hypertext field updated that way but that
doesn't
mean much... I get surprised here everyday. When you get the
Syntax
Error
does the cursor move to a specific spot OR perhaps show you
something
to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still
get
a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
:
Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
Jim08 said:Gina, Gina, Gina,
I am soooo sorry. You are so good and I am such a dope.
I checked the table and I had changed the field from hyperlink to text and
had not changed it back. I changed it back to hyperlink and the SQL works!
I defiantly owe you a beer.
Thank you so much
Jim
Gina Whipp said:Jim,
Was think that was my next step... Please tell Access version, and field
data types so mine can match yours.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Jim08 said:Sorry the last paren got clipped in the copy paste
Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity"))
is what is in the SQL
would you consider creating a table with one field table4.hype and try
it?
thanks
Jim
:
Ji,
You still had too few parenthesis'. Remember for every opening OR
closing
you MUST have one that corresponds.
Hyperlinkpart([table4].[hype],0)=Replace((Hyperlinkpart([table4].[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity")
Thanks so much for your time
Jim
:
Jim,
RE-copy/paste what you are using now...
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
I get no help with the error and the cursor goes to the open
paren.
Thanks
Jim
:
Jim,
No I have never seen a hypertext field updated that way but that
doesn't
mean much... I get surprised here everyday. When you get the
Syntax
Error
does the cursor move to a specific spot OR perhaps show you
something
to
indicate what is going on?
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but
still
get
a
syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim
:
Jim08,
Looks like a missing *(*, tey the below...
Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")