Hello.
I want to hide the scollbars on a subform. I selected "neither" for scroll bars under properties, and it works. However, the formatting is ugly. I have a blue background but get grey boxes where the scroll bars are supposed to be. Can I get rid of this and have the area blend in with the background?
Thanks in advance.
Hi everyone,
I have a 4 part survey database consisting of one source table : tbl_survey. I have created a main form with 4 subforms (each subform is a section from the survey table tbl_survey).
I have placed 4 buttons in the main form, and each button when clicked reveals its subform, whilst hiding the others. So when the main form opens, the first subform is displayed (others are hidden). When the user finishes the first subform, they click on the second button to display the next subform and so on.
My question is, i want to set the verticle scrollbar position of each subform to the very top when its appropriate button is clicked so that if a user goes back to a previous subform, the scrollbar isnt all the way down the bottom.
Reptar
Hello All!,
The results of a query by users are shown in a subform (in datasheet view) similar to this:
Months 2004-22004-32004-42005-12005-2
2004-06 0.9840
2004-07 0.9969
2004-08 0.9800
2004-09 0.9850
2004-10 0.9850
2004-11 0.9879
2004-12 0.9879
2005-01 1.0000
2005-02 0.9900
2005-03 0.9900
2005-04 0.9900
2005-05 0.9900
2005-06 0.9936
The second column onward denotes Years-Quarters. Where I need help is in hiding columns I don't need to show if outside of the range the user's chosen: for example, if user chooses Jul-04 to Mar-05 then I'd like hide columns 2 and 6.
For whatever reason I can't get the monthly values to line up with the Yr-Qtr columns, but I hope you all know what I mean :o, i.e., 2004/07-2004/09 lines up with 2004-3, 2004/10-2004/12 with 2004-4, and so on.
As always, any help provided would be greatly appreciated.
I cant get my subform to hide. Main form is called 'frm_main_add' and the subform is called 'tbl_transaction_subform'.I am rying to get it to hide the subform (tbl_transaction_subform) if a field in the main form(frm_main_add) is null but its doing nothing.....
I put this code in the 'on current' and 'on load' in the frm_main_add and nothing..If (Expense_Name = Null) Then tbl_transaction_subform.Visible = False Else tbl_transaction_subform.Visible = True
Morning all, I'm trying to hide a column of a datasheet in a subform I have... if I run the form and right click and hide the column, it doesen't save that the next time I load it (wasn't sure if it was suppose to, but after reading http://office.microsoft.com/en-us/a...2362201033.aspx it would appear so) I'm using SQL Server 2000, not 7 so I would think that problem shouldn't come up for me yet it is, I need to hide a couple columns from the user (mostly ID columns) while they are entering in data, anyone have any advice they could throw my way?
Much appreciated
- Chris
Ok this is a bit long winded and I will try to explain,
I have a main form, with a title at the top, then a row of buttons underneath and underneath the buttons I have a sub form.
Some of the buttons can have a dual function (or multiple function) so rather than open up another form I have hidden text below the button, so that when the mouse moves over the button, the text becomes visible. this gives the impression of a drop down menu off that button.
However I cannot get the text to appear over the top of the subform, it only appears behind it.
To give an example of what the buttons and drop downs are for, one of the buttons is a reports page, rather than open another form I can have a list of the differnt reports I wish to run (currently they are text boxes with an on click event).
any advice woudl be much appreciate and even an alternative to what I am doing if anybody has one.
Many thanks
MattP
Hello!
The problem at hand for me is to be able to hide columns in a subform wherever "#Name?" appears. My VBA experience is minimal to non-existent, but if a not so complex sample code exists out there then I'd appreciate any suggestions you may have.
I have attached a print screen document that shows the result of a query in the subform I just talked about. My anticipated thanks for your help.
How to hide the layout of subform in main form?
View 3 Replies View RelatedHow to hide the layout of subform in Main form?
View 5 Replies View RelatedI want to use VBA to hide columns in a subform based on what is checked in a multi value look up field.
I am creating this DB for use with sharepoint as a web database, which is why I am using the lookup field to begin with. There will be a client DB to use with some VBA code
So what I have is a lookup field with tests "Test 1, Test 2, etc" on form sample.
There is a subform called results, and I want to hide certain columns based on what tests are performed.
I tried using an If Then statement (code is being run on subform load)
If Me.Parent.fieldTest = "Test 1" Then
Me.Test1Col.ColumnHidden = False
Else Me.Test1Col.ColumnHidden = True
That is basically the code I was trying to use. I am getting an error 13, which I assume is because fieldTest can not = something since it is a multi value look up field.
Hi!
Is there any opportunity to paint a standard ScrollBar?
Thanks a lot!
Aleksandra
:)
I have a subform which shows records... usual stuff. However, when I turn on the scrollbar, it always shows the scrollbar... also when there are no or a few rows in the subform.
Can I make the scrollbar of a (sub)form conditional? -- so, if the form needs more than so many space because of records shows: it turns on the scrollbar.. else: no scrollbar.
Any help is appreciated,
Jazz
I'm using access 2007 and I have a form with six subforms on it. When the form is completely load the subforms DO NOT have scrolls bars (for up and down) on the right side even though the data (rows) far exeeds the number of rows displayed. I have checked all the properties and all appear to be set up correctly. If I refresh a subform with VB on load of the main form the subforms scroll bar will show. The problem with doing this for all six subforms is the amount of time it is taking. Is there something I might have overlooked, is this a bug with Access?
View 5 Replies View RelatedI have a main form with a subreport.
Mainform width is 22"(Maximum)
Subreport Wdth is also 22" (Maximum)
When i run the mainform, the subreport shows correctly but the vertical scrollbar is at most right side of main form so i have to scroll main form horizontally first to access the vertical scroll bar of subreport.
To solve, changing subreport orientation to right-to-left shows vertical scroll bar at most left but still if i scroll horizontally on mainform, that scrollbar hides as its not freezed.
Consider ActiveX Control of Microsoft ScrollBars 2.0 .....
Sorry about this - I should be able to figure it but it is one of those none-obvious things.
I want to format the background colour, font size and column headings of a subform & I cannot remember how to do it or find the posting on the forum that mentioned this. :o
Any pointers appreciated.
I'm working on a purchasing database where if the user checks a box on a subform, another field needs to be disabled. The code works, but since this is a continuous subform, it disables that field on every row. Is there any way to make it stick to the row the user is working on?
Here's the code:
If Me!acs_puchase = -1 Then
Me!inventory_po.Enabled = False
ElseIf Me!acs_puchase = 0 Then
Me!inventory_po.Enabled = True
End If
Thank you!
The Format Painter seems not to work in Access 2010.The Format Painter button is not in Home / Text Formatting, where you might expect to find it.I create a New Group and add the Format Painter icon. I cannot then use it. It stays greyed out.I add Format Painter to the Quick Access menu. It stays greyed out.If I view a form in Layout mode, I can sometimes get the Format Painter icon to highlight - but I cannot select just a single cell whose format I wish to copy.
Where use of the Format Painter is documented..How to do a very simple thing: copy a format from one cell in a subform to another.
I have a subform in Continuous Records format (records displayed are determined by controls on the parent). I would like to create a button that prepares an email and copies the contents of that subform in to the body of an email message.
The email. I have a method to create a new email, set To, CC, Subject and even Message Text.
Code:
strTo = txtName
strCC = txtManager
strSubject = "Something"
strMessage = "Hi, please find below list of details from X Y and Z" & vbnewline & vbnewline
That all works. Thats fine
The Records: I have found ways to have them added as an attachment, either the the SendObject and OutputTo method but I would like the list of records to be converted to a text string so I can include it within my strMessage variable, not include it as an attachment.
Code:
strMessage = strMessage & "Subform Records to go here"...
I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?
I have a list of dates in the mm/dd/yyyy format and I am looking to get it into the fiscal format of yyyyww. I am able to do this with the datepart and format functions, but I need to make it so that the fiscal month begins in January but the first week starts if there are three or more days in the week. For instance if Jan 1st is a Friday then this stands as the first fiscal week, if it is a Saturday then it does not count as the first week.
datepart and format functions have the Use the first week in the year that has at least 4 days for the firstweekofyear option but I need it where it has at least three to make it work.
I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark).
str = Format(Me.word, xxxx)
I'm trying to hide access(i.e. toolbars etc.), and only view a form. Is this possible?
View 5 Replies View RelatedOn a form, what is the best way to hide a label or text box? I'm guessing that I can do a checkbox which would work for me and just write a macro to hide on a false value?
View 1 Replies View RelatedHello,I was wondering if anybody knew if it was posslble to show an aproximated value of a field with decimal records. I would like to see only integer values on my form.
View 3 Replies View RelatedHere's another one on this subject... But can't seem to find the answer in the "Search" Currently I am using the "Call fSetAccessWindow(0)" method.... Well, all works fine until I start getting into reports. I have read in some post of other methods to hide Access. But I have yet to find any examples of the "easier way"..... Can anyone direct me to a post or link??
Thanks
Curtis
How do I hide prompts asking the user are they sure they want to update fields, etc?
View 2 Replies View Related