Search results for query: *

I am running a report in Access 2003 off of DB2. I am pulling multiple records for an event and am using 'select unique' to pare them down. Unfortunately, when I do this, it causes Access to loop. My time-out setting is 600 seconds and the data set isn't that large (2,000 records). Anyone...

Hello I am running a report in Access 2003 off of DB2. I am pulling multiple records for an event and am using 'select unique' to pare them down. Unfortunately, when I do this, it causes Access to loop. My time-out setting is 600 seconds and the data set isn't that large (2,000 records)...

There must be a way to do this. I have to stitch together two separate pdfs and it's cut and paste hell. In particular, I have to manually remove all of the carriage returns. I wasn't sure if there's some VBA out there to do this. Any thoughts/hints would be enormously appreciated.

Hello I was wondering if someone could help me out. What would be the best way for me to go about determining the sale number from the following table: applicantID calltime result 1 1/5/05 no sale 1 1/15/05 no sale 1 1/25/05 sale 1...

Hello I have administrative rights over an ACCESS 2003 ADP file. It's a backup of PROD data. I report off PROD data but have to manually import the objects into PROD each time to run the reports. I don't have the ability to permanently save objects on the server. Is it possible for a...

example: abc@abc.com ZZZm98@hotmail.com I'd like to extract the characters afteer the "@" but I can't use right () because the len varies. Any ideas?

Hello I am having a problem with the following: SELECT date, contacts, [contact pct], sales, elig, [elig pct], telco, badphone, fedex, inelig, dials, [sales pct], [fedex pct], [bad phone pct], [telco err pct] FROM dbo.qry_8_master I'd like the [contact pct] field to have two...

Hello I am more familiar with MDB files, but there has to be a way to do this. I have a MS Access 2003 .ADP file and would like to get the T-SQL for some views without cutting and pasting en masse. I don't see a 'documenter', as I would in an MDB. Anyone with any suggestions? Thanks. ps

I have a field dtmTimeStamp that comes across as 8/29/2005 10:45:58 PM. I am only interested in the date. Another date field comes across normall as 8/29/05 When I do a 'left' SELECT LEFT(dtmTimeStamp , 11) AS date, it comes across as Aug 29, 2005 I'm sure that there's a cast or...

I must be an idiot. I run this query in an ADP and get zeroes for the values on pct: SELECT dbo.qry_sales_30days2.date, dbo.qry_sales_30days2.[count] AS quals, dbo.qry_sales_30days4.[count] AS sales, (dbo.qry_sales_30days4.[count]/dbo.qry_sales_30days2.[count]) as pct FROM...

Can I pick your brains about how to best transform the following from a select statement a transform. In an MDB, I would just use the crosstab query wizard but that's not an option in an ADP. Thanks. SELECT dbo.VM_Users.FirstName, dbo.VM_Users.LastName...

I have written a series of queries for an MDB file that I am upgrading to an ADP one. See below for the series. Long story short, I created a series of queries that fill other queries. It's not uncommon for me to follow the following process: query 1: query a large table to get my dataset...

Hello I run this SQL statement: SELECT TOP 100 PERCENT dbo.VM_Leads.dtmTimeStamp AS BornDate, COUNT(dbo.Dispositions.contact) AS CONTACTS FROM dbo.VM_Leads INNER JOIN dbo.ED_Caller_VM_Leads ON dbo.VM_Leads.lApplicationID =...

I have written a series of queries for an MDB file that I am upgrading to an ADP one. See below for the series. Long story short, I created a series of queries that fill other queries. It's not uncommon for me to follow the following process: query 1: query a large table to get my dataset...

Hello I wrote a ton of queries in an MDB and now have to rewrite most of them in an ADP. I am used to writing a series of queries to get from point A TO B. Qry1 feeds 2, 2 feeds 3, etc. I'd like to know if this is a good general practice in ADP files. I am also concerned about the lack of...

Hello I am running Access 2003 and have done a good deal of work in an MDB file. I now have to use an ADP file and am trying to import (file, get external objects, import) my queries from the MDB but that tab is not available. Can anyone assist me? Is this possible? Are there any...

Hello I have access to an ADP file in ACCESS 2003 and have started looking into creating triggers. The ADP file is linked to tables from a backup of our production dB. Before I get too involved in creating triggers for ADP, I'd like to know about the transferability of triggers from projects...

Hello I am very new to ADP files but have worked with MDB files for eight years. I'd like to know how to set up a basic email trigger if records are added to a table (dbo.VM_lEADS). This is the MS template: CREATE TRIGGER VM_Leads_Trigger1 ON dbo.VM_Leads FOR /* INSERT, UPDATE, DELETE */...

Hello I am trying to move some queries and reports from an MDB file in Access 2003 to an ADP file in Access 2003. I am not very familiar with T-SQL and would prefer not to recreate all of them for scratch. For example, see the SQL from this Access query: SELECT...

Hello I am running Access 2003 and connecting my tables via ODBC to SQL Server 2000. I am getting this error when I try to hit the tables: ODBC - CALL FAILED MICROSOFT. ODBC SQL SERVER DRIVER. TCP/IP SOCKETS. CONNECTIONREAD(REC(). (#10054) MICROSOFT ODBC SQL SERVER TRIVER. TCIP/IP...