Search results

Hello again all, I have not had any internet access for quite some time now, so this project has been put on the back burner, but now I am getting "pressure" from the powers that be to get it completed. I really appreciate all the input from both Guus and cplmckenzie, but I am yet again...

Hi cpl, I just posted a reply and for some reason the forum logged me out, oh well... haha. I have had a quick browse through the amended DB, all looks pretty good to me. There are a few points I picked up on, that I presume are partly down to the only semi-altered things you have changed on...

Hi all, Apologies as I have not had access to a computer for the past almost a week and have only just managed to get access now. I will have a look at the suggestions/changes made and will post my findings later. Thank you all again for all your help I genuinely do appreciate it all. Thanks...

maybe i should stick to design in the future, haha. i think i get the relationship diagram, but not 100% with it, how would the new table (tb;_Contact_job) be populated? Have you altered my database with the noted changes that you could post here? if not don't worry I am sure I will get there lol.

I only see 1 image that you posted? Ok I will try to explain the "lead passenger" entity a little better. Basically when a job is booked a person from company X calls up. This is the CLIENT and CONTACT elements. During the booking they give the name of the lead passenger for the job. Each job...

Hi cplmckenzie, Finally got my head around the diagram you sent, was trying to view it on a phone initially and was hard to read so I got confused. Yes that is basically what I need it to do. Although a separate form for CONTACTS is not necessarily needed as long as you could add CONTACTS for...

thankyou so much, thanks for the compliemtns on the design, as I said to guus2005, design is more my forte than programming, but I am always looking to further my skills, so here we are with me building a database for my father's company. si

cplmckenzie or guus2005, have either of you gotten anywhere at all, no pressure intended by this message, I am just completely stuck and just want to keep the topic alive, hope you both don't mind. thank you to all for the help, i really do appreciate it

I would be happy to dive into the world of VBA coding, I have done a tiny bit in the past during my degree, had to build a very simple game using vba, but thats hidden somewhere in the depths of my memory. If I can achieve the same or better functionality with VBA (which i suspect I can), then...

Hi cplmckenzie, Nope I still haven't resolved. Guus2005 is still looking into it, but I would still appreciate any assistance you can provide. Cheers Simon

Cheers Guus, Really appreciate the help

Hi Guus, I have had a look at the changes you made now and as I suspected I do have some questions... so sorry to be a pain. If you can't answer any or I am asking too much then please just say. Questions... Location Table The way you have set it, would it allow an adhoc address (ones not in...

Hi Guus, Thanks for the works you've done and thanks for the compliment regarding the design (to be honest that is more my area). I will have a proper look at what you've added/changed etc.. I'm sure I will have questions... but thanks for now, i really appreciate it. Si

does anybody have any ideas with this one? as regards the original problem... also if someone can talk me through saving the DB as an access 2003 version so more people can have a look at it I would really appreciate it. Thank you so much for all your help so far. Cheers Si

Any luck with that Guus? I had another look at trying to save as a 2003 database vsinut really couldn't figure that one out. Cheers

Thanks Guus, I will await your expert input. Cheers Simon

I just tried to save it as a 2003 version, but it says that it can't as there are features I have used that are unsupported in access 2003. so hopefully someone with 2010 or 2007 can help, or if someone can point out how to override this error with saving as 2003 i will happily post a 2003...

ok db attached now, finally figured that one out. hope someone can help. cheers again

ok it appears you can't PM on this forum either, if you are able to message me or whatever, I will reply or give me your email and I will post you the link to my dropbox. Cheers Simon

Hi Guus, I cannot post links as I have not made enough posts on the forum yet. Will try to send it in a PM. I have not added the new table(s) as discussed as I wasn't sure how the links would need to work. I hope you can assist. Cheers