Using Access 2007 - My (Data Type) Memo field contains the following type of data ...
First Name: Jake
Last Name: Pies
Phone: 123-456-7899
Email: jakepies at apple dot com
Comments: Interested in all more information
How do I parse these records, about 400, located in the memo field column to multiple column fields: FirstName, LastName, PhoneN, Email, Comments.
Thanks, James
Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES
1 CR10070SW £29.60 HALLITE PRODUCT
1 RBS24690 £0.82
1 RBS354 £0.95
2 RBS345 £0.75
1 S95MMEXT £3.90
£36.77 PER KIT
I need to take out the carriage returns but keep the items delimited in some way so they all apear on the one line. These are the child parts for kits so i need to keep them on one line as i import them or via a query so i can see the parent part they belong to. I can then extract them for upload into our system retaining the association with the parent part.
Thanks
Hello,
There are 40 columns in a table in MS Access Database, i want to fetch all the columns data; but without only one particular column and without mentioning all the column names. How it is possible?
Please guide me...!
Thanks
I am trying to write a query to extract the first 3 characters from a character string but have no idea where to start since we usually use Select "field" etc etc
Example, for a Code ACC01, the query result should give ACC
Would appeciated any guidance. Thank!
TK
Hi,
Our shops use MS Access to save the details of customers. The shops have to submit us the customer records at the end of each month. How can they make some settings (e.g. query) to extract only the modified records and new records of that month? For example, at the end of Nov 04, I just want them to submit the modified and new records of Nov 04. Records created in or before Oct 04 should not be extracted.
Many thanks.
how to write VBA to extract data from .msg files and import that data into a table in my database.I have over 5000 .msg files of which I need to extract the following information:
First name: Tim
Surname: O'Rourke
Street & Nr: 399 Upper Eastern Green Lane
City: Coventry
[code]...
The field headings are all in black bold and the required data come after the colon, I have name the fields in my database exactly the same but using the normal naming conventions:
strFirstName
strSurname
strStreetNr
strCity
[code]...
Any way to extract a postcode when there are double space on some and not others.
SA1 1AB (i need SA1 1AB)
HU1 2AB (i need HU1 2AB)
HU17 0BG (ok)
For some reason the postcode field returns 2 spaces when the postcode length is only 6 digits and 3 spaces when the postcode length is only 5 digits. Im assuming that the postcode field needs to be 8 characters in length (including a space).
All I want to to remove the addition spaces and return a normal looking postcode!
I'm currently in the process of moving from Excel to Access and am setting up a user table with 5 Fields (Full Name, First, MI, Last, Alias). I would like to only transfer the Full name and have the other field be calculated fields, so they automatically fill in. I was able to get the "Last" field to work, but the others are being tricky. Especially the "Alias" field which would need to take the first letter of the first name, MI letter and the entire last name, like (JPDoe).
The current format of my "Full Name" field looks like, (Doe, John P.) without the brackets of course. I'm new to Access, so I was trying to use the Expression Builder to do all of it, unless there is an easier way?
How I can retrieve the following information from a field
[CONTENTS]
1 x 17.7ml
2 x 17ml
1 x 181.1ml
I need
17.7
17
181.1
I was using a combination of CAST(LEFT(RIGHT...)) AS Float
but that obviously won't work due to too many variations...
Hello,
I manage an access MDB, which contains two tables.
In one of the tables (Table A), I would like to insert a "Default Value" that will be extracted from the other table (Table B), everytime I add a new row.
For instance, the value I would like to extract from Table B is "900".
When I add a new row in Table A, I would like it to use "900" as the "Default Value".
But tomorrow, for example, the value in Table B will be "910", and so when I add new rows in Table A, I would like them to be "910", but at the same time I don't want the rows that I added a day before to change (from "900" to "910").
I tried going to the "Design View" and under the "General" tab, use the "Default Value" field by using an SQL query, but that didn't work (or maybe I just did something wrong).
How can I do this?
Thank you!
Hi,
There is a requirement for
1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented?
2_To click/double click a record in the datasheet,extract data and populate textfields,comboboxes with it which are in the main form.How is this achieved?Also,I can't find click events in a datasheet.
Pls let me know.
Thanks,
Savita
How can I create a field in a query, extracting the date portion of a date/time field? The format is mm/dd/yyyy hh:mm:ss. I need just the mm/dd/yyyy so I can prompt the user for a date range, without them having to key in the date mm/dd/yyyy 00:00:00 to mm/dd/yyyy 23:59:59. Please Help
View 3 Replies View RelatedHi,
I create the table, and fieldname,
What is the datatype, memo?
Datatype: Text
Fieldsize : 255 (max char)
Datatype: Memo
For the memo datatype, what is the size for that?
Is it unlimited size?
Please let me know, thanks.
I have a field on a table that is a memo field. I am trying to write a query to include this field but get the "Can't group on memo or OLE object. Any ideas on why and how can I query with this memo field included?
View 2 Replies View RelatedHi all
I've posted this in my usual Excel forum without any response so I figure someone here might be able to help. I'm using an SQL query in an Excel VBA macro to extract info from an Access table and dump it into an Excel worksheet, which works fine except for a Memo field, which is truncated to one character length - text fields are fine, just this one Memo field. I'm using the Microsoft DAO 3.6 library. Any ideas?
Cheers
Col
Hi All,
This is probably the simplest question to answer but alas I can't find the answer in any of my books!
I have a memo field which when made into the form is for a comments box (therefore has to be a memo box). However, the end user wants to be able to type in the comments and have this is paragraphs but of course the field doesn't want to do it.
I've tried various commands in the properties and also in the formats etc. and now I'm at a loss - can someone please give me some much needed guidance, and I really am sick of looking at this database and would like to get rid of it!
Thanks in advance guys.
Donna :eek:
ok, I have been searching for a while, and no luck. I think I have come close, but not experienced enought to adapt code. I have a memo field on my form. I want to append new comments to this field without erasing the current data in the field. I want to do this through code. Can this be done?
View 2 Replies View RelatedIs there a way to populate the value of a memo field with the push of a button. What I am trying to do is have a few default items that can be automatically entered into a memo field. When I attempt to change the value of the memo field either thru the wizard, macro or by using a simple code like me.[memofield]="test" I get the error that you cannot assign a value to this object or by using setvalue through a macro i get the error "Object doesnt support this property or method"
Any help with this would be greatly appreciated
Thanks
Ricky
Seem to be having a brain fade here, I have spent all day trying to figure this out.
I am trying to add notes to one of my forms with a date stamp. The form will be viewed every week so new notes will be added with new date stamp any ideas of the best way to do this.
Thanks in advance Kim
How can you use a memo field in a combo box.
How can you edit a memo field used by the combo box once it has been selected in a form.
I have a memo field in my database, as the data is too long to be a text field. The data in this field has been pasted in from other sources, and somehow it seems to have remembered the original pasted formatting, which was like a newspaper column. So when I include this field on a report, I get a thin column of text, even though the text box on my report is much wider. Is there a way of getting the text from my memo field to wrap to fill the width of my text box, so I get a neat-looking report. Thanks.
View 3 Replies View RelatedIs there any way of making a comments box (memo) have the functionality to press return and start on a fresh line as it all seems to run into one 'indecipherable blob'
View 1 Replies View RelatedJust wanted to know if filtering a memo box was possible. I know it's not the best idea to do so but I could really find this feature for my database useful.
View 1 Replies View RelatedI am using
DoCmd.OutputTo to export a query but this truncates the memo fields, but in the db window,right clicking and choosing to export does not truncate the data.
How do I code to output all the data without truncating?
Hi guys and Girls
I have a txt box on a report which should show comments..
In the background table the field this txt box is bound to has a data type of memo. Yet the txt box on the report stops showing any more than 255 characters! any clues? I know 255 is the field size set for my Txt fields but memo fields should be able to display 65000000000000000 trillion characters with no problems.
When I look at the table the memo field has all the txt in it, it just wont display all the txt on the report.
Thanks for any help guys.
I have been asked if is possible to highlight some text in a memo field and make it a hypertext link.
A memo field can be changed to a hyperlink field, this is not what is wanted.