Search results

  1. J

    Running Sums within a Query

    Hi there, I'm trying to create a running totals or cumulative totals query based on the following sample query in Access 2000. I'm trying to use a Dsum function based on a query not really getting the answer I'm wanting which is shown in the column Cumulative QRY_DealsSummary is the query...
  2. J

    Create New Back End table

    Hi there, Please help, I've trawled this site and others in an attempt to find some code to create a table in my database without success. The database is already split and therefore needs to be created in the back end and would happen when the user logs in for the first time to the front end...
  3. J

    Union Query & List Box help

    Hi there, I'm new to Union queries and this forum has been very useful in providing solutions up to now but I've hit a dead end having tried to search through the forum without posting a thread. Here goes..... I have built a union query based on two tables to link common fields as below to...
  4. J

    Activex component can't create object - Windows XP

    Hi there, I've recently changed from Windows 2000 to a Windows XP build and although my version of MS Access is 2000 still I've had a problem with some code since the move. The code originally attachs a database within an email and then sends it to a mailbox. It fails at the code in red...
Back
Top Bottom