Recent content by welbot

Thanks for the sample Mihail. Although it's not exactly what I was looking for, your example did give me some ideas on implementing the search side of things :) That will come in very handy! I'd upload what I've done with mine so far, but everytime I try to save it as a 2k3 file, it just...

Hi, Thanks for your pointers. I actually ended up getting my original plan working. Your links lead me on to some interesting reading, which revealed to me, the fact that columns start at 0 (which I already knew), but that bound columns start with 1! This was causing me a lot of confusion I...

I zipped up the database in 2k3 format, but it looks like it destroyed my form. After the conversion it only has the tables for some reason. Still, if it helps it helps. http://users.tpg.com.au/welbot/DNF_2k3.zip

That's right. It's basically to help me organize everything :) I think I figured out why the form wasn't doing what I expected too. It seems that the properties section on the side wasn't updating when I selected different objects in the form, so I must have put a rowsource statement in over...

Thanks for the reply AccessBlaster. I did a little re-designing last night and after thinking about implementing the fourth table, I decided against it, so now I have a tbl_brands, tbl_models and tbl_laptops. I managed to get the combo boxes to filter as well (so you pick a brand, and only...

Thanks for your reply. I hope this doesn't sound rude or arrogant, but I'd like to learn how to make it myself. I'm well versed in computer usage, and have done coding in the past, so I'm really looking for pointers on what steps I should take, rather than exactly how to do it. (I'm more likely...

HI, I'm fairly new to access I guess. Done a little in the past, but a long time ago. I'm trying to make a database for one of my workplaces, to help keep track of laptop parts. We have a pile of laptops that we use as spare parts, and I want to record their brand, model, location on shelves...

Hi there, I'm working on a small database for my girlfriend and I to use for tracking some products for a home business. We are the only two who will use it. I've created the database in Access 2000 on windows XP pro with sp2. Everything works great in the database. Problem is...

MWAH!!!!! <<<< That's me kissin your ass Ruralguy!!!! hawt stuff baby!!! I was beginning to give up hope! /me is a fan for life! I'll be back to give help where I can :) :) :)

ok! here's the notinlist code for the subsubcategory box Private Sub Sub_Sub_Category_NotInList(NewSubSubCategory As String, Response As Integer) 'Suppress the default error message. Response = acDataErrContinue ' Prompt user to verify if they wish to add a new value. If MsgBox("The Sub Sub...

Thanks for your reply. I got it working fine, although with slightly different code, but now I'm having a problem with the SubSubCategory Box. I can add new records (by entering them in the combobox), and they do appear in the drop down list, but it wont let me select the new additions. I click...

Check above post.. I thought editing my last post would bump it :\

Update... I got the heirarchy working fine! Turns out I wasn't storing the foreign key for the sub category... But, this has come full circle again. I am now trying to get the combo boxes to accept input for new records in their appropriate tables. Inserting a record in to the Categories table...

Hi there! I'm learning how to make a database for use in keeping track of some products. Extremely simple I should think. Just simple stuff for home. I want a form/web page (working with form for now) with a 3 combo boxes.. maybe more, but 3 for now... Category Sub Category Sub Sub...