Search results

Will read for sure and try to get some better understanding. there is nothing harsh about what you said. i am still a learner and am always keen to do it. i am also taking the help of the site "http://www.devshed.com/c/a/Administration/Database-Normalization/1/" to determine which normalization...

Hi All, Thanks a ton for trying to resolve my issue. I am extremly sorry for the confusion. i agree to ross that i am trying to replicate excel but i am also aware of the theory of RDBMS but maybe not enough as u people out there. This was a kind of requirement my business partner had and i...

Hi I did look at your suggestion and hence i replied too. As i have mentioned earlier the form textboxes do come from any table. they will need to be created new and then be able to input the data into table (mind you that i am not sure if i need to create fileds in the table) or maybe it can...

that is what i am not clear about and hence try to know it Agreed it is possible in spreadsheet which i am aware of. But is it possible in access? but we need to design databases based on customer requirment. Am i right, else how would our datbase be a good one.

no this is a predesigned template (form) on which the user fills in and the data goes back to the table. Hence my question is it possible to create multiple text boxes based on user requirment (in executable file) and then if possible how do i send them to table after being submitted?

ok first of all sorry for the repost. I thought that the earlier post was never posted as i had issues with the internet. Anyhow will explain. There is a form in excel which bank employees fill and send it to another region. Now in this form they enter details of multiple transactions. some...

ok first of all sorry for the repost. I thought that the earlier post was never posted as i had issues with the internet. Anyhow will explain. There is a form in excel which bank employees fill and send it to another region. Now in this form they enter details of multiple transactions. some...

Hi all, I have form which is designed based on a word template. I want text boxes to populate based on user input. For eg if user says 5 then i want 5 text boxes to populate. Is it possible? Even if possible how do i ensure that when user submits it it gets submitted in the table.

I have been searching this forum but to no vail. what i require is able to create multiple text boxes based on user input. For eg if user says 5 then 5 text boxes need to be created and so on so forth. I can predefine the text boxes which i can make them appear and disappear based on the input...

Hi Rabbie, I did the search as suggested but i think i could not figure out the solution. I have to take the data from the list boxes and i cannot use the combo box. The problem is check boxes are only selected (they are unbound) and data is displayed in the list box. I want to capture the...

sure sir, Just that i though the solution was a simple one and hence did not post it. what i have done is i have created another query which takes input from the questions query (output one) and used an expression like : Expr1: DCount("Questions","qryQuestions","Questions<='" & [Questions] &...

Hi All Finally i was able to generate the sequence numbers. Thanks a lot to all these forums.

Hi All, I will try to be clear as much as possible. I have a list box which generates a list of questions based on the input given in 2 earlier boxes. I have given check boxes beside each of those questios. User selects the check boxes if he has done what the questions says. Now i want to...

Hi Uncle Gizmo, The examples are fabulous but the problem that i notice is my table contains the same data which is repeated multiple times and hence it is not working for me. Can u help me

hi all, i have a query which give me a result of few records. For eg it give me a list of 10 records. I want also to generate a serial number in the output of query to list the records from 1-10. i cannot create a sno in the table. cany anyone guide me

Hi Bob, I have seen ur answers to many posts earlier. Those have been quite healpful. Thanq for your response. So now can i fairly assume that it is not feasible to create check boxes on the fly. if i have to do i need to go back to develp mode and do it. If you can confirm the same i will stop...

hi all, Thanq for ur replies. It is not question and answer type. I am not definign the check boxes at all. I will try explaining clerly. i have 3 list boxes. The first one gets populated when they select an option from a combo box e.g if they select credit card it throws 10 different options of...

hi all, i have a form on which there are list boxes which populate a set of question based on the selection of the previous list boxes. Now i want to be able to populate check boxes for all the question that populate on the list boxes so that the user can check them. The question can vary...

i got the solution. i took the result of this query into another query and there i caluclated the expression 1+DCount("Sno","qrysearch","[Sno]<" & CStr([Sno])) This gives me the numbers for all the records listed.

Hi All, i have a query which gives me a result of set of records. I want it to be auto numbered for making it random. I have tried several ways to increment by writing an expression but something goes wrong. For ex in the queyr that i have written like SELECT TblAccq.Pan, TblAccq.Queue...