Search results for query: *

I've taken the SQL code from a query that works and pasted it into the openrecordset arguement. When I run it, I get Too Few Parameters. Expected 1 Does anyone know why this might be hapening? Set rs1 = db.openrecordset("SELECT [Statement Query].Transactions.ID AS mmid, [Statement...

at djbmechanical.com we want photos to scroll from left to wright in a 1000px wide box. I made a jpg 3000 px wide, and imported it into a 1000 px wide stage. Ccreated two keyframes at position 1 and position 360, one where the jpg is justified on the left, and the other where the jpg is on the...

I've written this in MS Access VB, but don't know how to repeat it in excel 2000. I've imported two reports into Excel Sheet1 - All Customers (Cust Name in Col 1) Sheet2 - This Years sales, by Customer (Cust Name in Col 1) I need a list of all inactive customers based on cust name field. How...

A form contains two listboxes displaying items from two tables (Table1 and Table2). The user has selected one item in each listbox. A NEXT button adds a record to a Table3 with the id# of each item selected. I'm looking for help with the code for the button. How do I identify the id# of the...

The sql server on my website has some data I need. I realize I can install SQL server on my desktop, download and replicate the database, then import it into excel -- but I'm looking for something simpler such as: Link to the database at its remote IP address or Backup the SQL database and...

Would appreciate any guideance here - trying to set up a nice, categorized link exchange component, can't find anything I like.

I'm looking to use javascript to extract the title tag of the page, assign it to a variable, then put that variable into a hidden field in a form so it can be passed. It's "Where I came from" application. Need Help with both the Javascript and the Form. Sort of like...

Need to create a script: 1 - Click a button on an html page that sends the <page title tag> to a form 2 - On the form I need to print the <page title tag> and ask for the users name and email. Then Click Submit 3a - I need to send a confirmation email with the title tag and the name. 3b - Need...

I want to create a "Buy Now" button that sends the user, along with the page title in a variable, to a fill in form that has the page title field filled in. Can you point me in the right direction?

The project was to create a nice letterhead - Did some Graphics and text boxes at the top and everything looks nice until I get to page 2. The 2" margin needed on the top page flows down to every other page. When I change the margin on the 2nd page, it shifts my letterhead off the top of the...

I can not establish an ODBC connection with my MYSQL database, but I can back it up in SQL format (and LaTeX). Any way to import this? When I export as csv it truncates the huge memo fields.

Well, I've been working on this for days, unable to figure out the program logic. Maybe I'm getting old. I imported my message board into access. I've got 32,000 messages each identified with a MSG#: 24 - Number of this message PREVIOUS#: 23 - If any. Empty means top of thread NEXT#: 27...

I want to fill all fields in a do loop, which requires that the rs1.<fieldname> be a variable The code below doesn't work. I need "rs1.fname" to be "rs1.<contents of fname>." Set db = CurrentDb q1 = "SELECT FName, address, phone from msg1;" Set rs1 = db.openrecordset(q1) mcount=1 rs1.addnew do...

This works on my site: document.location.href = "mailto:?subject=You'll like this page on HandicappedPets.com&body=It's at: "+ window.document.location.href Until I get to this page: http://www.handicappedpets.com/gallery/index.php?category_id=&parent_id=0&photo_id=8&countdisplay=&start=0...

On my append query, memo fields get truncated at 255 or so characters. Is there a way to avoid this? Specifically: Table A has a memo field "Notes" in it. My Append Query send the record to table B, which also has a "Notes" memo field in it, but the text in "Notes" Table A is truncated when it...

Anyone else use this? I'm trying to set it up and finding that the opt-in verification email it send out looks like the msg copied below. No From, To, Or Subject and begins with all kinds of header information. .. Or is this a function of my smtp server? Thanks! Mark ------------------------...

Anybody know a graceful way to get this done?

I've found several program listing on this site, other sites, and one on the microsoft site. None of them seem to work, though. I've got access 2000. When I try to load in the ActiveX control it talks about licensing the ODBC. Several of the others that I've tried generate errors, possibly...

I've got a table with 68 fields. Too long to fit into an opebrecordset statement. I had to split them up as below. Seems sloppy. Is there a better way? Even better, is there a statement like: Set rs1 = db.openrecordset(&quot;SELECT MECdata.* from MECdata;&quot;) that selects all fields in the...

Beginner's Question. Default keywords/page names are included in my template. I would like to be able to edit these on a page-by-page basis. I don't see how to make an editable area in the html screens. Thanks, Mark Robinson www.HandicappedPets.com