Recent content by Woof

Hi and thanks for the reply. It is appreciated. The only "Count" I have is a field name called Count1. There is also count2 count 3 and so on but I apprecieate the warning. They are declared at form level making them available for other functions and routines. I'm always pleased to hear...

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...

Solved. I don't know if this is the 'right' way but I added a sub form to the options tab and bount it to the ini table. If there's a better way let me know please! :)

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...

I thought my form was bound. this is the code... SELECT dbo_ExtendedIncidentDetails.* FROM dbo_ExtendedIncidentDetails ORDER BY dbo_ExtendedIncidentDetails.MI_Prinx; But there is no third option showing. I am linked to the table though.

Good morning PB and others. Another weekend gone and another Monday morning. However I still do not have an answer to my problem. I'm using Access 2003 so I don't know if the wizard for other versions is different, but I can't see "the 3rd option, find a record". I put a new combo box on my...

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...

Good morning Nick. OK, newbie ignorance here. Form Record Source? Thats where I currently have the form bound, right? I think I see.... but do you mean the calling or called form? So this is where I sort it by 'Key' too? I shall have to look up the SQL for that. When I've understood the...

Hi NickHa. I'm a self taught newbie, and I have never heard of these ideas! Well, I have heard of recordsets and enquired about them in the past but they're still full of magic smoke to me! The table with the information on it is a linked table called "dbo_ExtendedIncidentDetails". It's on a...

Hi and thanks for responding. I've edited my original post to include that bit. It's not quite as complex as your version but it passes the message along. I have identified the record by using DMax on the 'Key' column. The problem is that Dmax returns the key number, which is not the...

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...