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 Mike Lewis 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. danielhis

    ADP Connection Properties & Users

    I'm currently converting to an adp project and need help with the user login. I want to use sql security rather than Windows NT security so that I can assign permissions to individuals rather than computers. In the connection properties I have to put a user (my user number) and password in...
  2. danielhis

    Date Format problem in a Function query in ADP

    Yes, they are defined as datetime and I have tried; WHERE (EmployeeID = @EmpId) AND (LeaveDate BETWEEN @Begindate AND @Enddate) but unfortunatley that gets the dates mixed up. e.g. if the begin and end dates where 01/08/04 to 12/08/04 (01 Aug 04 to 12 Aug 04) the returned results would be...
  3. danielhis

    Date Format problem in a Function query in ADP

    Hi I'm in the process of upgrading my mdb to an adp (using sql desktop edition for the moment) and although I used the upsize wizard, it seems like I'm having to rewrite almost everything. This is one of the more frustrating problems. I have created a funtion and need to query a date column -...
  4. danielhis

    How to select the first row in a list box with vba and get the value?

    I have a list box with records and when a user clicks on contine I want the first row to be automatically selected and the value of the the first column in that row to be appended to a table. When I use the following code, the first row is seen to be selected on screen but the value comes up as...
  5. danielhis

    Access 2003 + Windows NT

    Does anyone know if either Access 2003 or Access 2003 runtime will operate under windows NT 4?

Part and Inventory Search

Back
Top