Forms :: Moving Vertical Scroll Bar To Left Side?

Aug 4, 2014

I have a subform that�s in datasheet view, is there a way to align the vertical scroll bar to the left side?

Using:
Win 7
Access 2010

View Replies


ADVERTISEMENT

Forms :: Position The Cursor To The Beginning (left Side) Of The Field?

Apr 17, 2013

I have several comboxes where I'm using date/time input masks. When I go to enter data in the field the cursor is situated at the right end of the box. I have to backspace to the beginning of the field to enter the data. How do I position the cursor to the beginning (left side) of the field?

View 3 Replies View Related

Reports :: Cut Off Left-hand Side Of Text In Textbox And Show Only Right-hand Side

Mar 26, 2013

Access 2010

I have a report with some text boxes on it. Sometimes the text in these boxes can be a very long string of characters (maybe a path to some folder). In this case I do not want the text box to grow. I just want the report to show me the right-hand side of this path and cut off the left. How do I do this when still aligning my text to the left?

View 2 Replies View Related

Vertical/Horizontal Scroll Bar

Jan 6, 2006

Hi, In MS Access,

In the form design,

How can I change the Vertical Scroll bar color?
I want to keep it for using, but the color is always grey color.
How can I change the color of the scroll bar?

Thanks.

View 4 Replies View Related

Form / Subform Vertical Scroll

Apr 3, 2014

I'm having a vertical scroll issue thats very strange. Most of the time I can scroll vertically fine, but every now and then it locks up and wont let me scroll down, especially with the mouse wheel. A couple of the engineers have had even weirder symptoms where they cant even scroll down using the arrow keys on the keyboard.

View 14 Replies View Related

Changing Vertical Scroll Bar Position Of A Form With Code

Sep 15, 2004

Is there a way to change the vertical scroll bar position to always be at the top when I move from form to form. Right now, it will start at the top, but when I move to a different form and back, the vertical scroll bar is positioned in the center. I turned off the autocenter property of the form and saved it in the desired position, but that doesn't work. My form is maximized when it opens. I would greatly appreciate some help. This has been an annoyance for quite some time now.

View 1 Replies View Related

Left Side Tree Menu

Sep 24, 2006

Hi,

I would like to create an application with a left side tree menu.
Each leaf of the tree should open a form or launch a procedure.
The branches could expand or collapse.
Nodes could have pics.

There must be a couple of VAB examples. Would you recommend me some of the best ones ?

Thanks

View 1 Replies View Related

I Want To Put Text Down The Whole Left-hand Side Of A Form!

Jul 10, 2006

Hi Guys,

You know how you get the form header/detail/footer sections on a form. Well, how can you make text appear down the side (ie so that it overlaps all of the header/detail/footer sections).

Take a look at my drawing, it will explain it better...

View 3 Replies View Related

Forms :: Subform Scroll Bar Scroll To Bottom?

Apr 25, 2013

I have a form and in the form is a subform. When I add a record with the following code, the subform detail scrolls in such a way that you can't see the record you just added...only a single blank new record. Can you set the scroll position so that I can see all the previous records including the one I just added?

Private Sub Add_PROJ_RECORD()
On Error GoTo Err_Add_Click
Me.PROJECT_DATA.Locked = False
Me!PROJECT_DATA.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.PROJECT_DATA.Form.PROJ = PROJ_COMBO
Me.PROJECT_DATA.Form.SPEC = SPEC_COMBO
Exit Sub

View 2 Replies View Related

Reports :: Report To Show Records Side By Side?

Aug 12, 2015

So I'm trying to manipulate Access to create a Directory for my church. I'm trying to get a report to show the church staff, which I was able to do, but I was wondering, is it possible to get the records to show side by side instead of one on top of the other?

I included a picture of the design view showing what I would like to see. Excuse the way the numbers are written, it's hard to write with a mouse.

View 3 Replies View Related

Server Side Vs Client Side Queries

Nov 22, 2005

I have split my database, the data is in a DB on the server and the forms, reports, etc is on the client desktop. My question is "Is there an advantage to having all of my combo box queries (Lookups) on the server side (defined in the table as a combo lookup) or should I put the all on the form so that they reside in client side DB.

View 7 Replies View Related

Form With Three Sections To Show Side By Side

Jan 26, 2012

Form with three sections. I have three queries selecting different set of set in a table, I would like to show all three in a form side by side. How can I do this? I use form wizard bit it only uses one query as a source.

View 2 Replies View Related

Delete Only FK On The Many Side And The Record On The One Side

Jun 25, 2007

Hi,

I want to Delete only FK on the many side first and the record on the one side by one click of a button. I wrote some code which sometimes works and sometimes it does not!!

I wonder if any one have a better idea or doing this please?


Private Sub Delete_Click()

Dim db As DAO.Database, rs As DAO.Recordset
Dim n As Integer, i As Integer
Dim vStart As Integer
Dim vEnd As Integer
Dim vSite As Integer
Dim vRCCID As Integer

vSite = Forms![frmSite].Form![SiteID]
vRCCID = Forms![frmSite]![Roads Construction Consent].Form![RCCID]
vStart = Me.PhaseStart - 1
vEnd = Me.PhaseEnd + 1

Set db = CurrentDb
Set rs = db.OpenRecordset("tblPhase")
rs.MoveLast
n = rs.RecordCount
rs.MoveFirst
If n > 0 Then
For i = 1 To n
If rs![SiteID] = vSite Then
If rs![PhaseNumber] > vStart And rs![PhaseNumber] < vEnd Then
rs.Edit
rs![RCCID] = Null
rs.Update

End If
End If
rs.MoveNext
Next i
End If
rs.Close
db.Close
Set db = Nothing
Set rs = Nothing

'/////////////////////////////////////////////

DoCmd.RunSQL "DELETE RCCID FROM tblRCC WHERE RCCID = " & vRCCID & ""

'//////////////////////////////////////////////
End Sub

tblRCC is the one side of the relationship and tblPhase is the many side.

Any help will be very much appreciated.
B

View 4 Replies View Related

Vertical Lines On Forms

Feb 10, 2005

Rather than manually draw vertical lines on my forms, I'm looking for a way to generate vertical lines using VBA code. Has anyone done this?

Thanks,
pc

View 1 Replies View Related

Write Vertical In Forms / Report

Dec 5, 2005

I know about the option write vertical.

my problem that I cant to work with it.

for example I want write in the verical filed JUN 2005

and in all the other filed write Horizontal
is it possible?

if some one can printscreen of a report that seems to what I look for
it will help me alot.


other stupid question:
can I see in this forum just my question
thanks!

View 5 Replies View Related

Forms :: Vertical ScrollBar Of Subreport (on Main Form) Not Shown

Jul 16, 2015

I 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 .....

View 14 Replies View Related

Forms :: Three-Level Navigation Form - First Two In Horizontal And Third In Vertical Orientation

Sep 20, 2014

How to Creating a Three-Level Navigation Form, First and second level must be in horizontal orientation, third level desirable be to vertical orientation and dependent of level 2.

View 1 Replies View Related

Forms :: Allow Horizontal And Vertical Scrollbars But Remove White Space (AC2007)

May 22, 2014

I have a form which I would like to enable scrollbars both horizontally and vertically (the main reason being, the application is designed for users with large / wide screens but may at some point be required on smaller screens)

Currently I have the scrollbars switched off and the form maximises but everything goes to pot if I resize the window. I'd like to add the scrollbars so if a user wants to resize the window to, say, half the screen, they can still scroll across to the 'hidden' parts of the form.

The problem with this is, if the form is maximised - or at least large enough to show the entire form - the area of the screen where the horizontal scrollbar resides is white (whereas the background colour of the form is a pale green) Which is quite unsightly.

I know I can remove the problem by removing the horizontal scrollbar and the navigation bar (which is already gone!) but then I can't scroll?

Is it possible to have a horizontal scrollbar but not have that white space at the bottom when the scrollbar is not required?

(Doesn't appear to be a problem with the vertical scrollbar?...)

View 8 Replies View Related

Forms :: Can't Enter Data Into Blank Field On One Side Of Outer Join

May 21, 2014

I think I have just finished designing my database and I tried to test it and I couldn't enter any new records as it says "Can't enter data into blank field on "one" side of outer join" whenever I try and enter info and I don't know much SQL to work out what has happened. It probably causes this too but I also cannot select check boxes.

The form where I try and enter the info is called Crisis_support_workers v3. I have attached my database so you can look at what I have done.

View 1 Replies View Related

Forms :: How To Scroll Down Mouse With Record

Mar 15, 2014

i have a continuous form used for selling item , i want when the user selling item the scroll mouse working with the current record look the attachment to see how to fix the problem .

View 2 Replies View Related

Forms :: No Scroll Bars On Web Database?

Feb 17, 2015

My problem is that I have a couple of forms where scrollbars are not appearing on forms when they are too long to fit on-screen. Instead they're just going below the bottom of the screen and there's no way to access things at the bottom of the form. This is happening with a data input form as well as with a form I'm using to filter and display a report. I've tried selecting both "Vertical only" and "both" for the scrollbar property of the form, but it doesn't seem to make any difference.

The forms are being opened in "dialog" mode, the only option for opening a form in a web database when using a macro to open it, it seems. If I manually open the form in 'normal' mode, it has scrollbars. Also, if I open a report with a macro (on click), it has the option to open in 'normal' mode and has scrollbars and all is well. But if I want the user to be able to click a button to open the form, it seems I have to use dialog mode.

View 1 Replies View Related

Forms :: Scroll Bar Position With A Subform

May 22, 2013

I have a form that i have created with various tabs along the top, e.g. customer details, customer contact etc etc.I have a subform on one of the tabs.

That subform also has tabs on it.When clicking on the main form tab it goes to subform but the scroll bar moves down only to show the subform tab options. I have to keep scrolling back up to see the main form tab options.

View 7 Replies View Related

Forms :: Mouse Scroll And Tab Controls

May 8, 2014

I have a form with four pages and subforms on each page. I am having issues with scrolling on pages 2-4. The first page will scroll correctly (to the bottom of the form), but the other pages will not scroll at all. I did enable the scroll bars on the subforms, but they will only scroll to the bottom of the viewable form, not the whole form, which I would prefer. Is there a way to scroll through the whole form on pages 2-4? I tried setting the focus to the form itself, but my code didn't work:

Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
Me.Parent.FRM_TABLE_TAB_1.SetFocus
End Sub

I would change the form; however, it is designed to look exactly like the actual questionnaire.

View 1 Replies View Related

How To Disable Mouse Scroll Buttons On Forms?

Oct 10, 2006

Hi!
I want to disable the usage of mouse scroll on my forms. Because, as things are now, you may accidently choose/ scroll to another Record/ Post, when editing data for one specific record.

How do I accomplish disabling usage of mouse scroll?

View 3 Replies View Related

Forms :: Cannot Scroll Back To See Previous Records

May 2, 2013

I have a main form EMPLOYEE RECORDS with employees information, with a Subform, where pay records are entered. Mysubform always shows record 1 of 1, and I cannot scroll back to see previous records. How can I see the previous entries.

View 9 Replies View Related

Forms :: How To Get Horizontal Scroll Position On A Form

Jan 9, 2015

I have a form in datasheet view, with the record ID column frozen and users typically scroll to the right to see certain columns. Different users scroll to a different position.

I dont have the option to reduce the number of columns or create separate forms for different users, - they all need to see all the columns but typically a user scrolls horizontally to see a certain set of columns most of the time. I want to save that position for the next time they open the form.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved