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

  1. tomslacks

    Email Notification unavailable

    Install outlook on the server
  2. tomslacks

    cant browse VPN across in networks Help!

    Hello all, I am trying to setup a vpn from home to my office. At the office I have a netopia router and a NT server. At home I have a win 2K network and a linksys router. I have setup the netopia router using the guides from their website step by step. When I connect the VPN, the status...
  3. tomslacks

    extracting two digit year from date in query

    awesome thanks to all
  4. tomslacks

    extracting two digit year from date in query

    I am attempting to extract the two year (03 from 5/6/2003) from a date column and combine the results with another field and I dont know if it can be done. Anyone know how it is done? T
  5. tomslacks

    Query that sorts the Most current Date

    For those interested this is how I was able to get it to work First query qryMaxDate SELECT t2.JOBNO, Max(t1.CDATE) AS LastCommentDate FROM Table1 AS t1 INNER JOIN Table2 AS t2 ON t1.JOBNO=t2.JOBNO GROUP BY t2.JOBNO; Second query SELECT [Table2].[JobNo], [Table2].[Client], [Table2].[City]...
  6. tomslacks

    Query that sorts the Most current Date

    ok, this is my max(date) query Call qryMaxDate SELECT t2.JOBNO, Max(t1.CDATE) AS LastCommentDate FROM Table1 AS t1 INNER JOIN Table2 AS t2 ON t1.JOBNO=t2.JOBNO GROUP BY t2.JOBNO; Then this to bring it all together SELECT t1.JobNo, t2.Client, t2.City, qryMaxDate.LastCommentDate, t1.Comment...
  7. tomslacks

    Query that sorts the Most current Date

    even if i add the parenthesis I still get the same error. The message box doesnt have the line with the error line like a syntax error normally has.
  8. tomslacks

    Query that sorts the Most current Date

    SELECT t1.JobNo, t2.Client, t2.City, t1.Date, t1.Comment FROM Table1 t1 inner JOIN Table2 t2 ON t1.JobNo = t2.JobNo and [Date] = (select max([Date]) from Table1 where t2.JobNo = t1.JobNo; the statement I using is this, I spelled max wrong in the first post, I still get the same error with...
  9. tomslacks

    Query that sorts the Most current Date

    I have tried your query and keep getting an error "Syntax error. in expression". and when I click ok it sends me to the t1.JobNo = t2.JobNo section. SELECT t1.JobNo, t2.Client, t2.City, t1.Date, t1.Comment FROM Table1 t1 inner JOIN Table2 t2 ON t1.JobNo = t2.JobNo and [Date] =...
  10. tomslacks

    Getting the Current Date

    I forgot to mention DATE() returns the system date when used.
  11. tomslacks

    Getting the Current Date

    I think the simple answer is DATE()
  12. tomslacks

    Query that sorts the Most current Date

    Hello All, I have two tables that I am trying to join in MS Access and sort by a date and only return the most current date. Table1 JobNO Date Comment 1 4/2/03 yes 1 4/3/03 no 2 4/4/03 yes 3 4/4/03 no 3 4/5/03 yes Table2 JobNo Client City 1...
  13. tomslacks

    Creating non-printing images?

    Awesome that did the trick, thanks for your pointers T
  14. tomslacks

    Creating non-printing images?

    Have been unable to find if I can create non-printing images with acrobat. I have tried to create and image in Illustrator and make the non-printing and save as a pdf but when I open with reader or acrobat it does not show the image at all. I am trying to create a form that users fill out and...
  15. tomslacks

    Veritas wont start

    It doesnt show the job as failed in the job log. I put in a tape around 3pm, come back around 4pm to check that the tape is still in the drive. The job is scheluded to run at 11pm, when i come in on Monday morning (happens during theweek also) there is a error message that has a time of 11pm of...
  16. tomslacks

    Veritas wont start

    Hello All, I am using BE 8.5 on a Sony backup device with WinNT 4.0 server. On fridays I do a normal back-up at 11pm. for the last several weeks when I come in on monday morning the backup has not started and has kicked out the tape. I get an error stating unrecognized media, I push the same...
  17. tomslacks

    cant get samba shares to work

    I cant get my samba shares to work. I can see my linux server in My Network Places (win2K with AD) but I cant see any shares. I am getting an IP address from DHCP and my Linuc server is registering in WINS . When I try to get on to the Linux server in My network places I get an error box with...
  18. tomslacks

    missing nmbd service?

    Hello all; I am a Linux novice and am trying to setup a red hat 7.3 Linux file server for my Windows 2K & Mac OSX home network. I have tried several simple smb.conf setups and am able to get online with the Linux box. My linux box is getting a address from DHCP but i cant see it in the...
  19. tomslacks

    Cant see Win 98 Client on NT network

    After posting the question, I have decided to implement all XP pro, I am not a big fan of XP but I found that from between the time I setup the computer for the new user to when I posted this question (1 week) the user had uninstalled file and print sharing. He claimed he never uninstalled...
  20. tomslacks

    Cant see Win 98 Client on NT network

    Have this really annoying problem. I have a win98 client on a single WinNT server. Using Dhcp, the Win98 client is able to logon to the network, use the network folders, I can ping the Win98 client BUT I cant see the Win98 client from other computers or the server. There is an account on the...

Part and Inventory Search

Back
Top