Recent content by toyden

Thanks Majp

Hi Majp thanks for your help so far. would you be willing to help me through this process as i am a newbie to vba and am in need of a good teacher. im happy to build the data tables thats no issue, but the vba i will need lots of help.

thanks that will be an awesome idea i just need to add this to the form for cars incoming yes??

it currently is an auto number field so if i change it to string if would be fine.

ok new question the vin number im told could be alpha-numeric can i still use it as a PKey?

@dhookom sorry about the naming convention i generally use the _ instead of spaces but i have noticed that in my lack of sleep i have missed a few ill correct that. i have fixed the spelling as well i should have waited to get started when my full attention was able to be given. i like your...

so my sales table now has sale_id, Part_id do i need to keep Name_of_part, Position_on_the_car and colour or will that data be obtained from somewhere else. ill apologize now i have not worked in access for a good 8 years so i will be looking for lots of help to get this job done. thanks Jesse

well this didn't work ill try again hope this works.https://www.dropbox.com/s/nkgmhqga1fuyc9e/screen%20cap1.jpg https://www.dropbox.com/s/un0geqwl8vud5em/screen%20cap2.jpg https://www.dropbox.com/s/2lf1xqehp0g43l6/screen%20cap3.jpg https://www.dropbox.com/s/fi8ekejvqz3cm17/screen%20cap4.jpg...

here are the screen caps they show what tables i have and what each table contains, i hope this helps you guys to help me, i can be a bit thick sometimes. thanks in advance Regards Jesse

Thanks guy's for your guidance should I post what I have so far, so you have a better idea of what is going on so far? I understand the basic structure and a one to many relationship well at least I think I do its just that I'm not sure how best to store the information. I'll put up pics soon of...

Hi all I need help with a table structure. I'm building a database for a friend who has a auto recycling shop now I'm trying to put together a table for a stock list. So far it is called tbl_stocklist It has p/key:stock_list_id Car_number Vin_number Car_colour Body_type Etc what I need to know...

keep the ideas coming guys cheers

thanks ill give it ago

thanks Skip ill just keep moving on and enter them manualy regards, Toyden

Hi guy’s I’m looking for a way to automate a cell entry in excel 2003. The user types in a set of 25 characters and there needs to be a “-“ between every 5 characters I created a custom cell format #####”-“#####”-“#####”-“#####”-“##### But this dose not but the dash in for me, Can anyone tell...