Search results

Understand I dont really understand, yet at the moment there is no relationship as the table will not let me place two storeId fields into the table when designing it so i have left it out untill i find out why any good.

Not sure Hi, The store table is used to display the destination address and the sent address for each transfer taken place. I think i could change the table so that the destination address is writen in mannually with adding DName DAddress DTown DCounty DPostCode this would mean extra work...

thanks Thank you for replying the transfer table/s already hold a date field, Tables tblTransfer TransferId Date ShippedDate FromStoreId ToStoreId tblTransdetail TransferId ProductId Qty that is the current set up the fromstoreId and tostoreId fields i would like to use the storeId as the...

Hi, I have a problem in my database I have a transfer table which requires two fields one to say the store the shipment is from and the other the store destination. I have a store table where the addresses etc are stored but access want let me put storeid in the transfer table twice any idears. ??

Thanks Hi Thanks for your reply

Hi, I have seen some messages in the forums that show people placing validation though VBA and others using validation text/rules inside Access which is better ?? Cheers

Cheers thanks for the reply makes sence, any other problems or idears for the database.

Price Thanks for your reply, At current the items are brought into the business and a price is placed on each item, the buisness reduces items into clearance prices a maximum of three times, he would like the system to monitor each of the clearance prices and the date the item went into...

Hi forum members, I am trying to create a stock control system for a local business which have several stores in different locations. I have come up with the following tables, please could you take a look and offer some help/suggestions. I have a price issue as i do not know where to place...

Type Field Hi Mile-O-Phile, Since there will be several records with mens, womens etc size would it not be better to put these into a separate table or there will be lots of records with duplicated data. ???

Thank You SQL_Hell, Thanks will do it sounds good.

Help Now getting Run-time error You can't assign a value to this object. Any help text box enable =true

Thanks Will implement the new table structure Would it be better to replace the type field with mens womens and kids fileds and have them as check boxes ??

Set the timer to 1 and a event procedure for the form timer txttime.text = time() got back an error run time error can't reference a property or method for a control unless the control has the focus. So tried txtTime.SetFocus txtTime.text = Time() Then run-time error can't move the focus...

Hi, I am developing a database which is holding information on product's, I will need a table for the sizes of the product. That is simple but Sizes available come in three main categories (Mens, Women, Kids) should I have a table for all three?? tbl_MenSize ID Size tbl_WomSize ID Size...

Help Still needed This is what i have done so far can u have a look

Just found the contact database on access. cheers

Hi Guys, I offered to create a contact database for a friends buisness/personal use. I have got them to tell me what information she wanted. Contact ID Fullname = Title, Firstname, Middle, Lastname, suffix Nickname Proffesion JobTitle Company Spouse Anniversary PhoneNo = Type, Area Code...

Please read Hey everyone, I would like to create a database but do not like access forms/program. There are programs that seem to have some sort of database structure behind them, and appear to be a separt program. Any ideas on how to achieve this.

Thanks Hey mate, That is great just what I wanted, took you no time at all. lol was wondering if you wouldn't mind helping me with the query string u set up to achieve it Left([CustNo],3) AS Prefix, Mid([CustNo],5) AS Suffix Left([CustNo],3) AS Prefix - This is taking the first 3 char from...