Search results

Create a new field in your table to receive the data. Call it Place. Create an update query and drag the new field into the grid. In the UPDATE TO: line, put [C Code] & " - " & [store code]. Square brackets are obligatory!! leave criteria blank. Run the query to update the table. Edit...

Yes, you have to include the ampersand followed by the field name in square brackets. Well done.

No code is required. The Record Locks property of the Form determines how records are handled. Go into Design View of your form, select Properties, highlight the Records Lock item and press F1 for help on setting the correct choice.

Read Help on Pessimistic Locking

You didn't make it clear whether your combo has both columns (ID & FullName), but it must have for Peter's solution to work.

Open your form in Design mode. drag a new text field from the toolbox (symbol shows as ab|) This is an unbound (not stored in a table) field. Put your cursor into the right hand box of this control. (The left hand box is the label) Type in the expression, preceded by an = sign. Tab out of...

By the way, that should read "SFI" & [Autonumber Field Name]. I forgot the inverted commas. Sorry

Yes. Each record will show a change to the autonumber part, but the prefix will remain constant

If this is a fixed default prefix, you don't need to store it, as it will always appear on the form anyway. So just create an unbound calculated text box with =SFI & [My Autonumber Field Name] as control source and remove the autonumber field itself from the form

Do you mean that the query returns zero rows OR that the query returns rows where a field is blank? Please post the query with the expression, so we can advise on how to proceed.

Your report is based on a query which prompts you for an input, e.g: [ Enter a value:] to which you respond by entering LG or one of the other codes - is that correct? Let's call the field concerned MyValue. Go to Design view of the query and delete the criteria row of MyValue. This makes it...

The Set Value argument is the name of a control on a form or report, not a query. If you want to open a report with different parameters from a macro, you have to use the WHERE condition of the macro. This means writing a separate macro for each available parameter. You can use the Set...

Excuse me asking, but why don't you just run an update query?

Perhaps you should consider putting all the available values in a combo box and opening the report using the selected value in an SQL statement, on the After Update event of the combo. That's how it's usually done.

You probably aren't running out of RAM memory, but running out of system resources, which is a small heap set aside for housekeeping operations . See here foran explanation: http://www.infinisource.com/techfiles/win-resources.html

The values are retained until you change the combo, even if you go to a new record. If you want to retain the value after the combo has changed, you have to assign the value to a variable, which you later refer to in code.

You can create a small modal pop-up form that floats above the report and write code to trigger the desired actions from a button on that form.

Calculated fields are not normally stored, because any caculation derived from tables in the database can be done with queries. The tables should represent your data in its simplest non-repetitive form. You would store an item's price for example, and you would also store a specific client's...

It would make life less confusing if your table was called tblTikking and your combo was called cboTikking. Not that this helps with your current problem...

It sounds as if you have already set up the third table you require- your tables are related after all! If you have problems with linked tables, import the data as you suggest. In the Company table, CompanyID should be the PK (Primary Key). In the Products Table ProductID should be the PK...