Recent content by fogal

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

Here is how I did it in the end: Though the code below is actually for my real data, not the sample data given above: Dim dbs As Database, rst As Recordset, rst2 As Recordset Dim title1 As String, title2 As String, title3 As String, title4 As String, title5 As String Dim counttitle1 As Integer...

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