Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

Another issue I have discovered with the above code. It is not importing dates into the tables. I have tried it with the recieving table as text and as date to no avail. IF it is text, it holds the number value for the date, then transfering to record which has it as date, the value disappears.

Also forgot, MS Access 2003 and excel 2003.

My code to transfer spreadsheets is picking up a invalid range somewhere. If I only import the ME file, I get all 52 fields, if I import both, in any order, I only get the first 32 fields of both files, as the EXP file only has 32 fields. The excel files are being deownloaded from...