Recent content by dawhyte

Many thanks for the valuable responses. I`ve resolved my problem using a parameter query and some VBA

I see, the recordset will obviously grow over time and I`d rather use the most efficient code now rather than having to change it later. Should I stick with using parameter queries in VBA then ? Or is there a better alternative ?

Thanks for the help. I ended up using the DSum function. This seems more efficient code wise than using parameter queries. Thanks again.

I am trying to get a parameter query working so I can gather field data using VBA. I have a query (Qry_TotalOrderPrice) that uses one table and is as follows: Field1=Order_ID Criteria=[Forms]![Frm_Orders]![Order_ID] (form reference is valid) Field2=Total of two fields using the SUM function...

I am trying to perform a kinda copy and paste routine with the new file having a prefix at the end i.e after copying file copy1.txt, you can create copy2.txt, copy3.txt etc whilst keeping the original file. I know there is a way to do this, I just can't find the solution at the moment. Any...

Thanks, much appreciated.

I`m just wondering what kind of screen resolution in general should be used when developing databases. I am developing an access database using screen resolution of 1024x768. Should I be considering something like 800x600 (so a variety of users can see the forms correctly) Any help...