Search results

here's how I did it...I went to MS website and looked for the XML reader, but this require a lot of programming... good luck!

thanks for the tip, yeah I tried option 1 but its not the one I want. I want user to simply click a button, this way they stop asking me... :) Thanks heaps guys!!!

I cleaned up my code and its allllllll goooooooooood !!!!!!! YAY !!!!!!!!!!!!!!!!!!!!! Thank you "gemma-the-husky", "The_Doc_Man" and Galaxiom for pointing me to the right direction..... NOTE: table <----cannot hold sorted records!

YAY !!!!!!!!!!! thanks for the guide guys!!! I was thinking.... debug.print tells me...my code is right... how about instead of moving the arranged record to a table I will just directly output it to the textfile which MYOB uses!! and it worked!... Thank you thank you thank you...

hello!! :) it makes me scratch and pull my hair :confused::eek:..it works..not luck... hahaha, in that case I'll create the text file as I traverse along the query (on my previous code). It does work perfectly if database is moved to a Core2 Due laptop... ok got it...table is a basket...

hello Galaxiom !! thanks for the super quick response! hehehe my code is right..I have been doing a query to sort them out...the weird thing is...it works perfectly when database is moved to C drive of a good computer and run...but when run from a shared drive.... i get sorted table..then as I...

oh wait guys...I am doing the sorting thru a Query... so I gather all the data entered for the month of say "1 Feb to 28 Feb", arranged by Company name......then move it to a table called MYOBNow...then create a query (see strS variable below).... then iterate thru MYOBNow table from top then...

so instead of iterating thru a table I will iterate thru a sorted query right? I shall do that then?... I need the artificial "Z" record because my textconverted read for z then it inserts VBCrLF on the textfile, MYOB program needs a space to distinguish different invoices.

ok i thought by arranging the records in a table in order or company name will do the trick i shall use a query to sort it and iterate thru this query to create a new table with companies gruoped together and separate by "z" thanks in advance ! will post again how i go. thanks!!

btw i tried ordering by invoice number, it jumbles the result table as well, also sorted the original table by company unique number and same issue as well i cannot sortby date because thiscode is run in monthlybasis and other records are entered i. different dates. i want to group all entered...

the original table already has a sorted record arranged in company names all my code is doing is traversing a sorted record then when it detects it a new company it inserts a "z" which is an empty record i debug print my code above and its doing what i want it to do, what i reallydont...

ok thanks !! I shall order them by invoice number.... I'll try that... thank you! :) I'll post again if it worked. :) I'm nearly there I can feel it!

here's a weird challenge guys.... is MS Access overwhelmed with data? my code below DO what I want it to do but when the records jump up to 2 weeks of data (like 500 records)...it does not do what I want it to do. example below is the data in my table... I will traverse thru this table and...

got it! simple iterate the xml, collect the "insert into" less complicated :)

XML I'm reading, (I can read it now, and store the value to a string variables) I need a way to insert the data 1 by 1 to a row of a table. ReferenceID: NXX-001 FirstName: Nelson LastName: Smith ReferenceID: NXX-002 FirstName: Johnny LastName: Cash ReferenceID: NXX-003 FirstName: James...

hahahahahaha how silly of me... found the problem Dim stdate, enddate As String stdate = Format(CDate(Me.txtBatchStartDate.Value), "MM/DD/YYYY") enddate = Format(CDate(Me.txtBatchEndDate.Value), "MM/DD/YYYY") it was "DD/MM/YYYY" recordset works perfectly now, gives me...

hello, I'll keep trying and post the solution, I need to use recordset because I need to iterate on the records to create an XML file. :) wish me luck! I tried Dcount unfortunately its not the one I need...

Hi Drake, thanks so much for your help ! :) I think I'll give it a rest, im sure solution/ideas will pop out when I go to bed or something :) have a good weekend!!! :)

hi Drake, i tried what you advised and still the same, it gives me 0 records :(

arrrrrrrrgh that's weird...that didnt fix it...:( i'm going to cry !!! arrrrrrrrrrrrrrrgh :( same issue, query is working, but the rs.recordcount shows 0 any idea why its failing?