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...

hey, another small thing; when i open my form in the dialog mode, it doesn't show up in the correct dimensions i mean the height and the width of the form is reduced. ... any idea how to make it correct ? btw, i'm using Access 2K3 also regarding the If clause, it seems that work without that...

hmm,. still the error comes. the exact error is "you must enter a value in the <combo box name> field" the On Not In List event works well if i type something and try to loose focus... but the text assigning from the if event doesn't seems to fire the On Not In List event....

yeah its pretty neat but the first part is confusing... (the if condition thingy)...i mean there an error saying that "you must enter a value in the <combo box> field

nope they are not opened at the same time.. i mean the forms books and magazines are not opened same time.. but - books and authors - magazines and authors those 2 combinations are possible...

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:

thanx alot buddy ;)

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...

thank you very much buddy.. :))

wow !! it works well bro !!thanx for the coding nd time spent to this.. may i know how did u disabled the text boxes ?? coz i did it once and an error popped saying u cannot insert values for disabled controls.. FYI i'm using Access 2007 Thanx again :)