Search results

You have two tables. Presumably , you want to delete any records in table 1 that have corresponding entries in table 2, then append the records from table 2 to table1. First back up your tables in case anything goes wrong. Open a new query and add table1 and table2 to it. There should be a...

You can write an error handling routine that specifically deals with this error by ignoring it. Look up acDataErrorContinue in Help.

Then it can only be for two other reasons: 1) You have the same RECORD open in separate forms /queries simultaneously at some point in your procedure. It doesn't have to be the same FIELD involved. If you set pessimistic locking, the system should prevent this from happening. 2) The database...

This is a message that is caused in multi-user environments when two users change a record at the same time and no record-locking is enforced. It can also occur when two local copies of the db are open. Is yours a multiuser app.?

Sample sent to your email address

Rocky_pierre That wasn't "Technospeak", just my way of saying that you haven't got any linkage established between Makes and Options, and you now have to do this. You have blank records for exactly this reason-because your query is asking "show me the records in the "Option" table that have...

Luis In the field where you want your result, put the following calculation =IIf((B+B/6)>2759.6, 2579.6,(B+B/6)) If B is another field on your form, you must type it as [B] throughout the expression.

Murali If you are having difficulty in the timing of this error message, you can still use Rich's code, or something very like it, in your error-handling procedure. Suppress the Jet error, step through the controls as Rich suggests and use ctl.name if you want to refer to the field by name in...

Meet me halfway... OK. What's the error message?

These are manageable numbers . Do you need further advice or are you up to speed with subforms? If you need more explanation about what your third table does, investigate the "Order Details" table in Northwind. Post again if you need more specific help.

You need : in Table1:Makes&Models A primary Autonumber key field (MakeID) In Table2: Options A primary Autonumber Key field (OptionId) in table3: ModelOptions A primary Autonumber Key field (ModelOptionID) A foreign key Long Integer field (MakeID A foreign Key Long integer field...

Intervals, please What's wrong with Rich's solution? You put this in a standard module and pass 4 arguments to it. These are described in the code's preamble. Your source will have to come from a select query with a join between EACCode fields, rather than a table. Presumably the EACCode is...

If I understand correctly, you are trying to show relationships between Models and their options. If so, you have to consider the following: What is the situation with your Options? a) One model can have Many options? b) An option is available for more than one model? If only a) is true...

I got your e mail Murali I'd like to help, but I don't quite understand what you want. The error you refer to, appears when there is a null entry in a field that has the "Required "property set to True. In other words, you must key some entry into this field before the table row can be...

OK. Consider me squelched:( . You can do this from a tiny little popup form with a single command button on it. The button can be very small and have an X on it like the report's close button. The form can be stripped of Max/min and close buttons, record selectors, control box and nav buttons...

I must be misunderstanding this problem. If you have a tax code for each item, you can derive all taxes as follows: You can get the tax as follows If TAXCODE 1=No Tax, 2=GST, 3=PST 4=Both Then for GST IIf([TaxCode]="1" OR [TaxCode]="3", 0, 0.07*[ItemCost]*[Qty]) For PST...

If the item is associated with a certain code, I don't see the problem. Knowing the code, you can use an expression to get PST or GST working back from the total. I'll work it out and post my findings tomorrow.

Well, you can't "call a form from a query" as such, but you can certainly call more than one form from a command button. Now, in the table where your grits are, you may well have a column that defines grits as grain, strawberries as fruit and hamburgers as an invention of the Devil. This info...

How do you derive the total tax? What proportion is GST and what PST? Without more data, there is no point of reference.

Is "Lab2" the query to which you are sending the form's parameters? If so, it's expecting to have the parameters before the recordset is opened. If you convert the query to an SQL statement with the parameters included in the WHERE clause with the Forms!MyForm!Mycombo syntax and assign the rst...