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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jbphoenix

  1. jbphoenix

    Creating date field

    That's perfect. Thanks
  2. jbphoenix

    Creating date field

    How would I combine these to make my date field look like this 20090531 select year(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0))) select month(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0))) select day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0)))
  3. jbphoenix

    Pass data from 1 form to another

    I have an Enter_RMA form with a cmd btn on it. The btn opens another form. I would like to have the Customer_ID and Order_ID from the Enter_RMA form be on the just opened frm_6 form. I've been looking all over the place and can't seem to figure it out. Any help would be much appreciated. Thanks
See more

Part and Inventory Search

Back
Top