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

    Code to kick off linked users before maintenance

    The link below should take you there. thread705-79802
  2. msshaw

    Code to kick off linked users before maintenance

    Hi all, I am looking for some code to clear users who have linked a table from a database - hence keeping the database locked whilst accessing this data. Any ideas? PS This is not quite the same as the "VBA code to kick off logged users before maintenance" thread. Regards, Mark
  3. msshaw

    Duplicate rows added to a table

    The AvailBeds holds only 1 record per location, with the upto date information - hence that is why it is edited, and the appropriate line found in the data. The AvailBedsHist holds - in theory - 1 record per adjustment to AvailBeds. HTH
  4. msshaw

    Coding Problem Blah!

    Hi Bill, Dim SetData As String Dim pagectr As Integer SetDate = "SetPrintData" Do you mean SetData in the last line here? Regards, Mark
  5. msshaw

    Duplicate rows added to a table

    Hi Gus, Thanks for your prompt reply, however [code]Set AvailBedsHist = PrtFolio.OpenRecordset("AvailBedsHist", DB_OPEN_TABLE) Set AvailBeds = PrtFolio.OpenRecordset("AvailBeds", DB_OPEN_TABLE)[code] One is the AvailBedsHist table and the other is the AvailBeds table, so...
  6. msshaw

    Duplicate rows added to a table

    Hi, I have a piece of code that I have inhereted - see below - However, the code adds 2 identical lines to AvailBedsHist. I have stepped through and cannot find anything wrong with the code, and neither can my colleagues here at work. However, I did notice that it has only begun occuring...

Part and Inventory Search

Back
Top