Search results

Because of large quantity of info I am using tabbed form in Access. The problem is that page titles in tabbed form are long and i cannot make them shorter because the sections are predefined.So I need some kind of cascade tabbed form but I don't know if this is possible. Please help with some...

Hi Which is the best way to organize country data about municipalities,cities,villages and communes if to one city refers more than one village and so on...

Hi. I am creating a GUI from a paper form which contains a lot of data to be filled.Can you advice me any way of presenting all this in a pleasant form? I know is a very general question but it is creating me a lot of headache to pass from paper form to access..

Hi all. I don't know how to format my report in order for my column data to be in the same direction because they are not straight one below other Any help?

In the main form I have corresponding checklist for single,married widow etc and this data figures in table as 0,1,2,3.When I create a report this data is shown by corresponding numbers but I need to be seen as words like single etc. Where can I change this poperty?

Hi. In one table I have 1.column of personbirthday(yy-mm-dd) 2.column of personage(year) 3.column deathaccident 4.column deathnatural 5.death suicide How to create a query for reporting death by age groups like 30-40 40-50 etc and death kind?

Hi I made my main form start automatically when I open the file. It contains 3 buttons so I want it to be smaller but when it opens it fits all the access page and I cannot make it different. Any suggestions?

Hi. I have an Access form where I enter different data about patients. I need in my form a save record button in order to save the data I enter for a person after completed the form.Also I need a go to the next record to make possible the entering of data for another person. Please help

Hi. My client wants the scroll bar to be inactive during entering the data in the form to prevent moving through data unattended. How can this be done?

Hi. In the case of one mother there are 2 options: -she has a child YES -she doesn't have a child NO If I gave yes I need to specify number of children,and the birthday for each of them.How can these information be represented by table variables? Is there any shortcut or...

If the employment form is checklist where user checks if person is employed,unemployed and if employed we need an option to specify employee how does all these figure in table? thank you

In the process of building db I have similar properties and attributes for the entities.For example I have for entity father-age,nationality,ID number. Same data I have for mother and son.Do i have to include father mother and son in the same table or create different tables for each?

Hi.I got a table with columns like that: 1.first column-year of abortion for the first time (2006,2008 etc) 2.second column-end of pregnancy for the first time (1,2,3,4) 1 is spontaneously,2 is interruption,3 is birth alive,4 birth dead 3.third column-year of abortion for the second time...

Thx.But how to manage the problem of age if we got sometimes age in numbers like 34,45,56...and sometimes just birthdays i.e 01/02/1981

table People->fields Birthday format dd/mm/yy, Age format number(if you don't know the exact birthday),field Employment(Full time 1,Part time 2) I need to calculate how many people of age 19-35 are employed part time,how many full time,and the same for people more than 35

Hi I have a columns of records which are either 1 or 2. I need to calculate sum of (1) records and separately sum of (2) records but with conditions of groups.For example for people age 13-19 there are x records(1) and y records (2),for people from 19-35 there are x records (1)and (y ) records...

There are 9 tables named: Klinika AbortiKryesore Rrethet Komunat KomuneApoBashki QytetApoFshat Prefekturat ShkalleArsimore QytetFshatAll First three are connected 1tomany and the others 1to1

I generate reports for db files to see which records are added and then I enter them manually in my form one by one.It is a very long and boring process

Thank you for answering. My db contain 5 tables .All this db files from other users have 5 tables also identically the same with mines.The idea is that they enter the data to this tables through one form and then they post me all these files.I have to put all the data in my DB with the same...

Hi. I am working on a project where different users send data in access db files. I need some automation because till now I am joining this data manually and this takes me a lot of time.To be precise the files users send are the same regarding tables and forms ,only data different. Thank you