When you create a column chart and then change one of the series to a line, how can you then apply formatting to that line? I've attached a stripped down database showing what I'm trying to do. Series 1 shows individual monthly values (percentages) and series 2 shows the target which is 80% for each month.
The problem is that although I can apply formatting to the column series, I can't see any way of selecting the line series so I can set the formatting I want. I'm using Access 2003, on Win XP Professional, in case that's important.
I have text in a number of fields that I want to insert into a text box on a report. The size of the text box is large enough to accommodate, but I want each line to have a linefeed (or carriage return) before it.
The report is based on a query. I created a field in the query that consists of something like:...txtText1 & CHR (10) & txtText2 & CHR (10) txtText3 AS MYTEXT.
What I did was to set the control source on the text box to MYTEXT, hoping that there would be nice linefeeds in between the fields. Unfortunately, all I got were some funny-looking boxes.
What's interesting is that you CAN insert a linefeed into a memo field and that linefeed will display properly. I just don't know how to force one in there to separate lines of text.
how to make a line break in a rich textbox in access 2007? Chr(13) & Chr(10) worked until I changed the textbox to rich, which is necessary because certain words in the textbox need to be bold.
I want to create a query that looks for a manual line break in a memo field. Is there a code or some way that I can do this? (i.e in a Memo field the user has entered some data, hit Ctrl-enter to get to a new line, entered more data on the new line. I want to find the records where this has occured)
Also, on a similar note, is there a way I can deny my users the option of doing a manual break (Ctrl-Enter) in a Control in a Form? (to prevent me needing to run this query in the future)
I am writing a book, using MS Access 2007 (seemed like a good idea at the time I started, and the report that creates the formatted book content works quite well).
The book content is "per paragraph" which gives me total flexibility to move content to whatever spot in the book I might wish, simply by changing the paragraph number (free field, not auto-number primary).
To save paper (or pages) in printing (or viewing) the book, I have the report printing off para by para (as many whole paras as will fit to a page). This is fine but I want each new chapter to start at a forced new page, for "presentation"/appearance sake.
The relevant fields for the purposes of this post are:
paranumber paratext chapternumber forcepageifticked (a Yes/No box), which goes with each paragraph and which I thought might come in handy, I had in mind to link it to a page break control at the top of the "detail" part of the report in design view, and which would be "invisible" except if the report formatting process had got to the start of any chapter, and the Yes/no box was ticked.
I have a Query derived from a single Table in Access 2010 which I routinely export in spreadsheet format.
I have now built a report from the Query in which has labels have been added to suit an external agency. I wish to export this Report in Excel format, but the resulting file does not include the additional labels and is merely an xls version of the underlying query.
Is there an alternative method of achieving what I need?
I can not get a line graph inserted into a report by using the Wizard. I have 2 columns of paired data that I want to graph. I dragged the 2 columns to the "Data" control in the wizard and changed summarizing for both columns from "sum" to "none".
When I look at the report in Print Preview, the data points are stacked vertically in the center of the graph and the "Series" box displays what looks like the data. If I add a Date/Time column as the X-axis, I am told that I have to summarize the data, something I don't want to do.
I've made various selections using the wizard and all fail.
I have created an expression in a query to create an address label. My intention is to create one that looks like: Name Address City, State Zipcode
To get the proper line breaks, I used the Alt + enter method. Though it is not visible when I look at it in SQL, the fields appear on separate lines. Here is the actual expression used: MailLabel: Nz([Title] & ' ') & [FName] & ' ' & [LName] & ' ' & [Extension] & ' ' & [ADDRESS] & ' ' & [CITY] & ', ' & [STATE] & ' ' & [Zipcode]
Problem: Sporadically, the database drops my line breaks and the expression becomes: MailLabel: Nz([Title] & ' ') & [FName] & ' ' & [LName] & ' ' & [Extension] & ' ' & [ADDRESS] & ' ' & [CITY] & ', ' & [STATE] & ' ' & [Zipcode]
The resultant entry then just wraps around, depending on the size of the column. I am trying to use this query to create labels in a Report. Any idea why the line break disappears? Any suggestion on how to better build the expression to maintain the proper line up? Thanks
I'm working on a pretty serious report (at least for me)...I have 3 sub-reports inside, and the point of this is to use VBA and loop through several conditions (in the underlying queries), and print out in a batch for the user. When I add a page number footer it adds about 3 seconds to the processing time for a 14 page report. That doesn't sound like a whole lot, but when I loop through and process this 12 times, that's a lot of added time for the user...(the last thing I want to hear is it's slow!)
So, would it be faster if I set the page numbers in VBA? What event would I use? On Load?!? Also, how would I find the page number variables in VBA?
I've got a word mail merge document that is formatted exactly how I want it. I'm using an Access 2003 database to populate the word 2003 mail merge document.What I would like is to use a access report rather than a mail merge but correctly formatting everything is going to take me forever.
Is there any way I can use the word document I already have to enforce the formatting or must I spend hours positioning each line of text by eye and guessing where on my report it must go to match the word doc?
I am trying to page break my report to have it where the first name and surname of the employee has a separate page with the details of each appointment.
I have tried to do it via format on properties but it does not work..
I have attached an image of how the report appears.
Hello all...I'm having a problem when exporting some text from Access 2000/XP to Excel using the EXPORT function. The reason why report is used to export is b'cos I need certain layout & to be ported over to Excel.
Text like '00133484-001' or '00130898-001' will be changed to another number after EXPORT, can anyone help me in this ? How can I set these numbers so that they remain the same ?
It only happens once in a while a few times in a row and then, without changing anything, it's all fine again. It does happen on other pcs as well. (It happens on Office10 and Office13)
I'm not exporting tons of data to excel just two normal-sized querys.
This is some of the VBA code:
Code: Set qdf = CurrentDb.CreateQueryDef(tmpAbfrageLehrgaenge, SQL_Lehrgaenge) Set qdf2 = CurrentDb.CreateQueryDef(tmpAbfrageKunde, SQL_Kunde) DoCmd.TransferSpreadsheet acExport, , tmpAbfrageLehrgaenge, ExcelDateiName, True
I created a report that would generate, among others, a listbox on monthly payments. How do I make it spill-over to the next page when its contents have already exceeded that of a single paper?
I have been working on this for over a week in Access 2010 and I know that I am almost there, but need getting over this last hurdle as I have a severe case of tunnel vision on this while I am trying to get it to work.
I have a Main Report based on my Element table and a subreport based on my OTC table. There is a one-to-many relationship between the Element and the OTC table.My Master / Child Fields between the two reports are as follows: ElementID;GroupNum
My SQL for the Main report is:
Code: SELECT Val(DCount("*","Element","ElementID=" & [ElementID] & " AND Step <" & [Step]))2 AS GroupNum, Element.ElementID, Element.ProcessID, Element.ModelID, Element.Step, Element.ElementDescription, Element.RevDate, Element.GPCFS, Element.TrainingGate FROM Element
[code]...
As an example in testing this report, I am looking at a specific Element with 33 records and a total of 72 OTC records. Each of the 33 records can have 1 or 2 or 3 or up to 4 OTC records but the report is only 17 pages which tells me that the page break is occuring based on the ElementID and not on the OTC records....
I have a report which is grouped by employee number - each group can have one or many records displayed - it works fine, but can look untidy sometimes when there are more records than will fit without wrapping onto another page; this is particularly prevalent when there are two or three groups - the third one may run over onto the next page, without group headers.
Is there anyway to force a page break at the bottom of a group if that group is not going to fit on the current page in its entirety?
Is it perhaps possible to "copy" the format of an entire report and "dump" it on another? I have ample of forms and reports and I know how to use the Format Painter - but I need to alter the format of all the other physical reports.
I have a module which reads a CSV transaction file line by line and adds the correct transactions to an access table and places the wrong ones in a logfile.Now some transactions are rejected twice there is even one rejected six times. Whereas one wrong transaction is processed only once. I am certainly overlooking something obvious in the logic but what. Here is the relevant code.
Code:
Function ImportCSVForConfederation(inputCSV, ORG) Dim TNO As Integer, TACT As Integer, TABLE As String, TLINE As String, I As Integer, J As Integer, K As Integer Dim FLD1 As String, FLD2 As String, FLD3 As String, FLD4 As String, LogFile As String, LogPath As String Dim Lim As String, ITNO As Integer
I searched the forums and couldnt find anything that directly related to my issue. What I am trying to do is export a fixed-width text file, but the issue is that the file has to be line feed only. By default Acces creates CR/LF and the client's import specification only allows for Line feed.
I am currently using a macro, with export specification, to create the file. Due to time constraints and other obligations, I am really trying to avoid VBA programming.