Search results
-
E
form's background color property
How can I change the form's backcolor to yellow by code? thanks- E-D
- Thread
- Replies: 2
- Forum: Modules & VBA
-
E
A combobox sort
hi. I have a combobox, SuppliersID. the combo shows 3 columns. The width of the first two is 0, so I can see the third column only. I want to sort the combo according to the third column - the one I see once the Combobox is being openned. Is that possible ? -
E
Margins definitions
In one of my reports I have changed the side margins into 10 mm however everytime I restart the prog, the margins return to their default definitions How do I save my definitions? thanks -
E
What is the matter with this simple code?
Private Sub CmdCancelReport_Click() Dim a As Integer Dim b As Integer 'CUSTOMERS_ORDERSstatus.SetFocus If CUSTOMERS_ORDERSstatus.text = "" Then a = MsgBox("Are you sure?", vbYesNo) If a = vbYes Then CmdCancelHeshbonit.Caption = "yes" CUSTOMERS_ORDERSstatus.Text =...- E-D
- Thread
- Replies: 2
- Forum: Modules & VBA
-
E
Me.undo
hi guys. I really need your help: I have a form for Suppliers Orders. Every record has it's SuppliersOrdersID which must be a running number. My q is: When I open a new record and I want to cancel it for some reason, which code line should I use. I'm asking because When I use Me.Undo it erases... -
E
Creating a report based on a form
hi I have a form which consists of different fields + calculated fields. I want to create a report whose data will be taken stright from the form. The form has ordinary fields from a query + calculated fields (for example: field1=field2+field4) Is that possible? -
E
making a report from a form
hi I have a form which consists of different fields + calculated fields. I want to create a report whose data will be taken stright from the form. The form has ordinary fields from a query + calculated fields (for example: field1=field2+field4) Is that possible? -
E
A filter activated from a form
I have a form in which a number of Command Buttons activating a certain query. the query shows 2 fields: name, statusid each one of the Cmd Buttons should open the query but with a different status. I think it would be wiser to use only one general query and use the form's filter. How can I... -
E
Calling excel from a form
hi. How do I call a specific excel file using a Command button in Access ? thanks -
E
Form load cancelation
I have two question actualy: 1. I have a code written in the form_load section of a form that opens a new record. The form can be entered from various Command Buttons. there is a particular cmd button from which I don't want the form_open to be executed. Which open form arguments should I use... -
E
An array of objects in a form
I want to build an array of TextBoxes on a form so that I'll be able to go over them with the help of a a simple for-next loop and check out if one of the fields is empty. I can't seem to find such an option in Access Do you have a solution ? thanks p.s: I'm well aware if the option... -
E
A fiels not found in a form
A strange thing happens to me : I have a command button links between two forms. For some starnge reason once I use it, an error message pops up. When I enter the code and use Me. the options I see are customer_CustomerID instead of Customer.CustomerID and the program cannot identify the field... -
E
A fiels not found in a form
A strange thing happens to me : I have a command button links between two forms. For some starnge reason once I use it, an error message pops up. When I enter the code and use Me. the options I see are customer_CustomerID instead of Customer.CustomerID and the program cannot identify the field... -
E
Effective links between tables
Happy new year ! I have two different forms: frmPeople linked to Table TblPeople and frmAddress linked to table tblAddress both tables have PeopleID as a primary key field I want to use a Command button in form frmPeople in order to go from frmPeople to frmAddress, but I also want the...