Search results

i think i understand what u mean... the only reason i would prefer the other way is because i have well over 400 products in the database and with each haveing on average 4 possable sizes the total number of records comes to around 1600. and because i have a sample picture (OLE object) for each...

i dont know if u recall, but you helped me with sorting the size of products problem out. but now another problem has arisen... keeping track of stock. i have the 2 tables -- tblproduct productID sizegroupID ect... tblSize SizegroupID sizetype sizegroup how can i keep track of the stock of...

hi i was wondering how i would go about making sure that credit card details can be kept secure in access? i have a credit card table which stores all details of credit cards but i need to secure the data, can this be done and how??? thanks for your help!!

THANK YOU SOOOOOOO MUCH PAT.. it worked excellently!! :p :p :D :D :D

sorry about this.. im still having problems with getting the whole thing to work. iv made the size table but im unsure of how to have to form so that there is only 1 record containing several sizes but so they can only choose one size to order. can anybody help me out.... PLEASEEEE!!!!:( :( :(...

great, thanks pat ill give it a whirl...one other question is how would the user select the size when making the actual order in the form, any suggestions?? thanks.

well im going to have around 300+ products n the database, and to save space it would obviously be easier to have one record including each sizes available Item#1 T Shirt (Large, XL, M, S) in stead of Item#1 T Shirt Large Item 2 T shirt small ect........... There are several details for each...

but wouldnt that only enable me to select one size per product??? i need to have more than one size for each product in one record. if i select a size from a combo i can only get one size..?

im not sure im with u, could you expand on that to make it easier to understand..i mean what method would users use to select sizes if there was a seperate table????????????

i have a ProductTable which includes various products of different sizes. the only thing is, if one item comes in many sizes (S, M, L, XL) what would be the best way of representing this in the table. at the moment i have each product with each size EG LIV001 - M Owen T-Shirt - Size=M LIV002 -...

Basically i have 2 tables... TeamTable: TeamID, TName, TCountry ProductTable: ProductID, TeamID, Cost ect... what i have so far is a form in which the user can create new products using information in the team table. so what the user has to do is enter the teamID(Producttable) for the TName...

i work for a company which sells sporting goods. these can be ordered online. what i want is a system, which will allow me to put orders submitted from the web into the database>>> Product details, credit card details ect... At the moment we have to manually print out each order which is eating...

the company sells sporting goods... which can be ordered online. what i want is a system which will allow me to put orders made from the web into the database>>> Product details, credit card details ect... At the moment we have to manually print out each order which is eating up a lot of our...

im sorry to say that im lost. i was with you up to the dreamweaver bit. if i do use dreamweaver untradev what are the security issues of having the database online and how can i get around them. which way would be the easiest, the sercure.com thing or dreamweaver? thanks for your help!!

hey, how can i refresh a field, containing a DSum expression so that as i change parts of the form which dertermin its value it updates. the thing is it calculates fields in a subform, and i cant get the DSum field to refresh as i change values in the subform. if that makes sence to anybody is...

i was wondering how a database can capture information which is sent from a website. for example, when a person orders something, their details are automatically entered into the database. is there any way of doing this? at the moment the website is using securehosting.com to store the orders...

i have a listbox which contains a large amout of products and i need to be able to show a sample for when each is clicked. so for example, when the item LIV001 is clicked in the listbox, i need a picture to then show the corresponding picture. but then if the item NEW002 is clicked, i need that...

website intergrated database i need help on being able to get information from a website straight to the database. so for example when a new person signs up, the details are added straight in the database. i want to do this with orders aswell. can anybody please tell me the ins and outs of...

hi i have a DSum calculation in a field on a form, but it does not change unless i open and close the form, how can i prevent this? another problem is that because it is unbound (but has a formula) it does not record the value in the table... is there any way of getting around this?

hi, i want to set the value of a field twice...if that makes sence. i have a check box and a status box. if i click the check box so that its value is 'true' then the status should change to "avaliable". But then if i click it again so that the check box is 'False', the status should change back...