Search results

Hello I've being struggling with designing a MS Access Database Schema. It is for a Category Tree with 4 Category Levels. What is making it difficult is that and Category Level can be linked to any Category one level higher. For example; Computing, Electronics, IT & AVI >> Networking >>...

Hi, is it possible to have a Text Box control name based on a other value in a report. Thanks

Hi, In my report I have VAT Amount calculated. =[AmountExVAT]*[VRate] Then when I try to add the SUM of the VAT Amounts Controls I use this =Sum([VATAmount]) But it does not work, Why? Thanks

"You can't assign a value to this Object." this is a message I get when first trying to enter data into a form. But its a little strange. There is the form and the subform. The subform can work all the work all the nessary functions of the form. The main form is only for visual effect and ease...

I have a Undound combo box in the form header. The form is set to a Continuous Form and each continuation of the form needs to store the selected value of the header conbo box. So I put a hidden textbox in the detail section to capture the combo box selected value. And it does but I want this...

Hi, in this forum already I have being given an solution to a problem and it should work but [] brackets keep appearing in the expression. Here is the expression. =Forms![VatSub].[AmountExVAT]*Forms![VatSub].[VATRate].Column(2) But it keeps reverting to this...

In my form I have a combo box that gets in values from a table. 3 columns 1st bound column withs 0cm;5.083cm;0cm But I want to use the 3 colum in a caluation in a text box on the same form. How do I do this. Thanks

Hi, I'm new to ACCESS and I'm trying to build a simple DB app. It jus for calculating VAT and storing the info. First let me explain that it's for Irish VAT and Irish VAT works like this. VAT is payed for in 6 instalments, in bimontly format. Jan - Feb, Mar - Apr, May - Jun, Jul - Aug, Sep -...