Recent content by Akrogh

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...

May I suggest adding a proper subject if you want people to help you. I don't know the answer to your question, sorry.

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.&nbsp;&nbsp;You just need to sort the data appropriately. So in your case sort the data by Date - descending.&nbsp;&nbsp;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.&nbsp;&nbsp;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.&nbsp;&nbsp;Whenever you define a field as number, it automatically puts a default value of 0 (zero).&nbsp;&nbsp;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'...

With what?

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.&nbsp;&nbsp;Then you just union the 3 tables to get your master table.<br><br>The master table...