Search results

Hello all, I have a menu form that has several cmd buttons on it. The buttons are enabled/disabled depending on the users permission level. For the admin I want all buttons to be enabled, however it appears that VBA reads the first condition and then skips the rest. Below is the code: If...

Worked like a charm. Thanks much!

Hello all, I have a form and when I double click on a field (documentID) it opens a second form which filters for the documentID. DoCmd.OpenForm "frmPBCdetail", acNormal, , "[documentid] = " & Me.[DocumentID] I was wondering if it is possible to pass a second control value at the same time...

That did it. I was looking at the wrong control. Thanks much!

Hello all, I'm trying to get a field in a form to turn the text red when certain conditions are met. I have a due date field and a received date field. I would like the text in the due date to turn red if the due date is the current day or has past AND if the received field is blank. The...

Nevermind....figured it out! Just had to give the hamsters more cheese so they'd turn the wheel in my head a little quicker... Thanks for the help.

I'm not sure what the [value] criteria is supposed to be in the example you provided? Can you clarify for me? Thanks

It tells me I can't link unbound forms...

Hello all, I looked to see if this was answered prior, but I couldn't find anything on it. I have a form with an unbound combo box and then a subform. I want to be able to select a value in the combo box and have the subform pull up the associated value and description in the subform...

Ned, the value is only stored once in a table (tblControl) and then it is a foreign key in a second table (tblPBC) on the many side of a one-to-many relationship. The query the form is pulling the data from is the tblPBC table which is why it appears more than once. Paul, the vid I watched was...

Okay....now that I've got that working I can't seem to get it to filter the records so only those associated with the control number are pulled. I looked at that tutorial on the datapig website but can't seem to make it work. Thoughts?

Actually I got it to work using pbaldy's method. There was an issue with my query that caused it to come up blank...once I fixed that it worked perfectly. Thanks to both of you for the help!

No dice...it just has an empty combo box when I try that.

Thanks...I'll give that a shot and let you know how it works out...and I can change the name...it's my dev copy of the db. :D

so I'll start from the beginning. I have a table that is on the "many" side of a one to many relationship. One of the fields in this table is named "Control Number" and that field can contain the same control number in many different records. I'm trying to figure out a good way to pull this...

Unfortunately the link wasn't much help...

Ahhh....The table is already a part of the query that is the data source for the form. I'll check the link you provided and see if that helps any.

Not sure I follow you...add the table in where?

Sorry, don't mean to hijack, but I'm having a similar issue but can't seem to get it resolved using the method above. I have a form that is pulling data from a query. When I add the field to the form from the field list, it automatically creates a combo box that populates with the correct info...

The link to MS helped me figure it out...one of the tables in the query was not joined to another table. Now I have a different problem with the way the query is pulling info because of the join. I'll see if I can figure that one out. Thanks for the help.