Thanks Mary,
Based on your info I started again and have decided to teach users how to use Filters. I now have a working form....
Chris Larmer
Last Activity: Feb 19 '07, 10:48 AM
Joined: Jan 5 '07
Location:
-
Thanks for your reply. The database has extensive code used to append data each week to set tables which it first deletes all old data.
When the database is closed it compacts to 170,000kb in size even though the tables are now full.
However when it is running the database expands to just under 2GB. One of the first steps it does is a do loop where it reads a table which gives a start and end date for the flight. ...Leave a comment:
-
Thanks,
I tried that but it did not work. I'm downloading my backup copy and hoping that I can import the tables into the restored database. Do you know how I can find out the size of the various sections of the database are? In particular tables, code and queries. I'm looking at spliting the database into 2 code and queries in one and data in the other and want to see what improvement I get.
Chris...Leave a comment:
-
Can't compact my 2GB database Invalid Argument
Hi,
My XP database has exceeded 2GB when running and gives the error "Invalid Argument"
I've tried deleting tables then tried to compact and repair the database but it will not do it. Any suggestions as I need it to work tomorrow.
Thanks for the help
Chris -
I tried your format but while my code has changed the query correctly the subforms are not refreshing with the new query.
Is there a better way?
What I have is a main table and the query selectes a subset of the table based on date.
This query is what is used by the subform to list the data.
Then the users refine that subset, by selecting an individual flight and passenger class from separate combo boxes in the...Leave a comment:
-
How can I refresh a sub form
I have two subforms in my main form.
In the main form I want the user to select a customer, class, and date range.
The 2 subforms are similar. One is the history records in the recent past and the other is future records. The user has to input a passenger forecast for the customer for the selected class for each record in the date range.
The subforms are populated by a query which is altered according to their selection.... -
Thanks very much This works. Will definately use this in future....Leave a comment:
-
The eqation I am trying to use is a simple forecasting formula. Once this works I hope to make it as complex as is needed.
There are 4 fields
A - last weeks average pax (calculated separately in a similar function which works)
B - Last years pax on the same day eg monday
C - Last week's pax on the same day eg monday
D - Last fortnight's pax on the same day eg monday.
The formula is
...Leave a comment:
-
Access 97 FileShare Lock Count exceeded
I am getting the above message when trying to update 2 fields in a table with 41,000 records. I am using visual Basic to update the records as the IIF statement was too complex for a query. Here is the function I am using.
Any suggestions on how I can get Access to work. I can't touch the registry.
...Code:Dim rsMealMaster As Recordset Dim Wkcount As Double Dim restCount As Double Dim bReturn As Boolean
No activity results to display
Leave a comment: