Search results

I'm having a similar problem going from queries to tables. It seems to lack a solution. :(

I have my database set up to import certain emails from my Outlook folders, and then break down the data in the emails into certain fields. This is done using a couple of queries. The problem is that the queries refuse to pass more than 255 characters of data for any of the fields. Two of the...

I'm using code to take a value from a query and add it to a table (can't use append for various reasons) and I'm hitting a 127 character limit when I pass the value. I still get the problem if I segment the string. Is there any way around this limit? It's causing me some pretty major problems.

Weird...double post.

I'm having the same sort of problem....any luck yet? My problem is that I'm taking a field from a query and populating a new table with it using code, and it's truncating to 127 characters.

I just exported the query that the report is based on, and all of the data came through fine. Hopefully that helps track down the problem.

I have a report that lists a student's Social Security Number, Name, Department, Job Title, and Work-Study eligibility, and when I view the report, everything shows up fine. The problem is that when I send the report to a mail recipient as an Excel file, some of the Social Security numbers get...

I hate it when you run into errors like that. Oh well, at least it's all set now.

I don't think I'm good enough to solve your problem, but I'll show you a working code that does the same thing, and perhaps you will be able to see the error.: Private Sub cmdSend_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim MyDate As Date Dim NameRef As String Dim JobRef As...

Make sure it says [event procedure] in the After update field.

In the After Update event of the check box, put: If [New Page].Value = 0 Then Comments.Enabled = False Else Comments.Enabled = True End If

Here is the code to add your inbox: Function AttachMail() Dim db As Database Dim td As TableDef On Error GoTo Errorhandler Set db = CurrentDb() Set td = db.CreateTableDef("tblInbox") ' Substitute your own MAPILEVEL, DATABASE and PROFILE arguments...

Here's my email program...hope this helps: Private Sub Form_Load() Dim rsDLS As Recordset 'shows date mail was last sent Dim rsEmail As DAO.Recordset 'the recordset with the email addresses to be used Dim strEmail As String 'the email address Dim strMessage As String 'message to be sent Dim...

Oh...I see...it helps to read the original question well. :D Hey, if you ever need to have all of the addresses seperate, I'm glad I could help.

Are you trying to populate a new table with the addresses? One way I can think of to do it would be to set an Integer value to the location of the first comma (using InStr([start],string to search in, string to search for, comparison type)) and then take part to the left of that as the email...

I think I have it all figured out now...thanks for pointing me in the right direction!!

I went there and did exactly what it said on the page (create module) and when I tried to run it, it said it was expecting a variable or procedure, not a module. Any idea why it wouldn't work?

Now that I have figured out how to read and write text files, I was wondering if there was a way to read in from email. What I'd really like to do is have the code search my Outlook Inbox for messages with a certain subject and then read in the information. Is this possible, or am I crazy...

It's only going to be run once a month at most, and I can double check it for the proper number of records, so I'll probably just leave it as is. Thanks for the help. :cool: BTW, input past end of file is error number 62. I think I will fix it after all.

Ok, I did what you said, except for the EOF trap. I couldn't figure out how to code it for the end of the file, so I wrote some cheater code. Here's what I have: Private Sub Command9_Click() On Error GoTo Err_Command9_Click Open "H:\sfina\groups\FINAID\SCHL_DOC\ICSAC\gs001869temp.txt" For...