I looked through your forums and didn't see this question answered. Forgive me if it is already there and I couldn't find it.
I have a report that I want to add a new text box to. When I create a form there is no problem choosing the different control sources of data that I want to put into the text boxes on the report. However, once I have created the report I can't seem to go back and make the data come through correctly if I am adding a new text box.
Example: I want to add a text box that is pulling through data from a field named "Duty" in a table named "Container_Vendor_Information". I put the text box into the created form and navigated through the control source choices to get the text box to point to where I want it to. Something goes wrong after that. When I close the form and try to reopen it I get a pop up box that is asking me to enter the parameter values for "Container_Vendor_Information."
I know there has to be an easy way to do this. All I'm doing is looking to add a new text box to an exsisting form. Any thoughts would be most welcome.
I would attach the database but I guess I don't have enough posts yet to have that option.
Hello everyone - what I have is a a set of default text's that I need to be able to insert into a memo field - this is how I've set it up (Access 2000)
A table with the text fields in it called wordings table comprises of Id field wordingnme (txt) wording (Memo) and I have a combo box on a form which looks up the wordingnme and hold this info - I need to have a button that will take this wordingnme and insert the wording that it relates to into the field of my record - Called Endor (memo)- I will have many text s say upto 50-60 but when I insert these into endor field I will probable only use say 5 or 6 at any one time on the record line so an example follows
line 45 in endor I wish to insert wordingnme "A" and then Wordingnme "B" I also will do some free form type within this - any idea's :eek:
I have a strange problem, I have created this query:
INSERT INTO WEEKONE ( Assigned_To ) SELECT QPTActions.Assigned_To FROM QPTActions WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006');
It works, but it inserts Numbers into the Assigned_To column in the table WEEKONE. When I looked in the QPTActions database the values are text but the type of column was originally set to Number. I changed this to Text but its still inserting Number values into the destination table. How can I fix this?
I have a field and in front of all records in this feild I would like to add a fixed text. e.g. if the record is XYZ i want to add abc in front to make it abcXYZ. Sorry newbie here. ThaNKS
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.
I've got a table - "Products" - in my database, with a text field - "Info" - which contains info about products.
Within this field I would like to have footnotes. To do this, I think the best way to do it is by putting numbers inside the text at the location of where I want the footnote to refer to. These numbers will actually be foreign keys to a table called 'Footnotes'.
I can then program the forms and reports to show any numbers as superscripts or whatever.
(Of course, if the user will actually want to insert a number into the text field which is NOT a reference to a footnote, I will have to make a workaround e.g. by making access put a symbol in front of the number, so access will know the number is just part of the text (and I will program the form to not show the symbol in front of the number)).
Is it wrong to have foreign keys within a text field? I think if executed correctly, it should work perfectly.
I have a form which gets information from the user and upon pressing a button I produce address labels for the user. The form calls a report which does the job. This works. Now the user would like to have parameters like fonttype, fontsize and fontcolour together with margins, row and column space so that the output can be better tailored to his needs. I have inserted combo boxes on the form to get these parameters from the user, but how am I going to insert these parameters in the report layout through programming. What should be the approach?
I have a specific form, paper version, that I'd like to reproduce in an Access report. This form, which has 34 blank lines in the paper version, is used when people need to borrow some Tools or Equipment on a short period of time.
My report is made up in Access, but, if a person signs for, lets say, three different piece of Equipment, once it is sent to the printer, it prints three lines, which are the equipement signed for and it leave a big empty space before it reach the page footer.
What I need is something that will fill that empty space with blank lines. I found the following on the Net which meets my needs up to a point. What I mean is once it print the last line, it keeps on printing the last line until it meets the total count of 34 lines.
Here what I found on the Net: (note that I have a =count(*) into the Group Header)
Option Compare Database 'Use database order for string comparisons Option Explicit Global TotCount As Integer ' Call the SetCount() function from the group header section's ' OnPrint property using the syntax: =SetCount(Report)
[Code] ....
I submitted an attach file (blank_lines.gif) to show you what I end up with.
I am inserting a logo in jpeg format to a report. unfortunately the logo comes in very large. the frame around the logo can be adjusted but the image does not; it remains large.
I have been sending plain text emails for a while, but now I have a project where the formatting of the text needs to be specific and I need to send as rich text.
I can use the rich text from a table, excel, or word, but I am at a loss on how to get the data to Lotus Notes.
I have a form with 15 unbound text boxes (daily temperatures) and what I am trying to do after entering the temperatures into the text boxes the user clicks an add button which will add 15 new records into the temperature table
Is it possible to use find and replace to modify text in report design - or else is there something else I can do to get the same effect? I have a really useful report and I want to modify it for use with a different dataset. To do that I will need to change the text in over 150 text boxes. I have seven different fields which each occur over 20 times in the control source formulas in the text boxes, because they are used in different ways in different calculations. If this was excel I could do a simple find and replace to change e.g. every reference to fieldname OLD to fieldname NEW, but I cannot see how to do that within access report so am haveing to click on each text box in turn, go to properties and edit the text box .
I am trying to switch to a more general naming system in the modified report so then I will be able to assign data with the required fieldnames for the report within a query. But the report I am starting with has field names based on years 2013, 2014, 2015 etc.I want a quick way to change each reference to those field names to my more generic new field names.
I have a report that is opened from a form and is based on a query. There are three text boxes. The first two text boxes come from the query and their values are ratios computed in the query. The value for the third text box is based on the values in the other two. If the value in the first text box is greater or equal than .95 and the the value in the second text box is between .90 and .95 then the value for the third should be .03. If the value in the first text box is greater or equal than .95 and the the value in the second text box is greater than .95 then the value for the third should be .05. If the first box value is less than .95 and the second text box value is less than .90 then the third should have a value of 0. I have tried several If Then.. statements in the On Click event of the command button in the form and a Select Case in the On Format event in the Report Section but it never works. If anybody could help me with this problem it would be greatly appreciated!!
I have a report in an Access file that someone created for me. I have NO real experience in Access, it was all done for me, and now I want to do some editing. What I have is a letter with "letter head" at the top (text box 1.) This text is centered. The date (text box 2),then body of the letter follows in the main larger text box 3. This text is left justified.
When our Principals change I need to change the first text box sometimes this means there are more or less lines in this box. I have done this successfully, although I'm not sure if it was "correctly" I have replaced names, and made the box smaller to get it to wrap so there is the correct amount of text (Name) on a line. I'm not sure what I would do if I had a line that I don't want to wrap that is longer than the line I do want to wrap. but that is working for now.
The first thing I'm trying to do is put the date in the third larger text box instead of a seperate box. To do this I figured I needed to add a blank line before the first paragraph of the 3rd text box, then enter the current date code. I tried to copy and paste the code from its current seperate box and paste it into the third box, but then the report only shows the code/no date and the following paragraph isn't aligned properly since the only way I could figure to move it down was with spaces. I tried ctrl/enter, and that just gave me some pop up dialog box with some tools in it that I don't know what to do with.
The second thing I wanted to do is bold only part of the text in the large/3rd text box.
Some how I ended up with some blank space between 2 paragraphs so what I did to get the bolded text paragraph I want is add another text box, bold it and place it on top of the existing larger text box, but I always have to move the 2 boxes (3 if you count the date) when I need to shift the text up or down for any adjustments I do in the first box. Is there a way to only bold one paragraph of a larger text box? I have tried different things, and I have searched "help" as they like to call it, but it is NOT! I hope this is clear. TIA Susan G
P.S. I have tried different things, and I have searched "help" as they like to call it, but it is NOT!
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer) If txtFireType = "N/A" Then txtFireType.Visable = False End If End Sub
Hi! Don't know if you remember me, but I'm back again with a weird question.
A while ago, I built a database with a report in it that served as a schedule for my hospital. Names down the side, dates across the top, with counts in the data fields. Like if So and so works on 3/16/05, there would be a '1' in the field at the intersection of that date and her name. Now, because we have so many different shifts and the directors want everything in the grid fields, I'm trying to figure out a way to put in the actual shift symbol (7A, 7P, 12, D, E, N, etc.) in the grid for them so that if they have 7 nurses on the 7A shift and 3 paramedics on the 12 shift, and one unit secretary on the D shift, they will all show on the same schedule. Here's the data from the query I am using. It's a crosstab query and I'm not quite sure how to tweak it to get it right. Thanks for any help/advice you might be able to give me.
PARAMETERS [Forms]![frmDates]![Date] DateTime; TRANSFORM Count([Staffing Query for Department].Title) AS CountOfTitle SELECT [Staffing Query for Department].ERName, [Staffing Query for Department].Department, [Staffing Query for Department].Title, [Staffing Query for Department].Shift, Count([Staffing Query for Department].Department) AS [Total Of Department] FROM [Staffing Query for Department] GROUP BY [Staffing Query for Department].ERName, [Staffing Query for Department].Department, [Staffing Query for Department].Title, [Staffing Query for Department].Shift PIVOT "d" & DateDiff("d",[Forms]![frmDates]!Date,[Date Scheduled]) In ("d0","d1","d2","d3","d4","d5","d6","d7","d8","d9","d10","d11","d12","d13","d14","d15","d16","d17","d18","d19","d20","d21","d22","d23","d24","d25","d26","d27");
I am going to try an Iif statement and see if it helps. Thank you!
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer) If txtFireType = "N/A" Then txtFireType.Visable = False End If End Sub
I have a report and want to set the value of a text box to a value from a query (Field "Week1Start" from Query "qryWeekDates") that is not part of the record source of the Report.
I have tried setting a On Load event:
Private Sub Report_Load() [Text70].Value = qryWeekDates!Week1Start End Sub
Not sure if this is possible but I have a few text boxes on a report set to vertical yes under properties. They print fine, but on the pre-printed forms I'm using they print upside down. Is there a way to realign they way the text prints when using the vertical yes setting? I really need they text to be inverted. I'm I asking an impossible question? Thanks..
In my database I would like my report to run every 30 seconds and export that data to a text file. I am not sure if that is best with a Do While or Do Until.
What I am looking to accomplish is to populate a map with data from the data base report. it needs to rerun the report and write the text file every 30 seconds to 1 minute.
Any help with the coding would be greatly appreciated.
I have a date field in a form which is not compulsory.
I then pull this date field into a query to create a report.
If the date is not entered then is it possible for "Date not entered" to be written into the report automatically. I have tried playing around with nulls but have had no luck.
