Select Entire Field Automatically
Mar 14, 2006
Hi,
I want to have the entire field in a textbox selected, automatically, everytime the control is entered--- so the user can just begin typing and automatically type over the existing data in the textbox.
How do I do this?
I thought it would be as simple as adding something like the following to the textbox's on_enter event:
Sendkeys "doubleclick"
The textbox will always contain just a single "word", so this idea should work....but I can't find anything like a "doubleclick" that can be used with SendKeys.
THanks for any ideas.
View Replies
ADVERTISEMENT
Jun 16, 2005
Hello to everyone...
I have a calculated(unbound) text field named(Age) on my main form. The Age is calculated based on patient's DOB(Date of Birth) Field using datediff function, and in the subform, I have a field named (AgeNo).
There is a criteria for AgeNo Field depending on (Age) field for each patient.
Criteria:
If Age is 18-40 = AgeNo should be 0
If Age is 41-60 = AgeNo should be 1
If Age is 61-70 = AgeNo should be 2
If Age is >71 = AgeNo should be 3
MRN (Med. Rec. No) field & Age are in Main form and AgeNo field is in a subform.
I want the AgeNo field to automatically select ( 0, 1, 2 or 3 ) based on the calculated unbound text field(Age).
Many thanks... :)
View 3 Replies
View Related
Mar 13, 2013
I have one field AccountName in customer table and another field AccountID.
In my form I would like to select from the combo box AccountName during data entry and then have the AccountID automatically update in the Account ID field.
View 2 Replies
View Related
Aug 24, 2005
Hi all,
I had table with following data
Table
f1 f2 f3
1 10 aa......
1 11 aaa...
2 10 bb...
2 11 bb.......
f3 is memo field
I had to retrieve data by grouping records based on f1 value
so i gave groupby in totals section to f3 field also.
I am getting the values correctly, but memo field is truncating.
Its only displaying first half arround 236 charecters only.
If i query directly without performing any group by
then i am getting entire data for the memo field.
please any one give the solution.
waiting for your help.
Thanks
View 1 Replies
View Related
Oct 25, 2004
I am trying to view the contents of a text field in a form. The field can only be a limited size in the form, but I want to store a lot of text in the field and have it visible without having to enter the field and use the arrow keys to view the contents. Is it possible to programme a function that shows the contents of a field when I roll the mouse over it or something like that? The "Control Tip Text" is the principal of what I am trying to do except this gives a fixed value. When used in web page development I think this function is refered to as "Alt tag"
View 3 Replies
View Related
Sep 1, 2013
Here is a link that explains a little bit about it: [URL] .....
However, I'm having a problem with summing an entire field. Access does not have a DProduct() function, so it makes the math of "taking the Nth root of a product of 'X' numbers" kind of impossible without writing a custom function.
View 4 Replies
View Related
Mar 9, 2013
I know that multivalue fields are not the best to use, but I have a simple database that they work fine in. My question is this: Is there a way to show the entire list of choices in the multivalue field on a report? Not just the ones selected, but all of them, whether checked or not? The multivalue field has a list of names and the user selects each name if they repond to a incident (fire, car accident, etc.). My report would show the entire list and count number of responses by each name during a date range. I want to show all of them on the report, with those not selected showing "0".
View 3 Replies
View Related
Sep 26, 2014
I am building a database where one Form displays records from 14 different tables. For some reason, when I recently try to add a field on to a form from a new table, the ENTIRE form loses the record source, and every single field that is already on the form gets that green dot in the corner with errors surrounding a record source that cannot be found. What am I doing wrong? Am I exceeding some limitations with forms?
View 4 Replies
View Related
Dec 16, 2013
I am building a report that has a header with several details followed by a detail section.
What I need to do is make the entire entry not visible on the report if one of the dates is null.
So it looks like this
last first title id memb # date a date b
1. smith , john fng 8521 2356224
5/12/2012 6/20/2013
10/2/2013 (is null)
2. neckbone, jim dude 2548 85858412
6/20/2013 5/5/2014
8/5/2013 2/31/2013
On the report i want the 1st entry (smith john) not to be visible due to the null (B) Date.... but i want it to be visible once the date is entered...
View 2 Replies
View Related
Mar 12, 2014
Basically, what's the best practice or how do we store a query's value into an array then checking what the max or min value is and how to check if let's say "4" is in the array?
View 1 Replies
View Related
Oct 24, 2007
i would like in a form for a combo box to be able to select an item from a table and input relating information automatically into other boxes in the form..
I have 3 tables: Table 1 has product code and product description.
Table 2 has invoice number company details, address etc.
Table 3 has product code and product description qty and invoice number..
Table 3 relates to table 2 by the invoice number and table 3 product code looks up the product codes available in table 1 and also table 3 looks up the list of products descriptions in table 1 using the combo wizard.
This means the wrong code can be put with wrong description.
What i would like to know is how i select a product description and the product code in the form fills out automatically?? i hope this makes sense please helppppp!!
View 5 Replies
View Related
Nov 10, 2005
I need to create a New Form control for this situation:
If I enter a date into a field and the choice for another field is equal to a certain value. How can I get the date I entered to be automatically populated into another date field.
For example:
If I enter 11/10/2005 in a date field and I choose either "BN", "BA", or "BT" in a text field, I need that date of 11/10/2005 to be automatically populated in another date field on the same form.
Any help is greatly appreciated.
View 2 Replies
View Related
Dec 3, 2013
I'm trying to complete a database.
It is to manage details of pupils with additional support needs, and plan for the extra arrangements the school will provide for assessments.
It has 2 Tables
tbl-PupilDetails
-ScottishCandidateNumber primary key (Unique number which identifies pupils to the exams board)
-Forename
-Surname
-DOB
-YearGroup
-Class
-NatureOfNeed (memo)
-EvidenceOfNeed (memo)
tbl-SubjectLevelArrangement
-ID Primary key, Autonumber
-Pupil foreign key to tblPupilDetails
-Subject
-Faculty
-Level
-Arrangement
I currently use forms for adding new pupils, and updating pupil subjects/arrangements/levels.
I also have forms to search for specific pupils, and to create lists for faculty heads showing which pupils are taking subjects within their faculty and the arrangements we expect to provide.
I use the forms to run queries, which can then output to reports for printing.
Where I am currently having an issue is the faculty field in the tbl-SubjectLevelArrangements. (If I didn't have to report to faculty heads I would just leave it out, but management will insist.)
Currently I have a form with dropdowns for adding subject, faculty, level and arrangement manually. This is acceptable for the subject, level and arrangement because they are completely interchangeable and dynamic throughout the academic year as pupils may drop down a level, or change the type of arrangement they require.
However as faculties are inextricably linked to subjects, I want to remove the possibility of human error. i.e. when a user (me) chooses either geography, history, or RE, then the faculty will always be Humanities, likewise if the user chooses French, German, or Spanish, then the faculty can only be Modern Languages etc.
I'm convinced there must be a very simple way to ensure that the faculty field prefills based on the limited keywords available in the subject field, but I just cannot figure it out.
View 6 Replies
View Related
Dec 15, 2013
I made a report that have 'txtRemarks' field, I just want to get remarks automatically in 'txtRemarks' field based on the other field in report. that is why I used a function like below:
Code:
Private Function Estd_Remarks(Estd_Point As Long) As String
If Me.Estd_Point < 20 Or Me.Estd_Point = 0 Then
Estd_Point = "Earlier Established"
Esle
Estd_Point = "OK"
End If
Estd_Remarks = Estd_Point
End Function
And I wrote in properties 'On Format' event this code below:
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Estd_Remarks = "Ok" Then
Me.txtRemarks = "Ranked & Sortlisted"
Else
Me.txtRemarks = "Estd_Remarks"
End If
End Sub
When preview the report then it shows
Compile error
Argument optional
View 3 Replies
View Related
Aug 12, 2005
I have two tables, each has a "status" for a project. In the first table there is only one instance of each project name, in the second table there may be more than 1, will always have the same name but may have a different "Status" (field).
I need the Status field of the first table to be set to "Assigned" if ANY of the records in the second table pertaining to that project are set to "Assigned".
Can I do this with my table or will I need to do it with a query/form combination?
Thanks,
View 4 Replies
View Related
Apr 22, 2014
In Access 2013, in a table named DOCSDETAIL or form, I want the UTENTE (meaning user) field (Currency type €) automatically receives the same amount of PVP field (Currency type €) but can be modified as needed.
Example: Registration of documents in which the amount paid by the USER has two possibilities;
1. DifferS from PVP (Public Sale Price)
2. Equal the PVP
Looks like it might be used
= "Update your_table set your_field_new = your_field_old"
= "Update DOCSDETALHE set UTENTE = PVP"
But do not know where to put and if the syntax is correct!
View 5 Replies
View Related
Apr 14, 2005
Hi
Forgive me - but i am new to db.
I have an employee field in my purchase orders from and when I do stock transactions - i have an employee field against each item in the purchase order. I would like to just copy the employee field from the purchase order form automatically next to each product listed instead of having to keep typing the same thing.
the reason i am doing this is because when people come to take stock out - i would like to see there name against each item in the products from so people can not not take more than they ordered.
thanks in advance.
View 4 Replies
View Related
Dec 7, 2004
hiya... he's my problem........
i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.
in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)
If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.
How do i achieve this please..????
many thanks for viewing!!
View 1 Replies
View Related
Dec 7, 2004
hiya... he's my problem........
i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.
in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)
If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.
How do i achieve this please..????
many thanks for viewing!!
View 1 Replies
View Related
Aug 12, 2005
Hi everybody,
I have a table that has 4 columns as shown below:
(*It really isn't code, I just couldn't figure out how else to keep the columns in place!)
-------------------------------------------------------------------
Store Name Invoice Number Customer Name Customer Address
Store1 1 Bob PO Box 55
Store1 2 Joe PO Box 789
Store2 3 Chris PO Box 1254
-------------------------------------------------------------------
On my input form, for entering a new invoice, when you select the customer name, I want the form to automatically fill in the correct address in the "Customer Address" field.
I think there has to be a way to do this because there is only ever going to be one address for every customer. And the same customers will be comming back very often.
Does anyone have any ideas?
-Chris
View 14 Replies
View Related
Dec 16, 2005
Hi guys,
I have a mainform "frm_CaseReference" and a subform "subfrm_CasesControls".
In the main form I have "DOB" field and in the subform I have "DateSlideTaken" and "AgeAtSmear" fields.
I want to automatically calculate age in the "AgeAtSmear" from the "DOB" and "DateSlideTaken" but having problems.
I have tried the following code but it doesnt work:
=DateDiff("yyyy",Forms!frm_CaseReference!DOB-[DateSlideTaken],Now()
I have read it is not good idea to store age but my work place want this so i have to include it. Can someone please help....
View 2 Replies
View Related
Sep 12, 2006
I am currently handling an insurance operation. I have 5 Sales Executives (SE) who receives certain percentage of commission for each sold insurance policy. SE receives their respective commission on a pro-rata basis. Meaning, if they give 4 equal monthly payment scheme to their clients, they will also receive their commission -- 4 times.
Example:
SE Commission for one sold policy is: 100.00. (Granted SE gives 4-month-term, SE will be receiving 25.00 monthly, upon cleared payment)
On my 2 tables lies the following fields:
[Table1]
SECom1
SECom2
SECom3
SECom4
[Table2]
CustPayment1
CustPayment2
CustPayment3
CustPayment4
Is it possible to automatically update Table1.SECom2 based on the figure on Table1.SECom1, once Table2.CustPayment2 is updated?
Thank you!
Sheila
View 2 Replies
View Related
Jan 25, 2006
This is probably very simple to do, but, I am most likely missing the obvious...
I have 3 fields,
UnitPrice,
NumberPerUnit, and
NumberPerUnitCost.
I would like to have the NumberPerUnitCost field filled automatically based on what I have entered into the other 2 fields. I would also like to have this saved in my table as I will use this single unit cost when calculating some production costs.
Any and all help would be appreciated. If I am going about this the wrong way, please redirect me.
Thanks, Karen
View 3 Replies
View Related
Feb 5, 2015
My "MainMenuForm" contains a button that imports a specific csv on a specific location.Someone should do this import once per day. The problem is that there is no way for me, once the import has been done, to know which records are "new".There is no unique field that distinguishes the new records from the old ones.
I was thinking of adding like a Date() field to that csv (= the date where it was imported). Can this be done automatically? So if I import a file today, the final column would be 05/02/2015If i import a new file tomorrow, it would be 06/02/2015.
View 2 Replies
View Related
Jun 27, 2011
My boss has been asking me to create forms in which he can add new records at any time. He has different review cycles for each company he owns (either monthly, quarterly, or annually). I have a form called "REVIEWS" where my boss wants to be able to add a memo with a time stamp each time the review cycle is updated.
How can I use the "addNew" function so that a new memo text box appears in the form each time the review cycle is completed? My boss wants to be able to see each of his notes for each time he reviews a company so I want to be able to keep the old memos as well.
View 14 Replies
View Related
Oct 15, 2005
I have an Application that I want to re-use for a second user. The only change I need to make is to re-name the fields.
Is there a tool that can do this across the tables, queries and reports for each field name change ???
View 1 Replies
View Related