Search results

That worked great! Thank you very much jketcher

The 'All' selection worked perfectly. But, the Else condition did not work. This is my code. When I used the form it ignored my selection and gave no results. I tried putting brackets around the combo box field Me.[Type_Inst] and that did not help. Any other ideas of what might be wrong? Thank...

Need help with this. Getting errors every time I run it. I am selecting a text "1" or "2" or "3" or All from a combo box. I started out coding this directly in the query but ran into problems because I have five combo boxes on this form and found it easier to do VBA (I think) for combox that...

OK -- I think I understand that part. Now running into new issue. One of my five combo boxes has to check against numeric data in a table. The choices I gave (this if for college enrollment count) are: >0 <500 <1000 <5000 etc. I was hoping that it would compare equally to the data in the...

I opened your example and couldn't get it to work. Would this be easier to do in VBA? I sent a question to the VBA group. I hope it isn't a problem if I seek help in different categories for the same problem. I am having trouble with my VBA syntax and am not getting a response. Very stuck right...

Still needing guidance. One of the combo boxes has a selection of 'All'. I don't know how to express this to get it to work in the filter. Do I use a 'Dim' statement to declare a variable? Combo Box: CEO DFA All (this will be either CEO or DFA) How do...

This is now working !!:)! but have a little extra problem I need help with. One of the combo boxes has a selection of 'All'. I don't know how to express this to get it to work in the filter. Do I use a 'Dim' statement to declare a variable? I am basically selecting "CEO" or "DFA". There are only...

Thanks to both of you! Just got back from vacation. Am back at working on your suggestions today. Will let you know how it goes. I have multiple selection criteria so this could be tedious. jketcher

I am attempting to create a form that uses multiple combo boxes to provide selection criteria for a query that is run when a button is submitted. I am stuck with syntax errors and other types of errors when I create a DoCmd.RunSQL "SQL code copied from a query". I am using this as the base to...

Oh -- I am not following. Do you have an example I could look at. Would it be easier to do this in VBA?

OK -- so no one responded to this but I got it working -- to an extent. I still need some help though. How do I code or set up the combo box to work with three choices as criteria for a query? The two choices to select specific data are working but the choice to select all of the data is not...

I have a new project. This time I am using several combo boxes but will be happy if I can get the first one to work for now. It is unbound and has three selections that will be used as criteria for a query that displays output in a subform on the same form. I think this is a very basic scenario...

Thank you - it worked!

How do I set that up in my query. Is it in the SQL view?

Hi, It was suggested to me that I use the 'switch' function to translate codes from a table/query into meaningful descriptions. I do not know how to do this. Is it done at the table level or can it be done in a query? eg. 1 = public, 2 = private, 3 = proprietary Do you have some examples...

I am getting the following error message when running an append query. It only happens when I am using two of about 200 records from an existing table. The message is: 'You cannot update this field because the value you're trying to apply is not valid or would break a data integrity rule...

I changed the code a little - moved the database to the Program Files folder and it still hits the same error message. There really is a space in the code, the copy just makes it look like there isn't one. Does it make any difference that I am running in Access 2007? Recently tested code...

Thanks -- but I got that piece working. I added the Object 11.0 library and that line of code worked. I now have a new problem and I sent a message to the Forms Forum. I am now getting an error on objWord.MailMerge.OpenDataSource in the following code. Is there something wrong with my syntax? I...

Hi, I did not get a response from my last question (posed in the VBA forum also). Wondering why? :confused: The examples given to me were partially helpful but not fully applicable to this design. I have progressed a little. I hope you are still willing to assist me. Would like to get this...

Getting a compile error 'user defined type not defined' on the 'Dim objWord as Word Document' I researched the internet and found that I might have a problem with the Object Library from the References tab when the Module sheet is open. My Access installation has 'Microsoft DAO 3.6 Object...