Recent content by Blitzer

Yes, thanks for the link. I have read that a few times over, but to be perfectly honest, most of it is going over my head. :(

Thanks very much for your help. I had actually already used sub-forms in such a way and have actually taken a big step back to the basics after having read the various comments about look-ups at table level. So, just to re-cap. Although I have a field in my tbl_Products that is a effectively a...

Sorry - try again with the attachment. This is my first time trying to post one - please be patient! :o

The purpose of my message was to determine how avoid creating look-ups at table level rather than dealing with the actual Customer to Product relationships. That is to say - avoid the look-ups that Access 2007 would create for you, the ones where rather than storing a reference to a record in...

Having spent several months of trying to learn how to use Access 2007 I felt like I had been kicked in the teeth when I read that the general opinion is that using look-ups at table level is frowned upon. However, depite getting the reasons for not having these look-up at table level do make...

Well I have now managed to replicate an example of cascading combo boxes, which I'm hoping will help me with trying to do the same in my actual database where I need to be working with the data being held in various tables and bringing that data together to create a new record for a new purpose...

Ok, I must be completely stupid. I have looked at numerous samples of cascading combo boxes that all seem to do what I require,but no matter how hard I try I can't get my own to work. Am I so stupid that I can't use this wonderfully powerful piece of software to perform this simplest of tasks? I...

I don't know how to do things with previous versions either lol, :rolleyes: but I know what you mean so I'll take a loko at that and see if I can't suss it out. Thanks for the heads up. At least I feel I'm looking in the right areas now for the answer. :)

Thanks for the link, I found a very easy to follow video on there that seemed to do exactly waht I was after. Or so I thought, as when I tried to replicate the method in the video I found that because I'm using Access 2007 that I don't have the same options in the Query builder making it...

Seems to me I was a bit niave when I puchased Access and did not fully realise just how involved it was going to be! :eek: I think one of the major problems for a newbie to Access is knowing the "technical" terms for the objectives they are setting out to achieve. It can be very difficult...

Hi, My first post the forum and I have to say I'm very new to Access and relational databases, so please be gentle with me. I bought a dirty great book on Access, have searched the Access help and looked at various forums on the internet to try and find the answer to what I'm sure is a very...