Pressing TAB...

Mar 17, 2006

When I have a form opened and I press tab button like the user would most likely do to go to next window to enter information.

The think is when I open my form enter information and press the tab button
the information I entered before are gone.

It works fine if I just use my mouse to remove between windows.

..
Thanx

View Replies


ADVERTISEMENT

Pressing Enter- New Line...

Apr 6, 2005

Hello,
...I don't know if this is easily possible or not, but here's my question/scenario: I am trying to create a form that allows me to (using a memo field) enter in the dialogue from a staff meeting. [This field will also be used for preparation for that very staff meeting]. I would prefer a method in which I can do a bulleted list, but if I can get a new line that would be sufficient for the day. In access, if you press enter - It tries to create a new record (I believe even if you aren't on the last field in the form, but that doesn't matter) I want to be able to press enter or shift-enter to be able to just make it go to a new line. Not a new record. Yes, I could do this in word and if this was the only thing I needed, word or it's equivalent would be the best method. But there is much more to this database concerning my needs so I want to stick with one application.

So there's my question - If there is some other method of getting a new line please tell me, I'd love to hear. ;)

Thanks,
---roystreet

I just found out that you can use ctrl-enter for a carriage return.
I would still like to know if there would be a way (maybe via coding) to make the enter key do it?

View 5 Replies View Related

Pressing Enter After Entry Into Textbox

Jan 18, 2006

I have a textbox and a command button by this textbox that performs an action based on the value in this textbox when clicked.

I want to be able to press the enter key after entry into the textbox and have it perform the same thing the command button does.

I tried Calling the commndbutton procedure from the OnEnter event from of textbox, but it tries to process as soon as i "start entering data into the textbox".
I hope i am clear? How do i achieve this, so that by pressing the enter key after entering a value in my textbox, my textbox value is processed, instead of clicking the command button.

This is just to enhance usability. Any help will be mucho appreciatied :D

View 6 Replies View Related

Modules & VBA :: Run Code When Pressing Enter

Dec 5, 2013

I want to run some code when a user presses the Enter key on a form - how do I do this?

View 3 Replies View Related

General :: Pressing Enter Instead Of Button

Jul 25, 2013

i have a password logon form, after the user enters his password he then has to click on the button to validate and move to the next form.i have been asked to set this so that the user only has to hit enter on the keyboard to do this.

View 5 Replies View Related

Prompt For Password And Username Each Time While Pressing Cmd Button

Jan 23, 2007

Being dealing with my database and having quite some trouble with it. Is it possible to track down what the users did, during the time they login into, database, is it possible to prompt users for password and username when they buttons for like, delete cmd, or update command.

Just a breif idea on what im trying to do.(hopefully it won't confused you all)
Im trying to created a 2 main username. One is for admin group and another is for users group. Then users can login in to database, however whenever the users update or delete entries in the database, the user will prompt for their username and password (not the users group login ). Is it possible to build a table to store in the username and password for the prompting purposes one.

Sorry for confusing question. Actually im trying to think of another way, but for now this complicated event all i have think of. Feel free to voice your suggestion here. Thanks alot. TQ

View 4 Replies View Related

Prevent Default Command Button When Pressing Enter

Nov 7, 2005

I have a form which contains several controls and a listbox. I have set the Default setting to yes for a command button that returns the results of the search, so when i click the Enter key on any control (with the exception of other command buttons), the result is returned.

Question: I want to prevent the Default command button from activating when pressing Enter from the listbox.

I thought of using the KeyDown event with this code
If KeyCode = vbKeyReturn Then
'do something
End If
but i can't get it to disregard the default

Suggestions?

Scott

View 1 Replies View Related

Forms :: Show Info In Textbox When Pressing Button

Nov 16, 2014

I have a button that when I press it it goes to new screen where I can add new data in, and then save it.I have 10 texboxes in this form, how can I when press the button to add data let it on 3 texboxes show info eg. 4321MAG01- and when I am on the new form I can change or add to it. eg 4321MAG01-123

View 6 Replies View Related

When Pressing Enter Twice - Wrong Command Button Gets Activated

Mar 11, 2015

I've created a form including a text field and a search button - and have added a separate/specific filter button as well as a "New Record" button - but now when I press enter twice in the text field it opens a the New Record form.

View 3 Replies View Related

Auto Email By Pressing Button In Access 2007

Jun 29, 2012

So I have created this database for a lessons learnt system. Is it possible in Access 2007 to create a button that if pressed automatically sends an email out to someone? So my main form in the database is a split form which contains a search filter, which works well and also contains a button called add new lesson. This button is linked into another form and when pressed brings up this new form. In this form it has a save and close button. What I actually would like is when the form is updated and this save and close button is pressed, an email is sent to a "project head" who has to confirms the information before the data is saved into the database. Is this actually possible?

View 1 Replies View Related

How To Autofill Company Info In Employee Form By Pressing Button

Oct 6, 2005

Hi there,

I am stuck for over a week now, and tried just about everything I am capable off ...

I have two forms: COMP (where I fill in fields for Company Table) and PERS (where I fill in fields for Person Table).
On the COMP-Form I have a button, named: 'Add Person/Employee to Current Company'.

The two tables (Company and Person) are linked by PK - FK (PK_CompanyID & FK_EmployedAtID).

I can't get it to work properly.
The PERS-form must be filled with the company info I filled in the form COMP, after I press the button.
But the PERS-form also must be filled out normally (not via COMP, but seperately), choosing the company in the comboboxfield 'Company Name' on the PERS-form. Do you stick with me?

So I want to start the PERS-form with the filled in company Info by pressing the button.
And I want to be able to start the Form seperately (which I can off course) and choose the company myself , by selecting the right company in the combobox.

I have a attachment sent with this.

Can someone look at this for me, and explain what I am doing wrong.

I tried to do it with a autofill macro, and with some code ...

I just don't seem to get it right.

Thanx in advance for all the help,

Quinten

View 1 Replies View Related

Forms :: Adding New Record Line In A Subform After Pressing Add Button

Apr 9, 2014

How can I add a new line of record below a previous record after pressing the add button? I have attached a picture of my project.

View 3 Replies View Related

Forms :: View Records Automatically Without Pressing Refresh Button?

Nov 20, 2014

I added several records in another table but it wont show the records until I press the Refresh button at the ribbon of Home-> Refresh. How can i view the records automatically without pressing the Refresh button?

View 2 Replies View Related

Forms :: Cancel On Load Event When Pressing Command Button

Aug 21, 2013

I have a form (Pipeline) with an on load event that automatically directs the user to a new empty record.

Code:

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

Now my problem is that I am trying to design a 'search form' that will allow the user to look up a specific record in the main form by pressing a command button. Creating the search form is easy enough. I cannot figure out how to override the on load event in the main form when pressing the command button.

As it is right now, the button opens the form and then go directly to a new record.

View 5 Replies View Related







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