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 gkittelson 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. ashm01

    ADO Data Control Connection string at runtime.

    Thanx a million, That did the trick... Awesome, Solved my problems. ASHM01
  2. ashm01

    ADO Data Control Connection string at runtime.

    Guys, I have SP5 loaded with Mdac 2.7 I have the following code in there: SetupADO.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DB.mdb;Persist Security Info=False" SetupADO.RecordSource = "SetupInfo" SetupADO.Refresh As soon...
  3. ashm01

    ADO Data Control Connection string at runtime.

    That doesn't work..I have the same thing using the adodc1.connection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DB.mdb;Persist Security Info=False" adodc1.refresh adodc1.refresh First I get a msgbox stating old db not found. and a runtime error.. So no...
  4. ashm01

    ADO Data Control Connection string at runtime.

    Hello Experts, I am stuck in a bind here..I have a few ADO Data controls which need a connection string based on the directory the application is installed in..If I have a static directory then it is so problems. However if the directory changes then I got issues. Why won't this work? I put...
  5. ashm01

    Checking whether current time is in range of

    thanks..I think I got a solution.
  6. ashm01

    Checking whether current time is in range of

    well that worked pretty good..but, now another issue arises..For some reason if my timeEnd overlaps 23:59:59 PM into AM, i get no records..any solution for this?
  7. ashm01

    Checking whether current time is in range of

    I have 2 fields in short date format(TIMEstart and TIMEend) in an access table, I need to know whether the current time is within the range. It has to return all records if the criteria matches... something like this Select * From table where Now> timestart and Now < Timeend Its going to be...
  8. ashm01

    Calculating hours and minutes between two times in HH:MM format

    I have a query similar to that..I also have 2 fields in short date format(STARTTIME and ENDTIME), I need to know whether the current time is within the range. please help. Sincerely, Ashm01

Part and Inventory Search

Back
Top