Search results

Thanks for the quick answer. I tried that code, but I receive an error. I don't have any controls on this form, Presently, my form only has labels and textboxes. I've tried making changes to this code, but I'm stuck.

Hello, What is the most efficient code to set all fields within a from visible = False? Thanks for your assistance!!

I've done everything you've recommended. Your last paragraph is what created my question regarding field collection. I have everything working like the client requested. Thanks for your assistance!!

YOU'RE GOOD!! That was it. Thanks!!

How would you recommend to do this. Let me give you the full scoop. Table A contains a list of topics. Table B contains inventory items. Each inventory item record will have a true/false field based on the topics within Table A. If the end user adds more topics, how is the best way to get the...

Using a variable as a field name, I'm unable to get this query statement to work. I've manually entered the statement into the query design, and I receive the same error of "data type mismatch in criteria expression." Here's the vital info: This is the SQL statement that was created within the...

Thanks guys for the discussion. Here's the reason why. I have a table which contains a list of topics. These topics are then used within a data record as a yes/no response. The DB user will be able to add more topics. I need for the code to evaluate the number of topics, and then have all of...

I'm trying to learn using the fields collections. If I have a table, I'd like to retrieve the count of fields and retrieve the name of each field.

Thanks, I'll take it under advisement.

I have a table that contains options. For this example, let's use colors. The data within this table is edited by the end user. I have a form that has check box options based on the colors within the table. Is it possible for the form to be created dynamically based on the color options. Meaning...

Never thought about a global variable. Thanks!!

Here what's I have so far: within my modal form, this is what my variable looks like after selecting 3 states: strcheckbox = (((ARCustomer.State) = "AZ")) or (((ARCustomer.State) = "MN")) or (((ARCustomer.State) = "TX")) On the main form, this is my string for make table: strqueryexport =...

I'm creating a form for the user with 4 selections. These 4 selections will create a variable used in a docmd.runsql make table statement. For the user. 3 of the selections are combo box fields. The 4th selection is named state, and it opens a modal form with all 50 states displayed as a check...

I'm needing to concatentate that variable into a query statement.

It's not a control within the modal from. I'm having to create a variable based on multiple selections by the user.

I'm trying to pass a variable from a modal form to the main form. In my main form, I'm using this command to open the modal form: stDocName = "testselection" DoCmd.OpenForm stDocName, , , , , acDialog, stLinkCriteria After I've made my selections on my modal form, A variable is assigned...

Thanks Bob, that's exactly what I needed.

What code should I use to confirm that at least 1 check box is selected?

Thank you everyone for providing a solution. Based on my form, I decided to use Bob's code. It worked perfectly!!

On a form, I have 20 checkboxes for user to select from. I need a command button that will allow the user to click on this button, and all the checkboxes are selected. I've read where I can use collection controls, but I can't figure out the code.