Search results

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. ??

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

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...

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...

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.

Hi Forum, I have noticed that in many databases that the customer/user ID is fairly long and in some cases uses a mixture of letters and numbers. My question is there a way to automatically set the customer/user ID to take in some information from the users name say (first 3 characters of the...

Hey forum, I would like to sell items on ebay and want to keep track of them and to make sure I have all costs down I thought a database would be a kwl idea. Has anyone got an idea on what I would need and how to create it ??

Hi, How would you go about creating a data dictionary ?? I have been told that access creates one but it is hiden is there any way of making it viewable.??

Hi, I have got a product table that has a quantity field, this fields holds the number of items for each individual product. Product Sales also have a quantity for each product sold, I would like the database to take the quantity from the product sales table and deduct this value from the...

Hi guys I have set my database so when it is loaded it loads a frmmain. I have tried to edit the database but I cant, I have tried to right click the form and go to design, but the window with the forms tables queries etc is not there any help

I have a series of forms that are Pop Up forms, when I click on a button to display a report the report is loaded but not seen. The only way is to close all the forms so that the report can be viewed any way around this, please reply.

I have an Id field and I would like to prevent anyone from typing in letters just numbers. the field has been set as a text field and is linked to others.??

Forum, I have got a Delete button, as well as an edit button on a form so that the user can delete and/or edit information. I have desided to lock all the txtboxes so the user can't change information with out clicking on the edit button first. I need the edit button to unlock all the...

Hi Forum, Can you get a installation process so that the database will be loaded into the startup folder so that when the computer starts up the database will run auto. ??

Hi Forum, I created a table so that it would transfer products from one store to another, the table structure is as follows: TransferID AutoNumber StoreID Text ProductID Text Quantity Number One problem is that the table only allows one product on one transfer ID i...

Hello, I have placed a txtbox that outputs the time, but I would like it to keep the time rather than display the time the form was loaded. Not sure how to achieve this any ideas?

To Forum, I have created a table called categories and one of the fields is called Quantity, this field is supose to callculate all the products they are in the database under the relevant category. The products are stored in a product table and the quantity for each item is listed in the...

Hi Forum, I have created a database can I am trying to create an interface for them. I would like to get the database to do the following when it is loaded. I would like a form to equal the size of the monitor, so the user cant see the desktop. I would then like a switchboard to loaded in...

New Member Hi to all members, I need to create a management information system for a local company. I have met up with the company owner to see how the current system works and what he would like from this new system, The company has currently five stores, each store has a basic electric...