Search results for query: *

Hi I have a table in my shopping cart database which stores the delivery address info in a single field called address, each part of the address is separated by a semicolon. I need to create a recordset with each address element in its own field. I'd prefer not to have to convert the data...

I have a query which lists products. When a product has several options (i.e a pillow may either be feather or polyester) it is listed several times in the query results. I need to either add a field to the exisiting or create a new query which groups the product and shows all the options...

Thanks for your responses. Chaz, the data is all in one table (tblOrders), with parcelID (unique), OrderNo (not unique), Add1, PostCode, PartLotNo (this is the tricky one), and LotNo (the 'of 4' bit, calulated by counting the duplicate addresses). Thanks Again. Jon

Thanks Blof I think I didn't explain well enough. If there are 4 parcels to one address I need the first to be 1 of 4 (4 being the count expression you mentioned) the second to be 2 of 4, the third to be 3 of 4 etc. It's the 1,2,3,4 figure I can't work out how to do. Thanks again Jon

I have a table of customer orders containing the parcel type and address of the recipient (coming from our access based shopping cart). Sometimes multiple parcels go to the same address. So there are parcels with the same address. I need to give each parcel a 'part lot number' (for the...

I've just tested it again and it seems to work fine, I can not replicate the problem anyway. Thanks for all your time. Jon

the form code is : <form action="cdonts/contact3.asp" method="post" name="mailform" onSubmit="MM_validateForm('name','','R','email','','RisEmail');return document.MM_returnValue"> <table width="100%" border="0" bordercolor="#CCCCCC"> <tr> <td width="25%"...

Sorry, The actual code uses 'industry' in both, I changed it it my first post to make it clearer (obviously failed there then!). Thanks

Thanks As you will see the check box values are generated from a db. <% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <tr bgcolor="#CCCCCC"> <td width="95%" valign="top"...

Hi I've a contact page/form which generates THREE groups of check boxes. Each check box has a unique 'value' and is 'named' one of the three group names (products, services, applications). I'm using cdonts to email the results. I can only manage to extract the check box values from the first...

Hi I've a table with around 4000 records in a rather large application. The users report missing data, so i've been checking the tables in the backend mdb file on a server. When i open the table it shows all the records, when I sort the records by surname (not linked to other tables) it shows...

Hi, I'm having a problem with getting this image scroller to work on Mac IE (works fine in windows). ----this is in the head tag------- <SCRIPT language=&quot;JavaScript&quot;> var iTimer; function timeIt2() { iTimer = setInterval(&quot;scrollIt2()&quot;,50); } function timeIt() { iTimer =...

It's the windows 2000 password Thanks

I've just inherited a Dell Laptop with windows 2000 prof. The problem is i don't know the password. I want to install another OS but there is no floppy or CD drive with the laptop. How can I install the OS without getting hold of an external floppy (I've got an external CD writer, other PCs...

I would like to have a track playing when my website index page is loaded into a browser. When the user moves to another page I want to avoid the track stopping and starting again. Is the only way to use frames (i.e. a constant frame througout the website with the sound embeded) or can Flash...

I've a VB app which accesses an Access database. I want to package a version in which the database can be installed on a shared file server. How can I prompt the user for a data location during the install? Will something like 'Wise' do this for me?

Thanks, should've looked there first!!

I have to rebuild my PC. I have about 20 sites defined in DW, is it possible to save or export all the site definition data (ftp info, remote info etc) so I don't have to set them all up manually after i've reinstalled windows ans DW. Thanks

I want to display all the records on one page. So if my recordset had 16 records in it, i'd want a 4 x 4 grid, or if it had 8 records in it i'd want it in a 4 x 2 grid. Basically I need have a table with one record in each <td></td> and the table to expand (adding <td></td> then <tr></tr>...

Hi I have a recordset which I need to display in a 4 x ? grid (table). I.E. one record per table cell. Currently (using a repeat region I can only get it so the records display vertically with a new table row per record. Is there a way of populating the table horizontally for 4 records and...