It sounds like one of those dreaded Windows memory leak errors. I don't know where the log file is, but I'm sure it wouldn't help you (or anyone) that much.
Does it happen often? Does it only happen with a certain MDB file(s)?
It could be that your database (MDB file) is corrupt or that you need...
The query that you say looks OK, try to make that a 'Make Table' query and then export the resulting table to CSV. Perhaps not the best solution, but that's all I have time for right now :-)
Yes it does exist.<br>Queries have a property called Top Values. You just need to sort the data appropriately. So in your case sort the data by Date - descending. Read the help file as well, as there are issues when more than one value are equal.
Using the example above, but on a report...<br><br>It seems that you have to create 3 controls on the report with the field from table/query as the control source. e.g. <br><br><FONT FACE=monospace>=[Retail Revenue]<br>=[Concession Revenue]</font><br><br>The 'sum' control then needs to reference...
<FONT FACE=monospace> docmd.setwarnings false<br><br>[...run queries etc...]<br><br>docmd.setwarnings true </font><br><br>(last line is to turn warnings back on again. If you don't do this, access wont warn you when you run Update, Append and Delete queries - even if you are running them manually)
Create a new (blank) mdb file<br>Import the report (File, Import) from your 'current' mdb<br>If the report depends on tables or queries that are not in the 'another' mdb you need to Import those as well.<br>Copy the mdb to floppy<br>On the 'different location' machine open the 'another' mdb and...
Here is one possible solution (haven't tested it, but give it a go):<br><br>Add 2 columns to the table where you ID is, 1 for the date and 1 for the number. To generate the next number you need to get the Maximum of the number for the date in question, then add 1 to the...
Yeah this is a really annoying feature of Access. Whenever you define a field as number, it automatically puts a default value of 0 (zero). Go to the design of the table and remove the default value for the field in question.
Assumptions: The field in the DB for the yes column is named 'Yes'<br><br>Add 2 'blank' check boxes on your report.<br><br>In the properties for checkbox 'Yes' make 'Visible' False.<br><br>Place 1 'blank' checkbox under the 'Yes' column. In it's properties make it's 'Control Source'...
I'm not sure if I understand you correctly but ...<br><br>Try adding a field to each of the 3 tables to hold the year. I.e. The table that holds 1999 data gets a field with the value 1999 in it, etc. Then you just union the 3 tables to get your master table.<br><br>The master table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.