Visual Basic Email Script

I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?

Dragione5 pointsBadges:

Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?

Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

Restart15 pointsBadges:

Database Issues – Trying to prove that something has to be done

Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

Dcantwell480 pointsBadges:

Will the SQL performance improvements in V6R1 affect QUERY?

Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

Fw15 pointsBadges:

How to update a row in grid view?

how to update a row in grid view when changes made to database..

Santu1015255 pointsBadges:

Basic Access Database query question

I have an "Early voter list" table that I queried for matches against a "Dem Voters" table with the results generating a new "Identified Early Dems" table.   I would now like to query the "Identified Early Dems" table against the original "Early voter" table and be left with a table of "Early...

Sharx2th5 pointsBadges:

Replicating a partitioned table to a secondary server

I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is...

SQL Server Ask the Experts2,585 pointsBadges:

SQL Express 2005 query times lagging

I execute some simple queries on my own system's sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server's sql server express 2005, the queries execution time is about 3 seconds or more and I don't know why. both of the systems have the same...

Reza838325 pointsBadges:

crystal reports and access 2002 issue

can Crystal Reports 9 access data originally created with MS Access 2000 (successfully), be used in MS Access 2002. Getting error code 0xc28, no read permission. MS Access application had been recently updated.  Read permissions on access data file are correct, and have not been changed since...

Catcher5 pointsBadges:

SQL Server 2005 database design

What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help. 

Shamu75 pointsBadges:

Getting password when we know Product Code and Serial in Pl/SQL Developer

Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

PSRDOTCOM5 pointsBadges:

Data Extract

What is the easiest way to extract data from a pipe-delimited text file?

farmgirl165 pointsBadges:

Deduplication Backup strategy

I'm looking for a hardware base dedupe backup solution that does not require additional licensing. 

Mgtow5 pointsBadges:

Outlook 2007 templates in Access

I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I want to use. I have a...

Rdd111115 pointsBadges:

Crystal Report Writer DB Connector error

What does this error mean? Database Connector Error: '42S02:[DataDirect][ODBC XML driver][XML][Closed Integrator Base] A provider error occurred while calling the underlying provider. IOpenRowset::OpenRowset[Closed XML ADO Provider] returned 80040E37[The table...

Splows5 pointsBadges:

PHP functions

how do multiple functions work

SGB35 pointsBadges:

tutorials

hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

Mmm5550 pointsBadges:

How do I use primary keys in SQL server?

I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i...

Shamu75 pointsBadges:

docmd.sendobject – “FROM” variable

I am trying to get Access to send an email from an email address, "response folder", other than mine or anyone else who might be sending an email from the database.

Rdd111115 pointsBadges:

Display External File Properties in Excel

I have an MS Access database that uses two tables (tblOrders1 and tblOrders2) that are linked to two MS Excel spreadsheet files (Orders1.xls and Orders2.xls). The Excel spreadsheet files are occasionally updated by being replaced with new files with the same file names. I want to continuously...

OdeMitch35 pointsBadges: