Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update column in access table

Status
Not open for further replies.

proteome

Technical User
May 14, 2003
115
US
I am trying to update a column in an access table by using a public function:

Code:
Public Function Create_web_URL(ByVal data As String) As String
Dim url As String
Dim result As String

url = " result = url & data
Create_web_URL = result
End Function

data is a column in the table I am trying to update

I am using the following sql to try and update the column

strsql = "Update table2 SET url = Create_web_URL (data)"
acAccess.CurrentDb.Execute(strsql)

The problem is I keep getting that Create_web_URL is an unknown function

Please Help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top