Recent content by treva31

If you press ALT+F11 you get to the VBA window. Double click on the form name on the left. In the main window is where you put your macros. Mine code was on this event: Private Sub DESPATCH_VALUE_BeforeUpdate(Cancel As Integer)...

Beautiful, thank you :)

Ah excellent thank you! Can I also change the format of the totals to not show any cents?

Here it is. So if you put the previosuly quoted code in the immediate window and double click a number, it expands and the ones underneath are red. But how do I get the totaled ones in red? ie the first number: $31,663.11

Is there a way to set the format of a Total field in vba? This code sets the format of the underlying field but not the total of it: Forms("Form Name").PivotTable.Activeview.DataAxis.FieldSets(0).Fields(0).DetailBackColor = "Red"

Yes. I know it would have been better to have a separate meterials table, but this is what I have.

I have a pivot table in Access that is based on a query that looks like this: Project Material1 Material2 Material3 1 223 331 423 2 423 234 244 3 855 773 343 I want the materials to go from the columns into the rows of the pivot table so they can be collapsed and expanded and have a total at...

Hi, I have a table like the one attached (simplified from the original). If I make a query based on it, I cannot figuire out how (or if?!) I can get the last two columns to calculate: YearToDate and FullYear The CurrentYear and CurrentPeriod can be stored in a table called CurrentDate...

No I have not resolved the issue. The database is currently around 200mb, which in Microsoft terms is not an unusual amount of bloat from 70mb :p I would agree that deleting the tables, then compacting, then importing into new tables would probably solve the issue but I havent tried it yet.

Yea I have been trying to compact the backend. I just moved all the tables to a new database, 70mb. Did a single import and its at 200mb already!

Sorry I should have mentioned that in the original post. I am using 2003 and .mdb for frontend and backend. Maybe I should change the way it imports? Currently it uses "TransferText" in a Macro (not vba) which refer to saved "Import Specifications".

Unfortunatley that didnt work. There is very little vba, and none in the backend whch is the part that is bloated.

No the files are not that large, 12mb in total. The database at 60mb includes all of the data from them. I cant use linked files as I need multiple simultaneous users on the database.

Hi, I have an Access backend database that has bloated up to over 400mb. When I do the Compact & Repair it makes almost no difference. If I ZIP the database it shrinks down to 32mb. If I import all the tables to a new database it is 70mb. Is there another way I can compact it or avoid it...