Search results

How does that work...my qry skills don't go beyond qry wizard ;-))

Hey everyone, I'm playing with my DB a bit and I need help in determing which way to go. When I print out labels for Envelopes or directly on envelopes, sometimes I have people living on the same address (a family), so I would like to save some on printing and actually sending several envelopes...

Well, the query gives out good results into a temp table, which I use for a report...so I don't know...

Well...it's seems that everything had to do with paper size...it's all right now...though I still don't get it why it makes 2 pages with same name...anyways... I guess it's better to spend some time thinking than to start a new thread ;-) D

Dear reporters ;) I'm having some problems with printing out addresses on envelopes... I've made 3 reports for envelopes, depending on the envelope size...now usually what I get out when I hit print report is: first record on envelope blank envelope first record again blank envelope second...

Well, it is unchecked...but I'm having the same problem...not until I open my Microsoft Outlook (and Not outlook Express) that my e-mail are sent out. My outlook express being opened or closed doesn't help with sending out e-mails. Weird :eek:

Tnx I'll try that...it's funny how it opens new e-mail form but doesn't wanna send it.

I'm having the same problem...now, I've been using Outlook Express until now, and now when I opened Mic Outlook, it sent out 30 e-mails (from my testing period :rolleyes: )

I have the same code for select all...but what happens is that I see all the addresses selected, but actually not transffered to the e-mail program. If I manually select all the addresses then everything's OK. What might be an isuse here?

It seams that the second sub form had it's data property set to an SQL instead to the form that I'm using already...so now I can see it all the time...but still no editions allowed. And it's not about the allow editions property...cause even if you don't allow it, you can still set your cursor...

I moved this to it's own thread since it wasn't the same question as was posed by the thread creator. Pat Not really the same issue but I thought to save us all from another thread...I have three subforms on a main form which are linked master/child. When I go through records on my first sub...

I would like to make a button which would select all the entries in a list box...but I'm not sure how to. is its with me.lstbox.itemselect or me.lstbox.selected or something else tnx D

One more question...what if my Primary Key is not an AutoNumber but just a Numb, is it possible then to do the same thing. My problem is that I want to show all records in my first subform and not only those who are chosen by the recordselector from the main form. If this has any sence, or in...

Can you just check out the link you posted...all I get is Microsoft web site...tnx D

str1 = "SELECT DISTINCT tblUsers.Email,tblUsers.Ime, tblUsers.Prezime..." - this a long SQL string str2 = Nz(Forms!frmMain.txtSQL, "") b = InStr(str1, "order") If Len(str2) = 0 Then b = InStr(str1, "order") str1 = Mid(str1, 1, b - 1) str2 = " where email <> ''...

Yes, I am constructing the SQL statement..and it works great...the thing is that I need that same SQL st. in another form so I'm using a hidden text box to store my SQL string and use it elsewhere...a long way around

BUT...there's always but at some point, isn't it...now I get another error, and that is ONLY when I switch to design view and back again to normal if I am at my form where the code is (the one we just discussed above). it says invalid procedure call or argument ...and it's refering to the...

Yep... thanks a lot though I'm still not sure where could I have stored that string so that I don't get that error.

It seems so...anyways, thanks a lot for all your help guys...see ya around

No, the error apears when I open the DB and then highlights this line, and I knwo why...because it is assigning str2 a value which is still Null at the moment the db is opened...so I need to define either str2="" or txtSQL.value ="" at some point, but not sure where. D