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 Replies
ADVERTISEMENT
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
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
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
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
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
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
Oct 3, 2014
I have had my 4th SQL/APP Dev lab class, however I missed the 5th.
Our 5th lab was .
1. Create 3 tables, populate with given data and create relationships. 'Customer, Invoice, Payment'
2. We were given 8 queries to try do, we had to come up with which commands would be used.
I have no 1 completed.
As for no 2.. we are still learning all the commands, so the lab here is for us to find what commands we think will be used. I have researched and have them all 6 queries we have to run.., I have all those commands written out on paper which I think are answers..how to find the command line to test them.
I'm using Access 2007 on Windows 7.
View 1 Replies
View Related
Apr 12, 2013
When I click on my memo field and hit enter to go to a new line, it moves to a new record. Where do I look?
View 2 Replies
View Related
Apr 14, 2006
When entering data in a memo field i would like to be able to hit the enter button and go to the next line instead of tabbing into the next field. Is there anyway to accomplish this?
View 1 Replies
View Related
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 2 Replies
View Related
Jun 25, 2013
Here's the statement
Code:
sqlfinal = "SELECT Employees.ID, Employees.Name "
sqlfinal = sqlfinal & "FROM ((qryDeptVBA INNER JOIN qrySkillVBA ON qryDeptVBA.ID = qrySkillVBA.ID) "
sqlfinal = sqlfinal & "INNER JOIN Employees ON qryDeptVBA.ID = Employees.ID) "
sqlfinal = sqlfinal & "INNER JOIN qryAreaVBA ON Employees.ID = qryAreaVBA.EmpID "
sqlfinal = sqlfinal & "GROUP BY Employees.ID, Employees.Name;"
If i simply remove the GROUP BY line and stick the semicolon at the end of the previous line (.EmpID; ) it works just fine. How is adding a group by line causing an error?I tried adding another parenthes at the beginning ((( and ending the joins as EmpID); and that failed with the exact same error.
View 12 Replies
View Related
Jun 5, 2014
I have a main form with 3 sub forms. The main form is tied to a table called QUOTES_MASTER. The first sub form is tied to a table called QUOTE_ LINE_ ITEMS_DIRTGLUE. It calculates the subtotal when selecting items. The relationship is one-to-many linked on QUOTE_ID.
The second sub form adds up total of all line items and is not tied to a table.The third sub form adds ESTIMATED FREIGHT to the PRODUCT TOTAL and is not tied to a table. how to get the values from the line items form inserted into the QUOTE_LINE_ITEMS_DIRTGLUE table as they are added.
I also want to insert the total value from ESTIMATED DELIVERED into the LINE_TOTALS field in the table QUOTES_MASTER.I tried this code on the product total sub form but it doesn't do anything and there are no errors:
Private Sub PROD_SUB_AfterUpdate()
DoCmd.RunSQL "UPDATE QUOTE_LINE_ITEMS_DIRTGLUE SET QUOTE_LINE_ITEMS_DIRTGLUE.SUBTOTAL = Me.PROD_SUB WHERE QUOTES_MASTER.QUOTE_ID = " & Me.QUOTE_ID
View 6 Replies
View Related
Nov 29, 2014
I have a module which reads a CSV transaction file line by line and adds the correct transactions to an access table and places the wrong ones in a logfile.Now some transactions are rejected twice there is even one rejected six times. Whereas one wrong transaction is processed only once. I am certainly overlooking something obvious in the logic but what. Here is the relevant code.
Code:
Function ImportCSVForConfederation(inputCSV, ORG)
Dim TNO As Integer, TACT As Integer, TABLE As String, TLINE As String, I As Integer, J As Integer, K As Integer
Dim FLD1 As String, FLD2 As String, FLD3 As String, FLD4 As String, LogFile As String, LogPath As String
Dim Lim As String, ITNO As Integer
[code]....
View 8 Replies
View Related
Nov 18, 2014
I am having a little difficulty with my importing in Access. Every time I import my text file, the lines will be jumbled. I have been reading up and I found this recordset code that seems to be what I need:
Code:
Dim strLine As String
Dim intLineNum As Integer
Dim MyDB As DAO.Database
Dim rst As DAO.Recordset
Open "C:TestTest.txt" For Input As #1
Set MyDB = CurrentDb
Set rst = MyDB.OpenRecordset("tblResults", dbOpenDynaset)
CurrentDb.Execute "DELETE * FROM tblResults", dbFailOnError 'Clear tblResults
[code]....
Basically, this code will extract data from the text file as long as it fulfills the Mid$ criteria. Here's where my problem comes. Each line in my text file is of different lengths and I have to capture the entire line.
I think using the Left$ function would work, but I don't know how to determine the character count such that the entire line of text would be inserted into the table.
Another difference between what I need and the code above is that, I am required to store each line into each row of my table, meaning
Line 1 is placed in Row 1 Column 1
Line 2 is placed in Row 2 Column 1
Line 3 is placed in Row 3 Column 1
.
.
.
Line X is placed in Row X Column 1.
View 14 Replies
View Related
Oct 18, 2014
I can change multiple things on a line graph with VBA.
Me.Graph47.chartType = GraphType ' take 65 for line
with me.graph47
.SeriesCollection(1).border.Color = vbblue ' change the line color
.SeriesCollection(1).border.Weight = LineWeight ' change the line weight to for example 3
.SeriesCollection(2).MarkerSize = MarkerWeight ' Change the marker weight, for example 4
.SeriesCollection(2).MarkerBackgroundColor = vbblue ' Change the marker color,
.SeriesCollection(2).axisgroup = 2 ' put this series on the secondary axis
end with
SeriesColection(1) is line with markers. This is correct.But now I want the seriescollection(2) without line, so only the markers. I cheched the MSDN site from Microsoft. The Excel trick with the macro does not work for me.how to hide the line with VBA for only SeriesCollection(2) in Access?
View 1 Replies
View Related
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
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
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
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
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
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
Jun 20, 2005
I have the following code to display what choice I make on a drop down box:
Private Sub cboMajorLocation_AfterUpdate()
Select Case Me.cboMajorLocation.Value
Case 1
Me.lstPC.RowSource = "SELECT DISTINCTROW tblHardware.HardwareID, tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description FROM tblHardware WHERE (((tblHardware.Location) Like '*') And ((tblHardware.Type) = 'PC')) ORDER BY tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description;"
Case 2
Me.lstPC.RowSource = "SELECT DISTINCTROW tblHardware.HardwareID, tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description FROM tblHardware WHERE (((tblHardware.Location) Like 'FTM*') And ((tblHardware.Type) = 'PC')) ORDER BY tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description;"
Case 3
Me.lstPC.RowSource = "SELECT DISTINCTROW tblHardware.HardwareID, tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description FROM tblHardware WHERE (((tblHardware.Location) Like 'CS*') And ((tblHardware.Type) = 'PC')) ORDER BY tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description;"
Case 4
Me![lstPC].RowSource = "SELECT DISTINCTROW tblHardware.HardwareID, tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description FROM tblHardware WHERE (((tblHardware.Location) Like 'PQL*') And ((tblHardware.Type) = 'PC')) ORDER BY tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description;"
Case 5
Me![lstPC].RowSource = "SELECT DISTINCTROW tblHardware.HardwareID, tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description FROM tblHardware WHERE (((tblHardware.Location) Like 'Savage*') And ((tblHardware.Type) = 'PC')) ORDER BY tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description;"
Case 6
Me![lstPC].RowSource = "SELECT DISTINCTROW tblHardware.HardwareID, tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description FROM tblHardware WHERE (((tblHardware.Location) Like 'Retail*') And ((tblHardware.Type) = 'PC')) ORDER BY tblHardware.Name, tblHardware.Assignment, tblHardware.Location, tblHardware.Description;"
End Select
End Sub
What I need to know is how to make a statement that you can put in where you want it to display all but take out certain parts of it. Example: On "Case 3" it displays everything starting with "CS*" I want it to not display certain items like "Retail*", & "FTM*" & "PQL*" & "Savage*"
Any help for this statement would be great thanks
View 4 Replies
View Related
Jun 29, 2005
When writing a long line of code, I seem to recall there is a method of stating a new line, trouble is I cant remember what it is. I belive its something like an underscore. Can anyone help please?
View 1 Replies
View Related
Mar 18, 2008
I am typing in a long SQL string and seem to hit a character line limit in VBA...
How do I programmatically return to the next line and have to code continue to read the SQL String?
I need to add more fields and this is too long..
View 4 Replies
View Related
Oct 17, 2005
How Can I remove line breaks in a string.
View 6 Replies
View Related
