Search results

Dear John, Thank you for the help. I will study and learn. Regards, Gautam Patel

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

Please help in tax tables Hello, Can any one please help me in figuring out the right table structure, relationship and forms for the tax structure to be used in my purchase order processing database. I tried many time but failed. Any help please. regards, Gautam:(

Dear Fifty2One, Thank you for your reply, But I need to retain the taxing amount for taxation reporting and the tax structure can change any time in india (bullish governemnt policy ) and we need to select tax structure while entering the data of the customer so as all his billings will be...

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

yes mailman, This was bugging me every time I open the win explorer or Iexplorer and distracting me.

Dear Friends, I finally found the problem source and rectification from a friend. Please refer the below link for your reference. http://delwiche.livejournal.com/69911.html

Dear Minkey, The Demo software was in Access 2007 which I was building, and already deleted the same. The error I am getting while opening the Windows Explorer and Internet explorer.

Dear Mailman, Thank you for your reply. As per your suggestion I need to contact the Author of Program "Microsoft" but No reply from them, Hence I have posted here and am really in a big mess. Please let know if you can find some workout for the same.

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

Thank you for the assitance The "Godown" Address type is a "Warehouse" and is referred to as godown in INDIA.

Thank you for pointing out my mistake Dear Kenhigg, Thank you for pointing out my mistake and your assistance.:o

Dear Super Moderator, Thank you for your assistance and a very beautiful link to learn many things. I will be reffering the same.

I have modified the tables as below, tblcustomers - CustomerID - Autonumber - PK - CustomerType - BoutiqueType - Customer Zone - Customer Number - Company - FirstName - LastName - Phone1 - Phone2 - Fax - Mobile - Email - notes tbladdresstype - AddressTypeID - Autonumber - PK - CustomerID - FK...

Thank you all for the assistance. Now I am thinking to put the formulas in Query so as I can generate reports at later stage, but I don't to how to make a Query, please suggest.

Firstly thank you for your assistance. My problem is solved. Can you please explain a little about the first part of formula you entered so as I can learn 1. What is & used for 2. Why "=" is used Is this called nested IF statement. Please also justify whether putting this formulas in the...

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