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...

I get 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()...

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...

I have problems with the following sql statement: I am 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...

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...

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...

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...

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...

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...

I tried to execute the following job, but it failed. It kills processes older 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 >...

I have an sql statement I run to append records into a recordset. It works fine when [Forms]![frmAdvertQueries]![RenewFrom] has a value(i.e number), but fails when this value is a null value. When using a null value I get the error message: Extra ) in query expression '(((tblAdverts.Publid)=38)...

I am using the following sql to run an append query, but I get error messages. I have copied it out of design window in code, and replaced forms!etc!etc with end quotes and parameters etc... because these values are numbers Please help! strsql2 = "INSERT INTO...

Replacing select statement with the actual sql reproduced the same error messages

I have a problem in the following code where I reach set rst2........ The problem is that the recordset may contain no records, i.e not even a blank record, because it is based on a complex query. When the module reached this point in code I get error "Too few parameters. Expected 2.&quot...

I have 2 Windows 2000 Servers. I have a cluster in place using Veritas Cluster Server 2.0. Each Server has SQL Server 2000, and each server is solely used for SQL Server 2000. We have a raid array by RaidTech. Every hour an the hour on one of the Win 2000 servers, I get an error message...

I am trying to run the following stored procedure. When I click check syntax, I get the error message Incorrect syntax near keyword begin, Incorrect syntax near keyword select What am i doing wrong ??? declare @spid int, @sql varchar(1000) select @spid = 10 while exists (select * from...