Search results

OK, so I've got the following categories, 'Computing, Electronics, IT & AVI' 'Computing' 'Laptops' 'Rugged Notebooks' Using Markk's join method I would do the following. I link child category 'Computing' to parent category 'Computing, Electronics, IT & AVI'. Then child category 'Laptops' to...

I'm afraid Mark that this was alittle over my head. The category tree structure we use has upto 4 tiers so I can't just show 2 tier, like parent --> child. I need Category --> Categoy --> category --> Category. Thanks

Hello and thanks for your help. The product will only belong to one category but that category can be a Child (as Mark puts it) to more than one Parent Category. The only issue with marks solution is I'm going to find it hard to figure out how to import the category tree from a Product Data...

So not use Levels at all, just link any category to any other category, would that not get messy when you have thousands of categories? I mean not having them spearated in to levels. Thanks

I won't be ever using 5 Levels but less than 4 is possible. I can't see why less than 4 would be and issue. Thanks

Level 1 = Department Level 2 = Parent Category Level 3 = SubCategory Level 4 = Sub-SubCategory A 4 level category tier is the MAX anyone should go with a category system but it is possible to go further. I woudl use filters after level 4. A level 4 category can be linked to any number of...

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

Thanks for for everything so far Paul you have been a great help. Thanks.

Yes that is true, I was changing things around to get it to work. But I might not need a sub at all.

Is that code for changing all the entries. Thats not what I wanted, sorry. What I was just trying todo is when you open the form and choose a value for the 4 combo boxes that the same values are entered for all the entries in the detail section of the Continuous Form. Not all the existing...

Here it is. The form I need you to look at is VATReturn. Thanks

OK I'll upload it. What version of Access are you using. And I noticed some thing very strange. If I use the form to enter 2 rows of data the combo box entries are not entered. Then I open the form and enter two more rows of data and look at the table again. And the combo box values for the...

OK I did that and it stop the 3061 error but it still does not enter the info into fields. And can I just delete the two setwarnings lines. do I need to enter which column of the combo box is entered.

Is this the code you want or do you want me to upload the full DB. Private Sub OurCompanyID_AfterUpdate() Dim db As DAO.Database, sSQL As String Set db = CurrentDb DoCmd.SetWarnings False sSQL = "UPDATE Invoice SET Col4 = " & Me.OurCompanyID & " ;" db.Execute sSQL DoCmd.SetWarnings True...

It is numeric but I did remember to remove the single quotes. I put my original Tools/Reference back to default. They are Visual Basic Applications Microsoft 12.0 Object Libary OLE Automation Microsoft Office 12.0 Access DB engine Object These are the DAO options not selected. Microsoft DAO...

I was told to make sure that I had the right table and right col and I have. Then to have reference to MS DAO selected in Tools / References in the design mode. What I have selected and I did that but I still get a error: Run-time error '3061': Too Few Parameters. Expected 1. And when I click...

Yes I tried it and it works. Thanks a mill I just have one other issue to solve. I posted a thread about it already but no answer so far that works. Maybe you could help. here the thread link http://www.access-programmers.co.uk/forums/showthread.php?t=125654

the VRate can be different values. Will =Sum([AmountExVAT]*[VRate]) work then. Thanks for the quick reply.

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