Forms :: Stop User From Moving To Next Text Box In Access Form

Jun 20, 2014

I have a form in which user will enter few values but I need users to enter the comment in relevant text box too only if they have any non zero value.

I have attached an example for reference....where red encircled portion is for values and blue is for relevant comments. If value is non zero then user should be enforced to enter the comment too......system should not allow user to move forward or backward until there is some comment.

View Replies


ADVERTISEMENT

Stop A Form Being Moved By User

Feb 20, 2005

Is there anyway to stop the user from beng able to move a form. I.e. as in change its position on screen.

I am aware that you can do this by setting the border type to "none". However, I want my form to have a title bar along the top, so I cant use this method.

Is there another way to do this?

Thanks in advance.

EDIT: Ive found some information on the "movable" property, but I am using access 2000 and cant get it to work.

View 7 Replies View Related

Modules & VBA :: Moving Rich Text From Access Memo Field To A Word Text Box

Jul 24, 2015

We need to move rich text from an Access memo field to a Word text box. So far the best Ive been able to come up with is in the code below. In this code pprs!What is a record set field of a table memo field that is bound to a text box enabled for rich text. The rich text seems to be stored as html as so I can get word to convert it by enclosing it in html tags.

Dim What As Word.Shape
Set What = doc.Shapes.AddTextbox(msoTextOrientationHorizontal , doc.PageSetup.LeftMargin, 225, 534, 0)
Dim sPath As String
sPath = "G:Temp.html"
Open sPath For Output As 1
Print #1, "<HTML>" & pprs!What & " </HTML>"
Close #1
What.TextFrame.TextRange.InsertFile (sPath)

View 2 Replies View Related

Stop Moving Passed Last Record

Sep 11, 2005

I am writing a database with a number of tables with forms attached to each table. I have placed navigation buttons on each form to move to first, last, next, previous. I have set up the code associated with the buttons as "public sub" so it is available for each form to use.

This was working OK except that when I used the NEXT button at the last record it would open a new blank record & keep opening a new blank record on each click.

To over overcome this I put in an If statement to check if it had moved to a new record. To do this I used the following:

If Me!NewRecord Then ..... etc

Now I get an error "Invalid use of Me key word" I suspect it is because I am using ME in a public sub

How do I overcome the problem of moving passed the last record and still have the coding available to all forms?


The Code is below.

Thanks for any help.



Public Sub Next_Record_Click()
On Error GoTo Err_Next_Record_Click

DoCmd.GoToRecord , , acNext

If Me!NewRecord Then
' If new record move back to previous
DoCmd.GoToRecord , , acNext
' Send message
MsgBox "This is the last record", , "No More Records"

End If


Exit_Next_Record_Click:
Exit Sub

Err_Next_Record_Click:
MsgBox Err.Description
Resume Exit_Next_Record_Click

End Sub

View 3 Replies View Related

Forms :: Stop User From Leaving Field Without Selecting Item / Entering Data?

Aug 29, 2013

how to stop user from leaving field without selecting item or entering data

View 2 Replies View Related

Modules & VBA :: Stop Objects Moving When Others Grow

Jul 18, 2014

I was wondering if there's a way to set objects so that they don't get pushed down if an object above is set as Yes in the CanGrow property?can a report be split into columns?

I have been asked to replicate a form (previously written up on Word) which has two columns of information. As luck would have it all the fixed fields are on the Left hand side, so that part doesn't need (or want) to grow, However, the Right hand side has several sub-reports which can display 1-5 records each.

So if any of the sub reports show more than 1 record, they push down everything below it, but this includes the Left hand objects, creating gaps and often pushing the report onto 2 pages.

View 3 Replies View Related

Forms :: Caret Overlapping Text When Typing And Moving

Aug 20, 2014

I have an Access form that is tied to a recordset. When I Set Focus on 1 text box in particular, I move the caret with the keyboard arrows left-right, and the caret moves and flashes on top of the text characters, basically overlaps the character. When I then try to delete or edit the text, it moves the caret by itself to a different location in the text box and starts adding the text to that location. When I finally get the text how I want it, I set focus on another control, and it occasionally deletes random characters in the text box.

The only way I have been able to work around this is to copy and paste the current text into Notepad, edit it there, and then paste it back into the text box.

View 14 Replies View Related

Moving Instructions In Unbound Text Box On The Form

Oct 9, 2005

I need to display some of the insruction lines in unbound / bound text box that will gradually moves up.

Example :

"This multiuser client server db is licenced to "ABC & Co.". This sofrware is to reduce cost of production and it increases speed of your production process more...."

These instruction lines may be arojnd 10-15 lines. I need to display it as non-stop moving up text massages on the main form once the data base is opened.

Is this possible? How?

With kind regards,
Ashfaque

View 5 Replies View Related

Forms :: Limit User Access In Form And Report

Jun 19, 2015

what is the best way and good practice in limiting user's access in form or report.For example, i have 2 users in my UserTable, one is Administrator and the other is just ordinary user.In case i want the ordinary user to open the form in "Read Only" mode, and the Administrator in "Edit" mode.

Do I need to make a code for each form to be opened or there's another easy way to handle this? (I am thinking for additional fields in UserTable to store their individual rights, but after that i don't know what to do next)

View 1 Replies View Related

Forms :: Coding User Login Form In ACCESS 2010

Apr 14, 2013

I have used Combo box. security_level field is the one that describes their levels and there are only two levels 1 and 2.. I have a table called User (user_ ID, User_Name, Password, Security_Level) On form there is a combo box for user name and text box for password. Two command button where one is for EXIT (Closing the application) and the second button is to run the code.

if the password in table User matches value chosen in combo box or user name and password are correct Then it should check if Security_Level of the user is equal to 1 to displays a form called Admin and when the Security_Level of the user is equal to 2 to display a form called user1.All that I want is to have a login that has two user and each user when login opens his/her own form which is different from the other user.

View 14 Replies View Related

Stop User From Opening FE MDE File Twice

Oct 18, 2007

Is there a way to stop users from opening the front end file twice (stop from having two sessions of the same FE at the same time)?

I've been searching the forum and found this
http://www.access-programmers.co.uk/forums/archive/index.php/t-67724.html
but since im not using an .exe updater is not my case t.t

View 5 Replies View Related

Forms :: Stop Access From Creating New Record When Inputting Data In Field Or Tab

Dec 17, 2013

How do you prevent access from adding a new record when u input data in the current record or tab to the next field? My database is set up to open with a form where the user picks his name and then a week ending date once that is complete u open a new form where the name and date auto populate along with other fields to fill out such as job charge, charge type , times charged for each day of the week. But I don't want access to create a new record everytime the person inputs or tabs..... .

I have attached my database for better clarity!

View 9 Replies View Related

Forms :: Change Textbox Color On Form In Access 2013 For Dyslexic User

Apr 29, 2014

I have a new staff member in my office that has informed me that she has a degree of dyslexia. To assist her I've trialled changing the textboxes on one form in my Access 2013 application to a light pink color & this has instantly worked for her to read/input text.

Is there a way to automatically change each textbox to light pink on every form in my application on startup based on user login (say using an IIF statement in the OnLoad event of the startup form).

View 4 Replies View Related

General :: Stop User To Go Into Design View

Mar 7, 2015

Is it possible to stop anyone from going into design view ( even right clicking the mouse ) .

View 3 Replies View Related

Moving Form To Top Right Of Access Window

Feb 15, 2006

I have a form which I want to move OnLoad to the top-right of the Access window. Something like this:

Private Sub Form_Load()
Me.Move Right:=150, Top:=150
End Sub

But there isn't a Right:=, only Left:=. So maybe I could find out the width of the Access window? Is this possible?


Thanks for any advice.

View 6 Replies View Related

Forms :: Stop Tab From Starting New Record In Form

Nov 13, 2013

I have created some control buttons using the built in functions of Access2007 and then using the script supplied here modified the control.

So far the controls can add new record, save record, exit form, open next form and close existing form, open previous form and close existing form.

My next question is when the user reaches the end of the form fields how do I stop the form from automatically starting a new record?

For example, I use the TAB key to move from field to field and when I tab out of the last field the form goes straight to the next empty record.

I want this to be a deliberate action performed by clicking the Add New Record button and not an accident of a key press.

The other thing is, how do I get the form to open with blank/empty fields and not at the first populated record?
Some of the data is updated frequently so the records need to be able to be edited but I need to prevent accidental editing of the existing records.

View 14 Replies View Related

Forms :: Stop Record Selector On Form?

Nov 15, 2013

I am using Access 2013. I have a form with 2 subforms, each time the form is opened, the first record on both subforms are selected. Is there a way to turn off the record selector so no records are selected when the form opens?

View 3 Replies View Related

General :: Stop User Renaming ACCDR To ACCDB

Oct 14, 2013

I have a database that is saved as an accdr so it can be compiled for distribution as an exe..I have just found the accdr the exe installed and renamed to accrb and was then able to open it and view all the tables, forms etc.Obviously I cant stop someone renaming but if there was a way to stop the forms, tables etc opening.

View 8 Replies View Related

Stop Access From Changing Format / Value Of Data Entered From A Form Into A Table

Oct 7, 2012

I have a database (split into front and backend). Users populate the table using a form on the front end. Recently, it has been pointed out that some of the data entered into one specific textbox is being changed on the table. The data entered is always has a minimum of a letter and number value i.e. "A1", "A2" etc. Upon examining the table, this has changed into numeric values i.e. "1291", "1061", "852"... etc. Looks like it is translating them into both 3 and 4 digit numerical values by the looks of things. Where more complex data is entered such as "2(A1, A2)" these seem unaffected.

The field is set to text, I have set no validation rule, format or input mask. Just can't see why access is changing these values. It seems to be translating them, but I can't see a pattern.

View 2 Replies View Related

Forms :: Stop Generating Message Boxes On Form Close?

Mar 6, 2013

I have some code (see below) that checks if the start date text box is blank or greater than the end date, and if so, generates a message box and sets the focus back to the start date textbox. There are command buttons on the form that open queries based on the date fields. This all works fine.

However, if the user changes his mind and closes the form without filling in the date field, the message box "Please enter a start date" pops up repeatedly. How do I specify that a text box is required UNLESS the user is closing the form?

Code:
Private Sub txt_startdate_LostFocus()
If ((IsNull(txt_startdate) Or (txt_startdate) = " ")) Then
MsgBox "Please enter a start date.", vbOKOnly

[Code].....

View 3 Replies View Related

Forms :: Moving Form By Code On The Display

Jul 22, 2014

I'd like to do the following: when the user does something on Form A, Form B has to be open and the Forms should be located on the sides (Form A to the left side, Form B to the right side) of the display so the user can see them at a time.

However both Form A and Form B has an automatic centering function set when used alone.

Is there a way I could push this from code? I can't fine anything like that among the form's property.

View 2 Replies View Related

Forms :: Moving View Of A Form SetFocus?

Sep 19, 2014

I have a data entry form.

There are some selection controls that require the user to enter data before the next one becomes enabled.

My form then has two different groups of controls that the user see's depending on the selections earlier, either one group or the other is made visible.

My question is how to move the view so that the appropriate group is where I want it.

If I use setfocus to a control the form moves but not how I want it to (The control that i setfocus on is half way up the screen rather than close to the top.).

I know there must be a better way, I tried move size but it didn't seem to do what i wanted.

View 4 Replies View Related

Modules & VBA :: How To Lock A Table - Stop User Adding Or Altering Records

Sep 19, 2013

I have a form that allows a user to complete a stock take. I would like to stop other users from receiving or despatching stock while a stock take is in progress.

Is there a way I can lock a table, or stop users adding or altering records that match certain criteria. i.e. don't let users receive or despatch stock from with a locationID of 'A'.

View 4 Replies View Related

Modules & VBA :: Moving PDF Files To User Specific Folder

Feb 11, 2015

I'm Trying to move PDF Files associated with a customer to there specific folder

The query gathers the data, Gives me a list of files by account number

Now I want to use the results of the query to move those files

View 5 Replies View Related

Forms :: Find Current Record When Moving From One Form To Another

Aug 7, 2013

Lets say,

Form A has fields: ID, LN and FN

ID LN FN
1 A F
2 B G
3 C H
4 D I
5 E J

Form B has fields: ID, LN and TR

ID LN TR
1 A Y
2 B N
3 C Y
4 D Y
5 E N

I would like to be able to switch between these two forms and the form automatically set focus to the record that I was on the form prior. Meaning if I am on record 3 on Form A and navigate to Form B, I would like to automatically set focus to record 3. Is this possible?

A possible issue after this gets sorted out is what happens if with the same scenario above record 3 does not exits? is it possible in that instance to simply requery the form?

View 11 Replies View Related

Forms :: Cursor Moving On Multi Subforms In A Form?

Mar 6, 2015

Issue with Cursor moving on multi Subforms in a form.

I have 2 sub-forms in a main form as per screenshot. So Cursor moving from main form to 1st subform working well. After can't move the cursor from 1st subform to 2nd subform with tabbing or entering. Still there in 1st Subform in the last entered filed after tabbing or entering. I've checked on tab orders also they shown correct but it is can't move to 2nd subform.

View 2 Replies View Related







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