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!

  • Congratulations biv343 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: *

  • Users: Bjornson15
  • Content: Threads
  • Order by date
  1. Bjornson15

    Record Locking Issue

    I have an Access Database in 2003 format that is locked. The problem is, no one is in the file any files that have linked tables to it. When I try to compact the DB, it states that my computer is the one locking it. I have exited and restarted my computer, but still no change. Any ideas?
  2. Bjornson15

    Export Large Recordset from Access to Excel

    I have been trying to do this for sometime now. I have code that "works" but it takes too long to come back. I am trying to download a Access query into an array. I cannot take less data than what I am grabbing. Here is my code: Function GET_ACCESS_DATA(SQLSTRING As String) Dim QD As...
  3. Bjornson15

    Export Large Recordset from Access to Excel

    I have been trying to do this for sometime now. I have code that "works" but it takes too long to come back. I am trying to download a Access query into an array. I cannot take less data than what I am grabbing. Here is my code: Function GET_ACCESS_DATA(SQLSTRING As String) Dim QD As...
  4. Bjornson15

    Prompting for Like and Not Like (or any others)

    I don't know if this is possible, but this is the place to ask this. I am trying to have a query that can be ran 3 different ways: 1. All records. 2. Records that begins with a prompted string. 3. Records that don't begin with a prompted string. I can do all 3 seperately, but want to do them...
  5. Bjornson15

    Null Values in Crosstab query Report Headers

    Hello everyone, I am trying to put together an OnOrder report. In my table I have Lot/Week Ending Date/Quantity as my columns. Because of the way I have the data, I need to use a crosstab query to extract each individual Week Ending Date across the top of the report. I have given the...

Part and Inventory Search

Back
Top