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 wOOdy-Soft 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
  • Content: Threads
  • 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)...
    • patweb
    • Thread
    • Replies: 1
    • Forum: PHP
  3. 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...
    • patweb
    • Thread
    • Replies: 4
    • Forum: PHP
  4. 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...
  5. 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...
    • patweb
    • Thread
    • Replies: 17
    • Forum: PHP
  6. 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...
    • patweb
    • Thread
    • Replies: 4
    • Forum: PHP
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. patweb

    drop-down menu first value

    <!-- function writeframe(argdir, argname) { document.open(); document.write('<html>'); document.write('<head>'); document.write('</head>'); document.write('<frameset cols="18%,82%" framespacing="0" frameborder="0" target= "_blank">'); document.write('<frame name="left"...
  12. patweb

    new window

    function writeframe(argdir, argname) { document.write('<html>'); document.write('<head>'); document.write('</head>'); document.write('<frameset cols="18%,82%" framespacing="0" frameborder="0" >'); document.write('<frame name="left" src= ' + argdir + ' target="rechts"...
  13. patweb

    frame page

    From my index.htm I have a drop-down menu. The client select in this a page. He jumps to the frame where the page is in. I want that he shows in this mainframe the selected page : left(frame) is the directory (same as menu content) and rightframe should be the selected page page.htm. index.htm...
  14. patweb

    function

    hi, I am still confused about a function : how to pass a value and how to get the result of a number of action (e.g. calculation) on this value out of the function. Dim strpagid As String valuetosendtothefunction = rst1![PAG-ID] functioninclude (valuetosendtothefunction) calculation..... end...
  15. patweb

    function directory

    Public Function localhost(url As String) As Variant url = "C:\phpdev\www\web\mb_frm\" End Function I need to reuse in several places a reference to a local directory, how to to this with a function (this is not working). pat
  16. patweb

    update query

    Hi, I have to tables. 1. T_TO_UPDATE FIELD PWDFRAME "e.g. [SUP]" FIELD FRAMENAME empty but to update with the field FRAMENAME from the T_TEMP_SOURCE number of rows = 100 2. T_TEMP_SOURCE FIELD PWDFRAME "e.g. [SUP]" FIELD FRAMENAME with data "e.g. [frmsup222]" number of...
  17. patweb

    create table type

    strSQL1 = "CREATE TABLE [T-TEMP-PWDFRAME] (PWDON TEXT(1), PWDFRAME TEXT(255), FRMNAME TEXT(255));" DoCmd.RunSQL strSQL1 a minor flaw, I create a table, but the field PWDON is in fact a boolean and not a text. If I use text it is still working (represented true by -1), but does there exist a...
  18. patweb

    update group by query

    strSQL = "SELECT [T-02-CONTACT].PWDON, [T-02-CONTACT].PWDFRAME, [T-02-CONTACT].FRMNAME FROM [T-02-CONTACT] " _ & "GROUP BY [T-02-CONTACT].PWDON, [T-02-CONTACT].PWDFRAME, [T-02-CONTACT].FRMNAME " _ & "HAVING ((([T-02-CONTACT].PWDON)=Yes) and ([T-02-CONTACT].PWDFRAME)) " _ & "ORDER BY...
  19. patweb

    OR

    StrWhere = StrWhere + "((([T-LOOKUP-PAG].[" & CodeValue1 & "]) = YES)) or" StrWhere is a string that will be used for an SQL. The string will contain one or more Where Conditions. However the last OR is to much. I should count the lenght of the string and then probably use the left function...
  20. patweb

    Five SQLs in One

    I have made an SQL with 5 boolean fiels (yes or no value). The result with AND or OR is NOK. To many or to few records. page boolean1 boolean2 boolean3 boolean4 boolean5 page1 yes no no no no page2 no yes no no no page3 no no no yes...

Part and Inventory Search

Back
Top