Search results

I know it's a silly question, but I'm getting errors.:( Here's an example mini-table. Id is autonumber, Word is text(100 chrs) and count is number. A loop inside a function takes a word from the functions argument. It uses Dlookup to return the ID of the record if it's already in the table...

Hi. A form is bound to a large data table. All is working well. On the form I have a tab control and one of the tabs is called 'options'. Inside options I have a textbox which will hold a numeric value, (this is a user setting for a point over which actions will change.) This I wish to...

Hi all. Simple question, but If I run a query that looks for a serial or reference number in a table, where and how do I trap the resulting error when the number isn't found in the table? Form 1 is bound to a table. A button on form 1 launches form 2, a small dialog form with a few text...

Hi. A form is bound to a table. Each field's data is displayed in various objects such as labels, text boxes etc. The table has a field called, for example, [ID]. It has hundreds of unique records but they are not sequential as it's been sorted by another field. I may want the record...

Hi all. :) Excuse the length of this post as I'm trying to include all the necessary detail. Form 1 (a control panel / switchboard) has a series of command buttons which I wish to use to open Form 2 (where work is done) and take the user to a record which has a specific marker. Different...