Search results

Hello, Im linking table and generate query...tables are unicode and have č,ć,ž,đ,š When Im using StrConv query result missing only these two: Č and Ć Any help? Thanks!

nope, they are contained in a name of products. For example: I have: MENS SHOES NIKE AIR MAX With StrConv I can make: Mens shoes nike air max But I need this: Mens shoes NIKE air max

Products manufacturers, I have about 50 words in total.

Hello, Im linking to sql across ms access and I have all records uppercase. I need to set StrConv with first character uppercase and every other lowercase which is not problem. But I also need an exclude in this function to skip some words which I need to leave uppercase. Any ideas?

@Mihail @Paul thank you both. I make this thing work with a little play with code which Paul gave me. So this is how it looks like: Set ctl = Me.lstEmployees For Each varItem In ctl.ItemsSelected strWhere = strWhere & ctl.ItemData(varItem) & "," Next varItem Set ctl =...

@Mihail thank you, but I still have a problem with stop in vba. Here is a code which I use right now: Option Compare Database Option Explicit Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim strWhere As String Dim strWhere2 As String Dim ctl...

@paul If I use another query for this same table and only put id_organizacija listbox in form, query work just fine. opis_konta and id_organizacija are two listboxes which is adjusted on the same way. opis_konta work perfectly but id_organizacija wont work without enter parameter value popup...

After running with your code It bring me back in vba window with marked row Stop and this message in the bottom: strWhere = 4320, strWhere2 = TA3, FinalstrWhere = 4320 strWhere = 4320, strWhere2 = TA3, FinalstrWhere = 4320

@eugin thank you, but its not work. Still have enter parameter value and now I even cannot combine two multiselectlistboxes for reporting.

In my case broj_konta is number and id_organizacija is text I agree with you that problem is probably in this line, but Im not very good in vba. Thank you for reply ;)

I have one form which have two multiselect listboxes. They work, but every time when I choose id_organizacija from listbox popup enter parameter value comes up. Im already tried to put id_organizacija in [ ] but that didnt solve problem. Any suggestions?Thanks Set ctl = Me.lstEmployees For...

Here is(in attachment) a sample of my database and form where I begin to create listboxes.

Ok, I have a 3 tables which have their relationships. Every kind of query work perfectly, so If I choose one organization and one account number, report will came up absolutely correctly. Now I just want to put in form two or more organizations and two or more account number and got results for...

Hello, I have one table named Entry. This table have account number,work organization, price, date and etc. I use a combo boxes in form which is connected to query and I can easily choose one account number,one work organization and date to see an report. There is also a possibility to left...