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 RepliesWhen user enter the data other than date field or when date field remain empty and user press the Add button, it is giving error.
(Error 3075)
Syntax Error in date in query expression '#'.
while same code is working for text field. but it is not working for date field.
If (Me.rdate) = "" Then
Exit Sub
End If
I wish to use message boxes that pop up when certain options are chosen, that can either be immediately cleared by clicking the 'OK' button or that disappear by themselves after a short period (10 seconds in this case). After searching the net for various options, I found the following code:
Code:
Set objShell = CreateObject("Wscript.Shell")
intReturn = objShell.PopUp("Date of Birth updated", 10, "FYI", 64)
(The 64 displays an information symbol).The box is displayed correctly and the 'OK' button works fine, but the box does not automatically dismiss when nothing is pressed.
How to restrict the updation of a record while entering until a save button is pressed on the form ???????? is it possible without the vba ?
View 10 Replies View RelatedHere is my problem
In namefield_AfterUpdate, I check for duplicate name entries and notify the user if any are found - they are prompted as to whether the duplicate was accidental or intentional and continue working. This works fine for normal circumstances.
However, if the user updates namefield so that the value is a duplicate of an existing name in the database, but then presses Cancel (or Delete), then the namefield_AfterUpdate is fired and what button they pressed. The button Click code does not run first.
How can I tell if the user updated the name, but then realized they didn't want to save, and then clicked 'Cancel' (or any button) and the code should really skip the duplicate check validations/messages?
Running XP or Win7 with A2007
I have got a a form storing all employee's information and on that form I have a lookup field which looks up all the records in the "Qualification table" and the user can select multple qualifications. What I want to add to the lookup field is a data box so you can select a qualification and then enter the date that it expires (different for expiry date for each employee) How do I do this?
I have added the date field to the qualification table but when I create the lookup field on the form it shows the qualifications and a blank column next to it which data can't be enteed into.
I need to make my mainform fields required before any data can be entered into subforms. Mainform and Subforms are linked with LinkMaster Child ID. This should only be applied in this form.
View 4 Replies View Relatedafter 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] ....
I'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.
why I get a pop up asking for parameter value of fields I no longer have in my table? It says this when I open my form. I deleted the fields from my form but it's still asking for it.
View 2 Replies View RelatedI am having some problem with the Microsoft Access. I want to preview the report but it always show the popup asking me to enter the parameter value after I clicked the button. For your information, this problem doesn't occur in the subform. But when I try to test it with my main page, the problem is occur. Need to remove the popup.
View 2 Replies View Relatedi 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 RelatedI have a relationship from one table to another. If one item is entered into one field, I would like it to auto-populate it into another field. But there are several more fields I would like to be autopopulated.
EX
Table_1
item no, hull no, description
Table_2
item no, hull no, description..
I want to enter data into table 1 and have it auto populate into table 2. How is this to be done
I downloaded a student template from microsoft and have been able to figure out most of it. I cannot see where to enter the emergency contact information. Also, when I try to see the student and guardian table/list, the guardian list comes up empty even though I entered this information when I entered the student info...
View 2 Replies View Relatedit is zip file unable to get the size lower yet minimal amount in database I have 2 tables and one form when I create an query on the form the form then becomes that I cannot enter data in it or edit etc
View 3 Replies View RelatedI created a form that allows users to enter data into the fields and populates the table.But can I have it do that and populate instead of one table, two tables?
View 13 Replies View RelatedI have a problem with a DB I just designed. It has a combobox that is populated from a query, and it works great. However, the problem is that when I enter a new record the combobox is not being cleared, and is "holding" the data from the previous record. How can I get it to "reset"?
View 13 Replies View RelatedI have 2 form
main form = "TanggalF"
subform = "MerkFsubform"
I have a query with 2 field "Combo28" and "Combo30"
I use it in subform with query [Forms]![MerkFsubform]![Combo30]
Combo30 is combo box on MerkFsubform
If I open in subform "MerkFsubform" work, no problem
but if i open on main form "TanggalF" it get errror "Enter Parameter Value" Form!Merksubform!Combo30
i have to write a result of the query to the excel, which is a invoice template where i need to enter the data.
Depend on the result the template can grow in size also, here if the size grows there needs to be informatin coming on first page for eg: address in first page should not repeat in second page, second page have purly order details and footer at the end which have signatue and attestation.
Problem is data can be in 1 page, 2 pages, 3 pages ..or more
How can i achieve this task as all pages have water mark as page 1, page 2...sand so on...?
(A Sample i have attached)
So, I've got a frmCustomer and want to link the form to frmNewWorkOrder using a button.
More precisely when I choose/scroll to a customer and click the button "New work order" to autofill data from selected client from frmCustomerto frmNewWorkOrder (First and Last name, telephone number and client ID).
I continue to get this "Enter Parameter Value" on my access and I can't figure out how to fix it. I have access 2010..
"Field1. Filename"
I have a database structure with a series of queries which are all inter-linked.
I want my database to be user friendly, what is the cleanest way to be able to enter a single variable eg as a criteria for a query - say the date, rather than having to change it in a series of queries manually, can I call it from somewhere?
Whenever I open the form 'TrainingF' I get the 'Enter Parameter Value' msg box. I tried to look online but could not get rid of it. I have attached the file.
View 6 Replies View RelatedI'm looking for a simple routine, preferably in the On Key Down or or On Key Press event of a form to quickly navigate to a record based on the key pressed.
I have a form with names in a table layout (continuous form).If the user is on the name field, I'd like it to navigate to the first record that contains first letter of the key pressed. So if a user presses "K", the form will go to the first record that starts with a K.Yes, the names in the form are alphabetical, but in a list with over 100 names, this could speed things up just a bit and save a lot of scrolling and looking.I was thinking of using KeyCode and I already have an event to navigate by the arrow keys so I'm considering building on that.
Code:
If KeyCode = 40 Then ' Down arrow
DoCmd.GoToRecord acForm, Me.Name, acNext
ElseIf KeyCode = 38 Then ' Up arrow
DoCmd.GoToRecord acForm, Me.Name, acPrevious
End If
I am thinking to use a Select Case and add the key codes for all the letters.