Hi All,
I want to change existing entries in a table to upper case format. I know that it is possible with a query (update I suppose) using an expression with the "UPPER" function. But I am not quite sure how to implement it in Access. A little help would be welcome...
Hi, Is it possible to filter out entries beginning with a capital letter with a query? Ive tried Like UCase, but that doesn't work, and there is no upper case wild card. (I am creating a book index and want to have a look only at the entries that are people's names)
Just been searching around, found a few posts of uppercase questions, none that quite fit with mine, anyway,
Basically, the data I am working on produces names as such "JoeBloggs" "FredPerry"
Anyway, Im going to use a query to seperate these out into first name and last name, but, I can't seem to find a way to specify a capital letter as a wild card. So far:
CapPos: InStr(2,[calllogs]![CalledNumber],"A")
Then I am going to use the mid function to seperate the two, depending on the position of the first capital letter.
But I just need to replace "A" with something that will find any capital letter.
I have a field in the table that contains numbers and a mix of upper and lower case words.
I would like to have this to it check for numbers and then makes the first letter in a word upper case and the remainder lower case.
I know you can do it like this >L<????????? but that dow not work if the word lengths are different. Unless I am missing soemthing.
Example of text in field is this:
100 RCSCC MAJOR PAIN
I would like the RCSCC to remain in UPPERCASE and then move to the next work and change the first letter to UPPER CASE and the remaining letters lower case then repeat this on the next word if there is one in the field.
I have a database containing a mixture of upper and lower case input. I can make upper case appear on the screen by using > in the format box in the property section for each field. This works great but the same old uncorrected stuff remains on the database. How can I get the database to store the corrected upper case data after I have entered it in lower case?
I have a small issue where I do have names written in UPPER CASE, I would like to transform them in Capitalized (each word), I understand that I cannot use the same function as in excel (PROPER) but something like StrConv, but as I do have a ‘comma’ in between the names I have something like that
I know when creating a text field in the format option you can use the > or < sign so that when text is entered it automatically changes it to uppercase or lowercase - but i need it to be Title Case, any one know how I can do this....
I'm using the standard duplicates query on a field called trackTitle:
SELECT TrackTitles.trackTitle, TrackTitles.akTrack FROM TrackTitles WHERE (((TrackTitles.trackTitle) In (SELECT [trackTitle] FROM [TrackTitles] As Tmp GROUP BY [trackTitle] HAVING Count(*)>1 ))) ORDER BY TrackTitles.trackTitle;
I need to be flagged if there's a title in a different case - for example, the track "NEXT Year" might have versions appear as "Next Year" or "next year". These versions would need to be flagged and then corrected by hand.
Eyeballing a list of 4,000 new tracks isn't cutting it.
If I could get the duplication to be case sensitive, I could then use a left([trackTitle], 5) to weed down the review list - much easier to pick out the thorns.
Any ideas on how I could make that duplicates query case sensitive?
I have a combo box that populates many listboxes based on a selection (listbox values are coming from another table [Master]) - simple enough. I want the listboxes to populate with DISTINCT entries - also seems simple enough (right?).
As you'll see below, if the user selects "All" from the combo box (cboSite), I want the listboxes to populate with distinct values from all sites; otherwise, any other selection is a unique site and the listboxes will populate with distinct values based on that unique site.
This works BEAUTIFULLY if I select a unique site, but when I select "All", there is always one (and only one) duplicate value in EACH listbox. That is to say: all values but one in the listbox are distinct.
FOR EXAMPLE:Select unique site (not "All") from "cboSite"
The listbox "lstMajEquip" (which only has values "Yes" and "No") populates to show "Yes" and "No"
Select "All" from "cboSite"
The listbox "lstMajEquip" (which only has values "Yes" and "No") populates to show "Yes","No", and "No" (what?!)
As mentioned, this happens for all 8 of the listboxes, not just "lstMajEquip"...
Using Access 2010
Code: Private Sub cboSite_Change() If Me.cboSite = "All" Then Me.lstBusiness.RowSource = "SELECT DISTINCT Master.Business, Master.Site, Master.Exclude FROM Master WHERE (((Master.Exclude)=False) And ((Master.Business) IS NOT NULL) And ((Master.Business)<>''));"
I am trying to change all the fields of a table from All Caps to Propercase. I have used strconv propercase before, however only on a field by field basis. I have about 5 or tables that I have to do this to and am trying to save the typing. I know I can do this with a recordset (easily in asp), but am not familar enough to do this in vba. Can you do a for each fld, like in asp, or am I going at this the totally wrong way. I tried using an update query with the *, but access doesn't like that too much. Any help is greatly appreciated.
The table happens to only have one column in it, so each record only has one field..
How do I convert the entire thing to lower case?
I can not just convert the display info to lower case, this table is used as a cross-reference data table and I need to physically convert all the data in the entire table to lower case.
Oh, and I need this to be a macro of some sort, since the data is re-imported on a regular basis, and will re-convert to upper case on the import.
I'm creating a fairly basic case management system in Access 2007 and i'm wanting a way of populating a set of tasks when a case is created...
e.g.
I have a case table, which contains basic information about the case, case manager, ID, date created etc.
I've also got a task table with a list of tasks
When i create a new case I want it to pull in the list of tasks from the task table, the tasks are static so i wouldnt want them to update the task table but update progress on the tasks against the case.
Do i need another table for like casetasks where it populates the blank tasks and then they're updated with an ID linked back to the Case.
I've got a table tblPatienten, a table tblRechnung and a form frmRechnung.
The primary key in tblPatienten is KundenNummer, the primary key in tblRechnung is RechnungsNummer. The relationship between tblPatienten and tblRechnung is one to many.
Now, every patient (stored in tblPatienten) is allowed to make multiple orders (stored in tblRechnung).
How can I assign each new order entry in frmRechnung to an existing patient in tblPatienten?
table name : Schedule Field 1 = Vessel code Field 2 = Voyage Field 3 = ETA Field 4 = berthed Field 5 = Sailed
there is a query by using above table and data entry form based on that query.
need to add following facilitate
While data entering, if given voyage number is already exist for the particular vessel code, msg should be pop up immediately at that time saying " This voyage number is already exist"
Is there a way to minimize the navigation pane and the upper tabs on start up? I have several big forms that don't seem to fit unless these are minimized.
How do I put an upper limit on the amount of time allowed in a date/time field?
For example - during a heart procedure a person is exposed to radiation, it will never be more than a total time of 10 minutes. I want to know how much, but I want data integrity so I don't want them to be able to enter more than 10 minutes.
So I have 2 tables, the first is for "open" orders (where entries get edited changed and deleted), and the Second is for "finished" orders (where once an order is completed it should move from the open orders table to the finshed one where it will no change and will remain for futre reference)
I need help with the transfering part of this problem. I would ideally like to make a form that allows you to pull up the info for the open order then edit it to finally add the finished order to the other table. Im not sure where to start on this one.
I have a table named tblProduct, I have a table names tblProductSpec,
tblProduct contains basic info, tblProductSpec contains infomation linked with outer tables. What I need to is have the product ID's duplicated in tblProductSpec. Is it possible to do this via relationships etc?