Hiding Drop Down Arrows In A Printable Form
Aug 23, 2006
Hi
I am compiling a database of my fire system 'engineers reports' by creating a form that is identical to the one that I print and give to the customer.
I used combo boxes to look up system type details, from another table, after inputting the serial number. As these combo boxes can only produce one value I hid the arrows behind background coloured rectangles.
When I print the form the arrows disappear, the combo boxes expand by the width of the arrow and the last 2 digits of right-aligned numbers disappear behind my rectangles.
This form has over 200 controls (systems types, parts used numbers and quantities etc) and I need to print it on a single sheet of paper. I cannot afford to leave extra space between my controls.
The only thing I can think of is setting the visible property of my rectangles to screen only, which is not ideal.
Any suggestions would be greatly appreciated.
Thanks
View Replies
ADVERTISEMENT
Mar 30, 2005
Hi,
I have a data entry form that needs to become an invoice form.
The problem I have is that the background colour prints too, tried "print data only" option, but as it says on the tin, only the data is printed.
Ideally I want the formatting, field headings, but not the background colour.
Is the only option to remove the background colour?
Or should I create a "print" button that runs a report for the selected record?
Many thanks
daz.
View 1 Replies
View Related
Nov 10, 2005
is there any way to carry specific data entered by the user from 3 forms to one printable form which is set up like a city permit? ideally, i'd like the user to be able to click on a button to open the permit & then click print after having entered all the data into the 3 forms (1st form opens 2nd; 2nd opens 3rd).
ie - a contractor comes in & applies for a permit, the user (permit clerk) enters all the contractor's info into form 1 then clicks permit & enters the info for that specific permit (there are 4 types) into form 2, then clicks payment & enters check #, fee, etc. into form 3. the permit should now be issued but only needs to have permit #, contractor name, date, location, & amount paid on it. is this possible? i've tried building a query to base a report on with the with that info but am not gettin the results i want, and i don't know how to have a report display only one permit at a time. plus, my users don't want to have to run a query & then print a report. they just want to click print after entering the data (they're very lazy, set in their ways, and not very computer literate). please excuse my dumbness but the whole application is up & running except for this last part.:o please help! thanx in advance.
View 5 Replies
View Related
Jul 8, 2014
I want controls on the left of my form, but when I do it this way and then print a record, it displays a big blank section.
How do I make the left side a non-print section for my controls?
View 6 Replies
View Related
Aug 21, 2004
I have a project for a movie rental company, and I need to be able to account for rentals. So, how do I create an invoice (form or report) that will show ALL rentals for a customer when they check out, AND print it? I have an invoice table, a customer table (customer ID used) and a movie list table, and that works for the form I've got, IF the customer only rents ONE movie, but what if they rent like seven? I'm not sure how to update the "invoice" table to reflect that, then get all of the information into a the required report for printing.
If more details are needed, respond and I'll post em, but I think that about covers it
thanks in advance for anyones help!
ttmmm
View 1 Replies
View Related
Aug 25, 2006
hey, little prob for improving my database..
In a box on the form i have the date automatically entered. however it is also possible for people to change the date for say the day before or the day after.
SO what i really want is for the date to still autoset (most of the entries will be for the current day) but i also want two little arrows on the box (like standard scroll bar style) to give me whatever date in the future, or past, that i require.
at the moment this can be done manually, but i want to make it as simple as possible so no gets to befuddled!!!
cheers for the help (if anyone can)
Myle
View 2 Replies
View Related
Aug 11, 2015
I keep getting these annoying up/down arrows in the calculated control of a form. The top one is ok, but the bottom one has these. How do I get rid of them.
I've checked the alignment on the control properties in the form and the settings are the same in the table field properties.
View 2 Replies
View Related
Jun 16, 2014
I have a form which has a subform that holds records from a table. When in the table i can move through the records with my up and down arrows but when I am in the subform i can not move in the same manner with up and down arrows. What needs to be done on subform to allow user to move through records using up and down arrows.
View 1 Replies
View Related
May 17, 2013
In my forms I would often like to move forward or back a records, usually a date by keyboard alone.
The keyboard arrows are good but they are normally used to navigate along a line etc.
Page Up & Down again better & often used for moving between records but do sometime need there native functions.
Trying to avoid changing the functions of these keys depending of what part fo the form I am on or current function I an doing.
It would have been great if there was a Alt Left or Ctrl Left that gave a different ansii.
Alt N - next, Alt P - previous, not pretty.
View 5 Replies
View Related
Aug 8, 2013
I am trying to produce a report that shows a single record that has fields in multiple tables. When these reports we're in Word form they were about 7 pages long. I put them in access to be able to update the data in one or more than one of them at a time more effectively. But now I am unable to get them print out one at a time like they looked originally in Word form.
View 1 Replies
View Related
Apr 13, 2005
I would like to have a combo box that doesn't show the drop-down arrow when the user selects it. You say, doesn't that defeat the purpose of the combo box?
Well, look. In a form I have a datasheet (in a subform) that only displays data, so it is locked from editing. Within the datasheet is a field that contains a combo box with a row source from a linked table, and the control source of that combo box is the primary key. Essentially I'm utilizing the combo box because it is smart, and allows me to display linked data: this combo box contains two columns, and I set the first column's width to "0" so that it would only display the field I want. I didn't use a subform because, in datasheet view, subform fields are not displayed in the linear fashion I need, but instead go hide under the "+" button for each record.
So, even though everything is locked from editing, the combo box arrow still appears when the user clicks on the combo box field, and I don't want it to. It's just misleading to the user. Anyone know how to disable the arrows? Or, if you catch my drift, do you know of another simple solution?
I'm not a keen programmer in case you couldn't figure that out. If you've got any VB tips then let me know.
View 7 Replies
View Related
Dec 8, 2014
I had set Data Entry to True in order to always default to a blank record. However that locked up my ability to use the arrows to navigate between records in the database. Is there a work around?
View 9 Replies
View Related
Jun 18, 2004
Hi,
I have a form with command buttons on it (a menu) but I want the form to be full screen without hiding the taskbar. I can get the form to fill the screen with no problems, its just a matter of having the taskbar available to multi-task!!!
Also, is it possible to have a few forms open at once with each form appearing on the taskbar
i.e. START | Microsoft Access | Form 1 | Form 2
Thanks in advance!!!
Ty
View 4 Replies
View Related
Jul 14, 2014
I want to password protect the second tab control page, so I'm using this code :
Private Sub TabCtl0_Change() Dim strInput As String
Dim ctl As Control ' Hide controls on tab until correct password is entered F
or Each ctl In Controls If ctl.Tag = "*" Then
ctl.Visible = False End If
[Code] .....
then to hide the controls in the first place, we do this using the Tag Property, and in the OnCurrent event of the form:
Private Sub Form_Current() 'Hide controls tagged with "*" until password entered.
Dim ctl As Control For Each ctl In Controls If ctl.Tag = "*" Then ctl.Visible = False End If Next ctl End Sub
The password request and events works fine but when prompting for the password it still shows the second page items and info. so basically it is not hiding the tab.. How do I fix this
View 8 Replies
View Related
Aug 24, 2007
Hi.
I have a widely used application in Access 97.
Anyway, some staff are not using the forms' menu buttons but are playing around with the Access toolbar (file, edit, et cetera).
The administrator wants me to either disable that toolbar or hid eit from view. Any ideas?
Russ
View 1 Replies
View Related
Nov 28, 2013
How to hide the layout of subform in main form?
View 3 Replies
View Related
May 8, 2006
Hi,
Anyone know in microsoft access 97 is it possible to remove the close button (top right hand corner) when a form is maximised?
Thanks.
View 1 Replies
View Related
May 15, 2014
hiding parts of a form if a option button is selected. There are two option buttons and two parts to the form. I would like each part of the form greyed out or made invisible depending on which radio option button is selected.
View 14 Replies
View Related
Nov 28, 2013
How to hide the layout of subform in Main form?
View 5 Replies
View Related
Apr 30, 2015
On my form frmEmployeeDetails I have a text field that is named SSN for social security numbers. I have used the mask on it so it automatically inputs dashes. I am attempting to hide all but the last four digits of the ssn. This is on the on current event of my form.
Code:
'Hide SSN
Dim strLSSN, strSSN As String
strLSSN = Right(SSN, 4)
strSSN = ("***-**-" & strLSSN)
Me.SSN = strSSN
View 1 Replies
View Related
Jul 24, 2012
Is there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?
View 1 Replies
View Related
Jun 18, 2013
I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc
View 2 Replies
View Related
May 16, 2006
I am building a customer order database for a client and have this problem: I would like to be able to display a form that shows all a customer's order information ( pretty standard stuff, first name, last name, address, phone, etc.) but then would also like to display what they ordered as a drop down. Many of the customers are repeat customers, and so they will have multiple order records in the datatbase, but I would like to somehow display them in the customer profile form all in one form.
Any help on how to go about this appreicated.
thanks in advance
johnmr
View 2 Replies
View Related
Sep 8, 2006
I'm pretty much a noob to visual basic, I've only taken C++ so I dont really know VB language. ok here is my question... I have a form and I added a drop down list through a table. What I want it to do is output into another text box within the same form when an item in the drop down list is selected. I think I have to make an event procedure for the "On Click" or "On Got Focus" selection. please help me out !!
View 5 Replies
View Related
Oct 4, 2006
I am new at access..I am using Access 2003
I have a table with fields for Project #, client, description, etc..
I want a form with a drop down box that shows all of my project #'s when I click on it... I would like to then be able to click on the project number and have all of the information for that record appear..
I have managed to create the form with the drop down box, but when I click on the project number the record information does not change....
Any help would be so much appreciated!!!!
:confused:
View 4 Replies
View Related
Apr 26, 2007
I have a form with a combo box drop down, next to it I have an edit button. If the agent is not in the drop down list, I would like to press the edit button and add a new agent. This works but it does not show up in the list unless I do the edit before I hit the arrow on the drop down box.
I have a macro on the edit button to OpenForm and Requery.
I would like to be able to press the edit button, make the change/addition, when I close this go back to the dropdown and have the new/or changed value seen in the drop down.
Is this possible? If so, how do I make this happen?
View 12 Replies
View Related