Help With Copying Emails And Strange Text
Oct 30, 2006
hi i am trying to copy emails from a ms access document for work. (there are about 6000 of them) when i go into the data base...under the emails column i see ALL this
åëîõôèÀðáõìèåííåò®ãïí
its just lines of that!
if i cant copy all the emails this way, i will have to do 1 at a time with a program and it will take me literally 10 hours
please help
i dont wanna get fired lol
how can i copy the emails. In the program, the emails are all normal (you kno....like myemail@here.com) but in the access document, its like that
help!
View Replies
ADVERTISEMENT
May 13, 2014
I have a form on which there is a series of text box controls relating to different frequencies. At the moment I enter a value in to each of these manually.
However, I would like to have an unbound text box where I can paste in all the values (6 or 8 of them) from excel and then press a button and they would be copied in to the individual boxes.
So far I have my design:
I'm not sure where to start with regard to the code as I don't know how to handle delimited text - is it column delimited in excel?
I imagine some sort of loop, such as a do until will be required but again not sure.
View 2 Replies
View Related
Sep 9, 2005
I have a table called 'students' with the appropriate fields. There is another table named parents_prof which contains records of common professions. The tables are related through the 'ID_parents_prof' of the 'parents_prof' table to two fields on the table 'students', thus 'students.father_prof' and 'students.mother_prof'.
1st question) Is that possible? Is it possible to create a relation between the key field of one table to two different fields of another table? Is it a good practice?
I did this because I want to build a query which checks for both fields together, meaning I want Access to return a record if the appropriate profession is in either field of mother's or father's profession.
SELECT students.surname, students.name, students.father_name, students.father_prof, students.mother_name, students.mother_prof
FROM parents_prof INNER JOIN students ON (parents_prof.ID_parents_prof = students.mother_prof) OR (parents_prof.ID_parents_prof = students.father_prof)
GROUP BY students.surname, students.name, students.father_prof, students.mother_prof, parents_prof.parents_prof
HAVING (((parents_prof.parents_prof) Like "*" & [enter profession] & "*"));
Access cannot represent the above graphical, so I had to enter the
OR (parents_prof.ID_parents_prof = students.father_prof)
in the SQL formula.
2nd question) Is the above proper query, according to the rules?
View 11 Replies
View Related
Jun 4, 2015
I'm trying to continue with my rebuild of our call answering screen. It's basically a form with a button for each company we represent, clicking the button will lead to a call answering screen for the company. we also have software that pops the correct screen when we receive a call for the corresponding company.
I'm trying to get some of the fields to autopopulate, starting with the telephone number of the caller. the number appears in a text box on the main form and I'm trying to copy it into the caller telephone box on the call answering form. I've got code in place but it gives me the error "you can't reference a property or method for a control unless the control has the focus". Here's the code for the form I'm working on...
Code:
Option Compare Database
Private Sub cmd_recordcomplete_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd.Close acForm, Me.Name
End Sub
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
txt_dateandtime.Value = Now
Me.txt_callertelephone.Text = Forms!Switchboard!txt_incoming.Text
End Sub
View 3 Replies
View Related
Mar 15, 2013
I need to get an email address from a field and place it onto another form.. HOWEVER I dont want it as a hyperlink, nor do I want the mailto blah blah coming over.. I just want the email address as TEXT.In the application the user opens the email form by clicking an icon on an invoice screen, this will allow them to automatically email to the client.. Once they open the email screen they naturally see an arrangement of other boxes where they can enter subject, email description etc..
At the same time there are two boxes, the "To" box and the"From" box... I want these boxes to be auto updated with the email address (to save time). When the user clicks the icon on the invoice screen it automatically copies and displays the email address of the client in the "To" box on the invoice.. The problem I am having is that it is displaying as useless information which is associated with the hyperlink.The email address comes from a field that has already previously been associated as a hyperlink, and it HAS to come from this field, I have no way around it.... All of this information is coming from an address book section from a field that is a hyperlink field.. If it was a txt field then I would not be having this problem.
As I already have various forms open displaying information I am able to used simple code to fill in various bits of info to save time... Because of this I am using simply code to copy the email address from one form to another:
Forms![Email]![To] = Forms![AddressBook]![Email]
Obviously the above code is simple and works for 90% of this type of approach, however there must be some other code that I need to use to first translate the email address to text...
In the end I don't care what I have to do as long as it works.. Remember though that the original field is a hyperlink field and must remain so, I cannot simply convert that to txt..
View 1 Replies
View Related
Jun 24, 2014
I would like to be able to join 2 text boxes and then copy them to clipboard. My initial fumbling has had me to joing the 2 text boxes as a string and then set that string as the value of another hidden text box and then copy that text box.
strOut = Me.Title & Me.Description
Me.CopyTxt.Visible = True
Me.CopyTxt.Value = strOut
Me.CopyTxt.SetFocus
DoCmd.RunCommand acCmdCopy
Me.Title.SetFocus
Me.CopyTxt.Visible = False
This does work but I would like to format the output if possible to remove the element identifiers? The string copies out as below.
Title Information<div>Description Information</div>
Is it possible to remove the <div> and any other elements that may appear either using my method or another way. Not sure if they are appearing as the Title box is plain text and the description is Rich?
View 4 Replies
View Related
Apr 5, 2005
I have a database used by about 15 users.
Occasionally a record appears which contains strange characters in it rather then regular text and numbers.
The solution is to compact and repair the database but this means taking all users off the database.
But I need to find out how these characters are getting there - does any one have any ideas?
thanks in advance.
View 10 Replies
View Related
May 16, 2014
What I'm trying to accomplish is some sort of 'Order Confirmation' (filled with the info i have entered in my order form and sub_form fields) that i can copy and paste as a reply to their email-order.
I have taken 2 failed approaches so far:
1) I used a report to display the info
Private Sub Command103_Click()
DoCmd.OpenReport "Order Confirmed", acViewReport, , "OrderID = " & Me!OrderID
End Sub
This worked fine until the information was copied and pasted into outlook which upon doing so changed the column titles and layout
2) I used another form with a text box to fill with the data entered on the Order form
DoCmd.OpenForm "frm_Order_Confirmation"
[Forms]![frm_Order_Confirmation]![txtConfirmation_Text] = "Ref.:" & " " & [txtCustomer_Order_Reference_Number] & [vbNewLine] & "Item No.:" & " " & [cboProductID].[Column](1)
I got stuck here when trying to reference the data in the sub form... Also each order can have one or more colours and how to allow for this?
View 2 Replies
View Related
Apr 27, 2005
I have done some forms and it is the first time that i had this problem:
I can input data in several records without having any problem but when i close and save the form and next time i open it ,i do not find my previous records. I checked this in the tables and find that the values that i had input were there but in my form these values had disappeared. Can anyone explai this ..
Also,
Suppose i have 2 tables with NAME set as the primary key and which is linked 1-1. When i create a form for these 2 tables and when i write JO in the name field only once the name JO should automatically be inserted in the other name field i.e i should be able to input only one data. This is not the case. What i should do is : write JO then click in the other NAME field then type something e.g RO then this will be typed auto. in the other Field. Can you also explain this
View 2 Replies
View Related
May 27, 2005
I have a form with a tab control and each tab has a subform on it. 3 of these tabs/sub forms are continuous forms that allow the user to enter details for the selected job (i.e. on tab has a subform that allows the user to enter various scheduling dates for the job).
If I say have the scheduling tab selected and then change a field in the MAIN form, then click on the new record row in my continuous subform my main form jumps to the first record. However, if I update a field in the main form, select a different tab, then click on the new record row in my subform it works fine. Also, if I click the add record button it works fine as well.
I can't seem to find anything in my code that would cause the jump. Any ideas?
Thanks,
Hammy
View 3 Replies
View Related
Oct 4, 2005
I received a very strange error this morning.
I was going to create a new query with the simple query wizard, but as soon as selected a data source I got a message saying "The expression on Got Focus you entered as the event property setting produced the following error: The text you entered isn't an item in the list."
After this I can select a datasource, but the cursor remains in hourglass mode. It almost seems like this is a run-time error, when I am merely trying to create a new query. In addition to which, I haven't set any events to run on "got focus". Anyone have any ideas on what is causing this and how it can be fixed?
Thanks,
Chris
View 3 Replies
View Related
Nov 14, 2005
Hello,
I have a strange problem which have to be solved in Access in all way, if it is possible. :-) I have to create a table similar to an Excell sheet. Row headings are name of persons, column headings are workplaces. The aim of this table is to register worked hours at each workplaces per persons. At one person in one shift more workplaces are possible. The number of persons and workplaces is changeable. Does anyone know how could I solve that to store in different records each workhours? For example if a person works 4 hours at 1. workplace and then 4 hours at 2. workplace, this would mean only one row on the form, but two records in the table.
I would be very grateful if somebody would have a good idea! Many thanks in advance!
VoiD
View 1 Replies
View Related
Dec 28, 2006
I was working on the design of a form and had just made, what I thought, were some fairly minor changes. The specifics of which I can't recall. On saving the changes and attempting to go back to the form view I got a pop up window with the following header;
Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience.
I can either send and error report or choose not to :rolleyes:
The up shot of all this is everything else in the DB seems to still work fine, but I can not open the effected form in either design or form view without Access shutting down :mad:
Has anyone seen anything similar? and if so any idea what may have cause this dummy spit? and Is there any way around this without deleting the effected form and rewriting it?
View 3 Replies
View Related
Mar 9, 2007
Hi to all,
Here is my problem:
I import value from an excel sheet and write them in a table, i use Excel object reading cells row by row. All works fine but after 1900 or 2000 rows program hangs without errors if i place a stop in program when my row counter reachs 1900 and run the program step by step that works, i tried to place a sleep command each 500 rows without better result. Does somebody have any idea ?
(i use Office 2000).
I can't use transferspreadsheet because for any reason in my excel table generated i have #Number! errors in some fields and i don't know how to skip these records.
Thanks in advance for help.
VINCENT
View 8 Replies
View Related
Mar 30, 2007
Hi All
I have just noticed some strange behaviour in access. I hava and asp page which gets two dates which are then used in a sql statement to refresh a page. The end of the statement deals with a between clause like this
WHERE tbl_Movements.date_of_Movement Between #12/03/2007# AND #30/03/2007#
But when I view this in design mode it changes it to
Between #03/12/2007# And #30/03/2007#
Why does it do this and what can I do to resolve it
Thanks
View 1 Replies
View Related
Jan 31, 2005
Hello To All,
Has anyone seen the message in the attached file? I got this when I was trying to update the row source on the field after I had a problem with data in a report coming up inaccurate. I've been developing in MS Access for about 7 years now and have never seen this. Any explination for this would be greatly appreciated.
I am using MS Access 2000 on a Windows 98SE machine. :eek:
- Charles Williams
View 1 Replies
View Related
Jun 23, 2005
Hi,
I have a query that in some cases it works and in others no. I've tried :confused: everything :confused:.
The problem is very strange: attached there is the database!
Anybody have any idea?
Thanks!
P.S.: :) forgive me but I don't write well the English!
View 2 Replies
View Related
Oct 29, 2005
It may be a simple problem I don't know. I have to do an inventory control database in Access for my Systems Design paper however I am having an issue with queries.
I have a query called Item Status Check and it asks the user for the item code and goes in a table called Inventory Item to get the results. Now the problem is after I added a whole lot of new items (I had some from testing earlier) it does not bring them up in the query at all, its ignoring them basically.
Now I find this strange because other queries like suppliers etc still work fine and access any new data I put in.
I know its going to be simple but its doing my head in.
EDIT: Found more.
The ISC query has the following field
ITemID
ITemName
SupplierID
CarryCost
RetaiPrice
StockMin
StockMax
StockOnHand <--- from a stock on hand query.
Now if I delete the stockonhand it shows all the stock so thats the problem. The way I have calculated stock on hand is to simply take all the purchase orders, add them together and subtract the customer/production order numbers. I don't know why this would happen
EDIT 2
found the problem, need the solution
In the StockOnHand calculation is takes all the number of incoming stock and subtracts the outgoing stock to get its answers. If the stock isn't on one of each of the incoming/outgoing forms it doesn't show it at all.
EG
Incoming Stock:
Purchase Orders
Add Stock (from an alter stock form for discrepencies)
Outgoing Stock:
Customer and Production Orders
Remove Stock (alter stock form)
If items have not been used on 1 of each of these they don't show up in queries with StockOnHand.
Thanks in advance
View 1 Replies
View Related
Dec 20, 2005
Hello all. Have a bit of a strange one here (and fairly frustarting). I have a table which includes a field (type memo) which holds text comments.
I have a query which includes this field. For some reason, when the comments field is empty (identified thorugh opening the table), when it is returned through the query is shows two characters, namely '@v'.
Can anyone shed any light on this for me? Thanks for reading :)
View 2 Replies
View Related
Apr 30, 2006
I have a select querey
which contains the expresion
forms!frm_itemslct!text8
It should just pick up the value contained within [Text8] which is a number, and it was doing that earlier this evening. I've since changed something and instead of a number it is now showing a small square :confused: For the life of me I can't work out what it is that is causing this.
View 3 Replies
View Related
May 16, 2006
Hi,
The Problem that im getting is that when I query select a yes/no field in a table the results return TRUE and FALSE, even when the criteria states Yes.
does anyone know whats going on with it.
I know it isnt me as I have had my collegues check it over and they are all confused as well.
any help will be great!
View 4 Replies
View Related
May 6, 2005
i have a form with some control on it. Among these controls, i have 2 unbound image control, which displays linked images.
Now i am noticing that with this particular form only, if i start click the next record arrow in the navigational pane very fast to move through the records, all of a sudden the whole access database will disappear abruptly leaving .ldb file open.
Any idea why this happens ? Do you think that those 2 unbound image controls has to do with it, because if i try hitting the next record button extremely fast in other forms, it simply scrolls through the records, without the closing the database abruptly.
Thanks!
View 2 Replies
View Related
Jun 27, 2007
I have created a DB with many tables and I want to find a way where I can retrieve all the emails from every table (each one has a column with emails). Does anyone know what to do? If a record doesn't have an email address do I have to type N/A or just leave it blank?
View 1 Replies
View Related
Apr 27, 2005
Many will look at this and laugh but its real.
My Access Dbs are opened in hidden state and i dont see my forms.
This must be the cause.
I tried to hide the menubars using ghudsons code,i disabled the shift key. But i dont know what has happened.
I can nolonger view them. I have tried every method out and i think the only option is to repair OS, may be it will work.
I have enabled the database which i disabled the shift key but when i hold down the shift key, it loads but the forms are totally hidden, STRANGE! ijust see the grey access background and when i click on it twice from the task bar.It pops up.
I have tried to make another database, use the autoexec macro to call a form which enables all command bars, but this works only for this database and when i press the shift key down, this database hides the toolbars and i only see the grey access background. This is happening on EVERY DB ive developed on this machine. I thought it was the access that is totally corrupted but i tried to reinstall my office and i still get the same results
This is now a NIGHTMARE to me.
When db is shifted to another machine it works fine as before.
This is REAL but can i get some suggestions from you folks before i repair my OS.
View 1 Replies
View Related
Jun 24, 2005
Hello,
I am trying to add a normal JPEG image to an Access 2003 form through the "Image" control.
The problem is that when I browse for images , it does not show any JPEG images, but only BMP and images of other 3-4 formats - The JPEG format doesn't exist there. When I try to add a JPEG through "all-files" it gives me an error message - "does not support this format".
There is not problem viewing JPEG images on WinWord or other programs.
Has anyone heard of such a problem and its solution?
Thank you
Gabi
View 2 Replies
View Related
Jul 10, 2005
I am trying to use the runsql command and I am encountering a strange problem.
The following works:
DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" & edittime & "', Null, Null, Null, '12', 'Bob', 10)")
But when I change the Null to a textbox with a null in it, it wont work:
DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" & edittime & "', '" & txtacc & "', Null, Null, '12', 'Bob', 10)")
The textbox txtacc has a null value in it.
This is frustrating me beyond belief. Please help.
Thank you in advance
View 1 Replies
View Related
