Search results

Okay! In case you hadn't noticed rich and I have been exchanging (hopefully) meaningless insults for the last two pages now. This insult and subsequent curse are meaningless, and I am sorry about the fire thing. It's something that a friend of mine used to say, and I forget that that kind of...

And if you took it seriously, then that's my fault and I apologize.

Here here. Back to the matter at hand. Ahem. Rich, you're a dirty rotten no good scoundrel, and nobody likes you. Die in a fire.

Faeces? Well, I'll be darned. You spell poop different. You learn something new every day.

Feces lover! (took me a sec... had to run a spell check of feces.):D

Stupid-head! You know... it really is kinda fun.

I think this little piece of news is very interesting. I hadn't ever heard of 'the Hunt' before now. From what I understand about slaughterhouses, which is not much, the way they kill livestock is not that different from the way it looks like they kill the seals. They club the cow to stun it...

Ok, I added the SetFocus to the Code, and I am still getting the same error. Is this the right way to do this? The form is a navigator, allowing the user to move back and forth through categories and subcategories. It keeps track of the CatID of the current category. When the user clicks...

I see. Messing with the game by yourself is always fun. Don't they usually write codes like that into the game? It sounds like a strategy game. In any case, I don't think anybody on here has ever written one.

I once saw in this forum a link to a table that had instructions for referencing forms, controls, subforms and all that good stuff depending on which form you are on. I have searched and searched and I can't retrace my steps to find it again. Could someone please point me to it? Thanks. -Dave

Couldn't you just assign N/A a number, like 11? and then whereever it's going to be displayed have it switch to N/A if it's 11.

Thanks a lot man I didn't know that. I'll give it a try tomorrow.

Okay, I am heading to bed now, so I can't look at it too much tonight but I can throw out a few hints until I can check again. #name? is an error, it means your referencing something wrong. Type #name? into the help box and it'll tell you the technical reasons for it. Are you trying to...

Put the macro to open the form in the after update event of the textbox. Make sure the form is based off the query you made that refers to the textbox. Putting a query name in an event won't do anything so clear that and see if that works. -dave

When you open the combo box wizard, choose the third option, "Find a record on my form, based on the value I selected in my combo box." That does exactly what your trying to do.

Okay, right now you are using a textbox, right? That is fine. Im not sure how you want to display the information from the query, that would depend on what your doing with it. But to make the query run you have two options. 1. Have it run when they type in the box and press enter. To do this...

I still don't understand. From what I know, I don't see why you'd do that or even if it's possible. Maybe we're confusing terms here. A record is like a row from Excel, and in this case all the records for your form are coming from the table named Staff. So the table looks like this? Staff...

If I understand your question right, you're already halfway there. All you need to do is make the query with everything you want it to display, and then in the criteria reference the control on your form. So add something like this to the criteria row of your query on the MsgTxt column: Like...

So what you're saying is that you need to populate the controls with fields from two different records? Did I read that right?

Well, thanks to SJ McAbney I have a nice chart on referencing subforms from the main form and what not. I'm still having trouble making it work, so I am sure there is something that I don't understand here. Private Sub cmdNewCat_Click() Me.frmNavSNewCat.Visible = True...