Search results

I have a Database design in which there are 4 forms linked to and updating a single table. In table I have set many fields as combo box with value list, and default value (Text), for example Yes and No with defalut value as Yes, Normal and Abnormal with default value as Normal etc. When I try...

I have a main form and 5 subforms all based on single table. When I enter a new record in the main form, it says locked by another user. I am the only user. I can not add a new record to the table using main form or subform. I am new to access.please help. My form is for data collection and I...

Hello, I am novice to access. I have a form and few subforms as tabbed pages in the main form. I have a separate page as search page that consists of searchbox and searchlist. When I type a name in searchbox, there is listing of matched names in listbox. Now I want to click one of the names in...

I am still novice to access. I have a form and few subforms as tabbed pages. In form view, when I move through the tabbed pages, the tab headings disappear behind the header of main form, and I have to move the page up to see the headings so as to click next tab. I want the tab headings to...

Hello, I am novice to Acess. I have many forms linked to single table. SInce dataset fields are many, I created one form and kept rest of the forms as subforms in tabbed pages of the main form. Data in all forms are linked to the same single table. I have thousands of data in the table. I am...

I have a form with check box (Chk1) and a subsequent field (txtbox1). Field should be visible only if check box is checked. I put a code at afterupdate event of chkbox. Now on form load the checkbox is unchecked but the field is still visible. It becomes invisible only when I check it and again...

Hello, I am new to access and can design simple forms and tables. I am designing a form for patient's record. I have one table to record the data from which I have created the form with the same field names. I have two situations. 1. Combo 1 (CboExamination) --Options = Normal, Abnormal and not...

Hello I am new to access. I am using Access 2010 and designing simple database. I want to autofill a field depending upon a value selected in previous combo. I have three situations 1. combo after combo I have one combo Hypertension -- yes/No/unknown If hypertension is "yes", I would like to...