Forms :: Confirming Text Box Value?
Jan 27, 2014
I got sidetracked during my lessons by a discussion of a login form. So I built one along with a user table, and lo and behold it works. I got to thinking about how a user might change their password without support from an admin or someone else getting into the table and changing it for them. I figured I could launch a password reset form and let the user type in their new password. This works too. What I am hanging up on is this: I figured that the user should be prompted to retype their new password then run a little vba to compare the two values, and if they match, write the new value to the field. I tried an If statement that checks for equality, but I don't know how to go about configuring the code to update the field in the table.
View Replies
ADVERTISEMENT
Aug 5, 2005
Hi there
This is what I'm trying to acheive and I'm sure its possible but cant quite get my head around it to do it.
I have a form with a multi select list box from which our customers can select a number of items they would like added to their worklist for the day. They then click on a command button which then sends those items to a table from which our employees then generates a worklist.
However what I would like is that once the customer has entered their selections I would like them to be able to click another command button before submitting the work to the table which would then show them the selections they have made before the info is submitted to the table. They would then review what they've selected and make additions or subtractions as neccessary.
I'm not sure whether or not I have to create two tables the first of which would hold their initial selections and then the first button would then run a query based on that first table and then once they click the submit button it sends that info to another table from which the days worklist can be drawn.
Another question is what if once they've reviewed what they've selected and wish to remove something? If selections go to a temporary table and then they unslected an item will that remove it from the table or would it create a new record which is not what I want.
If you could help that would be most aprreciated. I know very little in the way of coding so any explicit instructions would be most welcomed
regards
Steve
View 4 Replies
View Related
Mar 22, 2014
I have 4 fields that are unbound on a form. img1 img2 img3 img4..When these are entered they are all combined and autofill another unbound textbox = imagename.. what i would like to do is from this unbound textbox 'imagename' ..i would like to populate a textbox that IS bound called FileName
[Event Procedure]
Private Sub imagename_Click()
Me.imagename = Me.FileName
End Sub
View 4 Replies
View Related
Jan 6, 2014
My database has Main form and a Sub form. On main form i place one unbound text box named investigations. In subform of which datasheet there is a column named TestCode. I want unbound text box (Investigations) to display row values which selected in a column (TestCode) of subform.for example:Investigation field should display "CBC,HB,ALP".
View 5 Replies
View Related
Jul 12, 2013
I have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..
View 3 Replies
View Related
Nov 12, 2013
I am trying to search on EmployeeID field and populate corresponding data like EmployeeName, EmployeePay in other text boxes in the same box .
In my Unbound Form I have three unbound Text Boxes and one Command button:
txtEmpID
txtEmpName
txtEmpPay
cmdFind
In my table EMPLOYEE i have three fields
EmpID -- Autonumber
EmpName -- Text
EmpPay -- Text
View 2 Replies
View Related
Nov 21, 2013
how can i disable a textfield or two in a form when the textbox is unchecked also how do i add a default value for it while the textbox itself is disabled, can i get away with it by adding a default value on the textbox?
View 14 Replies
View Related
May 10, 2015
I have a form with two text boxes and a button. I want to be able to type a value into the first Text box click the button and the second text box to be filled with the value which is stored in the Table.
The first Textbox is called barTxt, The second Textbox is called CustTxt The button is called SearchBtn and the Table is called BookInTable. I have been trying to use the code.
Code:
Private Sub SearchBtn_Click()
DoCmd.FindRecord Me.BarTxt.Value, , True, , True
CustTxt.Value = "SELECT BookInTable.Customer FROM BookInTable " & _
" WHERE Customer = """ & Nz(Me.BarTxt) & """" & _
" ORDER BY Customer"
End Sub
This however instead of displaying the Value for customer which is stored in the BookInTable. Displays The code SELECT BookInTable.Customer FROMBookInTable " & _ " WHERE Customer = """ & Nz(Me.BarTxt) & """" & _ " ORDER BY Customer"
View 6 Replies
View Related
May 14, 2013
I want to enter text in an unbound text box and for it to be repeated in another on the same form.
View 6 Replies
View Related
Feb 14, 2014
I want 2 text , when I add a name to text 1 automatically set number to text 2 (Random),
View 3 Replies
View Related
Apr 11, 2014
Is it possible to have the value in a text box be set automatically based on the value in another textbox?For example, Textbox Gender is Male, so Textbox Reference is Male.
Code:
IFF Me.Gender = "Male" Then
Me.Reference = "Male" And
Me.ID = "ea13-02c"
Else If
Me.Gender = "Female"
Me.Reference = "Female" And
Me.ID = "ea13-01c"
End If
View 1 Replies
View Related
Apr 8, 2014
i have a form that contains a combobox and textbox.i want according to combobox choice a fixed template to be populated in the textbox and then can be edited (delete and add more text as needed) without changing the original template
View 2 Replies
View Related
May 12, 2014
I have multiple sub forms and want to add specific text boxes of different sub forms into one another sub form. Then all sub forms are incorporated in one main unbound form.
View 6 Replies
View Related
Jul 25, 2013
I am running in to a brick wall with this. I have an unbound text box with the control source set to =IIF([text42]=0,0,[text42]/[text44])*100 and in continues to return a #name? error.
I am not sure how to get this expression to work. I have even tried to put =[text42]/[text44] and I still get the #name? error.
View 3 Replies
View Related
Jul 17, 2013
I'm using the following code to set text box fonts in all my forms. Problem is a couple of my forms have a combo box which I need to reference here but not sure how. I want the Combo Box font to be the same as the text box's. Not sure how to check to see if the control is a combo box.
Code:
Public Function TextBoxProperties(frm As Form)
Dim ctl As Control
On Error GoTo TextBoxProperties_Error
For Each ctl In frm.Controls
If ctl.ControlType = acTextBox Then
ctl.FontName = "Calibri"
[Code] ....
View 8 Replies
View Related
Aug 16, 2014
I need to make the text size smaller to fit everything on the screen (users use 17" monitors..). I have gone into each form and subform and changed the text size for each text box to 9, but when I view them in form view the size has not changed ?
Also .. is there any way to make the autocentre option actually work as it's name suggests !! ? it does in most cases centre horizontally, but never vertically, quite often putting the top of the pop up form over the ribbon bar.
I would actually like to be able to totally remove the ribbon bar so that only the database forms are the only thing the user sees.
I vaguely remember being able to do this in Access 97 (Which was the last version I used - a long time ago !) but this seems to be more difficult in 2010 version.
View 5 Replies
View Related
Jul 31, 2007
hello ,
I made a text box in my form , and I have a table with two records.
table:
name: yoav
phone: 055
I want the text gets the name yoav from the table.
I can't directly give the value beacuse text cannot get a record value.
I tried to use query but it doesn't help.
How can I do it then?
thanks alot, cricket.
View 3 Replies
View Related
Nov 5, 2004
I have a form with numerous text boxes, combo boxes etc. I want to make two of the text boxes active (visible) only if the value entered is "Yes" in the text box above. Otherwise, if the value entered is "No," I want these other text boxes to remain hidden. For instance, if the user selects "Yes" the DVD is out on loan, I want three other text boxes to appear so that the user can enter the borrower's name, date borrowed, and date returned. Thanks!
View 2 Replies
View Related
Dec 19, 2004
Hi,
I have a form which allows me to search between two dates by using two text boxes. The code for the query behind the text boxes is:
Between [Forms]![name of my form]![name of text box1] And [Forms]![name of my form]![name of text box2] and it works great. However, I was wondering if it was possible to use the same two text boxes on another form running from the same query, or would I have to make another query for the other form? I have tried to use "or" in my statement, eg.
Between [Forms]![name of my form]![name of text box1] And [Forms]![name of my form]![name of text box2] Or Between [Forms]![name of my 2nd form]![name of text box1] And [Forms]![name of my 2nd form]![name of text box2] but when I try the text boxes it says "Enter Parameter Value".
Thank you for all your help.
View 1 Replies
View Related
Oct 19, 2005
I am trying to create a simple form with tabs. I want each tab to read from different tables.
I created the Form
I droped the Tab Control on it and made 2 more tabs
Now I want to add Text Boxes and populate them with values from a specific table. In the Control Property of each Text Box I set it to =[Table]![Field] and I get #Name?
I cannot seem to link the Text Box back to the specific table.
Once I do that I want to be able to Goto Next, Goto Previous etc.
CAN ANYONE HELP ME?
Thanks in advance
View 6 Replies
View Related
Jun 23, 2015
I have a volunteer information database, and I am working on the form that will show the details of each volunteer's hours worked, among other things.
I've attached screenshots of a more or less final version of the Relationships (I've tweaked it a little in the last day or so but nothing life-altering), the section of the form in question, and a query I wrote (probably incorrectly) that does return hours on a given month sorted by NameID, which is useful, but doesn't put the information into fields like I'd imagined I could. If I can't figure out how to make what I'd like work, I guess I could just put a subform that displays the results of the query, but I'd rather do it another way.
I tried this in the controls for each field:
Code : DSum( [tblHoursWorked]![MonthWorked] , "MonthWorked='November'")
Obviously switching out the months, but I'm getting the response of #Name? in each field. No syntax error so I'm not sure if I have something configured incorrectly in the text boxes or if there's a problem with the function.
View 8 Replies
View Related
Apr 8, 2015
I have two forms where in first form i have options for second form. In first form i have a text box and its value is copied to second form using this code
Code:
=Forms![FirstForm]![Counter]
But when i open second form using button in first form the vba message that counter value is empty. I used vba if code in second form on counter
Code:
if counter.value = 1 then
solo.visible = true
end if
View 1 Replies
View Related
Aug 21, 2014
I have a text field with receipt numbers in the format 0001-00000### and I would like my data entry form to default the max existing value + 1.
If max value is 0001-00000201, then the new record should suggest 0001-00000202.
The problem is that if I use the "max" function, it does not work (I think because that function is intended for numbers, not text strings).
Table: RECEIPTS
Field: receiptnum
I also have a query with just one field that lists only the receiptnum unique values so that I can use them in comboboxes in other forms... it may be useful I guess...
Query: unique-receiptnum
Field name: receiptnum
View 4 Replies
View Related
Jul 31, 2014
I am new to access but I am creating a form on access 2010 for a Pass Request. On the form so far I have two cascading combo boxes that work great so far. The problem is that once a name is selected from the second combo box(cboFullNames) I want a textbox underneath to populate(txtOrg). I have tried using requery and refresh but it never works. The only thing that seems to pull up the information is pressing the refresh button.
View 14 Replies
View Related
Feb 3, 2014
I have a form with text boxes bound to a table. There are two fields, ProposedSalary and ProposedIncreasePercent, that should not be populated at the same time. It's either one or the other. I've tried to add a validation to the percent field to check if the salary field is empty or has value. That did not work for me and I removed the validation. Ever since, if I try to input a percent value into percent field, it changes to zero on exit. I think i might have tried to add that same validation to the form itself but i checked all the properties and I don't see anything. I've looked at the VBA code view and did not see ProposedIncreasePercent referenced anywhere. I created the document for the form through the document analyzer and searched for that field and couldn't find it. So, I can't find anything coded anywhere to change that field to zero but yet it does. I've also tried to remove the field and add it again and it does the same thing.
View 2 Replies
View Related
Jun 27, 2014
How can i make a picture appear when I've entered data in a text box. I tried the code for a check box but it didn't work.
Me.Image190.Visible = Nz(Me.checkbox, False)
View 9 Replies
View Related
