Recent content by ca268339

ksbigfoot - I fiddled around with your suggestion and referenced directly to the /fpdb and I was able to access. Thanks. My connection prefix now looks like: dim conn dim DSNtemp set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "...

DotNetGnat - thanks for the tip, but that I though by using the server reference, (e.g., -mappath) that the correct link would be assured. If I "write" out the -mappath it is the correct link - I think?? I'm not comfortable with the D: that is used on the prefix of the output, as the file...

I'm having a difficult time trying to accomplish a very simple task that is to create a small ASP page using FP that will take the contents of a post and update a DB. Before I can update the DB, I need to connect to the DB and that is the problem - I can't connect. I'm using what I assume is a...

MichaelRed You suggested to "Set the sla property of the named query". What si the "sla" property and how do you set the property for a named query? Thanks

GingerR Hi again and sorry that I wasn't more clear in the description. The data for the report's sql WHERE clause comes from the specifications provided from a form called in the OnOpen event. The WHERE data is selected by the user from a drop-down list and the values can be a single value or...

GingerR, Normally I was lucky if I ever got a reply back on a question, but on this one WOW - I hit the jackpot!! As for your question, yes the user must select the criteria from a drop-down list of selection variables and then those values are built into the sql's WHERE clause. That's the...

CosmoKramer - Again, thanks for the response. You're right about the placement of the code if a form were used to OPEN the report. Unfortuantely, - or by design - I create a report that opened the form on the report's OnOpen event, so I believe the code option is out as the form is already...

CosmoKramer - My apologies for implying that you "missed the point". I thought that I was replying to the other responder to this question. Your insight and clarification into the problem appears to reside in the fact that once the OnOpen event is invoked, then the report is...

Again, you're missing the point - but I really do appreciate your comments. What you've suggested would work if the report wasn't already open. On the OnOpen Event, I've coded a procedure whereby a Form is opened that allows the user to select criteria by which the report will be generated. (The...

Yes, you are missing the point which is that the SQL is constantly changing based on selection criteria provided by the user in an associated form. You couldn't simply insert the SQL in the record source, because the "WHERE" clause is constantly changing for each report generation. The...

First, thanks for the reply. Yes, I'm putting the SQL equivalent of a saved query directly into the rowsource property. For example: dim sqlstr as string sqlstr = "SELECT [FrameRelay-DLCI-Port].CustomerName, OVDB_ATTFRAMESTATS.RECORDING_WEEK, FROM [FrameRelay-DLCI-Port] ORDER BY...

This question has been asked before without any answer. Has anyone been able to set the rowsource property of the embedded graph with VB. I've tried to create a sql and simply set it equal to the rowsource for the embedded graph. When I execute the report, I receive the message "Run time...

Thanks for the tip. I wish there was a way to do this with the native ODBC/Access environemnt instead of intorducing some other "shim" into the mix.

Herb, Thanks for the response. Actually, I am aware of the auto linking along with the ability to link via the external data access, but I need the ODBC to link the MDB to a FrontPage application that doesn't use external data access. I was simply trying to use Access to test ODBC access to the...

I'm trying to link an external MDB with a local database. After I've defined the ODBC data source and try to link or access the database I get the following message: "Error "You cannot use ODBC to import from, link to an External Jet or ISAM database table to your database." Is it...