Search results

Hi all, I managed to change the format in form, but the format in table still remain the same if i enter data using table. How can i change the data format in table? Thanks

Hi Taruz, Thanks for your reply. But I dont see format in properties sheet.

Hi I would like to input the date as 25/12/2011 and have it displayed as 25 Dec 2011. How can i use the expression to show in input mask? Thanks

Hehehe, SQL still beyond my capability. currently, i am still designing my table structure. hopefully, i will be able to use VBA and SQL soon. Thanks everyone ;-)

Hi I am a newbie and to create a simple payroll in Access. Would it be useful to create a field by checkbox in employee table for resigned staff? My purpose is to know who to include and exclude for current month payroll. Thanks

Hi all, Thanks for your respond. Since those phone and fax numbers of our company is constant which will print as letterhead in report and not required to mix with other info of our customers,suppliers and employees. Is it still necessarily to create another table to store phone and fax...

Hi I am to create a table to store my company details. Below are the field name that i store single facts about my company: Our_Name Our_Address Our_City Our_Address_Post_Code Our_Post_Box Our_Post_Box_Post_Code Our_Country Our_Phone_Number Our_Phone_Number_1 Our_Fax_Number...

Hi, I see it from the below link http://www.databaseanswers.org/data_models/payrolls/index.htm What is it and what is it for?

Hi I understand that PK = Primary Key, FK = Foreign Key. but, what is PF? Thanks

Hi I am a bit confused. My understanding is all info in access is to enter once. Hence, i assume i need to create a table for gender and to link it to employees detailed table. However, in http://www.databaseanswers.org/data_models/payrolls/index.html, gender is in employees table without...

Thanks the net 2.0. Would you please direct me where i can find the 2nd ways in toolbar? I will go from there. Thanks again

Hi I would like to confirm my understanding that there are two ways to create a relationship in tables. One is create it by using 'Relationship' and the other is go to lookup wizard. Thanks

Hi Spikepl, I am looking for an alternative for creating a relationship from lookup wizard without success. I will be grateful if you can provide me with a link where different approach on creating relationship is available. Thanks

Hi When i set up relationship for two tables by using lookup wizard, i chose to view the description instead of ID. It was successfully done. However, when i open the table today, the FK field becomes ID and its data type changed from text to number. Anyone has any idea of this changes? Thanks

Yes Gina. It is another branch/location of the restaurant.

Thanks again, Gina. I will refer to your table structures while building it. I just include: tblTables tables_ID (PK) Outlet_Location (FK) Tables_No (eg, Table 1, table 2, table 3,etc) No_of_People (eg Table 1 can sit 2 persons, etc) TblOutlet Outlet_ID (PK) Outlet_Location My issues...

Thanks Gina. I would like to build a system for a restaurant. for the time being, i am thinking about the daily sales report. and slowly expanding to inventory, debtor, booking, etc. As such, only two tables are being created. I will develop more tables when i go along. Thanks again

Hi, Please comment about my work. I created two tables: 1) Products & 2) Menu Items. for (1), Product_ID (PK) Product_Name (ie appertizers, salads,soups,set lunch, hot beverages, voucher, catering, etc) for (2), Menu_ID (PK) Product_ID Menu_Item Price Details (Description of the menu...

Hi, I have created a few tables. For example, Table 1) Contact Table 2) Invoice So in Table 2, do i need to key in the customer name? or to relate it to table 1 by searching table 1's customer name? When using excel, i can relate it by using index and match function. But with Access...

Hi What is index? I read the explanation and still get confused. Can someone please explain to me in plain English with a few examples? Thanks