Search results

Hi friends, I want to make cascading combos for my tables as below on the form "Customer Details" tbl_Zone ZoneID Zone Name tbl_City CityID CityName tbl_State StateID StateName tbl_Country CountryID CountryName tbl_CustomerDetails Zone Name ... ... ... Address City Name State Name Post...

Hi Friends, I am stuck in a situation of Taxation due to complication in Indian Tax structure. Can anyone please help me out in figuring the right table structure for below, Primary two (Rather Five) types of Taxes 1. VAT - Local Tax applicable to the sale inside the State 2. CST (Central...

Dear Friends, Few days back During developement of a time trial demo software I had changed the system date to advance the end date of demo to check the result and forgot to change back to the system date on the same day and did the same the next day, and since then I am in a big mess. I have...

I am a newbie to Access and learning the same. I am stuck in a problem and not able to get through. Please advice I have made tables as below but am not able to get through the relationships an form for input of data tblcustomers - CustomerID - Autonumber - PK - CustomerType - BoutiqueType -...

Dear Friends, I am into a situation where I have to calculate Warranty Date and accordingly set the warranty Status in the subform with fields as below, tblProductDetails - ProductNameID -Autonumber - PK - CustomerID - FK (linked to tblcustomerdetails) - SerialNo - InvoiceNo - Invoice Date -...

Hello friends, Can any one please pass on the detailed comparison of Access 2007 and SQL 2005/2008 with the limitations of Access over SQL. Thanks in advance.

Hi, I am a newbie to access and leaning the same, I am stuck at a problem as below, I want apply a customer number based on other criteria as below, AAA : 0000 : BBB 9999 (without spaces) where AAA is our Company Short code (Like MEC, MIC, MTC etc.) 0000 is the serial number for every...