Recent content by mond007

Thanks to all, I understand the differences you have stated access vs Excel. Got it!. flat-file is not the correct thought pattern for access. The problem is that i work in a world where Excel is dominant/overused and has a culture of being the accepted solution to everything and myself...

Hi Ok, having heard all the compelling ways forward which I whole heartedly appreciate. I think I have to add some flesh to my original question as posted. I agree with the split DB as mentioned and Autonumber scenarios. Also the no of columns will not change, nor will the "contents" of the...

Hi I have been tasked to design and maintain a database of car information. I in simple reduced form have the following dataset : Imported Country DataTxt Field 1 Imported Static DataTxt Field 2 Imported Static DataTxt Field 3 … Imported Static DataTxt Field 15 Autonumber Common Enterable...

HI, Appolgies for the late reply but I had posted this subject in another forums and managed to get quite far in the Dev. utteraccess.com and search for "Primary-Key-Custom Autonumber" or search for post for user : mond007 (not allowed to insert a link at th emoment). Thanks I will however...

Hi All, Apologies if this has been covered as I have looked and read quite a few threads. I am trying to create the following table. Request Reference Autonumber i.e. OVR1001, OVR1002, OVR1003 (Unique) etc. Requester (text) Dept Code (e.g. PT-1000, PT-2000 … to … PT-9000) (Read only)...

Hi having the read all the above and the pitfalls of fixed price quotations I was wondering if anybody would care to comment on how much a typical project such as the following might be costed at ? (fixed price) I am a VBA programmer and do very complex Excel reports etc... (15 years as a...