Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jonohara
  • Order by date
  1. jonohara

    Create a recordset from a csv data on the fly

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

    Concatenate child field for each record

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

    Numbering duplicate records

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

    Numbering duplicate records

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

    Numbering duplicate records

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

    Multiple groups of check boxes

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

    Multiple groups of check boxes

    ...bgcolor="#CCCCCC">Contact Name</td> <td bgcolor="#CCCCCC"><input name="name" type="text" class="required" id="name"> *</td> <td bgcolor="#CCCCCC">Company Name</td> <td bgcolor="#CCCCCC"><input name="company" type="text" id="company"...
  8. jonohara

    Multiple groups of check boxes

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

    Multiple groups of check boxes

    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"...
  10. jonohara

    Multiple groups of check boxes

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

    'Sort Ascending' loses data

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

    Script won't work on Mac IE

    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 =...
  13. jonohara

    Install OS with no floppy or cd drive available

    It's the windows 2000 password Thanks
  14. jonohara

    Install OS with no floppy or cd drive available

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

    Seemless Soundtrack while navigating a HTML site

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

    Distributing VB App with Access Database

    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?
  17. jonohara

    Exporting/Saving Site Definitions

    Thanks, should've looked there first!!
  18. jonohara

    Exporting/Saving Site Definitions

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

    Displaying records in a grid...

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

    Displaying records in a grid...

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

Part and Inventory Search

Back
Top