Search results

07 Runtime & "Execution of this application has stopped due to a run-time error." Well, i've spent some time trying to figure this one out with error handling and removing references and stuff but... I'm using the Access07 Runtime (SP2) and on some computers everything works just fine, however...

thanks OldSoftBoss!!!

SOLVED! thanks!!!:D:D:D:D Although, I think it only required me to do this after the ON...:confused: Ehh... Problem solved! Thanks again!:D:D:D:D

okay, let me try it... i'll be right back (thanks in advance) i'm assuming i should do this for everything... right???

For some reason it fails... I think i'm just not in the zone to see what I'm doing wrong.... INSERT INTO [shipped_items] ([ID], [item_id], [shipment_id], [item_weight], [entry_date], [exit_date], [by_user], [customer_id]) SELECT [shipping_items.ID], [shipping_items.item_id]...

You could set up the return values in the function declaration if you wanted to... I'll test the speed when I get some time for sure...:eek: If you get a chance to test it yourself please let me know how it turns out. For now I just like the simplicity of it...:D Thanks for the info!

I wrote this quick function (Alookup) which works just like Dlookup except it can return as many field values as you give it. Function Alookup(Exprs As String, Domain As String, Criteria As String) As Variant An example of how to use this function would be... Dim AlookupRet As Variant...

I made a modification to your code. Just letting you know so you can check it out for approval...

Here's a modified version of CyberLynx code. I modified it because my reports were not showing correct data (showing data from the previous query). This will create a unique query every time. What you want to do here is create a report that will show every possible record you want to be able to...