Hi, i have excel sheet its contain lot of formula and VBA(macro) code, its for used for user purpose, i need how to protect the formula and VBA at the time...

Hi all, reg amt amt total 1 10 10*50=500 1 100 100*50=5000 1 200 200*50=10000 2 2 2*50=100 2 ...

hi all i have doubt in acces, i was creted the table in the name of table1. table1 contain,

hi all, i have doubt in acces, i was creted the table in the name of table1. table1 contain, reg no. name add amt

Hi all I have doubt in below code amt1 amt2 balance(text box) 001 500 500 0 002 1000 700 300 in access formula...

Hi all, In access i have 2 table name main and paid details, based on this table i has create the form also. bcoz the both form have with relation ship 1....

Hi All, Pls Help me on this 2formula,Is not working fine can anyone help me on this. Reg Code Is a Text Format =Sum(DLookUp("Amount","Paid details","Reg...

School Group form has a subform for Students. When I'm in the School Group form for Manhattan High School and I enter student names in the Students form the...

I've been getting the following error everytime I try to add a new record: LinkMasterFields property setting has produced this error: User-defined type not...

1.01 million is perfect I need the land , I will bleed purple in july and christ help me you hang me out on this one I will do...

Hi! Sppose I make two tables tblName and tblAge. tblName has two fields name and address. And tblAge has two fields age and telephone no. I want to know...

Hi I have created a query where i m calculating two dates A1 and A2 Now i have a form Premium Paid, where i m inputting the premiums paid by users. The...

I want to do simply this in MS Access. PARAMETERS pTableName; SELECT * FROM pTableName; This doesn't work ( if it did I wouldn't ask you :) ) but is it...

I have a membership database and within the main input form is a sub form for address input. - A person may have more than one address. I have added a...

I have the following table test3. RESERVATIONID Site SitePrice 101 RV2 $25.00 101 RV3 $25.00 102 RV4 ...

I have the following query and I am figuring a number to fill a text box in a form. The code works but I cant get the text box to update unless I change record...

I have a report question if anyone could help. I have a query that I want to drive a report. The query can have multiple lines of information driven by an id...

I need some help figuring something out. I'm not sure if I heading in the correct direction. What I'm trying to accomplish is the following. I have a table...

Is there a way to sum a specific column in a query? What I have is a query that pulls several line based on a id field. I want to total just 1 column in the...