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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by hercule2
-
Is it possible to execute VBA code from external app via ADO like ASP?
yes, could you help me with an example ? Set appAccess = CreateObject("Access.Application") appAccess.OpenCurrentDatabase "base.mdb", False Set db = appAccess.DBEngine.Workspaces(0).Databases(0) db.querydefs.Delete ("Dynamic_Query") Set QD =...- hercule2
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
How have count of words (in a field) for orderby ?
no, this response is not useful. Thanks.- hercule2
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
How have count of words (in a field) for orderby ?
FROM ASP with access 2000 database: <% Set m_Conn = server.CreateObject("ADODB.Connection") m_Conn.Open "eq14CVs", "", "" SQL = "Select TOP 5 [field] as toto from table orderby fct([field],'the_word') desc" ' MyFunc is not permit here Set...- hercule2
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
How have count of words (in a field) for orderby?
FROM ASP with access 2000 database : <% Set m_Conn = server.CreateObject("ADODB.Connection") m_Conn.Open "eq14CVs", "", "" SQL = "Select TOP 5 [field] as toto from table orderby fct([field],'the_word') desc" ' MyFunc is not permit here Set...- hercule2
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
How have count of words (in a field) for orderby ?
FROM ASP with access 2000 database: <% Set m_Conn = server.CreateObject("ADODB.Connection") m_Conn.Open "eq14CVs", "", "" SQL = "Select TOP 5 [field] as toto from table orderby fct([field],'the_word') desc" ' MyFunc is not permit here Set...- hercule2
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
HOW have count of words (in a field) for orderby ?
FROM ASP with access 2000 database : <% Set m_Conn = server.CreateObject("ADODB.Connection") m_Conn.Open "eq14CVs", "", "" SQL = "Select TOP 5 [field] as toto from table orderby fct([field],'the_word') desc" ' MyFunc is not permit here Set...- hercule2
- Thread
- Replies: 1
- Forum: Microsoft: ActiveX
-
To complete with my last work ...,
To complete with my last work ..., i do this from web ASP page: "Requete6" is an already existing request in database. <% Set appAccess = CreateObject("Access.Application") appAccess.OpenCurrentDatabase "base.mdb", False Set db =...- hercule2
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Is it possible to execute VBA code from external app via ADO like ASP?
I can't use what you said because my function will be in the order by, but after work i do this from web ASP page: "Requete6" is an already existing request in database. <% Set appAccess = CreateObject("Access.Application") appAccess.OpenCurrentDatabase...- hercule2
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Is it possible to execute VBA code from external app via ADO like ASP?
With your solution 2, i do this from web ASP page: "Requete6" is an already existing request in database. <% Set appAccess = CreateObject("Access.Application") appAccess.OpenCurrentDatabase "base.mdb", False Set db = appAccess.DBEngine.Workspaces(0).Databases(0)...- hercule2
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Is it possible to execute VBAcode from external app via ADO like ASP?
hercule2 (Programmer) Nov 30, 2003 Hi, I'm french, Using Access 2000 I have written a small VBA routine inside of standard module. I have also written a query that calls this routine to modify one of the columns in a table, ie. to strip punctuation characters from the column, eg. select name...- hercule2
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Is it possible to execute VBA code from external app via ADO like ASP?
hercule2 (Programmer) Nov 30, 2003 Hi, I'm french, Using Access 2000 I have written a small VBA routine inside of standard module. I have also written a query that calls this routine to modify one of the columns in a table, ie. to strip punctuation characters from the column, eg. select name...- hercule2
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
Is it possible to execute VBA code from external app via ADO like ASP?
Hi, I'm french, Using Access 2000 I have written a small VBA routine inside of standard module. I have also written a query that calls this routine to modify one of the columns in a table, ie. to strip punctuation characters from the column, eg. select name, MyFunc([name]) from myTable where...- hercule2
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
