Recent content by Ramzess II

Hello! Is it possible to make a reference from a code within a report to a certain field in a form which is based on query or table? Or maybe it is better to refer to that query or table this form is based on? Anyway, is it possible and if it is, - how? By now I have to open the form where...

Thank you John! This is what I was looking for. I inspected the code, and tried to understand it. Of course I can't tell you I fully do understand it and that I could write such code by myself, though I got the idea of how it was done. Thank you again!

Pat, thanks for reply. Sorry I wasn't clear explaining the thing - I called it 'status' since I couldn't find any other word for that. If that would be converted to english language then it would be like Avotu primary school Sidgundas primary school Turaidas primary school Ozolu high school...

Hello! There is this report based on query. And there is one field which may contain school names (where one word represents a school status), as well as it may be empty. school names (in Latvian) are like: Avotu pamatskola Sidgundas pamatskola Turaidas pamatskola Ozolu vidusskola Irbes...

WayneRyan, Thanks! That explains a lot and solves my problem. Really - thank you!

WayneRyan, Thank you! I had to know that... it really is so simple... I am ashamed :( anyway... do you know how to solve that other problem?

Hello! I was wondering if somebody could help me on this: I got this expression in control source of an unbound text box in a report: ="Phone: " & IIf([schGSM] Is Null;"";[schGSM] & ", ") & IIf([schPhone] Is Null;"";[schPhone]) As you see it concatenates two fields 'schGSM' and 'schPhone' and...

You see Rich, the actual reason why I need this code is to print the defined number of posters for each record I have in this form. Though since it is possible that for some records it is not necessary to print posters, at this stage I open the form, go to the record for which I need to print...

Rich, it still asks me to enter this schID value as I press the button on my form. Now I reduced the code to this: Dim Copies As Integer Dim RepName As String Copies = Me.psbPostersCnt RepName = "rptPosters" DoCmd.OpenReport RepName, acViewPreview, , "[schID]=" & Me![schID] DoCmd.PrintOut...

Hello! I put this code: Private Sub Command40_Click() Dim Filtrs As String Dim Copies As Integer Dim RepName As String Filtrs = "(((tblSchools.schID)=" & CLng(Me![schID]) & "))" Copies = Me.psbPostersCnt RepName = "rptPosters" DoCmd.OpenReport RepName, acViewPreview, Filtrs...

Maybe this should be moved to Reports forum, I don't know. Anyway I guess it is not that hard to manage, the thing is I always stuck on such small things. Probably because I am not a progammer but an artist :)

PrintOut many copies of filtered records? Hi, There is form based on query. When I click a button in a form (with many records of course) this code in buttons OnClick event is executed: Dim filtr As String Me.Refresh filtr = "(((tblSchools.schID)=" & CLng(Me![schID]) & "))" DoCmd.OpenReport...

Malcy, thank you for your posts... I already made a wee dB with such structure as well, so I can post it to you and you don't have to make it from zero, but it seems you already did it. Anyway, you see, the reason why I export the resulting table to excel is because I dont know how to make it...

Well, whether I didn't fully understand your solution or it is not what I need, that is why I made this explanation material in Excel. See attached file. Since I am not good at this I might think this must be very easy to make it work the way I need, though may be it is different. Please help if...

Ok, thank you. I will try that tomorrow. Probably that might work. I will let you know if so.