Search results

Don't split the table just filter out the records. Simon

Rather than split the file, you would be better to change your approach. Try having your query to filter out the Shipped transactions and another to show the history i.e. has been shipped. If you index the Shipped field it will probably improcve performance. I did once try splitting as file...

Here is an example, GetWebPath is a stored path, the Exhibition is on the Form: Function Web_ExhibitionsOriginals() With CodeContextObject Dim WebLink As String WebLink = GetWebPath & "Originals_Exhibitions.aspx?Exhibition=" & .[Exhibition] & "&OE=1" & ""...

The simplest method is to a Financial Week table I have also seen a Date based method and then update each record with the Week No and/or Year No. Probably not the most technical but the easiest method to encompass Financial reporting. Simon

The Path should be common that should be set-up once. Providing the Image is named as the ProductID you can reference that image by combining the common path and the imageID and file type. If you want images in one directory for a supplier then you can set-up the directory on the supplier and...

You could try putting the excel spreadsheet functionality into Access? Simon

Because the Review can be filtered in a variety ways I do this: Function SchemesReview_Entry() With CodeContextObject If IsNull(.[Pig Scheme Number]) Then Exit Function Else DoCmd.OpenForm "Pig Schemes Entry", acNormal, "", GetFilter, acFormEdit...

You can also create a "Financial" Period Calendar and store the Period into the record. Simon

Access 2007 + can handle native formats - jpg images can withstand a get deal of compression - lossy yes - noticeable hardly. Referencing an image is pretty straight forward even with 25000 + jpg images. Simon

This not being PC but when you think about it these are all individuals but it is there relationship to each other that is relevant. So you could create a Junction table with Person ID, RType and RPerson ID. This could work both ways treating the partners equally within the structure - saves...

I use a Dialogue Box and then build the Criteria depending if any of the Search Feilds are used. The Last Scheme uses any of the above Criteria to qualify the number of Schemes. Simon

Well then if you put in the criteria <> Event (and excluding In-House Events) on screen have the query as u do in descending order and then SELECT TOP 1 should pull the first (previous) Event. It is just a matter of constructing the SQL query to met your needs. If may not work the firdt time...

But u r associating an event with a client? Got most of the second bit r u just showing the previous event? simon

That no problem - processing multiple transactions is not unusual. All it needs is with each record have a dropdown of Events. I not asking you to rebuild - but providing a single mechanism to distinguish between current and past Events. Personally, but putting the Clients Events is date...

Functions are fine but running consecutively will be slow. I have a Menu so I can fire off a Docmd.OpenForm with a filter to test whether or not the ImageFlag is set and the Invoice field is blank. 3,000 records isn't that bad but if it is a problem SELECT TOP 100 and do it in batches although...

There are two ways to do this - top down or bottom up: Client and subform with Events. The Events are one the many side. OR Event Entry linked to the Client on the one side I'm not suggesting that have separate tables just emulate Cost_Category with different values. Simon

Trying building Relationships in your database to graphically help your data structure. It can be iIlluminating. Simon

Firstly - multiple forms using the same field with a Where or filter Statement simplied code but the [dot] reprsents the current object (whatever Form is being used) Dim Client_Event as Long (assumption it is a Long Integer) With CodeContextObject Client_Event =...

You can use one file providing you have a flag NewData. I need to add additional information to ETL data and clear this down once the process has finished. There are three updates from this data - 300,000 p.a. records are used to create KPI information that can be summarised to about 30,000...

What you can't take away from Access is the remediation that Access can perform. There are so many corporate solutions - NHS Spine was promoted as a all "singing and all dancing solution". Billions of pounds later it was essentially scrapped. SQL Server is basically a high performance...