Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: psimon88
  • Content: Threads
  • Order by date
  1. psimon88

    unique records causing Access to loop

    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...
  2. psimon88

    unique records causing Access to loop

    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)...
  3. psimon88

    Word help - removing carriages

    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.
  4. psimon88

    ranking data on an ADP (TSQL)

    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...
  5. psimon88

    macro to import objects from another ADP file?

    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...
  6. psimon88

    Know how to delimit data in SQL?

    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?
  7. psimon88

    convert to percentage

    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...
  8. psimon88

    best way to extract T-SQL from ADP

    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
  9. psimon88

    problem converting dates

    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...
  10. psimon88

    problem with simple pct calculation

    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...
  11. psimon88

    question about using TRANSFORM statement to convert select query

    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...
  12. psimon88

    consolidating queries from MDB to ADP file

    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...
  13. psimon88

    question on counts in DDMMYYY HHMMSS format

    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 =...
  14. psimon88

    advice on consolidating reports

    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...
  15. psimon88

    general reporting assistance...

    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...
  16. psimon88

    importing queries from an MDB file?

    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...
  17. psimon88

    triggers created in ADP files valid in SQL Server 2000?

    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...
  18. psimon88

    example of email trigger?

    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 */...
  19. psimon88

    converting MDB SQL to ADP T-SQL help

    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...
  20. psimon88

    problem connecting Access 2003 to SQLS2000 (ODBC connection)

    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...

Part and Inventory Search

Back
Top