Search results

dear everyone i am advised to create a database for the following form. note that this is only part of the form and the actual form contains 20 questions (in similar format) whereas this contains only 2 questions. i though of having the following table structure city...

hi i have a form and a subform.. when i click new record, most of the time the focus goes to the text box in the subform. even-though i have set the tab order properly in the main form. how can overcome the problem ?

hey i am planning to implement a Data Management System with the following features 1. using access .mdb (or .accdb) files in the data entry level (since access has forms, i find it as the most easy and quickest way of designing a neat data entry app) 2. Pomp the data gathered by several mdbs...

i have the following view attendant type | attendant number | program name | Shop owners 678 Book Keeping Farmers 679 cultivation Players 680 discipline now, i have 2 combo boxes. what...

first of all; i'm using Access 2007 and the forms are not being opened in the default "tab format" i changed it in a way that the forms are being loaded in the overlapping manner. I open a form: DoCmd.OpenForm "dlg_get_product", , , , , acDialog The window appears extremly small, I can't see...

Hi I'm using Access 2007 and this is the problem i encountered. when i design a form in the design view i give dimension, then i check them in the layout view and it seems OK. but when i open it as a dialog box, the for gets shrink and 2 scroll bars appear ether side. how can i open the form...

hi i have 3 forms form A, B and C for A and B have combo boxes each which are having values which are being entered through form C eg: books and articles have authors all the authors are stored in one table which has form C to enter data the books form (form B) has a combo box filled with...

hi .. my main form has a check box named additional details (the main form is student form btw) the main form has basic details of a student. if the check box named require additional details is clicked, the sub form is visible and the user will have the ability to enter data. but when the check...

hi my database has several forms and most of the forms have ombo boxes which loads data from other tables etc. for example, i have 2 tables in a database called book (bookid, title, authorid(FK)) and authors(authorID, authName) in the book form, i have a combo box which loads all the author...

i adjust the size of the form in design view, and then even in the layout view.. but when i saved it and re-open, the form is slightly expanded to the horizontal direction or in some cases resized... when i press the size to fit form button in the home tab, it becomes ok but again when i reopen...

i got a form.. and in it thers a combo box where some data is getting filled.. once i changed the layout and the fonts of the form, the auto fill feature disappeared... i mean when i drop down the list, i get all the values but they want get auto-filled when i start typing.. i tried rebuilding...

hi i have a student table it has this gender column. it saves males as '1' and female as '0' i want to write a query to display all the '1' as "MALE" and '0's and "FEMALE" how can i do this in Access Queries ???:eek::eek:

please refer the following table i created a form to the above table. participant group names are loaded into a combo box. another text box is assigned to the participantGroupType Column what i want is when a person selects the type name, the relevant type should be entered to the text box...

consider the following tables i have 2 interfaces for the above 2 tables. the training attendance is a subform of the training program form. and the form looks like follows the training sesssion sub form saves data as follows. (i.e the sesion id starts again from 1 for a new program id)...

consider the following form and table set also theres a query which contains the following fields [Participant Group NAme] > all the names of the above tables [Group Type] > VC for village committees, PG for producer groups, PH for Pharmacies the group name combo box's Row source is this...

the currency data type always shows values with $ sign. cant i modify it and insert any localized currency symbol ? (like Rs. etc ?)

is there a way of creating combined unique keys in Access ?:confused::confused:

whats the difference between this 2 terms ? i.e OLAP versus data warehousing ?? c'mon this is not home work so i'm specially saying this to "some people" who usually make "idiotic" comments when they cannot find answers... i'm just curious thats why asked.. so if u know, please share.. thanx :)

consider the following table i want to query and take the total population and the number of GNs group by the district so i wrote the following query SELECT District.DistrictName AS [District Name], Count(GN.GNCode) AS [Number of GNs], sum(population) AS [Total Polulation] FROM (District...

hi i want to generate a graph using access and i'm damn new for this... can anyone guide me ? apples 3 manges 6 banana 4 say i have those data. i need to show them in a chart.. how can i do it ?