Search results

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.

Hello there! I got such problem - in Latvia where I live we have 7 cases for nouns. What I need is to output a date in such format: dddd", "d". "mmmm but... the result shown on the screen is "for example "tresdiena, 12. maijs"; instead of this I need "tresdien, 12. maija". So in another words...

The thing is - I don't need this data in printed version. What I need is to export this data of two joined tables to Excel, where I will work with it. Please, can anybody help me?

Hello guys! Problem - There are two tables with such fields: 1) Schools SchoolID; SchoolName; 2) Performances PerfID, SchoolID; PerfName; PlayDate; (in real life there are much more fields in each table but I skip it to make things less complicated) These two tables has a one to many...

well yeah, I am sorry - I forgot to mention that I use access xp instead of 97. Now I will notify 'bout this as a first thing.

well & is missing just in this last post, normaly I have it. But it seems I have found the problem, and as I thought it is the way you write it: so instead of =[par_id] & ", " & [par_name] & ", " & IIf(IsNull([par_name]), "", [par_name]) you have to write =[par_id] & ", " & [par_name] & "...