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...

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...

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...

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...

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...

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...

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...

Greetings! Most likely it's simple one. I have table with many different fields for parts of an address, like city, parish, street, region etc. For each record some of those fields would be empty, others filled. At the end what I need is to combine all those fields together into one, so making...

Greetings. Is it possible in MsAccess, to make thing like this: I have a table with number of records, each record consists of many fields and one of them is check box. I'd like to open this table via form in way of continious form or in datasheet view, and to have records where check box is...

Greetings. I can't understand how to do this most likely simple thing: I have a query, based on table, where I have 7 fields for entering address, like street, city, parish, county, post office, zip & country. For many records some of those fields will be empty, like Brown street, Moscow, -...