Search results

Nobody? I'm sure that there are experts in here whom know how to tackle this one. So please give me advise. Thanks, Lord Byron

I'm facing a problem with an Access application I built. The Access application is linked to a third party financial software (the supplier gave permission to figure out the purpose of all its underlying tables). When I developped my tool, the main data was stored in a single table on its SQL...

Hellfire, I would go with the solution FloBob proposed. If you use a seperate pop-up form to enter the name of the courier company, and you link the dropdown to this table (or possibly a select query on this table to get the result alphabetically). The third problem could be solved in a...

I would try to solve this by using 3 queries to count the results. This way, each of those 3 queries would go over their own field. But a more elegant solution for this might be the use of subforms. With this, you could use different tables for each question since there can be multiple answers...

The_Doc_Man: The survey databases do not use an autonumber field, I already thought of the possible problems with that ;) The survey consists out of 2 parts. They have to fill in a part for the site itself. This should only be done once, and therefore I have designed the form so that they can...

cogent1: I have a small question. To automate this, would I have to use these commands for every single database, or is there some kind of a loop that I could use to go through a whole list of files (preferrably also looking in subdirectories)? This offcourse providing that I already use a...

The_Doc_Man: I want to receive the submissions as a .mdb file per email. One of the major problems is that those 150 sites are actually located in 150 different countries. So not all of these are located in Europe or Northern America. Most of them are located in Asia and Africa. Another problem...

And how would I set up these append queries to take data from the donor databases? Would this have to be done donor-database per donor-database, or is this automatically for all the donor-databases? The table names and datatypes are exactly alike. Thanks

Dear All, I have created a survey in Access 97. This survey needs to be filled in by different users(over 1000) in different locations (150 locations). The problem is that I need to consolidate all that information in 1 database. Is there a way to automatically import the data from those...