Search results

I have a form that with a combo box that is populated by a query. The user can select a value from the combo box which then opens a form filtered by the chosen selection. However I have noticed that the identifier field gets changed when the form is closed. I would like to prevent the...

I tried creating a new form and got the same result. Would you mind posting the one that you got to work and maybe I can figure out what the difference is. Thanks

Thanks so much for your help.

I start with the form switchboard choose from the combo box then click the button federal.

What is the process for posting the sample database?

Yes, it still gives me the Enter Parameter Value textbox.

The 1st form remains open, I used the expression builder to get the control name. I'm stumped. ??

I have a main form which has a combo box which the user selects a value. Then I have 3 buttons, depending which button the user clicks it takes them to another form that would be filtered by the selection of the combo box. I have a query set up with the criteria as [Forms]![Form1]![cbo3]...

Ken when I switch them I get the same error. Ray when I try the column set at 0 because I want the 1st column I get the error "Undefined function'[Forms]![Form1]![Combo3].[column]' in expression." What am I doing wrong?

I am trying to use a combo box and then a command button to open another form that would be filtered by the combo box on the first form. My command button macro reads where condition [Forms]![Form1]![Combo3]=[Query1]![Code] but when I click the command button I get a popup that says Enter...

I would like to copy and paste a large number of criteria in access. Is there a way to paste the criteria in without entering each one? Thanks

Can you have another column that sorts based on the absolute value?

I have full access to the access database. I have a complex excel spreadsheet that queries data from a sequel server. I would like to capture text info to supplement the sequel data. I would like to store this text data in access. Lets say you had a table with approximately 500 columns and...

Actually I am not trying to edit the query but the source data table. While I am in MS Query under records I can select allow editing which then enables me to edit the source data. However once I return this query to excel I lose this capability. I would like to know if there is a way similar...

I am querying an access table from excel using microsoft query. I have selected the option under records allow editing. While in microsoft query I can edit the source data but when I return the query to excel I lose that functionality. Is it possible to run a query on an outside source return...

A simple formula may be easier =find("corp",b1) this formula will return a value if it finds the string and #value if not which then could be eliminated by =if(iserror(find("corp",b1)),0,1) this would return a zero if the string is not found and a 1 if the string was found.

On a tax form data base partnership ownership information is entered based on ownership percentage, however if the ownership percentage fluctuates during the year they want the ability to enter "various".

Is there a data type that I can use that will handle both text and numbers such as percentages? Or is there a way I can set the field type to text then convert the text to a percentage? I plan on using this field in a form so when the user inputs the info I will want to display it in the...

That did exactly what I wanted. Thanks

I am new at this and I am a little confused. On the table where the data will go it is set to number and single. My field on the form is called text73. On the text box properties on event after update I typed me.[text73]=me.[text73]/100 I then get an error that it can't find the macro me...