Search results for query: *

Did Microsoft do away with replication manager for MS Access 2002, 2003 databases?

Tried this to no luck. If I move to previous record, then main form field shows correctly, go back to record I was on when the subform was being edited, the main form display still is not getting updated. Somehow seems I need to change the state of the main forms record, but not sure what to...

I have a subform that calculates a total for amount paid with control named sumDelAmtPd and data is (=Sum([DelvBonusReceived]) where DelvBonusReceived is entered by user. This control is in the subform footer and data is being updated as user updates field in each record. On the main form I...

Your suggestion has got me thinking of a way to accomplish this with another table to link information. I can put the "middle" table as you suggested and that way identify a payment id with multiple orders. Another twist is that I need to then spin through each payment id and...

I have an Access 2002 form that lists the orders (by unique order id) associated with a customer. When a check is received, I want to be able to update a payments field with the orders in which the check was for. The payment might not be all of the orders, so I need to identify those rows...

Since it is Activesync that does the updating, I am not in control of when the end user will run activesync. Activesync updates the table a, so I was trying to figure out how to know when the table was updated and then run something to update table b. Table a is not really tied to any form or...

Is there any way to place a "trigger" on a table (similar to what can be done in Oracle, SQL Server) so that when a table/field is updated an action can be carried out? I have a pocket access database that sync to an Access 2002 database on the LAN. Using Microsoft Activesync, want...

I have a combo box that has 2 columns - an identifier and a description. The control is bound to the identified field. Once the user selects the correct option in the combobox, it will update the field in the table. I also want to be able to update the description field in the table at the...

I cannot figure out how to calculate subtotals on two different variables in a subtotal line. Have a report that has sales calls on report and want to produce the following layout. There is company name and products shown such as below: Company x product A Company x product b Total...