General :: Checkboxes - Create Text Field On A Report That Show All Yes Answers
Apr 8, 2013
I have multiple fields in a table that are set up as Yes/No and display as checkboxes on a form. Now I need to create a text field on a report that showes all the Yes answers. The text field needs to figure out if it's a Yes answer, then display the field name, if there is more than one yes answer in the fields it is looking at, it should separate each with a "," . This is a large text field, that could show as many as 10 Yes answers.
What is the best way to go about doing this? I use Access 2010
View Replies
ADVERTISEMENT
Sep 19, 2012
I have a combo box with the following
YES
NO
EXPIRED
this is named "Permit_Holder"
when you click yes i want two extra fields to appear called
"Permit_Date_Issued"
"Permit_Date_Expired"
but i cannot seem to get them to hide or show?
I have used the below codes but no success
Private Sub Permit_Holder_AfterUpdate()
If Me.Permit_Holder = 1 Then
Me.Permit_Date_Issued.Visible = False
End If
End Sub
Quote:
Private Sub Form_Current()
Me.Permit_Date_Issued.Visible = False
End Sub
View 6 Replies
View Related
Oct 19, 2013
I have a report and at the footer i want to show how many of the txt boxes i have are >0
i tried
=Count([txtbox]>0)
I know that this is quite simple but i just cant get it.
View 9 Replies
View Related
Aug 7, 2013
How can i put a fixed time for the current date in a text field.
So the field will be 06:00:00 for the current day when the form is open?
View 1 Replies
View Related
Jul 8, 2014
Encountered this bug in Access 2010:
1) Create a table with a single text field
2) Enter some text values, including one which begins either "aa", "AA" or "Aa" (but not "aA"!)
3) Sort the field, and note where it puts the string(s) created in (2)
For me, they appear at the wrong end of the sorted list! I have tested this in Access 2007 and 2010 and it only happens in 2010. I'm using 32 bit Access on 64 bit Win 7 Pro.
View 4 Replies
View Related
Jul 7, 2014
I have a field in a table where it is a lookup is a combo box. So this makes the data type of the field a number when in reality it is a text. When I have this field show in a list box it shows the number instead of the text.
View 5 Replies
View Related
Feb 19, 2014
I have a field on a form (exception) that is also a column in a query. I would like to create a report an only show those records that had an exception in it. I am not sure what criteria in the query to use, but it would seem creating a report off of this query would work.
View 1 Replies
View Related
Feb 17, 2014
I have created 3 tables for simple inventory.
a) Item details
b) stock in
c) stock out
All I simply want to do is create a new table by item id to show balance of stock.
View 2 Replies
View Related
Nov 12, 2004
Hi, this is my first post here.
My question is this: I am creating a database for a student survey. Some of the questions may have multiple answers.
For instance, question 2 reads:
"What location/time are you taking courses (select all that apply)"
and the possible answers are:
1)Daytime/Oakland
2)Evening/Oakland
3)Saturday College
4)BC
- Where a student could be taking classes at multiple locations or times. I am completely lost as to how to set this up. I have tried to set the properties for the field on the form to accept multiple responses, but of course, these do not save to the table and so it's completely useless.
Thank you in advance for your help!!!
View 6 Replies
View Related
May 31, 2013
Im building an expression where I am dividing fields by constants and adding them together. I need all answers always round down, so 19/20=0, 21/20=1
View 8 Replies
View Related
Dec 16, 2013
I have a report that I had set to not show 0 value when it was a number field. I have now changed the field to a text field (don't ask) but I need it still not to show thw value if it is 0. How do you do that?
View 3 Replies
View Related
Sep 12, 2005
I have a form where I display the client's information and a series of checkboxes showing which services have been registered to them (ex. telephone, internet, cell phone (all info is held in separate tables with client id as the foreign key...).
For instance: I have a working query that pulls the client's id from the form to search the Cell Phone Table to see whether the client has a cell phone registered to them or not. How can I get that to translate into the checkbox on a form?
It seems so simple, yet the solution isn't presenting itself.
Any help is appreciated.
View 14 Replies
View Related
Apr 26, 2014
I want to insert a text box in the report design that show the last date in which the data was modified ...
View 3 Replies
View Related
Jun 23, 2015
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 Related
May 5, 2013
I would like to input data into textbox and it will automatically open up a new blank textbox for another data.
View 3 Replies
View Related
Mar 21, 2014
I want to create either a Macro or VBA that will automatically create a report or a query.
View 4 Replies
View Related
Feb 20, 2005
I am working on a database that tracks products. The products are divided into groups (Bath Salt, Stick Incense, Candle, etc.) and these are store in a table. The products themselves are stored in another table.
When a new scent is created, it can belong to multiple groups ... for instance, Strwberry Vanilla could be a perfume, a bath salt, a candle, stick incense.
When the form is opened, I want to read the contents of the groups table and create a check box for each entry.
I do not really want to use a list/combo box for this task ... would prefer to be able to check in a list of boxes to specify what groups to create entries for when a new product is entered.
Thanks
Phil
View 1 Replies
View Related
Feb 25, 2014
I have a report that shows the daily activities. it shows how long it takes to do each task. however some tasks are 8 hours andsome are 10 hours. when all these times are added together it will give the time on a clock. not a total of hours spent.
i.e.
treatment1 : 8 hours
treatment2: 10 hours
this will give 06:00 in short time. in medium time it will give 18:00.
however if I add another 12 hours to that it will give 06:00.
I want it to show either 1 day and 4 hours /or 30 hours.
View 7 Replies
View Related
Jun 27, 2012
I'm currently working on fixing an older 97 database that I've updated to 2010. I have just populated the Drop down box with about three fields. Ideally what I want to do is after having selected the item number from the drop down box I then hit the button that creates a report with the information about that item number.
At the moment...If the box is blank it reports all the item numbers, however if i fill the box(select an item) it returns nothing i.e the report is blank.
I've looked at the query that builds the report, there are only three fields that populate the. location, part number and description. from a tbl called MainDetails
the only other thing:
If([Forms]![frmReports]![FLoc] Is Null,[FUNCTIONAL LOCATION] Is Not Null,[FUNCTIONAL LOCATION] Like [Forms]![frmReports]![FLoc])
it has a criteria of <>False
*FLoc is the drop down box *functional location is the location field.
I believe all the above does is populate the report if Floc is empty.
What can I put to make the report generate what ever I pick in the drop down box 'FLoc' source the three fields from the 'MainDetails table'.
View 7 Replies
View Related
Apr 25, 2014
I have parameters set in a query. This query generates a report. I want to have the parameter field the user enters show in the report. Example: I have Region set up as a parameter. The criteria in the query is Like "*" & [Region] & "*" The problem I'm having is in the report it only returns what the user enters in the parameter prompt.
For Example: If I type south it only shows south rather than south east or south central (which is the whole field), etc. on the report. It shows in the table generated by the query but not on the report. If I leave the parameter prompt blank it brings back all the records like it should but again leaves the "region" field on the report blank.
View 4 Replies
View Related
Jul 14, 2015
I'm currently working on a project within access which will allow users to select/input information in a form which will then save to the database.
What I need is to create a button on the form which will allow you to convert the data collected from the form to a custom text file template.
(Or maybe the last row added to the database. - although this may cause errors. Example: the form information doesn't save which will in turn create a text file with the data collected from the previous job)
The custom text file template should have a sentence description followed by the value recorded from the form.
Example:
1 configuration type: (data from form)
2 model type: (data from form)
3 Poc: (data from form)
And so on.
So in summary - I would be to use the form to collect the desired information which will save to the database.
Once actioned, a custom text file should be populated with the collected information (with specific data placement as per the example above)....
View 1 Replies
View Related
Oct 25, 2012
I have txt input [txt choice] which has a number (1-9) and then a query which uses the following formula to define which records are visible linked to a Yes/No field
Code:
=IIf([Forms]![frm selection]![txt choice]="4",Yes,Yes or No)
If the choice is "4" then it works fine, but if the choice is anything but 4 it still shows only the Yes items. If i change the code to
Code:
=IIf([Forms]![frm selection]![txt choice]="4",Yes,No)
Then it does show just the 'No' items but i want it to show 'everything' if the choice is not 4
View 2 Replies
View Related
Jan 1, 2013
In Access 2010, I'm creating a table with a rich text memo field.
I name the field (BugDescription), select "Memo" as the Data Type, and from the Text Format dropdown I select "Rich Text."
However, as soon as I do that, it switches back to plain text.
I can't find any documentation anywhere that would indicate why I can't set this property...
View 6 Replies
View Related
Aug 9, 2006
Hi,
I have a table with a field that shows the number of pieces that a parcel contains. It looks like this:
ParcelID, Pieces, Description
Data example:
1001, 5, Jackets
1002, 10, shoes
etc
I need to print labels for each piece that shows to which parcel it belongs. The report will look like:
1001, Total pieces = 5, 1 of 5 pieces, Jackets
1001, Total pieces = 5, 2 of 5 pieces, Jackets
1001, Total pieces = 5, 3 of 5 pieces, Jackets
1001, Total pieces = 5, 4 of 5 pieces, Jackets
1001, Total pieces = 5, 5 of 5 pieces, Jackets
and
1002, Total pieces = 10, 1 of 10 pieces, shoes
1002, Total pieces = 10, 2 of 10 pieces, shoes
1002, Total pieces = 10, 3 of 10 pieces, shoes
1002, Total pieces = 10, 4 of 10 pieces, shoes
1002, Total pieces = 10, 5 of 10 pieces, shoes
If I could populate a table where the number of records equal the value of the pieces column then it's a pretty simple report but I can't figure this out.
Can anyone help?
View 1 Replies
View Related
Mar 9, 2013
I know that multivalue fields are not the best to use, but I have a simple database that they work fine in. My question is this: Is there a way to show the entire list of choices in the multivalue field on a report? Not just the ones selected, but all of them, whether checked or not? The multivalue field has a list of names and the user selects each name if they repond to a incident (fire, car accident, etc.). My report would show the entire list and count number of responses by each name during a date range. I want to show all of them on the report, with those not selected showing "0".
View 3 Replies
View Related
Sep 2, 2014
I have two collums, currentowed and currentpaid. i want to add another field to my report showing the percent of currentpaid to currentowed but I can't seem to be able to make it work. I tried:
=sum([currentpaid]/[currentowed]) and it doesn't work.
View 3 Replies
View Related
