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!

Recent content by fb63

  1. fb63

    Update Subfrom based on Listbox selection

    I have a subform that shows a pivot graph of the records tied to the main form. That form has two listbox's used to filter those records. I have that tied to a button to pull new form to review individual records that were filtered. I would like to update the subform to show the pivot graph...
  2. fb63

    transferspreadsheet not functioning.

    ok, now I am really stumpped. I am working on this from home where I have Access 2007, I tried just importing and got the same record restrictions. Now I have created a totatlly new db with only 1 table, with fields f1-f52. Then put in this code in a module and ran it. And it loaded...
  3. fb63

    transferspreadsheet not functioning.

    Ok, going back and trying to reload old files, tried manually importing file into new table. Still cut off at column 32, instead of all 52. And brought in 255 records, including row 1 which has record count in B1 and column headers in row 2. So back to 253 records, instead of the 379...
  4. fb63

    Subform Relationship question

    Thanks, MajP, that is the exact issue that I have. I will try that to resolve my issue
  5. fb63

    Subform Relationship question

    I have a master form with location field that is pulling a subform based on a table that used yes/no fields for each location. I was trying to link by converting all yes's into the locations 3 letter code and concatenating them into one field. But Can I use the *location* from master to the...
  6. fb63

    Subform updated by 2 or more listboxs

    I have an unbound form with two listboxs, one for category and one for location that are pulling from the main table. I also have an unbound subform pivot table showing total records form that table by age. After users select categories and locations they want the subform to show only the...
  7. fb63

    transferspreadsheet not functioning.

    Just got a new file in this afternoon that only had 196 records on it. All records pulled in, so I can't see how it would be a data issue, when it always stops at 253 if more but pulls everything under 253. If there was a data issue, then no matter how many records were on the file, it...
  8. fb63

    transferspreadsheet not functioning.

    OK, now I am really stumped, The files did not load today, going back to only 253 records, and 32 columns. I was able to get each file to load once correctly today, after deleting the table I load to and reseting the all the fields to text, 255, no index, not required, zero length allowed...
  9. fb63

    transferspreadsheet not functioning.

    Everything is working correctly today, all records were loaded today and all columns as well. I am not sure which issue it was but I changed all field in the recieving tables to text, no index and zero length allowed to resolve the issue. Not sure which one did the trick but after those...
  10. fb63

    transferspreadsheet not functioning.

    No,I am not using a range name, would naming the range, instead of listing it as "Sheet1!A3:V1000" make it work? When this is run, the only time it pulls in all records, is when there are less than 253, 1 file had 192 and it only pulled in those records, most days I have over 253 records and...
  11. fb63

    transferspreadsheet not functioning.

    Could there be a recordset limit of 255 that I am hitting on this issue?
  12. fb63

    transferspreadsheet not functioning.

    Skip, Yes, the data is contiguous, as the files dropped onto the network folder by Peoplesoft nightly. But I don't see how the table name has anything to do with the issue. Perhaps I am missing the correlation or I didn't provide enough data. I am loading today's data from both files...
  13. fb63

    transferspreadsheet not functioning.

    Ok I have tried the named range as shown below, Private Sub LoadME(strfilename As String) 'set query names to variables Dim strq1 As String Dim strq2 As String Dim strq3 As String Dim strq4 As String Dim strfilepath As String Dim strtable As String Dim strSQL As String ' location of files...
  14. fb63

    transferspreadsheet not functioning.

    So what is the best way to fix my issue? Since they wants hands free on the data, going in and manually deleting the first row is not an option.
  15. fb63

    transferspreadsheet not functioning.

    Well, I have all dates, expect the row 2 which has the field names. Row 1 has the record count in b1 Since it is variable record counts, is it possible to pull the value from b2 and use it in the range section of the transferspreadsheet? Right now, I dump it all into a rawdata table then...
See more

Part and Inventory Search

Back
Top