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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by wsproperties

  1. wsproperties

    scheduling acess query to run

    Thanks, I put in my password and it worked intially. Here is my issue. The macro is a sendObject macro designed to email two or three people. In reading microsoft help, it mentions some limitations in using outlook to actually mail the document to people automatically. Presently using task...
  2. wsproperties

    scheduling acess query to run

    1. I created a macro that sends an rtf file to two people 2. I created a form as a startup, added a control button and linked it in events to the output macro in step1 3. In tools startup I added the macro name I gave it in step 2. 4. In task Scheduler I scheduled the macro to run using MS...
  3. wsproperties

    Crosstab in SQL

    I have the following fields giftkey(numeric) giftid(char) giftmkr(char) I have the following query select a.giftkey,a.giftid,a.giftmkr b.giftkey,b.giftid,b.giftmkr from gifttable a left outer join gifttable b on a.gifkey=b.gifthrnkey here is an example of what I get a.giftkey a.giftid...
  4. wsproperties

    password encryption

    I have not used this before. Using my example how would I set code this? Can I get an example
  5. wsproperties

    password encryption

    Using php admin (server side) I have the following code insert into admin values ('','Smith','smith_gr ',password('tlc84')) ; I have done this several times. I general get the name and an encrypted password resembling a hexidecimal numeric sequence. Now I get a long number like this...
  6. wsproperties

    Adding Primary Key to an SQL View

    Is there a way to add a primary key after the fact to an sql view. I designed a view in QA then dumped the results into an sql view. Now I want to go back and establish the giftkey as the primary key. Is there a way without a re-design???
  7. wsproperties

    Grouping and totaling by date in SQL Issue SQL2005

    This is what i get now no_of_Years GivenLastyear 4 350.00 3 5000.00 2 5000.00 2 5000.00 1 50.00 1 5000.00 Here is what I want no_of_Years GivenLastyear 4 350.00 3 5000.00 2...
  8. wsproperties

    Grouping and totaling by date in SQL Issue SQL2005

    The following query, done in QA, totals the sum of giving for a particular account number. It will list each gift separately and insert the number of years that elapsed when the gift was given. In my case, the account number made 3 gifts in the first year or no_of_years. Here are my...
  9. wsproperties

    Remove Comma, show decimals

    I have the following formula totext(Sum ({@giftamt}, {gifts.giftacctno}),0,"") It returns a number similar to this: $8720. Thus I successfully removed the comma. However I want to remove the dollar sign and add two decimals at the end. Thus $8720 becomes 8720.00. How would I accomplish this?
  10. wsproperties

    Date Range Question

    What is the best way to display a date range when you know which date range you want and then do a booleon based on that range. Here is my example. I have a field called gifteffectiveDate. For each transaction if the gifteffective date occured between 07/01/2007 and 06/30/2008 I want to...
  11. wsproperties

    Uploaded Access Table to SQL Issue

    As a piggy back, is it possible to create a new query in access by creating a field name, populating the field name with sql data in a table on your server, also including blank fields or fields with no populated data then upsizing it into sql to create a new table. The key is to establish a...
  12. wsproperties

    SQL Query Times out before completion

    Then why does it work in query analyzer and not in a view. In addition I am including blank fields that will be updatable. Here is another snipplet: select nameID,name,addr1,addr2,city,jobname,FY2006,FY2007,email, space(30) as update_name, space(30) as update_Addr from name_table left outer...
  13. wsproperties

    SQL Query Times out before completion

    I am not an expert in SQL. Can you tell me how to get to my indexes and what to consider when setting the indexes. Also am I right about the grouping? If you get an aggregate error, it means you must include each field in your query. Also this must be updateable. So should I be creating a...
  14. wsproperties

    SQL Query Times out before completion

    I have a rather large sql query that pulls from 4 different tables with left outer joins. The table also has a grouping due to a total. here is a snipplet of the view (note I did the coding in SQL Analyzer then copied code into a view) select name,addr1,addr2,city,jobname,sum(giving)as...
  15. wsproperties

    Connection String Using asp.net and Dreamweaver

    My mistake Actually I am in an asp.net environment. So how would I get the connection string to work in this case? And did you see my follow up question about the path of where the database is housed on the server?
See more

Part and Inventory Search

Back
Top