value from combobox or user value

Hi,

I'm starting to program some forms with combobox which value is criteria for
a query. This combobox is based on a table.
I want user to select one of the value from that table (this is ok) OR user
specified criteria (* or like "abc*").

Is that possible?

Thanks karmela

Is that possible?
Yes.
Had you posted your query SQL, form name, combobox name, and and textbox
user would enter thier data then I could have edited it for you.

Otherwise maybe you can decipher this --
WHERE [YourField] = [Forms]![YourFormName]![ComboBoxName] OR [YourField]
Like [Forms]![YourFormName]![TextBoxName] & "*"
--
KARL DEWEY
Build a little - Test a little


"karmela" wrote:

Hi,

I'm starting to program some forms with combobox which value is criteria for
a query. This combobox is based on a table.
I want user to select one of the value from that table (this is ok) OR user
specified criteria (* or like "abc*").

Is that possible?

Thanks karmela

Hi,

as I see, it means combobox for values from the table AND textbox for
entering user-defined values? I though about the property of combobox Limit
to List, so it should accept user entered value.
This [Forms]![YourFormName]![ComboBoxName] I have in criteria of the query
and the same with & "*" after it, but it does not function.

karmela

KARL DEWEY pÃ*Å¡e:

Is that possible?
Yes.
Had you posted your query SQL, form name, combobox name, and and textbox
user would enter thier data then I could have edited it for you.

Otherwise maybe you can decipher this --
WHERE [YourField] = [Forms]![YourFormName]![ComboBoxName] OR [YourField]
Like [Forms]![YourFormName]![TextBoxName] & "*"
--
KARL DEWEY
Build a little - Test a little


"karmela" wrote:

Hi,

I'm starting to program some forms with combobox which value is criteria for
a query. This combobox is based on a table.
I want user to select one of the value from that table (this is ok) OR user
specified criteria (* or like "abc*").

Is that possible?

Thanks karmela

This [Forms]![YourFormName]![ComboBoxName] I have in criteria of the query
and the same with & "*" after it, but it does not function.

'does not function' tells me nothing. Is there an error message and if so
what is it?

Too many records, no records, wrong records?

Post your SQL statement.
--
KARL DEWEY
Build a little - Test a little


"karmela" wrote:

Hi,

as I see, it means combobox for values from the table AND textbox for
entering user-defined values? I though about the property of combobox Limit
to List, so it should accept user entered value.
This [Forms]![YourFormName]![ComboBoxName] I have in criteria of the query
and the same with & "*" after it, but it does not function.

karmela

KARL DEWEY pÃ*Å¡e:

Is that possible?
Yes.
Had you posted your query SQL, form name, combobox name, and and textbox
user would enter thier data then I could have edited it for you.

Otherwise maybe you can decipher this --
WHERE [YourField] = [Forms]![YourFormName]![ComboBoxName] OR [YourField]
Like [Forms]![YourFormName]![TextBoxName] & "*"
--
KARL DEWEY
Build a little - Test a little


"karmela" wrote:

Hi,

I'm starting to program some forms with combobox which value is criteria for
a query. This combobox is based on a table.
I want user to select one of the value from that table (this is ok) OR user
specified criteria (* or like "abc*").

Is that possible?

Thanks karmela

Hi,
Im sorry - SQL of the query is quite long...
When I do not write anything to the combobox, there is error message
"Property not found", I think there should be some procedure on NotInList
property, but I have no idea, what to write .... I'm not really strong in it,
it's my first db.

Thanks a lot

karmela

SELECT faktury_dodavatel.Rok, faktury_dodavatel.[SAS Ä�Ã*slo dokladu],
faktury_dodavatel.[ÄŒÃ*slo dodavatele], Dodavatele.Dodavatel,
faktury_dodavatel.[ÄŒÃ*slo faktury], DateSerial(Left(faktury_dodavatel![Datum
faktury],4),Mid(faktury_dodavatel![Datum
faktury],5,2),Right(faktury_dodavatel![Datum faktury],2)) AS [Datum faktury],
faktury_dodavatel.[SAS Ä�Ã*slo dÃ*lu], faktury_dodavatel.[ÄŒÃ*slo dÃ*lu],
faktury_dodavatel.[Po�et ks], Round((faktury_dodavatel![Hodnota
faktury]/faktury_dodavatel![Po�et ks])*Dimenze!Dimenze_ks,2) AS [Cena na
faktuře], CStr(faktury_dodavatel![Hodnota faktury]) AS [Hodnota faktury],
Round(([Dorovnaná hodnota]/faktury_dodavatel![Po�et
ks])*Dimenze!Dimenze_ks,2) AS [Cena dorovnaná],
CStr(IIf((dorovnani_dodavatel![Hodnota faktury nová]) Is
Null,faktury_dodavatel![Hodnota faktury],dorovnani_dodavatel![Hodnota faktury
nová])) AS [Dorovnaná hodnota], dorovnani_dodavatel.[Datum dorovnani],
cenik_nakup.[A cena], cenik_nakup.MTZ, cenik_nakup.LN,
cenik_nakup.Dimenze_ks, cenik_nakup.Měna, cenik_nakup.[Platnost od],
cenik_nakup.[Platnost do], CStr(Round(cenik_nakup![A
cena]+cenik_nakup!MTZ+cenik_nakup!LN+cenik_nakup!LS,2)) AS [Sou�et ceny],
Round(([Cena faktury]/faktury_dodavatel![Po�et ks])*cenik_nakup!Dimenze_ks,2)
AS [Nová cena], Round(IIf(cenik_nakup![A cena] Is Null,0,(cenik_nakup![A
cena]+cenik_nakup!MTZ+cenik_nakup!LN)*faktury_dodavatel ![Po�et
ks]/cenik_nakup!Dimenze_ks),2) AS [Cena faktury], Round([Dorovnaná
hodnota]-[Cena faktury],2) AS RozdÃ*l,
DateSerial(Left(faktury_dodavatel![Datum
pÅ™Ã*jmu],4),Mid(faktury_dodavatel![Datum
pÅ™Ã*jmu],5,2),Right(faktury_dodavatel![Datum pÅ™Ã*jmu],2)) AS [Datum pÅ™Ã*jmu]
FROM Dimenze INNER JOIN (Dodavatele INNER JOIN (cenik_nakup RIGHT JOIN
(faktury_dodavatel LEFT JOIN dorovnani_dodavatel ON (faktury_dodavatel.[Po�et
ks] = dorovnani_dodavatel.[PoÄ�et ks]) AND (faktury_dodavatel.[SAS Ä�Ã*slo
dokladu] = dorovnani_dodavatel.[SAS Ä�Ã*slo dokladu]) AND
(faktury_dodavatel.Rok = dorovnani_dodavatel.Rok) AND
(faktury_dodavatel.[ÄŒÃ*slo dÃ*lu] = dorovnani_dodavatel.[ÄŒÃ*slo dÃ*lu])) ON
cenik_nakup.DÃ*l = faktury_dodavatel.[ÄŒÃ*slo dÃ*lu]) ON Dodavatele.[ÄŒÃ*slo
dodavatele] = faktury_dodavatel.[ÄŒÃ*slo dodavatele]) ON Dimenze.Dimenze =
faktury_dodavatel.Dimenze

WHERE (((faktury_dodavatel.[ÄŒÃ*slo
dodavatele])=[Forms]![frm_Dodavatel]![Dodavatel] & "*")
AND ((DateSerial(Left([faktury_dodavatel]![Datum
faktury],4),Mid([faktury_dodavatel]![Datum
faktury],5,2),Right([faktury_dodavatel]![Datum
faktury],2)))=[cenik_nakup]![Platnost od] And
(DateSerial(Left([faktury_dodavatel]![Datum
faktury],4),Mid([faktury_dodavatel]![Datum
faktury],5,2),Right([faktury_dodavatel]![Datum
faktury],2)))=[cenik_nakup].[Platnost do])) OR (((cenik_nakup.[A cena]) Is
Null));


"KARL DEWEY" wrote:

This [Forms]![YourFormName]![ComboBoxName] I have in criteria of the query
and the same with & "*" after it, but it does not function.

'does not function' tells me nothing. Is there an error message and if so
what is it?

Too many records, no records, wrong records?

Post your SQL statement.
--
KARL DEWEY
Build a little - Test a little


"karmela" wrote:

Hi,

as I see, it means combobox for values from the table AND textbox for
entering user-defined values? I though about the property of combobox Limit
to List, so it should accept user entered value.
This [Forms]![YourFormName]![ComboBoxName] I have in criteria of the query
and the same with & "*" after it, but it does not function.

karmela

KARL DEWEY pÃ*Å¡e:

Is that possible?
Yes.
Had you posted your query SQL, form name, combobox name, and and textbox
user would enter thier data then I could have edited it for you.

Otherwise maybe you can decipher this --
WHERE [YourField] = [Forms]![YourFormName]![ComboBoxName] OR [YourField]
Like [Forms]![YourFormName]![TextBoxName] & "*"
--
KARL DEWEY
Build a little - Test a little


"karmela" wrote:

Hi,

I'm starting to program some forms with combobox which value is criteria for
a query. This combobox is based on a table.
I want user to select one of the value from that table (this is ok) OR user
specified criteria (* or like "abc*").

Is that possible?

Thanks karmela