after entering data into a text box I need to run some code (i.e. sql update the table) by just pressing the {enter} key, what code is required? how do I go about doing it ?
any info would be appreciated.
thanks
jabez
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 RelatedI am trying to edit the following code to be able to require the user to enter a Loan number and keep prompting the user to enter a value as long as the field is blank. Once the field is filled in, then the code should go on to check if the sql condition is met and make the necessary change if met, then finally, I have a save command code that will require the user to save the record. Right now I am getting errors when I added the code to require the user to enter a field. I am new to loop and if statements in vba so I am not exactly sure how to structure it.
Code:
Private Sub Save_Record_Click()
Dim SQL As String
Do
If IsNull(Me![Loan Number]) Then MsgBox "Please Enter Loan Number. This is a required field."
[Code] ....
Right now on a form I have code that runs when the used DoubleClick on that field. Users want to have the code run when the EnterKey is pressed as well but when putting the code in the onEnter command line it would run the code when you tab thru the field.
View 2 Replies View RelatedI'm not an advanced user of Microsoft Access 2010, I've been working on a database for a company that does Non Destructive Testing, so my task is to simplify how the technicians process the information and make their jobs easier.
Firstly, I have assigned a Unique Identification to a code in this case - X8120 This code is assigned to a row of information.
What i want to do is enter the code X8120 into a text-box and once the code is enter, i want the database to retrieve all information that's assigned to that code from the row (which is 17 fields) in a table.
When the information is retrieve, i want those 17 fields to automatically populate into their own text-boxes, so there would be 17. This would all be on one form. So the technician only has to enter a code which displays the information relating to the testing the technicians have done.
What i have done so far is made the table into a form and added a select button command, so a technician would click on a button that opens a form and select the row of information they want and populates those 17 fields.
So my aim is to simply enter a code or an event and the database will retrieve the information instead of going through a form to select the information. So i am simplifying the process even more.
Works great, but when I hit the number "3", (3 times in row) it will let me into the form. I want it to not let me in IF I don't know the password.
Where did I go wrong?
Private Sub Form_Load()
Dim pw As Variant
If InputBox("What is the password?", "Password") = "1" Then
Else
MsgBox "Invalid Password", vbCritical, "Sorry Charlie"
DoCmd.Close
If InputBox("What is the password?", "Password") = "2" Then
Else
MsgBox "Invalid Password", vbCritical, "Sorry Charlie"
DoCmd.Close
End If
End If
End Sub
I protect my code from people being able to read it by setting a password on the code from Tools > Properties, selecting the Protection tab and entering a password, and clicking "Lock Project"
Is there a way to write code that will remove that Lock Project check and check it back on?
I've looked through the Application.SetOption command and it doesn't seem to be one of the choices. It would be very helpful if someone knew how to do this.
Thanks
SHADOW
I want to be able to simply type out my query. It's faster for me than using the GUI.
Where in Access can I just enter a statement?
Hi,
I have a Data Access Page which is generated on behalf of a query.
Query uses one parameter field ,so when is started it promts with the form named Enter Parameters in which I have to input parameter value.
So before the DAP is opened, first is displayed parameter form.
I would like to change dimensions of that form(height, width) but I dont know how.
I already tryied by opening DAP in design view & then in microsoft script editor but i couldn't find anything about this pop-up parameter form.
Any suggestions are wellcome:rolleyes:
I have built a database which has been running OK for 3 or 4 years. Something happened the other day (error - rebuild d/base) and now there are certain fields that I cannot enter any data into. Others are fine and I can see what is already there.
Any suggestions very welcome.
I have a form and it is related with a query and by clicking ok I got the required results in Access 97. But now I have converted to Access 2002 and whenever i enter values in the form and click ok I get a Dialog Box "Enter Dialog Box". I read MKB article but it did not help me at all. Please help me out I am not getting any idea at all to solve this problem?
View 6 Replies View RelatedI have searched other threads and cannot find one that helps solve my problem. So, I hope someone can help.
I have a query which runs ok until it is filtered. I have tried using criteria to filter the info I need but this returns an 'Enter Parameter Value' message. Running the query without using criteria works okay but using a filter in the report itself returns a 'Data Mismatch' message.
The report filters fine on fields until it gets to one that has been changed from text to number. It also includes an Nz formula. The formula in the is field is: CLng(Nz([order_no],0)). Other fields related to this also appear to be affected.
I need the CLng formula as the field is needed to calculate other fields using a zero instead of a null which would otherwise cause an error. I was given the formula on this forum yesterday, (thanks Bob Larson and AlanJ10), which was great in solving the other issue but is this is what is affecting filtering, (ie. a confusion between text and number?!?!) I have also tried converting the result of the calculation I want to filter back into text using CStr but this does not make any difference.
I have checked the field names and also renamed fields that were 'Expr' (as in default names for calculated fields), and cannot see any problems.
Thanks
I have a query and one of the fields/headings i have it create is a "cost" total where it does a dlookup from a defaults table.
I then have a "listprice" which is antoher field in the querry of which the data table sits.
I want to take the [listprice] and minus the [cost] without re-creating the dlookup function...
I need this to help with an APR calulction using the RATE function which if i have it do all the dlookups it says I have exceeded the limitiation and will be trumcated. So if i use the name [cost] it works but i have to hit enter because it says "Enter Parameter Value".
Any ideas how to get around this?
Thank you.
I have the following query that gives me this halt. If I enter without responding to it it opens in Datasheet view as intended. It wants me to enter Query2.EmpID. This is my SQL statement.
SELECT qryPolicyByDriverName.CWSPolicy, qryPolicyByDriverName.EmpID, qryPolicyByDriverName.DriverName
FROM tblTrainingPoliciesNotCoveredDrivers INNER JOIN qryPolicyByDriverName ON tblTrainingPoliciesNotCoveredDrivers.CWSPolicy = qryPolicyByDriverName.CWSPolicy;
I don't know why this is happening. Thanks for looking at my problem.
I have a continuous form with an unbound text box (for search critera) and a command button to kick off the search, which simply applies a filter.
When a user enters text in the unbound text box and hits "Enter", I want the search to be kicked off (instead of having to tab over or mouse over to click the "Search" command button. This is the default functionality of an HTML <form>, so users kind of expect it. But I'm having trouble implementing it in MsAccess.
I've tried using the KeyDown property of the unbound textbox, but no luck, since the KeyDown method occurs before the data in the box is saved. I'm guessing this is related to detecting what key has been pressed but my issue seems to be the order of events occurring on the form.
Any suggestions? This *must* be common situation, but I've found no related topics in searching the forum.
ok im am not sure if this is in the right place but it seems to be a form problem.
i have a form that has a textbox(text1) which is used to enter a supplier name, the user then presses enter and another form opens up with all the supplier details.ok.
the code i have to do this is on the afterupdate of text1 which is unbound is
DoCmd.openform"SupplierDetails",,,"[Supplier Name]=" & Supplier name
when i use this code and the enter key is pressed an `Enter Parameter Value` dialog box appears with the supplier name under the blue title bar.if i then enter the supplier name again it opens the second form and displays all the details i want.
If i use the code
DoCmd.openform"SupplierDetails",,,"[Supplier Name]"= me.Supplier_name
it opens up the second form without the dialog box but it doesnt display any details.
is ther any way to adjust the first code so the dialog box isnt displayed and just goes straight to the second form and displaying the details.
i have gone through as many posts as i can but cant seem to find a fix.
any help would be appriciated thanks
Hello all,
Thanks to all the folks that have helped with my posts in the past.
I have 2 questions.
I have a form with textboxes.
When I tab from one textbox to the other, the tab goes to one of the buttons on the page. How do I tab from one textbox to another.
Also, I have a textbox for memo. I would like to press enter and go to the next line in that textbox.
Thank you very much.
I created a form to let user enter project summary. However, the maximum charaters is 255. What can I do to allow more charaters be entered in the form? I already set up "can grow" as yes.
Thank you.
I have a text box next to a button that takes the value in the text box and performs a search with it. I'd like for the search to be performed when the user hits Enter after entering the value in the text box (when the focus is still on the text box). I assumed that i'd need to use the onkeypress event to run the search function performed by the button, but i'm not sure how to do this. help anyone?
thanks,
Jason
I have one form where I want the 'Enter key to be disabled. What is the best way to disable the 'Enter key for this one form without disable'n it for the entire database?
View 1 Replies View RelatedHere's an awkward problem that i'm experiencing...I've created a form and everytime i hit the Enter key, any data that i've inputted disappears . I've noticed on the bottom right corner where it displays form view when i hit enter it say's calculating...and then poof , data gone...i've created a test record, #3738...Any help will be greatly apprecitated...i've attached form for a better understanding...
View 3 Replies View RelatedI have table that is used to collect roster information the date field is formatted dddd/dd/mm/yyyy a second field requires the end user to insert W to designate the entry as a weekend date. The end user's often forget to insert the W (not functional) I need a way to code the field to look @ date field and update itself with a W if [DateField] is a weekend date.
A query calculates the roster hours and * the hours field by 1.5 if the W is true. The query works fine, I just want to automate the "W"
Weekday Fn perhaps? Help anybody???
Hello,
I get the above message when I try to open a database created by someone that no longer works here. I tried to create a new version of the workgroup information file and assume the permissions of the administrator, but I still cannot access the database. Any leads?
Thanks
Does anyone know if it's possible to edit the contents of the "Enter Parameter Value" Box...for starters, I'd like to delete the phrase "Please Enter Parameter Value" as it means nothing to most users of Access; also, I'd like to format the text that I've entered in the query itself, i.e. make it bold, increase the size of it.
Incidentally, I did go down the route of linking my query to a form but this caused problems as I want more that one user to be able to view their particular parameter value at the same time.
Many thanks
Can anyone tell me if the following is possible in a table or do I need to use a form.
I have a check box in a table that when I check it I want it to automatically enter the current date. I also don't want to change the dates that have already been entered manually and that date should only display the date on which the check box was checked. :confused:
It is a database that hold the details of IT equipment and when it is disposed.
I think I may have to use a form but I would like someone to confirm this if it is possible to do in the table could someone also help me implement it.
Thanks in advance
Hi all
Can a SQL query be written so that when the user runs the query, a prompt asks the user to enter the field they wish to see?
i.e. a query is written to return certain predefined fields, plus a field that is not defined. When the query runs an error comes up to enter the field it should search for.
It would be handy for the start of each month, when a new field (month's data) is required. It will avoid updating the query each month.
Thanks in advance!!
Lucas