Recent content by smokingmirror

Thanks Mark, but what I'm trying to do is understand the process behind relationships and linked tables so I can replicate this kind of database in the future. I've been working from a very old database written before I started with this company, which was - I believe - itself based on...

Doh! It's always the obvious basics you learn at the start that get overlooked when you are working on more complex databases! Thanks, Len.

Hi Len, Thankyou very much. I've had a look at your demo and now understand the problems I was encountering (well, enough to proceed on my own for a whiel longer yet!). I think part of my problem was that I didn't have a proper query to define certain fields; that and my relationships were...

Hi Len, And thank you for taking a look at it for me... ...unfortunately, I'm still not sure I see what you mean. I've had a look at your two new forms, and I understand that the new subform Calls is embedded into the new form Contacts. But what I'm trying to achieve is having two buttons...

Thanks again. I'm actually beginning to think that my problems with this new database (which, with the exception of the separate call loggers works perfectly), stem from the fact that I'm trying to log everything from both forms to the same table. I've noticed that if I use the SALES button...

Thanks Len, your help really is appreciated. I'm going to take a look at the database relations and see if I can use it to resolve my current problem (see my last post). If you get time, could you take a look at the newer database, since it's 99% of the way to what I need. I'm just having...

Hi Len, I've made some headway (I think!) with this subforming business, but really need some help just to identify the last place I'm going wrong. Firstly, I've ditched the old database (which was only a brief example I was working on) and am now trying to replicate the unqiue records of an...

Um...Len, I don't actually see any changes in your attached database. The tables look exactly the same as in the original one I posted!

I'm sorry, Len, but I'm not sure I quite follow you. I'm reasonably comfortable at writing basic databases, but Master/Child linking business is not something I've seen before. I've included a copy of the database that I'm trying to get it to work on (which includes my rather poor attampt at...

Try this link for an excellent way to solve the Shift bypass key problem. For versatile protection of command buttons (which you can then link to forms), try this link. I use both of these in my own database, and - acting as a regular user - haven't found a way to crack them yet.

Firstly, my thanks to everyone who is going to be able to help with my problem, and also my apologies if this thread isn't in the right forum. Ok, I am trying to construct a database at the moment for a small business. The database holds a number of customer records, and all of the basic...