Search results
-
E
Displaying a Summary of many fields
I have a situation where I use the output of a combobox in a query. When I run it everything is fine. Now I want to make a summary of 9 of these text fields in the query. However, when I do this only the bound columns show up in the summary field. I can't get a summary of the second columns of... -
E
Creating incremental numbering on a page
Can some one help me with this code. I have 2 page tabs on a form, and I want an incremental number assigned to each new record on that page. Been doing some research and this is what I came up with: Private Sub Form_Current() If Me!tabSupplier.NewRecord = True Then... -
E
Calculation using Combobox output
What code can I use to multiply the quantity field by the cost field on a form, when the cost field is the output of a combobox. Been trying lots of angles but no breakthrough. -
E
Use a Check Box to select records to print
I have a form open, but want to print only specific fields in each record. Been trying lots of filtering methods to no avail as I am a novice at filtering. I can filter records, but cant figure out how to filter specific fields from those records. My project goes something like this: Each... -
E
Populating an Invoice from an underlying table.
As simple as it sounds. I have set up a table with a list of items and the costs. I then created a form with a list comprising 10 combo boxes. I want to be able to select one record from the underlying table per combobox on the form. I am able to do this but the records in the underlying table... -
E
Subtracting Totals in a Business Database
Hi, I need some help as I have been battling with this problem for over a week. I consider myself at the intermediary stage and do not use much coding in my programs. I have set up this database here for my new sole trader business. In it I enter data of my purchases and my gross sales. I have... -
E
Where Clause
Hi, hope someone can help. I want to be able to point my where clause to a specific record in a field when I double click on the record. At present when I doubleClick it is defaulting to the Field but not the specefic record. -
E
Counting "True" Values in a Query
I just hope someone here is able to help with this. I have on a form a combo box with its list of values derived from a table. The values selected from the combo box are all stored in one field in another table. I want to count all the like values so I can group the like values into different... -
E
An expression used in a to reference a value in a combobox
I would like to write an expression in a control on a report that references a particular value in a combobox column/list. Please, can someone help, it is holding up my project. I want to filter each like value and total each set. -
E
Fill a record with data from a previous record
Hi All, I have set up a simple databse to monitor stock movement, but there are some filds I would like to fill with data from the previous record viz.: Cost, Balance, Tax etc...............Idealy I would like to make the balance from the previous record be the default...