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. jasonatsmtc

    Trying to delete current Recordset from database!

    Thanks a lot everyone! I was able to get it to work with this code: Set objConn = New adodb.Connection objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\School\Applications in Software\hotel\data\thebigone.mdb;Persist Security Info=False" objConn.Open...
  2. jasonatsmtc

    Trying to delete current Recordset from database!

    Hi, thanks for the reply, Here is the code that I am trying to use... Deletestring = "DELETE FROM " & CurrentRoom & " WHERE [Customer Number] = " & CustomerNumber frmData.datRooms.RecordSource = Deletestring MsgBox ("we have deleted your reservation!") It all...
  3. jasonatsmtc

    Trying to delete current Recordset from database!

    Hi, What i am doing is filtering a table using certain specifications, i then want to take all of the records that meet these specs and delete them.. this is what I have for code right now, I dont get an error, but it does not delete anything from the database...
  4. jasonatsmtc

    Intriguing problem with Variables, Dates, etc

    Thanks a lot everyone! I can now move on... :) I have been stuck on this detail for days!! Jason
  5. jasonatsmtc

    Intriguing problem with Variables, Dates, etc

    When i try your code i still get the run-time error 9 on the following line: Do Until varDate(varIndex) = frmMakeReso.dtDepart.Value Any other ideas would be awesome! Jason
  6. jasonatsmtc

    Intriguing problem with Variables, Dates, etc

    Hello, I am trying to create a function that will take two inputted dates, from 2 MS Date Time Pickers, dtArrival and dtDepart, and create veriables for those dates and every date in between. Here is the code that i am trying to use. Public varDate() As Date Public varIndex As Integer Public...

Part and Inventory Search

Back
Top