Caps Lock
Jan 6, 2005How can I convert the lower case data into upper case data automatically while entering data without using Ucase() function, in each and every textboxs or other objects in the forms ..
View Replies
ADVERTISEMENT
Lock And Un Lock A Text Field Through A CMD Button
Jun 13, 2005I need to lock and unlock a a few text fields with a CMd Button.
and i do know about the allowedits thing, but i only need to apply this to a few fields on my form.
can some one throw me a clue?
Returning Caps On A Form
Jan 7, 2005Heeelo all:
I have a form with text fields where I am entering customer last names and first names in different fields. Does anyone know how to return UPPER CASE letters automatically?
Thanks,
Dee
Make All Text Caps
Aug 30, 2005I need to make all my text in all my fields Caps.
The users want type the text in the field and have it be caps even if they don't have the caps lock on.
Is there an easy way to do this?
Any help would be great!
How To Set Font To Small Caps Using VBA
Jan 18, 2014My client wants a company name that appears on multiple forms and reports to show as font name Garamond which is fine... however, he also want the font to appear as "Small caps". In Word and Outlook, under the Font submenu, I can check Small caps and get what he wants... lower case letters are shown as Small capital letters. Is there a way I can make the same settings on labels in Access without installing a new font on each workstation that runs the database.
View 3 Replies View RelatedCombo - LimitToList Small Caps.
Feb 7, 2005I have a combo with the LimitToList set to yes so I can add new data to the underlying tbl. This works fine with one exception. When I enter the data I occasionally want to enter it in all Capitals but when I select Ok to add it to the tbl the first letter is a capital & all others change to small caps. I'm a little rusty on Access at the moment so I need a prompt pointing me to what I need to change to fix my problem. I'm thinking this is a formatting problem? :(
View 2 Replies View RelatedModules & VBA :: Automated Caps In Code?
Jun 3, 2015I am having a few issues with my module code in Access 2002. for some reason every time I write some code Access is automatically making the first letter a capital so for instance [Our Ref] should be [Our ref] but it simply will not let me do it!
Temp = rstHTML!html1 & rstProp![Our Ref] & rstHTML!html2 & rstProp![Our Ref] & rstHTML!html3 & rstProp![Property Title]
Modules & VBA :: Caps And Num Locks Switching Off
Dec 15, 2014USING ACCESS 2010..My user has reported that his caps and num locks gets switched off when entering a particular form and after testing he's right!!
I've googled this and it seems that sendkeys is/could be the culprit.I do have sendkeys in the code so how do I get around it other than not use sendkeys? Can I switch num lock on in VBA?
Queries :: Change Name Field To Display ALL CAPS
Oct 14, 2013My attendance dB has some last name in lower case and others in all caps base on user input. Is there anyway to make it consistent? Also, please there will be about 250 users scrolling through the name column for attendance. What would you recommend for the most user friendly way to display names? How to create a form that would perhaps allow a button for all last name like "A- C" member name
SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[First Name]),IIf(IsNull([First Name]),[Last Name],[last Name] & " " & [first Name])) AS [Student Name], Students.*
FROM Students
ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));
Cursor To Left And All Caps In Code Field
Dec 14, 2014I have a table with CODE number as text. (1234-11-3456). I also have this field in a subform. How do I get the field to start at left, and also make all CAPS. Also where do I do the input mask. In the Table or the Form where it is a subform?
View 4 Replies View RelatedLock The Field
Apr 22, 2006Hi,
I create the datasheet form,
I know how to lock the field, but it lock the whole column of the field.
I want to lock the field except the last record field only.
Can I do that?
eg.
ID Field1 Field2
1___a______b
2___c______d
3___z
I want to lock the field2 except the ID=3
Please let me know, thanks.
Lock Records
Oct 30, 2005My company has asked for an issue tracking database with the requirements that if is someone is edditing records it locks that block down until that user is done. I don't have any idea how to do it. my db is set up this way.
tables
tblPolls
tblIssues
Querries
qryPolls
qryIssues
qryFindPollsByID
qryFindPollsbyName
Forms
FrmFindPolls
FrmSearchResultsbyId
FrmSearchResultsbyName
FrmIssueTrackingMain
FrmIssueTrackingSub
The Form Issue Tracking Main has the Sub form IssueTracking Sub
Here users enter the issues in the sub form. The forms are linked by Poll ID
Is there a way to lock all the records with the same pollid in the tbltblIssues. Also to check who is editing them at the time?
How To Lock Records
Apr 5, 2006I've set up a database for use by a team of approx 10 people. I've got problems with locking records so that only 1 user can edit a record at one time. This is happening in a form with a subform included... Can anyone help?
View 6 Replies View RelatedLock Problem
Aug 16, 2007hello,
Access gives me the following error:
runtime error 3326 this recordset is not updatable
How do I make a recordset UPDATABLE?
2 days ago, I was able (from front end file) to open a table (in the back end in another computer) and modify the records or add a new one. Yesterday, Office 2007 was automatically updated from the internet, and now I can open the tables but it locks me (it doesn't let me modify or add anything)
Does anyone have any idea of what's going on and how to fix this?
thank you
How To Lock Tables
Oct 13, 2004hi,
i have created a table with 2 records.i want to lock the record such that nothing can be done with the existing records but allows to add new records.wat should i do??
thank u
Lock Table
Nov 5, 2005I want to lock a table to disallow further records.
I want to have only one record (I would have created this rec by myself) to store initial conditions and infos such Username/company etc.
Any ideas?
I'm also interesting in other solutions than locking a table if sucj a thing is not possible or nt functional.
Tnx in advance
Record Lock
Dec 1, 2005I have a created a database for insurance policies.
I'm using a form in the database to edit the data in the underlying table.
I use "pessimistic lock" in the database and in the form.
The database runs in a multi-user environment.
My question is the folowing:
When a user is editing a record, it is obvious that this record is set to
lock in the table (--> pessimistic lock), but the 4 records that are right before this record
are also locked too!
There is nobody else editing at that same moment in the database and it is
not a one-time occurence!
Can somebody help me out with this one... I'm realy desperite and I
searched the entire forum.
Lock A Table
Apr 12, 2007I'm working on a database that calls on a table of zipcodes. All of these zipcodes have latitudes and longitudes connected to them..... I've searched around but cant seem to find anything on locking a table. Is it possible to lock down a table so changes cannot be made?.....(until I need to make them)
View 1 Replies View RelatedHow To Lock Tables
Aug 30, 2007hello to all
i want to lock the tables and queries of my database in access so the users cant modify any information
Lock Down Record
Feb 2, 2005Hi all. I have a form that when I click a button is automatically changes a field on another form and then closes both forms. Can I add anything to this button to stop that record from being altered again. IE. when i click on this close job button nobody can ever change the record again. Thanks.
View 1 Replies View RelatedSecurity Lock
Jun 10, 2005Dear everyone
I have enclosed a sample need someone to help.
I have a form and in the form there are sentitive information such as cost price. Is there a way to make it invisible or make it protected (cannot see) and then set a button beside this field, if I want to see the data in that field, I just need to click the button, it will appear with a password(for security wise, this button must be password protected) only when I key the correct password then it will appear.
Can someone help me please.
Thanking in advance.
Cant Lock Record HELP!
Jun 15, 2006Hi All, I've searched the forum and have found a lot of info on locking records/forms. I pulled this from a thread but it doesnt work. I have a subform with many fields with a check box. if the check box is true then I want to lock that record(or the form). I loaded this in the on current event and I can still edit the form and or record.
if me.closed = - 1 then
Me.AllowEdits = No
Me.AllowDeletions = No
else
Me.AllowEdits = yes
Me.AllowDeletions = yes
thanks
Lock A Field
Aug 6, 2006I've looked through the forum but haven't found quite what I want. I am a novice but realise this is going to be a relatively simple one ....
I use an invoice form for my own business with client details and a sub form with invoice lines. The client is selected via a combo box. I realise the danger that I could inadvertently alter the client, so would like to lock the client field when I move on to the next invoice or close the record, I don't want to lock the invoice lines. Can't get the code quite right and not sure whether this should be AfterUpdate or OnExit?
Any help much appreciated.
Need Help To Lock A Field
Aug 6, 2006I'm doing a project for Tafe and I have some yes no questions on my form and a text box next to each one for detials if the answer was no for tick box I want the text box not to be able to write in ...
View 8 Replies View RelatedHow To Lock A Form For Changes?
Aug 24, 2006I made a table containing information about products (price, amount, supplier,...). The most inportant info is the order number (cause it's unique).
Then I made a form, containing a combo-box and several text-boxes. The idea is to find a record using the combo-box, and vieuwing the information of that product in the form. This works, but a problem occurs: the order numbers change each time in a single number (I guess the autonumber). How can I solve this problem so that my combo-box is still available for searching, but no changes can be made in the table that is the source for the form?
Could Not Lock File
Nov 1, 2004
I created a database for one company. So, this database needs to support multiple users environment. One of the users has problem opening the database. Sometime he can open it. …. sometime he has an error message “Could not lock file”. What’s wrong with the database? (I gave him permission to “Read”, “Write” and “Read & Execute”)
Thanks in advance for all your answers.