Search results for query: *

In event log I am geting errors: Error: 0, Severity: 19, State: 0 language_exec: Process 57 generated an access violation. SQL Server is terminating this process. Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005...

new to fp. I am able to extract data from url using request.querystring and have it as a variable. I then want to save this info to a field so I can send it back to my db later. ie save it to a text box or hidden field. Please help???

new to front page. I have a url like www.comp.com/test.asp?field1=1000 and I would like to store the value 1000 into my webpage. how is this done? I will send lots of different web addresses to users with the value of field1 being unique www.comp.com/test.asp?field1=11...

New to Front Page! I have created a fp page which allows users to send responses to questions to my database once they click the submit button. I plan to send users a link to this webpage, which they can use. However, each webpage needs to be unique (ie store a reference number), which I also...

...the error msg no current record with this, but works from design view of query and sql is similar to sql view in query????? sql1 = "SELECT * FROM tblAdvPublDates WHERE (((tblAdvPublDates.LastAppear)>=#" & [Forms]![frmReports]![PublDate] & "#))" Set dbs = CurrentDb() Set...

I have problems with the following where statement in my sql query. I am trying to open a query and sql1 is the where statement belonging to that query. sql5 and sql6 are used in sql1. I get the error no current record found. The query was a working query and I copied and amended the sql from...

...opening it in a recordset, and get the message too few parameters. missing 4. I can not then open the recordset. I originally tried "select * from queryname", but this produced the same message, so I then copied the sql from the query into code. sql1 = "SELECT DISTINCTROW...

...As Integer, counttitle3 As Integer, counttitle4 As Integer, counttitle5 As Integer Set dbs = CurrentDb() Set rst = dbs.OpenRecordset("SELECT * FROM Table1", dbOpenDynaset, dbSeeChanges) Set rst2 = dbs.OpenRecordset("SELECT * FROM Table2", dbOpenDynaset, dbSeeChanges)...

I have a query with 2 fields as shown below: I want to create a new field (Field3) to do as shown below. Field1 Field2 GroupA A1 GroupA A2 GroupA A3 GroupB B1 GroupB B2 GroupB B3 GroupC C1 GroupC C2 GroupC C3 I want my query...

Unfortunately, I need to do this in a query. I plan to export the query to a text file using access xp. I have this working in a report, as you stated but when I export the data to text, it misses some of the text in the export. It works fine from access 97. I now believe the ebst way to do it...

I have a query with 2 fields as shown below: I want to create a new field (Field3) to do as shown below. Field1 Field2 GroupA A1 GroupA A2 GroupA A3 GroupB B1 GroupB B2 GroupB B3 GroupC C1 GroupC C2 GroupC C3 I want my query...

Unfortunately, I need to do this in a query. I plan to export the query to a text file using access xp. I have this working in a report, as you stated but when I export the data to text, it misses some of the text in the export. It works fine from access 97. I now believe the ebst way to do it...

I have a query with 2 fields as shown below: I want to create a new field (Field3) to do as shown below. Field1 Field2 GroupA A1 GroupA A2 GroupA A3 GroupB B1 GroupB B2 GroupB B3 GroupC C1 GroupC C2 GroupC C3 I want my query to display a new field, don’t mind if it is done from a new...

Tried this and it produced same errors. The export works fine from access 97, but not from access xp

I have problems exporting the contents of a report to text. It looks fine in print preview, but when you export to text sometimes it appears correct, other times it differs. On occasions exporting the same rport has produced several different formats. Spaces appear after lines of text and words...

I have problems exporting the contents of a report to text. It looks fine in print preview, but when you export to text sometimes it appears correct, other times it differs. On occasions exporting the same rport has produced several different formats. Spaces appear after lines of text and words...

So far I've found: create a sql pass through query save odbc connection in properties to the sql server then type: Exec nameofstoredprocedure parameter1, parameter2 etc.... i.e where parameter is for eg what to insert if my sp is an insert sp. The sql table is then updated, but access returns...

I have an Access .mdb front end database and have a sql 2000 backend. I have created stored procedures in the Sql Server for my database. How do I run these stored procedures from MS Access. Can I link them to forms etc... I have read articles that talk about using sql pass through queries, but...

...than one day, that are non system user processes. All ideas welcome. declare @spid int, @sql varchar(1000) select @spid = 10 while exists (select * from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,getdate())) begin select @spid = min(spid) from...

Just tried that and it produced the same error message. I've now tried the following and it works: If IsNull([Forms]![frmAdvertQueries]![RenewFrom]) Then strsql2 = "SELECT tblAdvDuplicates.AdvertID, 1 AS AlreadyDuplicate, " & Forms!frmUserCapture!User & " AS Operator FROM...