Hi people,
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
This doesn't seem to work by the way!
Really appreciate all of your help.
Hi people,
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
This doesn't seem to work by the way!
Really appreciate all of your help.
I am using Access 2007 and 2010. I would like a text box (or label) on a report to autofil using fixed text from a label on a different (closed) form.
View 8 Replies View RelatedIs 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.
how can i disable a textfield or two in a form when the textbox is unchecked also how do i add a default value for it while the textbox itself is disabled, can i get away with it by adding a default value on the textbox?
View 14 Replies View RelatedDoes the MS Access Report support Hide/Show specific fields according to parameters or even by click?
View 3 Replies View RelatedI have an odd thing happening with my reports. There is a main report that gives class information (from query). There are two subreports (from queries also ) with scores (one for each type of test). There are some unbound controls on the main form that display a count of how many scores are recorded which are totals from the subreports. The controls all report the correct numbers however, when I scroll down to view each record, some of them change to #error, or #name, or similar for a moment. Sometimes they will stay in error form when I stop scrolling but change to correct if I scroll up just a bit. Is this because the controls won't calculate unless that report record has focus?
View 1 Replies View RelatedI have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:
Code:
Me.txtAddrMainLine2 = "NAME " & UCase([Forms]![frm_OrderRx].[txtPatientName])
This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.
I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.
I have imported a link table into access.
The Year field I wish to search on is Text.
I have entered a wildcard before the year i.e *2003 within the criteria, but still cannot read the number.
Can anyone suggest anything?
what code do I need to put behind my txt fields on my form so that it automatically writes to the relevant table?
Also, how do i program an unbound txt field on a form to link to a field in a table?
many thanks in advance, Steve
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!!
Thank you in advance
I have many rows of information i am entering in access. I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row.
Hi all,
I have been given the task of cleaning up an old db. One thing I'd like to do is combine 3 text fields into 1 new field.
In the old db there was a form that included 3 memo text boxes, when the first one was full the user then started using the second and then the third. The relating Table fields are message, overflow message & overflow message extended.
I'd like to combine the fields into 1 and then design a new form to suit so that the memo text in the new db goes into 1 field only.
I have many rows of information i am entering in access.
I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
sorry cannot explain very well
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row
Just say I want to summarise in a text box the options given in three option groups.
For instance I have chosen A then B and then C and then in a text box I want to put ABC.
Do I need to set up a query to do this? or do I need to write some code?
Can anyone tell me how to count (sum) text fields. My current query will search for:
1) Name
2) Ticket Number (ww*, beginning of one type of ticket)
And it works fine except that after running the query I have to manually add up how many of the ww tickets each person wrote. Is there a way to make it change the ww* tickets to a number, like 1, so that it can be added up or to add up by the persons name how many tickets they wrote. I'm using Access 2000.
Thanks
Hi All,
I have a field with a bunch of records. All is formatted the following:
CAN-2007-US-00001
CAN-2007-US-00002
CAN-2007-US-00003
CAN-2008-US-00001
CAN-2008-US-00002
CAN-2008-US-00003
and so on and so forth. Is there a way Acess can break the fields out? I want 1 field with CAN, 1 field with the year, 1 field with US, and 1 field with the number (4 different fields broken by the hyphen).
I can do text to column in excel before I import, but just wondering if it can be done in Access. Thanks in advance, guys...
Caliboi
I have text boxes that combine two fields into one, for example the control source is =IIf(IsNull([BuckC])=True And IsNull([BoostC])=True,"",[BuckC] & " , " & [BoostC]) . For simple its just =[Buckc] + ": "+[BoostC]. I am trying to set a condition that if one of them exceeds a certain number the background color will change to yellow. I know how to do this if its only for one field but I am wondering if it is possible to do it with multiple fields?
View 9 Replies View RelatedI 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!
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!
Kelly Jo
I have a need to take two fields and make them appear as one with the first one bold and the second one nonbold.
The text needs to look like:
FOOD tomato
HOUSING STYLE log cabin
FISH cod
COLLEGE DEGREE BA - Biology
These are all from the same table, two fields (type, value)
To have a report look like this I figure I need to know the width of the first field and then position the second field near that position.
Any ideas.
Thanks
Hi,
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.
Thanks
Eddie.
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
How can I change the code to get it working?
I have a main report which has a subreport. On the main report I have txt fields that I want to change their background colors based off values in fields on the sub report.
Thanks
Jon
:p Hello,
I am wondering if anyone can help me create a query (which is used as a basis for a report) using a criteria which is clever enough to know that if all fields are have an N (no) that a report should not be generated - but with anything else e.g. all Y's or a mixture of Y's and N's that a report will be printed. There are 6 columns where there could be a Y (yes) or an N (no) and I would really like to know if this is possible in access??
Thanks.
I am really close to finishing up my report. But, as I had discussed in an earlier posting, I keep coming up with an error "#name?". I believe I am getting the error because I have reached some kind of maximum amount of fields aloud for a report. Does anyone know how many fields can be added to a single report?
I am going along, copying one field to the next, with a minor change to each new field, and then all of a sudden I start getting the error message.