Search results for query: *

Hello Markros - I have thanks but looking at that makes my head spin. I don't even know which are the variables I need to change. Do I paste it into Access? (passthrough query space)

Thanks for all your help but maybe I'm not making myself clear.... I would like to know whether you can in one passthrough query do a search through the database for all tables containing '_ACNT' in the name and returning the records for all of these tables and at the same time inserting the...

Thanks for the proposals. This is useful. Is there anyway though where you can do a search for all the tables with the naming convention of ***_ACNT at the same time?

Hi there, Not being very techie myself, I am facing a brainteaser and I was hoping someone could help. We have a database with about 20 tables with the names in the following format ***_ACNT The first three letters differ examples E01_ACNT N01_ACNT etc Is it possible to do a pass through...

Thanks a lot Randy! I ended up using a subform which works quite well =:0)

Hi there, I have a form in place whereby the user enters data. I want to insert a field on the form which would be automatically generated and displayed based on a date parameter entered by the user beforehand. If the user enters 01/10/2008 in the 'start date' field then I want the associated...

Thanks a lot fneily! =:o)

Hello everyone, I want to design a form in Access which is to be used for reporting on a database with data spanning over several years. I want to be able to select the from date and to date from a drop down list for the month and the year, select the query from a list and then run it. How do...