Recent content by NRGZ

Think i've managed to work out what the problem was, https://support.microsoft.com/en-us/office/summing-in-reports-ad4e310d-64e9-4699-8d33-b8ae9639fbf4 'Click the Data tab. In the Control Source property box, type the field name or expression for which you want to create the running sum. For...

Copy of database, No due to private company information held within database. Similar thread, I ALWAYS trawl the net with various searches and also look within forums as much as i can before posting for help.

Nope #Error, infact even if i put =sum([Sales_Price_]*[Qty]) it still errors hence why i was looking at VBA route....

I got a basic invoice form that has a 'line total' (in a subform but i'm keep the invoice total in the subform), I want it to total all the 'line totals' I have 'invoice total' in a table to record invoice total but i cant seem to get anything to work, it either errors or just doesnt do anything...

ahhh see always learning something, no i was trying to check for he value 0 so i've changed it accordingly. Lets see how it goes. Thanks.

I tried that but it didnt work. had another look and this seems to work, more testing to be done but looks good, Private Sub VAT() Dim a As Single Dim b As Single Dim c As Single Dim d As Single If Me.VAT_Code = "0" Then Exit Sub ' If IsNull(Me.VAT_Code) Then Exit Sub a = Me.Sales_Price b =...

It now says 'invalid use of NULL' with b = Me.VAT_Percentage (has the yellow arrow pointing at it) locals say that it is '0' so i'm not sure.

no matter how a dice this i cant get it right it just keeps saying 'else wihout if'...... any help appreciated! Private Sub VAT() Dim a As Single Dim b As Single Dim c As Single Dim d As Single a = Me.Sales_Price b = Me.VAT_Percentage d = Me.Qty If IsNull(Me.VAT_Percentage) Then End Else...

Yes that worked. It now shows 3 columns for the dropdown (even though1 would be better....) and now populates the POSTCODE field. Very odd and i changed COLUMN WIDTH back to 'blank' and it formats the columns alot better. just odd solution is all but hey ho! Thanks to EVERYONE who helped. o/

OK, so if i'm in the right place it was 'blank' but i have changed it to 1 (which = 1cm)

Is that in the PROPERTY SHEET for the combo box? if so i cant see an 'unhide' option.

Thats what i'm trying to do, I know that ACCOUNT_CODE is valid but i cant seem to find what its dimension are...?

The COMBO BOX does retrieve its values from excel workbook/s so yes column(0) is the ACCOUNT CODE but although i understand the coding, Private Sub Account_Code_AfterUpdate() Me.Company_Name = Me.Account_Code.Column(1) Me.Postcode = Me.Account_Code.Column(2) End Sub i'd like to see what...

Gasman, That works but i cant seem to get the POSTCODE to show although i'm pretty sure its column 2. Is there anyway to see what my 'variable' account_code contains/returns? Thanks.

Hi, New to the forums and its been a while since i did any Access stuff but for the life of me i cant seem to find a solution , for what i believe is a simple issue. I have an excel workbook that holds the value choice for the drop down box and what i would like it to do is populate 2 other...