Search results for query: *

Hello, I have an Access report like this: Date amount 10/11/2004 $200.00 9/27/2004 $100.00 9/27/2004 $100.00 How can I supress the Date and amount that show up more than once. Thank you Jill

Hello, I am trying to import this number -1,855,151.82 from a .txt file into an access table/column. But for some reason the number can not be displayed correctly. all I can see is 855,151.82, any recomendation on what I need to do to import this number to show correctly Thank you Jill

Hello, I have an access table that shows the users and the number of times they have visited my site by month. So picture a grid where all users are on the left and the months on the top and the number of hits/visits to my site in the middle. I would like to create a query that shows me the...

I use the code below to send emails from excel. I am trying to enter code on the LastRow line so excel will go to the last cell in the sheet instead of me having to specify the lastrow in the spread sheet that contains data. Thank you Jill Set Sht = Worksheets("TEST") FirstRow = 2 LastRow...

Hi, I have two columns in a Access table: Amount1 Amount2 100 200 300 400 500 I would like to divide amount1 (100) by amount2(200), (300), (400) etc. How can I do that? simply, I would like to divide values in amount1 by every value in amount2 Thank you Jill

Hello, I have a table in SQL server that has two columns with different dollar values. I would like to create a query that looks at each value in column 1 and compares that value to each value in column two. I would like to extract the values in column 1 that are less than 5% the values in...

Hi I have an access table with 2 columns. I would like to compare each record in column one to all the records in column two. If any record in column one is less than column two then produce a report with the records that meet the criteria. Thank you Jill

Hello, I have an Access Table: Values (1) Values (2) $200 $200 $250 $250 $300 $300 I need to write VBA code that checks if EVERY amount in the values(1) column is less or equal to the amounts in the values (2) by 5%. Each amount in Values (1) need to be checked against...

I have a column in Access 2002 that contains different amounts of ($) Assets. I need query that can loop through the values in the column and show me the assets amount that have a diffrence of 5%. In the example below the values 100 and 105 should be the result. $Assets $300.00 $250.00...

I have a column in Access 2002 that contains different amounts of ($) Assets. I need query that can loop through the values in the column and show me the assets amount that have a diffrence of 5%. In the example below the values 100 and 105 should be the result. $Assets $300.00 $250.00...

Dim Sht As Worksheet Dim FirstRow As Integer, LastRow As Integer Dim App, Itm Dim SendTo As String, Esubject As String, Ebody As String Dim Attachment1 As String Dim Attachment2 As String Set Sht = Worksheets("Sheet1") FirstRow = 2 LastRow = 5000 ' You could insert code here to find...

I have an Access table that shows the following info: Client Name Email Attachments ABC Inc. ABC@air.com C:\Folder\file1.pdf DEG Corp. DEG@out.com C:\Folder\file2.pdf FGO Inc. FGO@test.com C:\Folder\file1.pdf GIO Inc. GIO@ert.com C:\Folder\file1.pdf These clients receive PDF files via...

Hello, I use CFGRID to display data from a SQL database. I would like to be able to export the output to excel after I view the GRID. Any suggestions will be greatly appreciated. Thanks

Hello, I have a Web page with multiple text labels written in cold fusion. I also have a SQL database connected to this web page. The SQL database has a reference table that contains the names of the text labels. I would like to make the text labels dynamic, meaning I would like to change the...

I would like to automate an outlook application. I would like to send emails to about 200 emails addresses with attachments. The trick though is that the attachments are different depending on the email address. I have to do this process on a monthly basis. Any suggestions Jill

Can someone help me add code to the code bellow that will send pdf files as attachments. Private Sub Command0_Click() DoCmd.SendObject acSendNoObject, , , [substitute the recipient's e-mail address here], , , "this is the subject.", "This is the message body. Here is a value...

Hi, I need to add a total to a result that a query produces I need the query result to look like this Account Funds A 100 B 200 C 300 D 400 Total 1000 Please let me know how to do that Thanks Jill

Hi, I need to create an Access query that can cycle through different ACCT numbers and net the Negative CASH (negcash) from the positive Cash (POScash). And display the net amount. For Example ACCT 90313-13-0005 should net to -200.00 The ACCT field is not numeric it is text. Thanks Jill ACCT...

Hi I have two queries one that results in 55 records and one that results in 23 records. I would like to run a query that combines these results for a total of 78 records. Both queries have the same column headings. Thank you Jill

Hello, I would like to be able outlook from a control in VB. Can some one please provide me with the VB code. Thanks Jill