Search results

To Frothingslosh & spikepl, thanks for your replies & link. I've done some further investigations & reading up on the Round function & all now works - thanks again for your help :)

Hi Frothingsosh, thanks for your reply, I'll have a check. I think all the fields are set to currency so would I need to change this to general number or fixed with 2 decimal places? Apologies if this is really obvious! Thanks.

Thanks for your reply spikepl, I have a summary report which totals different types of order & also one which details all the individual transactions. The transactions all appear correct, just some of the subtotals in the summary report are a penny out. Thanks

Hi, I wonder if anyone can help please. I have a report in Access 2000 with footer sums which has been working fine but is now out by a penny either up or down depending if it's a negative figure or positive. It looks like it might be trying to round up and down. Please can anyone shed any light...

Wayne, Apologies for the late reply, I've been off work due to a bereavement. Many thanks for the code, I'll try it.

Apologies for not being clear. The [CustDetails] table is in one database and I have a seperate database in which I have linked the [CustDetails] table. The seperate database has a form which users use to input certain information that updates the original database via a macro. The Customer...

Hi All, Hope someone can help. I have a database with a form where a user inputs a customer number to update another database. What I want to do is put some validation on the customer number field where it checks if that customer number exists in the other database. If it doesn't I want a...

Hi Bob, The code was on the On Current event of the subform. I've changed my code to If Len(Me.ToBeDraftDte & vbNullString) = 0 Then and it works just how I was wanting. Thank you so much for your help.

Hi all, Hope someone can help. I am trying to write some code so that when a user goes into a subform only certain choices in a combo box, in that subform, display depending on whether another field in that subform has been populated. I searched the forum & found this...

Thanks John Big Booty, I'l give it a go.

Hi, Thanks for the swift responses. Dairy Farmer, I tried your code but it keeps saying Access can't find the field strCategoryName. I've also tried using cboCategories.Column(1) but it comes up with the same message Option Compare Database Private Sub cboCategories_AfterUpdate()...

Hi All, I wonder if anyone can help. I've managed, with the the help of searching this site & Google, to set up 2 cascading combo boxes on a subform. The subform is now on my main form linked by customer id & is working. The 1st combo box is called cboCategory, the 2nd is cboProducts and I've...

Many thanks John, it works using [Forms]![MainFormName]![SubFormName]![ClinetID] Thanks again for your help.

Hi, can anyone help with this: I have 2 tables, customer and contact. There is only 1 record per customer in the customer table but many entries in the contact table for the same customer. I have created a main customer form with a subform for that customer's contacts. This works fine &...

Hi, thanks for the advice. I think the problem may be that I have a table, Diary with a field called Diary Entry. This is formatted to memo as users may need to input more than 50 characters. There is another table, Payments with fields called Payment Reason and Payment Amount. I've changed the...

Hi, I've tried changing the format property of the table field and the subform field to currency & decimal to auto but it still doesn't show the decimals if they are zero. Any other ideas?

Hi all, I wonder if anyone can help. I have an update query that updates a diary table with the payment reason concatenated with the payment amount. It works fine but if the payment amount is no pence ie. £5.00, it just shows £5. If the payment amount is £5.52, it shows £5.52. I want to get...

Thanks for all yor replies. ChrisO, thanks for your response. cat is a column in the [all trans] table & pay is the text input into that field (among other text values). I tried using =DSum("amt","[all trans]","cat = 'pay' ") but it still shows on the form as error. I think I may cut my...

Hi, I want to do some calculated fields in a main form to show the total payments, adjustments and outstanding balance. The main form data comes from my customers table and the payments and payment types come from a seperate transactions table. I thought this would be simple but I'm finding it's...

Many thanks David, that works a treat!