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

...several times. I general get the name and an encrypted password resembling a hexidecimal numeric sequence. Now I get a long number like this *EAA2EB17BB18979A5D3824AC. The password will not work when I access it. In addition, if I want to encrypt using a particular ID would the code be...

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

...select datediff(yy, gifteffdate,getdate()) AS no_of_years, case when cash.giftjntkey >=1 and marr.SPOUSEid=cash.giftjntid then sum(giftamount*2) else sum(giftamount)end as GivenLastyear from gifts cash left outer join coreVIEW_married marr on marr.SPid=cash.giftjntid where cash.gifttype...

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?

...in wwwroot is that statement appropriate? Set dbaseConn = Server.CreateObject("ADODB.Connection") dbaseConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("\db\myDatabase.mdb") & ";" SQLQuery = "SELECT * FROM Test1" dim rs as oleDbDataReader Set RS =...

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