Search results

OK, i've used recordsets before, not as up to date with them as i like but clearly will be soon lol. to be clear i'm loading about 35-40 summed querries for 1 page (no i don't have a choice!) so that means loading and unloading that many queries in code. DSUM works to test but is SOOOOOOO slow...

i can get the queries, but i would have THOUGHT ( i was wrong i guess) that tallying a query column with a simple DSUM was fastest... loading it into recordset memory in vba and processing all that seems slower or more intesive and a lot of coding just to get a total.

ok ... i will experiment with that, thanks!!

if i go the first option, how do i retrieve the aggregate summations from the query with vba code? i need them to tally with several queries on way to form....

so when i DSUM a query i'm making a query of a query? i just want to total a field in a query, DSUM seemed the easiest way. the queries are already filtered as much as possible i just need the total of a field in it....

this is a complex situation, so bare with me here... we have a project management database, split in 2 (tables live on serve, front end on users pc's). we've decided to link this to the company MYOB info. there are 4 myob company files, we need to tally them ALL. direct linking is slow and...

*grin* i love an academic argument .... yeah i think i fell for loving intellisense too as i hadn't used access in about 10 years when i started again... fortunately i don't call the forms_ argument unless the form is going to be open anyway, still a good point. i must say, i love this place...

got it! thanks for the help, the final baby was Like "*" & [Forms]![frmCivilMinorJobs]![txtCivilJobNumberDisplay] & "*" *looks at mass find and replace regarding your previous comment* cheers :)

huh no joy anyway. very odd.

thats unfortunate.... lol.

i am trying to sort all variations of a job number ie: job 093 has 093-20 093-10 etc if i enter 093* in query criteria it works (as i would think!) but i need it to adapt to whatever job number is current on the fly. i can write a script to get current job number from form...

i suppose that saying i want to have your babies is over the top, but your a legend!!!!! love straight forward answers!!! sorted it right away. i tried to nest a VBA statement there doing something similar, didn't want to work but that did!!! Thanks again!!

ok... i have a database linking to MYOB DATA (actually 3 myob files which will go just great lol...) prob is where trying to rebuild job transactions from raw tables. when you print a job transaction report from myob it list a "debit" and "credit" column for transactions. in reality there is...

actually found some documentation (from myob of all people. last place i looked oddly enough, but hey, who would think to find it there?) not the pretty "relationships" visual diagram i would like but hey beggars cant be choosers can they... myob allows u to link (via ODBC Driver) to its "raw"...

I'm looking for an Object model for the MYOB Tables extracted with the MYOB ODBC Direct Driver. lots of tables here with no relation ships.... looked EVERYWHERE. short of giving MYOB $700 for a full development package...anyone?????

lmao pretty true... turned out renaming the "download" part "mdb" was correct and chrome did ok - i'm lacking the OWC11.DLL (version 1.0) needed anyway. on access 2007 they no longer support that object on install....

haven't used fox much but had to go to IE to get those files (thanks btw!) - still scrubbing the still of IE of me!!!(i feel dirty...)

well i won't try to hold that against them this once... i love my chrome!!!! lol

chrome downloads timeline_a.mdb as timeline_a.download, i swear ;)

doesn't seem to be openable for me, changed the "download" extension to mdb but access not happy with it, keeps saying it wants another dll?