Hi, Does anyone know the VB code used to convert a report in access to ADOBE PDF format and E-Mail it automatically? I can do so manually but it would far easier if I could just click on one button while in the form. Thank you

I am in charge of 10 computers and a server, I have them all on a workgroup and i can only use the database application installed on the server on the older computers. I try to use the same program on win xp but it says that the program is outside of the local intranet or on a untrusted source so...

I am setting up a database of photos and fine art prints made from those photos. I have a table that lists each photo and its related data. Each photo can then have a number of prints made from it (each one can be different size, material etc.) They should each be numbered individually and...

I'm looking to get a random selection of rows from PostgreSQL. I've already tried this: select * from table where random() < 0.01; But one of my friends told me to use this: select * from table order by random() limit 1000; My table has over 200 million rows so I need it to be fast. Which way...

My boss left and I took over her access database. When I try to pull the information from tables she created I get error that says"C:user****is not a valid path make sure path name correct or connected to server. How can I change the database to be "mine" so I can access the tables information?

I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?

I'm trying to pull out duplicate records in a MySQL database. I've already figured out how to do it this way: SELECT address, count(id) as cnt FROM list GROUP BY address HAVING cnt > 1 This is what it results in: 100 MAIN ST 2 But I need to do a pull that shows each row that has a duplicate,...

We have a table with the following fields: id (Unique) url (Unique) title company site_id We now need to remove rows that have the same title, company and site_id. We've figured out one way to do it: SELECT title, site_id, location, id, count( * ) FROM jobs GROUP BY site_id, company, title,...

Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy