Search results

here's what i wish to do: i have fields named status1,status2,...,status5 abd caller1... caller5 (i know this kind of field names are a lil absrd but i wanna keep them like this cuz the end users want them to be so) when i add record i fill status1 and caller1. thats fine i need to build...

i have table with fields name,phone and status1,status2... status5 i have a form to add records which uses status1. now i want to build a form to update status... it should how many fields for status i have used.. and allow me to fill the new one... how can i do so. plz help..

hello, i am having a strange problem i have table with PK: name+phone number. i have a form which has a combo box and a subform combo box is used to select a name... on updation of this combo box the subform finds related details.. when i click on any textbox to update etc.. i get an error...

i have some forms having subforms.. the linked tables are loacted on another PC.. these foms work fine when the linke tbles ar on the same PC but when the linked tables on another PC.. the foms are blank!!! please hlp..

well i have a form.. where one of teh fields(serial) has a control source of type Autonumber. this form also has a macro which takes it to a new record on opening.. the problem is it shows (AutoNumber) in the serial instead of the actual serial no. which will be assigned to this record.. it will...

i have a multi-user file..which i created using user-level wizard.. now suppose a user logs in and fills up a form.. and adds that as a record.. the form must identify the user and add that to appropiate field in the record. how can i identify the user and fill the user field. plz help.

i have made two files.. front and back.. i have used it on my PC only as of now.. i made a new workgroup file. but now i have to use the front end file on another PC on the network. i shared the shortcut whih is created after running the user level security wizard but am not able to open my...

i had a DB which was owned by Administrator. i ran the user level security wizard and created some users. next i made one of the users administrator and admin was left in user group which had no permissions. i need to change ownership(the book i followed asked me to do so, otherwise Admin from...

i created this database but am not able to create a password for the same.. actually i tried the security User Level Security Wizard and created a user.. i thought i was the admin but now i am getting an error message that "you dont have the permission to open "c:\...\filename" for exclusive...

i have a table which has Name+phone_number as PK. now i need to build a form where one enters a name and presses a button. All records having that name in the Name field shoud be displayed in a subform. please help me out here.. A soln which i thought... i build a query which takes the...

can any one please give me good download source of some basic forms like searching and updating reocrds etc

hii, i am new to access. i must say i am really amazed by its power. i have worked on a single user file so far. now i need to implement a multiple user file. i have no idea how to get started.. i read that i should have my tables on server and front ends on clients.. but how do i connect...

i am really new to queries.. and this might seem very easy to u all.. but please lemme know.. i have a huge table and i have to change some values.. how to do it in one go... thnx piyush

i have some query which i run every day and want to keep a record of different data it returns. for this i import that query as table. but each time a new table is formed.. is there any way i can directly pull the data returned by this query into an already existing table.

can i rename columns of a crosstab query?? can u explain using this example.. TRANSFORM Sum(foJUN.OPEN_INT) AS SumOfOPEN_INT SELECT foJUN.SYMBOL FROM foJUN WHERE (((foJUN.STRIKE_PR)=0) AND ((foJUN.OPTION_TYP)="XX") AND ((foJUN.TIMESTAMP)=Date()-1) AND ((foJUN.INSTRUMENT)="FUTSTK")) GROUP BY...

SELECT FO.SYMBOL, FO.today, FO.yest, (today-yest)/yest*100) AS perc FROM FO WHERE (((FO.today) Not In (0)) AND ((FO.yest) Not In (0))); sometimes when the value of FOValInLakh.[6/18/2008] is 0 i get #error. I am not able to sort(MAIN REQUIRMENT). if i use not in (0) criteria... i loose out...

SELECT June.Scrip, Avg(June.[Quantity Traded]) AS [AVG] FROM June WHERE (((June.[Trade Date])>Date()-14)) GROUP BY June.Scrip; the above query gives me average of Quantity traded for last 14 days... now i want to see today's(or yesterday's) quantity traded as % of this average.. how...

i am really new to access i have built a table which appears like this: SCRIP DATE QTY A 6-jun 100 B 6-jun 50 . .. .. Z 6-jun 200 A 5-jun 140 B...

there is a set of data (some 15 fields) related to some 250 co.s which NSE releases everyday. this data is contained in 3 different tables which is made available at the end of each working day. i need to make a database from this. how can i incorporate all these data in three different table...

hi, i want to import data from an excel file starting from the 5th row. how can i do so efficiently.