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!

  • Congratulations SkipVought 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: patweb
  • Order by date
  1. patweb

    print A5

    Default print out is A4, is A5 (the half of A4) also possible. Or can you even print an A4 in a folder format (3 times fold).
  2. patweb

    selection on selection

    Is its possible to run a query on another query ? I have a table import filled with data from uploaded files. On these data are several analyses queries running. I would like to run these analyses queries not on the table import but on a query (select * from import where file_id = $file_id)...
  3. patweb

    $filename

    directory
  4. patweb

    $filename

    $filename = "http://www.lllll.ch/upload/test.txt"; I use a hard coded url and file name to open this file and insert his content in a table = ok next, i like to get the file under this dir (not longer a hard coded name), the file name is variable, because the clients are uploading this file...
  5. patweb

    two table fields names

    I have the next barrier : tbl format description formatfieldname - 01_SUP (value of this field) - 02_DES (value of this field) - 03_NED (value of this field) formatfieldrequired tbl import 01_SUP (field) 02_DES (field) 03_NED (field) Exactly the same names...
  6. patweb

    open excel import table

    no problem, I found it myself : - file() to get the data and put them in a array - insert to put them in a table.
  7. patweb

    upload FTP or HTTP without limit

    yep
  8. patweb

    open excel import table

    I have excel files uploaded to my web. These files have fixed columns. I need to open these and the content (number of rows, records is always different) should be inserted in a existing table (fixed colums). What is the best function to open and read the .xls file (fopen ?) and how to insert...
  9. patweb

    upload FTP or HTTP without limit

    Goal : my clients need to be able to upload .xls files to my website along a form. Thes files can be small but also relatif big. From 1000 kB to 9000 kB (9MB) or more. I used two script. First with HTTP. However he could opload big files. I even changed the php.ini. Secondly my profider...
  10. patweb

    addressesmembers and brandaddresses

    wow, nice reference. I know the basics about relationships but never to late to sharpen the knowledge (there is a first time for everything - like self-joing one table). pat.
  11. patweb

    addressesmembers and brandaddresses

    yes, I see, if it is well understand to me, in this way I can maintain my addresses in just one table and I can create a many to many relationschip (form and subform) with a between table containing the IDs.
  12. patweb

    addressesmembers and brandaddresses

    yes, number 5 could be linked to more then just number#1. Several members can ask for the same brandaddress. Several members itself can ask over a year to many brands.
  13. patweb

    addressesmembers and brandaddresses

    ok, but one FK won't be enough. Each addressemember can have more then one adressebranch after a while. headform addressemember id 1 subform addressememberbranch fk linked to 1, his own id is 5 addressememberbranch fk linked to 1, his own id is 8 addressememberbranch fk linked to 1, his own...
  14. patweb

    addressesmembers and brandaddresses

    thanks Leslie, your comparison was matching ! Is it difficult, do you need an extra table, or do you have to make a copy of your addresses table ?
  15. patweb

    addressesmembers and brandaddresses

    now I have a table addressesmembers and each record in this table can have one to many brandaddresses with are in an additional table. (members, suppliers are looking for some addresses of certain brands). I was thinking, won't it be better, to add the brandaddresses to the table...
  16. patweb

    mail frontpage images

    hi, little question, using frontpage 2000, a page texte with two images (.jpgs). Afterwards we chose send. The page appears in outlook correctly but on the place of the images a red cross (he refers to images he can't find. How to include the two images. Do we have to past them as attachtments...
  17. patweb

    HARD RETURN

    Public Sub S95ZIP() Dim SourceFile, destinationfile, DestinationZIP, sourcefile1, strpad, i, filetosave, zipfilename strpad = includedir() With Application.FileSearch .FileName = ".xls*" .LookIn = strpad If .Execute() > 0 Then & .FoundFiles.Count & " bestand(en) gevonden." For...
  18. patweb

    HARD RETURN

    I have a little piece of code that writes a file name and afterwards zips this automatically. Not visible but during this he include a hard return in the name of the file. When uploading this to a webserver a apache server seems this and when a user likes to download the file, he can't find it...
  19. patweb

    matching records

    i have an id to solve the question below, but just to know if there are eventually others or better or quicker. my data is coming from excel (to access) 1. excel1 - colomn1 : idarticles colomn2 : description number records : 100 2. excel2 - colomn1 : idarticles colomn2 : description number...
  20. patweb

    drop-down menu first value

    If you read my first post here, there is not a word about speed, its out of the question. I have a drop down menu and I overwrite this by document.write. As said in the answer (and that was a nice post) is if you overwrite you can't refer to your drop down menu in this way. Ok, but can this be...

Part and Inventory Search

Back
Top