Search results for query: *

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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?

I have sample code to be used in a conncetion string for an Access table using dreamweaver as an editor. When I preview the webpage on my local server, 1. I get an error message. Compiler Error Message: BC30451: Name 'RS' is not declared. Line 10 creates the error. Line 10: Do While Not...

It would be a column called Combine

Using sql 2005, I have 2 fields, bioID and MillID. I want to create and populate another field, lets call it Combine. If the contents of bioID equal MillID then I want to print 'N', else if the contents of bioID are not equal to MillID I want to populate the same field with a 'Y' So far my...

I used the upsizing wizard to upload an access table to sql. Lets call the table mytable1. I set permissions to alter, delete, insert, select, and update. I went back into MS Access, I chose File, Get External Data, Link Table. I then linked the mytable1 and brought it in as a table. I went...

We are about to use crystal reports 10 or beyond to create reports and deploy them using a scheduler. They are to be web based reports and we have chosen dreamweaver as the editor. 1. If you are running windows xp, doesnt microsoft provide a method of installing an IIS server on your local...