A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Reload this Page from text to combo
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

from text to combo


« Previous Thread | Next Thread »

 
 
Thread Tools Display Modes
  #1  
Old April 6th, 2006, 08:18 PM posted to microsoft.public.access.forms
brown_eyes
external usenet poster
  
Posts: n/a
Default from text to combo
I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
  #2  
Old April 6th, 2006, 10:17 PM posted to microsoft.public.access.forms
Ofer
external usenet poster
  
Posts: n/a
Default from text to combo
What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
  #3  
Old April 7th, 2006, 02:44 PM posted to microsoft.public.access.forms
brown_eyes
external usenet poster
  
Posts: n/a
Default from text to combo
Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

"Ofer" wrote:

What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
  #4  
Old April 8th, 2006, 10:17 PM posted to microsoft.public.access.forms
Ofer
external usenet poster
  
Posts: n/a
Default from text to combo
What is the code you are using to run the report?

--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

"Ofer" wrote:

What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
  #5  
Old April 10th, 2006, 02:44 PM posted to microsoft.public.access.forms
brown_eyes
external usenet poster
  
Posts: n/a
Default from text to combo
I don't have a code. I am not experienced with Access. Don't know much
about coding. What I did is, I pull the report by a query by form. However,
when I enter the criteria on the query it changes and adds more rows and
columns. The SQL is huge because of it. But it pulls the information that I
want. It just does not work using the combo boxes. Here is the SQL:
Its huge I hope it does not scare you!!

SELECT DISTINCTROW [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [sum of Num_Apps]/[sum of total] AS Yield, [Inst Base
Data 1-19-06B2].City, [Inst Base Data 1-19-06B2].State_CD,
REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc, [REF_Minority Serving
Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
FROM [zHealth Advisor] RIGHT JOIN ([zMCAT Contact] RIGHT JOIN ([US New
Selectivity 2005 Query] INNER JOIN ([REF HBCU] INNER JOIN ([REF_Minority
Serving Institution] INNER JOIN ([REF_Hispanic Serving Institution] INNER
JOIN (REF_Region INNER JOIN ([Apps Total query] INNER JOIN ([Inst Base Data
1-19-06B2] INNER JOIN REF_Carn_Class ON [Inst Base Data 1-19-06B2].Carn_CD =
REF_Carn_Class.Carn_Class_CD) ON [Apps Total query].IPEDS_CD = [Inst Base
Data 1-19-06B2].IPEDS_CD) ON REF_Region.Region_CD = [Inst Base Data
1-19-06B2].GeoReg_CD) ON [REF_Hispanic Serving Institution].HispServInst_CD =
[Inst Base Data 1-19-06B2].HispServInst_CD) ON [REF_Minority Serving
Institution].MinServInst_CD = [Inst Base Data 1-19-06B2].MinServInst_CD) ON
[REF HBCU].HBCU_cd = [Inst Base Data 1-19-06B2].HBCU_CD) ON [US New
Selectivity 2005 Query].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON
[zMCAT Contact].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON [zHealth
Advisor].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD
GROUP BY [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [Inst Base Data 1-19-06B2].City, [Inst Base Data
1-19-06B2].State_CD, REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc,
[REF_Minority Serving Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
HAVING ((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main
Menu]![filter1]) AND (([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main
Menu]![filter3]) AND ((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4])
AND ((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR ((([Inst
Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR
(((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter3]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null))
ORDER BY [Inst Base Data 1-19-06B2].IPEDS_CD;

"Ofer" wrote:

What is the code you are using to run the report?

--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

"Ofer" wrote:

What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
  #6  
Old April 10th, 2006, 08:39 PM posted to microsoft.public.access.forms
Ofer Cohen
external usenet poster
  
Posts: n/a
Default from text to combo
If in the combo box row source you have something like

Select Id, Description From TableName

Then try and remve the id field if your filter is based on text
Select Description From TableName
=============================
Keep in mind that it's not wise to keep the text value in the main table,
you should store the Id, and that incase you change the description of one of
the records you want need to update the main table with the new value.

--
HTH, Good Luck
BS"D


"brown_eyes" wrote:

I don't have a code. I am not experienced with Access. Don't know much
about coding. What I did is, I pull the report by a query by form. However,
when I enter the criteria on the query it changes and adds more rows and
columns. The SQL is huge because of it. But it pulls the information that I
want. It just does not work using the combo boxes. Here is the SQL:
Its huge I hope it does not scare you!!

SELECT DISTINCTROW [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [sum of Num_Apps]/[sum of total] AS Yield, [Inst Base
Data 1-19-06B2].City, [Inst Base Data 1-19-06B2].State_CD,
REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc, [REF_Minority Serving
Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
FROM [zHealth Advisor] RIGHT JOIN ([zMCAT Contact] RIGHT JOIN ([US New
Selectivity 2005 Query] INNER JOIN ([REF HBCU] INNER JOIN ([REF_Minority
Serving Institution] INNER JOIN ([REF_Hispanic Serving Institution] INNER
JOIN (REF_Region INNER JOIN ([Apps Total query] INNER JOIN ([Inst Base Data
1-19-06B2] INNER JOIN REF_Carn_Class ON [Inst Base Data 1-19-06B2].Carn_CD =
REF_Carn_Class.Carn_Class_CD) ON [Apps Total query].IPEDS_CD = [Inst Base
Data 1-19-06B2].IPEDS_CD) ON REF_Region.Region_CD = [Inst Base Data
1-19-06B2].GeoReg_CD) ON [REF_Hispanic Serving Institution].HispServInst_CD =
[Inst Base Data 1-19-06B2].HispServInst_CD) ON [REF_Minority Serving
Institution].MinServInst_CD = [Inst Base Data 1-19-06B2].MinServInst_CD) ON
[REF HBCU].HBCU_cd = [Inst Base Data 1-19-06B2].HBCU_CD) ON [US New
Selectivity 2005 Query].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON
[zMCAT Contact].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON [zHealth
Advisor].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD
GROUP BY [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [Inst Base Data 1-19-06B2].City, [Inst Base Data
1-19-06B2].State_CD, REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc,
[REF_Minority Serving Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
HAVING ((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main
Menu]![filter1]) AND (([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main
Menu]![filter3]) AND ((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4])
AND ((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR ((([Inst
Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR
(((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter3]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null))
ORDER BY [Inst Base Data 1-19-06B2].IPEDS_CD;

"Ofer" wrote:

What is the code you are using to run the report?

--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

"Ofer" wrote:

What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


"brown_eyes" wrote:

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
  #7  
Old April 10th, 2006, 10:12 PM posted to microsoft.public.access.forms
guido via AccessMonster.com
external usenet poster
  
Posts: n/a
Default from text to combo
Check the name of the combo boxes to make sure they have the same names as
the text boxes. The query is expecting the names to be filter1, filter2, etc.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200604/1
  #8  
Old April 11th, 2006, 07:26 PM posted to microsoft.public.access.forms
brown_eyes
external usenet poster
  
Posts: n/a
Default from text to combo
They all have the same name as the query. My problem now is that it only
works once. Just to run the first report. I can run the report using the
combo boxes in any combination but only once. If I want to run another
report I have to close the form and open it again to get it to work again.
Is there something in the form's properties that can fix this problem?
Thanks for replying!!

"guido via AccessMonster.com" wrote:

Check the name of the combo boxes to make sure they have the same names as
the text boxes. The query is expecting the names to be filter1, filter2, etc.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200604/1
  #9  
Old April 13th, 2006, 04:22 PM posted to microsoft.public.access.forms
guido via AccessMonster.com
external usenet poster
  
Posts: n/a
Default from text to combo
I'm not sure exactly how it is set up. If the form opens a report, then you
need a requery button that closes the report and then opens it again after
you change the criteria;

Private Sub btnReQuery_Click()
DoCmd.Close acReport, "My Report"
DoCmd.OpenReport "My Report", acViewPreview
End Sub

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200604/1
 



« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking text boxes Volunteer Mom Publisher 7 November 12th, 2008 01:29 AM
Need Feedback on table setup Little Penny Database Design 1 December 28th, 2005 11:32 AM
Newbie Looking for Help Little Penny Using Forms 6 December 27th, 2005 08:33 PM
Add New Field to DB Karen Database Design 7 October 19th, 2005 08:03 PM
Change font of part of text John Powerpoint 7 March 15th, 2005 10:10 AM


All times are GMT +1. The time now is 05:40 AM.

Feed Icon - Contact Us - OfficeFrustration excel & word help home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.