Search results
-
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
thanks again. your routes are ok, but they require building another form or more queries with different creterias. I wish to use one query only while each Cmd Button is filtering the list according to needed statusid. I dn't want to take the creteria form the form. I have a frmSuppliers. I... -
E
forms using queries
changing a form will not reflect on the source tables or query -
E
Caluculate with forms
You don't need excel. just write down the arithmetical calculation with the relevant fields: =[FieldName1] + [FieldName2] * [FieldName3] -
E
A filter activated from a form
thnaks for your reply, however it does not meet my needs, since in my case this query should be called from different forms. basically we are talking about a list of names that I want to filter according to a statusid. Is there any filter option that I can use in my Cmd Buttons or within the... -
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
I want to open the file in excel. I used this code but it only opens a blank excel shit: Dim oApp As Object Set oApp = createObject "Excel.Application") oApp.Visible = True oApp.UserControl = True -
E
Form load cancelation
As I explained I can enter this spoken form from various locations in the prog. when I enter the form I usually want it to open as in a new record, however there is a specific Command button from which I don't want the form_open to work. -
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
thank you very much! I have learned a lot from your code -
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
I know I should use the right prefix however, Access automatically generates the names of the fields for me.. so I left the given names as they are. What about the problem I encountered Do you have any solution? -
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...