Search results

I have a popup form which contains 2 command buttons that open other forms onclick. when a user click on a command button in a popup form another form should open. How can i minimize the popup form when the other form opened. Thanks in advance

I have 2 forms, Form1 and Form2. Form1 has 5 command buttons, all of them take a user to Form2 but they are different areas for example: Button1(Area1), Button2(Area2)...etc. when a user press button1(Area1) then Form2 opens and has data related only to area1. If a user press button2(Area2)then...

I have a subform in a form. In my form i have a combobox and a command button. When a user choose form the combobox then the data appears in the subform. Sometimes, when a user choose an item from the combobox, it doesn't return data or records. what i want is to show the command button only...

My main form has a combobox. Users can choose from a combobox to open a form. I got this to work but i need to close the main form when another form is open. How can i close the main form after a user choose an item from the combo box? I know how to do it with a command button by Macro but how...

I want to fill in one field automatically from previous record. i have done the following but i didn't get what i want, it filled in all fields but i want only one. Function AutoFillNewRecord(F As Form) Dim RS As Recordset, C As Control Dim FillFields As String...

I have a form with 3 syncronize comb boxes and a sub form. First thing i see when i open the form is the three combo boxes and then when i select the third combo box, the sub form appears with data that match my selection criteria...which is good. But if there is no data then the subform...

I have a textbox (txtEnddate) and another textbox (notebox), i want if txtEnddate is empty then display a message in notebox. Is there any wrong with the following code: Because it doesn't return any error but it doesn't do anything. If IsNull(Me![txtEndDate]) Then Me.notebox.BackColor...

Some one help me please with this challenge. Let me first give you a short summary about my DB, Lets take an example, there is budgetRef(ProjectNumber), each budgetRef has 7 phases(Activities) these phases are standard, each phase has a number of SubActivities. For example, P30158 has all the 7...

I have a number of combo boxes in my tabular form but i don't want to show the arrow (the drop down arrow). Is it possible to hide the arrow of the combo box? if so, how. Note: I know there is enable property but i don't mean this one. Thanks in advance.

I have a form with 3 comb boxes and one subform. First combo box contains project numbers. Second combo box contains Activities. Third combo box contains SubActivities. The subform displays all the projects numbers, Activities, subActivities and planned and actual dates. When i select a project...

I have a query consists of 3 tables and one crossReference table. I built a form that display my query but the problem is I can't update and insert data in my fields and i can't add new record...It says that "This recordset is not updatable". Any help is appreciated. Thanks.

I have "project number","start date", and "End date" text boxes. I want to diplay an alert, let say for example 2 weeks before the "End date". I have lots of "project number" records. For example, prj1, prj2, prj3,...Each "project number" has different "start date" and "End date"...but they can...

I wan to retrieve data in text fileds(in form2) based on passing value from a command button in form1 to form2. I have a form1 that contains several text boxes, one of the text boxes is a "project Number", for example, the project number for the first record is "P14X" and the project number for...

I have a form that contains several text boxes, one of the text boxes is a "project Number", for example, the project number for the first record is "P14X" and the project number for the second record is "P14XZ" and so on.. Lets say i am viewing "record 1" and the project number is...

I have a form in MS access 97 contains a number of text fields and records about projects types, and i have a number of MS Word document or files contains information about each project saved in C:\. I need to display each MS word document in a big text field seperately in a form (in MS Access)...