Search results

THANKS! i adapted it well enough for my prototype

how did you do this>?

still need help people thanks!

still need help people thanks!

for Excel 2000, just use docmd.runcommand accmdimport.. thanks VBA!

still need help!! thanks!!!

There would be close to 1500 records sorry, but how should i use the sort order column? Just to clarify again, i would need to arrange the in the way that it is sorted in continuity.. i tried looping through the current excel rows against the remainder rows but only manage to achieve A to B...

Hi all i have a problem at hand, i am required to sort the below spreadsheet data using any method, most probably through a procedural call. i am tried using a access table to import the table from an excel file and sort it using dao recordset then write it to a excel file. i attached a code...

hi!, i created a empty table called FinalTable and opened a dao recordset by doing this: ''sets current databse to an object Set db = CurrentDb() ''initiate the record set Set rs = db.OpenRecordset("tempHoldingTable", dbOpenDynaset) 'dbOpenDynaset ''rsNew is the empty recordset...

I used the following code to sort and got the attached results, look at record 256 and 257, there was a break in sequential order yes? it resumed at 281 and 282.. CODE: Private Sub cmd_Sort_Click() ' uses recordset as a way to sort the data and insert into ReformattedTable Dim rs As...

Hi Husky, Thanks for your reply, i understand that access table is just a means of storage and the order that is represented on display is mostly achieve through the order by clause in the select query. i have attached a copy of my test data please take a look : what i am trying to achieve...

i tried doing the recordset method, but the recordset isnt in the correct order when i used a array to check it's data, specifically using the recordset.getrow(recordset.recordcount) method, could you supplement me with codes that can write the recordset to a excel file too?

You can try using this, DoCmd.OutputTo acOutputReport, "Class Roster By Instructor ID", acFormatXLS, "S:\BasicSkills\BaSIS Output\ClassRoster" & me.FieldName.value & " + " " + " & Format(Date, "yyyymmdd") & ".xls"

Thank You Very Much, Would try it out! keep you posted! =)

i cannot order by Sno, it will render my previous effort to sort the rows in a specific manner to either the default ascending or descending

same feelings, i think a date time field would suffice, but still there should be a more efficient way, because i need to remove the date time field when i export it out to the excel file. the excel file will be fed to a industrial program for use.. could you explain more on the using the...

Would you have any suggestion in where i could place the data that has a follow a FIFO approach to something similar to a insert statement? perhaps a new record set? or a direct write to a excel file?

i am trying to sort a table that has 3 columns. Sno Origin Destination if record 1 destination is QQ All records that Origins from QQ would be inserted below Record 1 in a new table And if Record 5 starts from QQ and ends at TT and has records that orginate from TT would be places...

Hi thanks for the prompt reply, i thought access tables when being inserted it will always start from the bottom?? as in like first come first serve eg.. Record 1 to Record 100, as i loop through 1 to 100, Insert 1 Insert 2 Insert 3 ... ... ... till Insert 100?

My Result are as you can see, record 1's destination is record 124's origin thats why i place it beneath records one.. but out of the blue record 64 got brought up to the top... is it because DoCmd.RunSQL got some sort of bug or technical loop hole? Sno Wire Spec Origin Destination...