Search results

It gets stranger. I have created a temporary form from the RecordSource behind the subform and added a control to calculate GM works on that which works fine. I have removed GM from the list of fields on the subform saved it and then added again but still getting #Error. What is frustraiting...

Hi Bob, This is very strange!! The calculated control used to work but suddenly stopped whilst making some changes to the form although not related to the GM control. I have added the NZ() function to no avail. The GM control comes from the underlying recordsource of the subform and populates...

I have a control on the footer that I refer to on the main form. The calculated control sums a control on the subform. It used to work but as suddenly stopped and all I get is: #Error. The controlSource is a simple =Sum([GM]) Where [GM] is the control on the subform that I am trying to...

Ignore that posting - I have fixed it. A simple error that I really should not have made. Revised cose below. Public Function CommPayment(gm As Double, percent As Double) Dim dblGM As Double Dim dblPercent As Double Dim dblMultiplier As Variant dblGM = gm dblPercent = percent Select Case...

Many thanks for everyone's help. I have now managed to speed up the system by have a temp table that is indexed and changing the underlying query. The running sum works nicely now. However.... (isn't that always the case) I am now trying to vcalculate the commissions payable based on a...

Thanks for putting my posting right Bob. Must learn to read what I write before submitting!! :mad:

You could do this in VBA. (assuming the unbound control is a string. Forms!mainformname!subformname.Form.filter = '"&Forms!mainformname.controlname&"' The subform name needs to be the sub form container and not the actual form. If the control is an integer or date then change the syntax to...

How would I go about putting an index on "account" as it comes form a query that is formed from a linked spreadsheet and not a table?

Applying running totals to a form or query seems to be a difficult area for Access. I am creating a database to show the profit margin and subsequent bonus and commissions for the sales manager. Because of the complex commission rules (commission multiplier changes based on the percentage of...

Hi Bob, That was a super fast response and fixed my problem - Many thanks. Why do I also have problems with Forms/Reports references!!! Dohhhh :-)

I am building a system to show all orders and commission payable for the Sales Team in the company I work. I want to show this as a monthly and year to date figure. I have setup the main form that works ot my likig and have a subform that shows all orders. What I need ot do is have a tab...

I do have a previous version but without the latest mods and backups but have no idea how long it has been corrupted. Will get IT Support to check their backups I guess.

Tested with Access 2003 and got the same error. :-(

I have a database that I need to make some changes to for the users. Users all use an MDE file on another part of the servers and don't have access to the MDB that I use for development. On opening the file I get the attached message about not being able to read the VBA Project contained...

Hi Everyone, I'm trying to create a Cross Tab type of Matrix in Excel. To put this in to context I have a list of license prices but want a matrix (similar to to distance chart that you get in road atlases) with license quantity and price across the horizontal access and and also down the...

I have a spreadsheet with Macros (VBA) and need to save as a Macro Enabled Spreadsheet. The problem I have is that some users save local copies of this spreadsheet in their default format (xlsx rather xlsm) and therefore loose the macros and VB code. This is particularly difficult when my boss...

Thanks everyone. I did it exactly as you said "chergh" but found the solution on www.contextures.com at http://www.contextures.com/xlDataVal07.html#Weekend before you posted. Tim

I want to ensure that users can only enter a working day (Monday to Friday) in a column. I know I'll need a custom validation formula but have not been able to work it out. Any ideas?? Thanks.

Let me know when it is published Brian :)

This sounds an excellent uitlity. Any chance of a sample database being posted. Regrettably the blog that was referred to earlier in this thread has now been removed!!