Search results for query: *

Try changing the Recordset Type property of the form to "Dynaset (Inconsistent Updates)" Jeff

I had the same problem and fixed it by increasing the virtual memory on my computer. It's accessible via System on the Control Panel. Jeff

The error occurs because you're trying to set a control to a text string. Replace the line causing the error with this: Set ctlLabelName = frm("lbl" & ctl.NAME) Jeff

The easiest way is probably to create a subform which contains a text box displaying the price. Just create a form with one text box, set the control source equal to the Price field, and add this as a subform to your main form, linking on the ID field. Or, you could use a list box. The...

If you don't want to go with a snapshot format, you could use a text box in your report that displays Y or N or anything else you want to use. Use an IIf statement in the Control Source of the text box: =IIf([YesNoFieldName],"Y","N") Jeff

You could probably dump the records into a temp table, open the form based on the table, and then use event procedures as you have said to update the database. I would think the performance using linked tables would have to be extremely poor for you to go through all this trouble. Jeff

What is the structure of the field and what part are you trying to extract? You could probably write a function to get what you want in one query. Jeff

You don't have to do this with code. The following can be used in a query or a calculated control. It essentially adds 3 weeks to the current date and then subtracts the number of days since Friday. Of course, you can write a function that does this; it's not much different than MichaelRed's...

I just realized my dates are different than yours, but you get the idea. Jeff

Changing your criteria to Between #12/31/00# And #1/1/01 11:59:59 PM# should work. Jeff

I found Smith and Sussman's "Beginning Access 97 VBA Programming", published by Wrox, to be helpful. I think they have a new version for Access 2000. Jeff

I'm not sure what you mean by overlaying a mask, but you can implement an input mask on a text box so that users can only enter data with a specific format, usually used for dates, phone numbers, etc. You can find it under the Data tab of the Input Box properties, and you can create custom input...

How does this work for you: Create a new query and add your table to the design view twice. Join on all fields that you want to match on. Let's say you have Table1 and Table1_1 (this is an alias for Table1). You'll need a field such as Expr1: Format([Table1]![DateStamp],"mmyyyy") with...

What you want to do is use the same design structure as the "Find Unmatched Query Wizard", but extend it to the additional fields you want to check for. Look at the design of the query that the wizard gives you. It uses a left join that gives you "ALL records from 'table A' and...

Terry has the right idea, but the easiest way to do this is to use the Find Unmatched Query Wizard. Jeff

Set the Limit To List property of the combo box to Yes. You can find it on the Data tab. Jeff

DateValue("12/31/" & [Year])-Weekday(DateValue("12/31/" & [Year]),6)+1

Set the Page Header property of the report to "Not with Rpt Hdr"

You can use the offset property in an Excel macro: ActiveCell.Offset(rows, columns).Select for example: ActiveCell.Offset(1, 1).Select moves down 1 row and over 1 column

You could add a field to your query of the person's maximum payment due. Then in your report sort by max payment due, then by person.