Search results

Suggestion. Why don't you put a list or combo box on the form that allows the user to pick a vendor. With the use of a filter you can open your new form or report with specs for that vendor.

I typucally stay away from macro. Use the following code in the On Click event of your button Command10 is the name of the command button, so you'll have to put yours there Private Sub Command10_Click() On Error GoTo Err_Command10_Click If MsgBox("Exit program now?", vbYesNo + vbQuestion...

Here's what I have on one of my forms. It warns the user when an item is not in the list and allows the user to add a new item or go out and clear the box. Set Limit to List property to Yes and the following code to the NotInList property Private Sub FieldName_NotInList(NewData As String...

I wonder why you want to split up the table if you "only" have about 60 fields. There is no immediate need to do that.

I have a form that has a list box and several textboxes. Clicking on a person will display his/her info in the textboxes. When I open the form though it displays the info of the first record. I like it to open with a new record. If I set the DataEntry property to Yes, it won't allow me to click...

I am using the following code to set a label to invisible if the textbox is empty. It works great for each textbox / label on the report, but the problem is that I have to set it for each one. If Me.Textbox = “ “ or IsNull (Me.Textbox) Then Me.Label.Visible = False Else Me.Label.Visible = True...

Sorry, I did use the wrong term. I was indead referring to the runtime version created with the ODE which allows you to use the program regardless of the version of Access you have. As far as I know converting into an MDE file only provides some protection, but still makes your program...

Thanks for the reply. Just as yours my code works well for a single textbox. Pat It looks like your idea of looping through the fields is the way to go. How do you set this up. Marcel

It's hard to go into details, but this might giev you an idea. In order to sell your database you will have to make an executable version. Main purpose is so that the client can run it regardless whether they have Access installed or of they do what version they have. Microsoft has a "Developers...

The following will warn you that you are entering a choocie that is not in the list. I will allow you to continue and enter the new choice. It updates the undelying table. If you do not like them to enter a new choice, just take that part out. Set the Limit To List property of your combo box to...

I usually do not post the same problem at multiple sites, but I am desperate for help. I am looking for the code that will set all labels in the section of one report to not visible when the corresponding fields are empty. The report is bound to a query populated by a form. Each form receives...

Hey there Since you both kinda hopped into this post, maybe you could help. Again I need code that will look for ALL empty textboxes in a detail section and make ALL corresponding labels invisible. I have about 20 boxes on the report and don't like to repeat the same code over and over. Actuallt...

I think I am a step furthrer. The shrink property works but I have to make the label invisible. That's no problem anymore. Need help with code that would make all labels invisible for all empty field in this form Anyone out there with suggestions? Thanks tjs206

The Canshrink property is set to yes and will do the trick if the label is set to invisible. I know how to set the code for an indidividual field, but like to have one that would do the trick for all fields that are empty on that particular report.

Still confused I have used the Grow/Shrink property before. All it does for me is to adjust the size (so there is no waisted space between the fields), but it never made the field invisible and / or move into teh space of the previous empty field. Am I missing something here?????

Cool beans Let me pick your brain now. Do you have a code that will hide all empty fields with one code or did you set a code for each one? Thanks Marcel

tjs206 I'm confused here. Did my post help your problem or did Rich's grow/shrink property work. Like to know because it does not work for me (it still leaves a space in between)

I assume your query or queries are bound to more than one table. If so did you set the relationship right?

Sorry Discovered typo. Textbox should within [ ] or not. If Me.Textbox=" " or IsNull (Me.Textbox) Then Me.LabelName.Visible = False

Here's the code the set the property to not visible. Set it on the ONFormat event of the detail section. If Me.Textbox=" " or IsNull (Me.Textbox]) Then Me.LabelName.Visible = False I did a post here to look for code that would do that for all empty fields. Look for answers. So far it works...