Search results for query: *

By that I mean, a row gets highlighted, a selection to insert a row is made and a blank row is displayed before the hightlighted row for data entry.

I have a subform on a tab control page. I would like to have the information in the subform refreshed as it is displayed. To explain further, step by step: 1. Tab is clicked for the page containing the subform in question. 2. The subform and the query results are displayed in a tabular...

In order to enable and disabled command buttons correctly, I need to be able to know that the last record or the first record is being displayed. That is, when the the last record is displayed, I want to disable a "Next" command button.

I take it that by the lack of response this can't be done?

When a have a blank form I can create a tab form and place a different subform on each page. However, when I add a tab subform to a form having other controls and a data source of header type of information, the same subform appears on each tab. What has to be done that a tab subform can have...

Thanx Grant, You read my mind thinking it may have the same control manipulation as with VB. Next release maybe?

I have several check boxes, who's label and value I want to dynamically define. Is there any way of indexing thru them, rather than to load them individually. In the VB code I'd like to be able to loop thru loading them, where I would use a subscript to indicate each occurance.

Is there anyway to programmatically (VB or with a macro) set the confirmation options to off.

Keep getting the "operation has been stopped because another user" error message when trying to delete a row in a datasheet. This only occurs when another table is updated first. The update of this other table is done on the On Delete event for the form. What do I need to do in...

Robert, Thank you. I have everything working great except one thing. So, I have a tab control, with a subform on top of it. On the On Change event of the Tab Control, a text box on the main form display the tabctl + 1. The number displayed is correct. Following the setting of the text box...

I know what I want to accomplish, but am uncertain that it can be done. I want to use a tab control on a form. Each page of the tab control would contain the same subform. Since the subform is based on the same query, I want to be able to dynamically change the criteria as the user selects a...

I have 2 tables: Header and Line Items - a one to many, respectively. I want to set a flag on the Header to False when there are no Line Items associated with the Header. However, that would require either a Count of Line Items or some other aggregate function - but can't have that in an...

I have two tables: Sales Order Header and a Customer Master. It is defined as a one-to-many relationship(Customer to Sales Order). When I create a query based on the Sales Order Header, with the Customer ID from the Sales Order Header and include some items from the Customer Order Master (for...

The sales order line is as stated in my first message. The part master contains: Part Number Part Description Unit Price The SOL table is linked to the Part Master on the Part Number (one to many - Part to SOL). The query for the subform is as stated in the first message - a simple fill in...

I am sure this has been done a thousand times - but not by me. The application is Sales Order Entry. The area is sales order line items. To keep it simple for this discussion: The sales order line (SOL) has: Sales Order # Sales Order Line # Part Number Unit price I have a query for a...

This should be an easy one, but I need a point in the right direction. I have a table with two columns. I want to create a query that would result in three columns. The first two from the table and the third be an sequence number, starting from zero and incrementing by one.

I have a table with a numeric column. This amount is the ending amount. The starting amount for the next row would be the amount from the previous row plus 1. The report needs to be formatted as: Starting Ending 0 10 11 20 21 30 etc. The given is the...