Search results

You could always add info on the query in the properties/description box from the query.

I use round in an sql in access, it looks like this ROUND([WORK_LEDGER]![SUM]*[DIST_KEYS]![PERCENT];2)

Thats what i meant :). Sorry still new to vb and all. Dont like it that the path is hard coded in my program. Thanks nateobot

problem solved using DAO now instead of ADO. seems that the odbc driver was giving me ttroubles

I'm doing something like this, not completly the same tho. I have on my main form a field called Total Percentage. My subform contains all kinds of records with a percentage. If you add or delete a record in the subform it recalculate the total percentage in the main form this is what i have in...

Hi all, I the below code example how do i need to program it so i dont need to hard code the path to the data source? I have the data source defined in my administrator tools but i dont know how i need to do it so i can point only to cost_accounting.mdb in vba. Thanks ' connect to the...

Hi all, I wrote a vba program which I couldnt get to work correctly, so I redid the whole thing in java and now I get the output I'm supposed to get. I'm wondering now if I can execute this java program from a button on my forum in access? and how should I do this if this is possible? Thanks

I posted my problem in another thread before i saw this one ;). When i read this one it sounded like the same problem i have, when running the code from my command button it is not doing what i want, if i step thru it with the debugger i get sometimes the records inserted that i need and other...

Can you tell me what you did, i think im also an idiot ;) since im having the same problem. Stepping thru the program seems to work but executing it from the form doesnt work thanks

Hi all, I'm new to vba and have a problem in an application I wrote. It seems that the requery is not working. I'm working with 3 resultsets. The first one contains all the records that from the original final that needs to be processed. The second one contains the distribution keys that needs...