I can create a recordset against a table with the syntax:
CurrentDb.OpenRecordset("SELECT * FROM tblMyTable;")
but I can't figure out how to create one against a Named Query.
I have develope...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20334033.html
Zones:
MS AccessDate Answered: 10/26/2002 Grade: B Views: 0
Am getting an error message when I try and run the following code
Dim strsql As String
Dim count As Recordset
Dim db As Database
Set db = CurrentDb
strsql = "SELECT * FROM KTRAVEL WHER...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20335903.html
Zones:
MS AccessDate Answered: 08/13/2002 Grade: A Views: 0
"SELECT YEAR(tblCrs.Crs_Strt_Dt) AS FiscalYr, Sum(tblCrs.Crs_Amnt) AS amount, Sum(tblCrs.Auth_Paid) AS Auth_Pay FROM tblCrs WHERE (((tblCrs.Stud_id)=" &Request.QueryString("ID")& ")) GROUP BY Year(...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20562534.htm...
Zones:
ASPDate Answered: 03/27/2003 Grade: A Views: 0
I am trying to export a query to excel that pulls from a combo box in a form (Totals). I keep getting the error message :too few parameters. expected 5. Here is the code that I have. What am I d...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20976531.html
Zones:
MS AccessDate Answered: 05/04/2004 Grade: A Views: 0
Hi. I have been asked to create a ColdFusion application to track events for May-July. The events need to be searchable by users. The resutls page should display a calendar of the selected month...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21807633...
Have a query with 4 fields:
via shown via QBE
- criterias set via right hand side
qryOne
field 1
field 2 - "CL" or "EN"
field - True
field 4
field 5 - [forms]![frmName]![field 5]
In my code have -...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10139505.html
Zones:
MS AccessDate Answered: 03/16/1999 Grade: B Views: 0
Why does this NOT work :
datDate = now()
vandaag = right("0" & day(datDate-1),2) & "-" & right("0" & month(datDate),2)
strSQL = "select user_info.* from user_info where (geb_datum = vandaag) o...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20393430.htm...
Zones:
ASPDate Answered: 11/08/2002 Grade: A Views: 0
Hi Experts,
A few simple questions about web.comfig in ASP.Net:
1. I put a web.config file, an aspx page and some asp pages in the same site. Will the config affect the asp pages at all?
2. ...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20535465.html
Zones:
.NETDate Answered: 03/26/2003 Grade: B Views: 0
I'm using VB6/SP5 on Win2K/SP2 and DAO 3.6 with an Access 2000 mdb.
This works;
Set rssms = dbSMS.OpenRecordset("SELECT * FROM Suppliers WHERE SupplierID =
" & SuppID)
This gives the erro...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20597312.html
Zones:
Visual BasicDate Answered: 04/27/2003 Grade: A Views: 0
I have the following statement:
QueryString := ''
+ 'UPDATE Preferences SET OptionValue = '
+ QuotedStr(edtICRate.Text)
+ ' WHERE UserOption = ''ICRate'''
+ '';
Can anyo...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_20612498.html
