Search results

no idea where to post this, so it goes here! I'm about to link our database to myob which i have only tried on the sample myob database. now we have MYOB Account Right (premiere version). i don't want to be a drain on the myob package (many say it can be) and for us a daily update is more than...

lol figured it out is lovely - i more candidly like to say "making it up as i go along" (i'm pretty good at that but still..) thanks!!!

using a different data type for variable maybe???i'm guessing...

lol fair questions!! the table is in currency as are the fields on the subform. this is like a simple accounting system table to track expenditure variations. we have a ValueSubmitted Field with these numbers: 8950.00 4160.00 82560.00 43000.00 15950.00 -2686.40 the whole thing is processed by...

any one tell me why (and how to stop!!!) dsum from rounding up or down for currency?? seems like a silly thing to do...

me 4!!! and been searching heaps, all solutions seem to involve spending cash :)

ok.... i have a situation where i am putting together a project database for work. last version i compiled the front AND back end, seemed to help make things faster. now we're onto next version and i need to add more tables. still have the uncompiled version to edit and recompile but the data...

been looking for a 12month 'timeline' control...seems to be what i want, can't seem to find them anywhere...anyone ever heard of one?

i need to track employee days of and RDO's (rostered days off). i want to track this visually. now the calendar control has potential. HOWEVER... need to be able to mark more than one day per month, need to make the days marked different colors...is there a way to do this(i don't think there is)...

thanks - seems to work on sample file!

ok this is a little confusing - the latest version of myob is called AccountRight19 though really myob lol. pretty much a marketing thing far as i can tell. myob produces and supplies its own ODBC driver but can't find documentation for it - if u buy expanded dev pack it should come but doubt i...

linking accountright19 (latest myob version) and access 2007 - in READ ONLY CAPACITY ONLY. just want to run some tests on sample databases to see if it will work for us and all that before we commit to dev - SURELY there is some help file, documentation for syntax etc... is it all sql based, do...

where the heck is it????? dead set all i want is the syntax and some examples so i can see what the learning curve is on it.... where the heck can i find this documentations? google has never failed me so badly....LOL.

OMG i think the syntax was subtly stuffed. so stupid...almost embarrased to mention it lol. however format works in print preview only...is there an event to format before print preview? i can just jump user to there anyway...

ok i'll be more verbose - i tried to keep it simple lol. somehow it never is... i have a project management database. over 100 projects in it. the main form loads relevant details from table for half the fields but rest are unbound controls. they calculate and load data from a range of queries...

this is so frustrating works for 1 record report only...

lol ok idea but only works for first record in report anyway....

lot of vba processing form many unbound controls, better to just be able to do it all from code... not sure all my dsum()s and such will fit there ;)

to make it simple if i have a report with an unbound control where the heck do i put this: Report_rptCivilJobs.txtCivilJobNumberDisplay.Value = "001" normally would go in form_current but need it to process for each detail in report (assume "001" would be some code generating that number) i've...

lol not really.... i had the subform by just dragging it onto form. i opened query and added lineID even though not the linked field. then went to subform, deleted the offending fieild in subform and ADDED MANUALLY the lineID AND BillByType, it work.... made line ID col width 0.... got on with...