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: *

  1. PGTurner

    need TCL file CREATION time

    Thanks for the reply - I should have specified WINDOWS world I added the "ctime" as a possible TCL option switch name - in TCL atime=Last access, mtime=Last modified. But nothing for when the file was created, which is what I am looking for. In Windows - current - 2000/2003 server or...
  2. PGTurner

    need TCL file CREATION time

    Any way in TCL to get file creation time - as opposed to accessed time or modified time? Familiar with mtime & atime - but apparently no "ctime". Don't need to change it just need to retrieve it. DIR /TC filename.ext is valid in DOS and I am playing with parsing out of an exec call but that...
  3. PGTurner

    SMTP messages not leaving server

    Is it every outbound message or just some? Are you sending directly to destination or are you using a remote mail handler? If every, then there could be something amiss with Exchange/SMTP connector - but my problems have always been with certain destinations, even certain messages. If that is...
  4. PGTurner

    No local printer mapping with Terminal Services ActiveX

    I am battling printing issues with terminal services. Servers are Win2K, clients vary but for discussion purposes assume 2KPro. I can access the server via a web page and the Advanced client - the activeX download. I can access the server via the terminal services installed client. Win2K...
  5. PGTurner

    i want to konw my ip internet address

    I have had a chance to test jonscott8's solution. It does operate but I get the visible-to-the-world IP address from my web server, rather than the visible-to-the-world address of my client. It would seem the the web server is doing the querying, not the local client. Which I guess makes...
  6. PGTurner

    Access Query

    For all the code, it needs to go into either a module or behind an object ( eg a command button ) on a form. Code can also go behind objects in reports as well. Just to be more complete, I will describe how I would use what I posted. Create a new module. One of the Access tabs. Paste all...
  7. PGTurner

    Access Query

    If you are asking me, the code will create the table & queries. On my version, "temp" is sort of a misnomer in that they do not go away when you leave ( unless you delete them ). The table & query names are re-used - the content could change on each run but they will stay there...
  8. PGTurner

    Dynamic Queries!

    Assuming users pick the IDs they want from a pick list, the following technique will build an IN(X,Y,Z...) list from the picked selections. I have built it with a picklist ( in my case called PhyPickList). And a command button that builds the query and presents it once the list is picked...
  9. PGTurner

    Why can't I View Source?

    Well, that would seem to be it. Maybe my cache looked like the top of my (real) desk, but I can't say as I have ever intentionally cleared it out. I have often seen clearing the cache as a fix for problems I wasn't having, so I guess I just never did it. Thanks.
  10. PGTurner

    Why can't I View Source?

    I have done something - perhaps checked or unchecked something - such that I now cannot view source. This is on any page I go to. Even ones I have written. My office PC can view the source but not this one. It used to work, but now it just sits there. I know I am probably missing...
  11. PGTurner

    Hopw to export user details to a file

    To concatenate all the files you could use: FOR %a IN (dir *.txt) DO type %a >> c:\AllUsers.txt That assumes all your files are in one folder. Just point your AllUsers.txt to somewhere other than that folder.
  12. PGTurner

    Terminal Server No Login Screen

    Don't know if anyone is still looking at this but I saw it in a search and since I do battle with this issue from time to time as updates get put on the server, I thought I would add my 2 cents worth. It seems to be because the OCX doesn't get properly updated. My fix has been to go into...
  13. PGTurner

    i want to konw my ip internet address

    You are probably reading it correctly. The http returns the vpn provided ipaddress to my ( home based ) PC. The https returns the isa address. I am not ( at least I don't think I am) proxying the http traffic. I don't know what alonak is trying to do but my interest is driven by some...
  14. PGTurner

    Access Query

    Don't know if this will confuse more than it helps but barring a better inspiration, this is what I would do. Add the code to a module - watch line wrapping. You will end up with a table named zTblTable1 that, I think, has what you asked for. The zTbl will be recreated each time the code runs...
  15. PGTurner

    i want to konw my ip internet address

    Try: <% IPAddress = request.servervariables(&quot;REMOTE_ADDR&quot;) ' returns local address response.write (&quot;IP of local: &quot; & IPAddress & &quot;<br>&quot;) IPAddress = request.servervariables(&quot;LOCAL_ADDR&quot;) ' returns web server response.write (&quot;IP of server: &quot; &...
  16. PGTurner

    First day of week Date

    I use this function for a similar purpose. You can play with offset & vbMonday, vbTuesday etc constants to adjust to your week. Make sure you do reality check to see that a weeks worth of dates returns what you think it should. Function StartLastWeek(SomeDate As Date) ' Any time from >...
  17. PGTurner

    Access Query

    Interesting project but I haven't been able to come up wiht with any bright ideas with straight queries. At least I don't see it yet. I think my approach would be a temp table created & populated programatically. But that could get ugly depending on how big your real table is and how many...
  18. PGTurner

    ok, Im getting an odd error, is it a server version issue?

    Maybe I have just never used that syntax but I wouldn't 'set' the query string. One of mine looks like: sqlString=&quot;SELECT &quot; & FieldList & _ &quot; FROM PDFList &quot; & _ &quot; Where Acct Is Not Null &quot; & _ &quot; ORDER BY Acct ASC, TimeStamp...
  19. PGTurner

    Make Table Query

    One way would be use a form to allow the user to provide a name; assemble the query out of the name provided and then call the query.
  20. PGTurner

    Mapping Network Drives

    Maybe my servers are slow or the network is busy but I have found I have to have While/WEnd wrapped around the get user name line. It would misfire periodically ( often enough to aggravate the users ) and fail to map the user drive. While strUserName = &quot;&quot; strUserName =...

Part and Inventory Search

Back
Top