Search results

Insert query from VB Thanks, Fornation. I'll try it. I searched a bit more and found the following CurrentProject.VBcode.execute 'query' (syntax is at work and I can't find it again). Anyway, it ran without error -- exept for the fact that the tables did not update with the new records...

I'm parsing several fields that have been imported with comma delimited data into several tables. When I finish, there is some data I need to append to a table. I run a query in Access and it works fine, but if I run the same query in VB after the code parsing all the other data, using...

This ought to be simple, but you have to love Access VB help. I'm processing multiple MS Project files and loading up a database. It takes a while, and I want to simply display which file is being read and worked. That is, "File being read is: " & thisfilename.mpp Documentation is not much...

Project to Access and back Well, managed to do it. I guess I turned off alerts and visible correctly so all 85 .mpp files imported with no problems after I got the correct field sizes in Access. Only problems was that a few tasks had external links that insisted on trying to connect as they...

Project to Access, and back Wayne, Updating project is a maybe. Mostly, I have about 80 project files to suck into Access to facilitate a single view for analysis of gaps and duplication of effort. There are only a few of Project's fields to import, but I want to do it with VB to avoid having...

MSProject to Access Wayne, Your code helped a lot. I'm getting there. I've converted to ADO, but still have questions. -- When I OpenFile ("project.mpp") it actually opens the project file in Project in an open window. I have to close Project to have the code continue. -- I get the...

MsProject Wayne/Pat, Thanks, so much! This will help immensely. As I played with VB, I did manage to find the method and objects to update Project from VB in Access. We are just beginning, so I didn't do anything but realize how it is done. These code examples will help, for sure. Our first...

We have this idea that presenting HTML pages to update a database with basic schedule info, then transferring that data to MS Project might be easier than making everyone buy Project and learn how to use it. Only the Project Manager will use Project for detailed schedule stuff. Others will get...

Truncated memo field Well, since there are no answers, I'll give it a try. Not really an answer, but may be a fix. I deleted the query and rebuilt it, and everything worked as it should. Prior to a complete deletion, I reduced the query to one table and two fields, one a memo. Still...

This is a common problem based on the search I just did. On Monday, I used a little VBA to send email to contacts. It looped through a query result and sent the email to each contact. The email included a msg from a separate table with one record defined as memo. Then it looped through the data...

Truncated Memo fld Wouldn't it be nice if Access help would actually tell you that. In fact, it should Alert you if you tried to format it. Or, not allow it. Something useful so some fool like me doesn't apply a format to a lot of good data and zap it. Thanks,

SendObject stops Jack: Came to work this morning, started sending emails (I was going to do 2 and then reset) and saw bad data in the emails. Noticed that memo fields from the table were being truncated to, probably, 255 (I've seen this caused by using the @;"None" to format a memo, but I...

SendObject Stops Friday, Guess you're lucky. The article Jack pointed me too makes SendObject seem impossible -- unless you've got the latest sevice pack and updates. Maybe you do? But, the button calls the subroutine, that then opens a query and loops through it to grab the addressees and...

I could copy and paste if I was allowed to bring a floppy disk into a secure area. Can't. We have an isolated network. Trying to do basically the same thing as with other code (I tried to attach it on first post, but didn't notice if it attached). But, only using a displayed form with subform...

SendObject Stops Jack, Thanks. That explains it. My email message is quite long so maybe that is it. I'll try to get the patch, but I work in an area where getting patches is not always easy. So, I'll probably have to type in all the code....Ugh. What about filtering with the macro...

I have a few tables with related data to send to interested contacts (in a table). I've put a button on a form, tied it to a module, and executed it successfully, looping through the records and checking that each contact is found and appropriate data put into the a message. However, when I use...