I've search the forums...If you can find a thread that discusses this, or can give me some advice on this topic, let me know.
Is there any built-in function that will allow me to delete any text before a certain point in a record... Or perhaps a way to use the REPLACE function to do so?
All of my records look like this (They're ticker symbols):
AMZN:Amazon, Inc
WMT:Wal-Mart Inc.
A:Agilen Tech Inc
MSFT:Microsoft Inc.
I just want the company name...Unfortunately, the ticker symbols aren't always the same length, so I can't use the left or right function.
I need to delete the colon and anything to the left of the colon. I've thought of a great use of the replace function for this purpose...I used wildcards...Too bad it didn't work!
Just The Company Name: Replace([Ticker Symbol and Name],"*" & ":","")
I have a form where I want a textbox [txtMaxOrdLimit] to be visible only if another text box on the same form [PaNumber] contains the letter D in the string. This is the code I have on the forms On Current property but I'm missing something because textbox [txtMaxOrdLimit] doesn't show on the form at all.
If Me.PaNumber = "*D" Then Me.txtMaxOrdLimit.Visible = True Else Me.txtMaxOrdLimit.Visible = False End If
I have a form to capture client information. I would like to have the the first character of the name fields (First and Last) be automatically capitalized. How can I set the field to do this?
What can i put on a text box to limit the amount of characters entered like the 'field size' property for a table. I want to limit entry to 40 characters. Thanks in advance for any help,
i would like to make a query in ma access can extract text between first and second character "/" and when there are not "/" in field it returns null.now data in my table are like below
Quote:
No option1 1 100 2 145/Mechanical/0800 3 120/electrical/1620 4 131/mechanical/0200/dw-001
Now I like to make a query can extract text between first and second character "/" like below: No option1 discipline
I have a database that I imported as a comma deliminated csv file. To keep my original text comas intact I changed all the commas to semicolons before I created the csv file and imported the data. I now have a data base with semicolons in place of the original commas.
I am trying to use the update query function to change all the semicolons back to commas in one of the database fields called File_name
I have a data entry where a record in the File_name field looks like this for example
Chevrolet cavalier; red
and I want to change it so that it looks like
Chevrolet cavalier, red
I run an update query with the criteria set as Like "*;*"
and this finds all the records which have a semicolon in them
I have set the update field to "*,*"
but all this does is to change the record from
Chevrolet cavalier; red
to
*,*
Is the query update the way to go and what is the syntax that I should be using in the Update field just to change the semicolon to a comma and leave the other text intact?
I'm having trouble converting text to proper text in Access 2010 using Windows 8.1 as OS.
The message I keep getting is:
The expression you entered contains invalid syntax. You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks.
I am using Access 2007. I recently converted my table field from text to memo. When I run a query and report linked to the qry the memo text is displayed as Chinese character or square box (if field is empty). In some forum posts this is shown as a font bug e.g. with Calibri. I changed from Calibri to Arial as this was reported to correct the bug. It did not work.
My field is set to Grow and Shrink, and table font is Rich Text also as mentioned in other posts. Still not working out.
I have a file that I need to import on a regular basis. There are two different issues with the import:
1. the first digit in the file indicates if it is a record I want to keep. In this case a 1 indicates a repair record and an 8 indicates it is just information such as email, contact info etc.
2. I have a field in the file that may change the import specifications
For example:
If the record is a Non wheel repair then column 167 is a 50 character description If the record is Wheel repair then column 167 is a 28 character description and the remaining 22 characters are broken down into 10 different fields
So I need to do the following
1. Read the first character in the line and determine if it is a number 1 and if not discard it 2. Read a field in column 109 that is two characters long and if it says it is a wheel repair the import will break column 167 -216 down to the appropriate 11 fields and if it is a non wheel repair it will import columns 167 - 216 as one big description field.
I have used the import specifications with Access but it seems this will have to be done in code in a module or something and I am not very good with VB. (only know the basics)
One other issue is I have dates in the file that are 130225 and 1302 (so full date and then Year/Month) if i take out the / date separator in the import spec the full date works but the Year/Month doesn't.
I am trying to delete some text from a text field. There are almost 8000 records and almost all of them are like this.
Example: johnsmith-2.network.home.com
I want to delete everything after the dot and including the dot, to end up with "johnsmith-2". How do I do that? I think I can do it in a query, but don't remember how.
Is there any way that I can restrict a text box entry from being changed? I am working on a tracking system and presently can capture when a text field entry is added or deleted. I can't capture when a text field entry is overwritten. Therefore I only want the user to delete the present entry and then add a new entry in the text box. Is this restriction possible for a text box?:cool: :rolleyes:
In my Dbase, I have a table with a text field. Field name is Country There are over 5000 records in the table and many of these in the Country field start with a space. I would like to get rid of this space as to ensure that all text starts with a character, rather than a space. How can I achieve this.
We have a table with approx 2m records. Just three fields: Key (primary) Postcode Postcode reference
The problem is with the postcodes. Many of these have a double space in them such as this DE13 7EL but we need DE13 7EL.
Find and Replace runs into a problem because of the number of records.
An update query seems obvious but we can't figure out what to put in Update to as this appears to return the literal value. We are not VBA programmers so that isn't really an option for us. How can we strip out that extra space?
I have a field that is text format. However many of the records in that field contain numbers.I want to delete all the records that are numbers in this text field, leaving only records with textual data.
All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.
I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.
How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?
I have two simple tables. I want to delete the records from Table1 that are on Table2. I've created a select query that gives me what I want but when I change to a delete query, I get this message: "Unable to delete from specified tables"
I think my problem has something to do with security but I can't figure out what to change.
Hello, Tried a search but could'nt come up with an answer.
I have a number field with an amount. The format will always change as far as the LEN is concerned. I need to remove the decimal. There will always be 2 numbers to the right of the decimal but the left will always change.
I posted an earlier question about an Access query export to Excel putting leading apostophe (') before all data. To remove them I thought I would use Find/Replace but the Apostophe is not recognised!
Is there a way (programmatically) to remove the first character of each data entry in each cell in a column?
My undertsanding is that text fields are limited to 255 characters. A friend has a databse with some "notes" type fields with data a few sentences long. Is there any way around this limit. If not, what database recommendations can anyone make for someone who needs a questionnaire component in his database?
Hi! I'm stuck and need some help. I have a list of about 1600 entries, all merchant names and i need to place an * at the beginning and end of each entry, example *Arizona Central*. Each entry has a different amount of characters...would any one know if there is a way of how I can do this easily in Access or Excel?
