Recent content by smaviddavid

Ah ok, so rather than linking an order to another order, I would link them both to 1 payment. Thanks for the reply, I will upload a copy of it tonight with some sample Data in it.

Hi, I made a post explaining a database, but I have now came to a conclusion on the database structure; If somebody could look and comment on my listed design it'd be great! And feel free to ask for info, I always miss things :banghead: Table Structure Customer Details (Person 1 & Person 2)...

Hi Gemma, Thanks for those ideas, I suppose your right, currently the "main customer" is always the women, so I could add a "sub customer" so to speak. Maybe I am underestimating the power of queries and reports. With this I'm going to go speak with them and get a definitive idea using iput...

Thanks for the speedy reply. I'm glad you could make some sense of my waffle! I'll start with the second part first, we do get repeat work actually! eternity rings, and a new thing is to get a ring with manmade diamonds, and for anniversary's, birthdays buying real diamonds to swap in at a...

Hello, first post in long time here, restarting a project i abandoned. Firstly, my access knowledge is limited, although i taught myself a lot last time, and eager to relearn. My database is for tracking orders for wedding rings, and currently is done using an Access DB. Now its over 7 years...

<---Your messsage :confused: <-- my head! Ok, basically all i done is added a button and given it the save form feature. So if thats the 'elevator door close button' is, then i obviously have been doing it wrong! lol. I'm working on database at the moment. i will upload a new copy later and...

from the local

Hello, I have added a save button to my form, and i was wandering what are the benefits of this? As it seems even if enter data and close the form without saving it seems to still appear? Have i set it up wrong?

Ahh brilliant, cheers!

I am looking into this now, and yes your understanding is correct. Thanks very much for the reply nigel. I have now been given more requests on the databases features.. so i shall be posting alot more! (eek!) ------------ After looking where is this relationship? Do i create it on the tables...

sorry if bumping isnt allowed, but i cant seem to figure out how to sort my problem out on my database. Anybody able to help?

Hello, I have Recently been plodding along with my database and im now hitting more problems! Wohoo!!! This first image is of the tables, setup perfectly how i want them. Now i want to portray this information in forms.. which i have done....... kind of. Red = Error im having, i want the...

Hello, If you havn't guessed my name is David! I'm an amateur Acesser?/Databaser Whatever its called! I'm working on 2 Databases, one of clients and chickens they breed, and one of clients, rings and their orders. & Hoping to release them here for people to use as a resource once i've picked...

Would there be another way of doing this? I'm interested as in my database i have office staff, setters, craftsmen, and reps, and having them in one long list is a bum.

BF3 Graphics may top COD... but COD is still massively popular after 6 releases, and i cant seem to find anybody who i know with Bf3