Recent content by servoss

There may be another way... I've been poking around a bit in the Visual Studio Professional Edition and noticed that one can import, or link, to an Access database and then use the tables and queries as objects in the project being built. And, there are example reports to follow as templates...

I have developed an Access mdb file with lots of tables, forms, queries, reports, and VBA code. I want to be able to distribute this to Access-less users. I understand that the Access Developer Extensions enable this to be done and that the two wizards assist. My first question is this: Are...

helpful, but... Thanks a ton, pbaldy! This may do the trick, but I'm using an autonumber for the table in question and the example specifies that this be switched to number for the record field. The autonumber assists with other aspects of my database. Any other ideas?

Ok, here's what I am trying to do: I have one mdb with lots of tables, forms, reports, VBA, and macros. Two people in two cities will each get a copy; each will populate data. At some point, User2 will export data and send it to User1 for import into User1's copy. Likewise, User1 may send a...

createitemfromtemplate template? What sort of templat is being sought for the createitemfromtemplate argument? Is there a default template for Outlook email notes? Can I avoid having to specify this since I may not know the path for a template? Thaniks for the help - I'm almost there... Tom

Super, for items within the database, but... can I attach a file saved to the local harddrive in the same manner (ie using sendobject)?

Using VBA, tied to a form button, I'd like to open an email note with a file as an attachment. i can open the note, insert an address, insert a subject, and insert message text, but cannot figure out how to add the attachment. I'm currently using DoCmd.SendObject to create the message and add...

perfect! this did the trick! Thanks.

not so good... got an error saying I could not open a new MDE with a current database open. Should I put the runcommand() right on the onclick event line - I placed it in the VBS module for the onclick. Tom

care to chat via yahoo IM? care to chat via yahoo IM?

How do I simply create an mdb file using code? I want to use a transferdatabase command to export data to a table (for import at another time), but this expects a file to exist already. I've searched with no useful example - perhaps I've missed it, if so, please point in the right direction...

Thanks, but... I'd like to not have to rely on someone having Excel if I can get away from it. Anyway, I appreciate the code and will definitely give it a try in case I need to use this approach. Thanks, again. Tom

Easy way to create an mdb file, then? An alternate approach would be to create an mdb file and then export the data to individual tables within that file. Again, I've searched for file creation and haven't had much luck. I assume there is a fairly straightforward way to create an mdb file...

So, it seems both outputto and transferdatabase both write to an Excel file just fine, but is there any way to write table data to a new worksheet within an existing workbook? I want to save several tables to the same Excel file, but am not seeing clearly how to do this. Is it even possible...

Just in case anyone cares... I figured out the problem, I think. When I uninstalled the previous version of my database, I was also uninstalling a couple of the reference libraries. When i installed the new version, I did not install the same libraries. One of them - I'm not sure which - was...