Search results

Are you trapping any errors or anything? That may be causing it to be slow and inresponsive, it's probably better to sort the errors out if you are just using something like on error resume next, if you're not using VBA then just ignore this post.

I referenced the Microsoft DAO 3.6 Object Library, now upon running the code I get an Invalid use of property error on 'RS =' Thanks for the help so far by the way, very grateful :)

Another possibilty is the way that you're comparing 'spec', both machine's may have 512mb of RAM and a 1.5gh processor but they may have different latencies, technologies etc. Are they the same brand hardware etc?

Thanks I think this looks promising, if this works I'll forget DSum all together :P, do I need to set references at all?

Have you compared the memory usage in task manager for each machine?

Hi there, I have this code in my form_dirty event, Price.Value = DSum("[Price Each] * [Quantity]", "[Products]", "[OrderID] = " & Form_Orders.OrderID.Value) Basically I want this to look in the table 'Products' for any value that has the same 'OrderID' as the current 'OrderID' on the form and...

Hi there, I quickly made a database, and for some reason, can't get past this 'cancelled' error, to get it to occur, open the Companies form, click orders and then it pops up. By deleting all of the data in my tables, I can get to a state where I can once again enter data, but after closing the...

Hi there, new to the forum but hopefully I'll become an active member quite soon :). Basically I have 2 comboboxes, Size and Part_No, I get the dreaded 2115 error while calling this event, the error claims that my beforeupdate property or validationrule property prohibit me from doing this, am...