Search results for query: *

I have the total placed in the report footer. If the there is a value then the value will appear but if there is a null value #error is displayed. Anyway to get around this?

Using VBSCRIPT how can I add the value of my variable (var1) to the html page?

I am importing an array field into a field within my access database. The field value will show like this: Vermont, New York Dallas, Texas Is there a way to say take the values before and after the comma and place them into seperate fields so it shows like this: Field1...

My Excel spreadsheet is setup like this: Cell A Cell B Cell C Cell D John Smith Yes Alberta,Ontario,Quebec How can I code it so that I can turn that into this: Cell A Cell B Cell C Cell D John Smith Yes Alberta John Smith Yes...

I have a datetime field where I want take the lastfullmonth... ONLY problem is I am getting the first of the current month as well.. Here is what I am using in the criteria field: >=DateAdd("m",-1,Date()) This displays all of October but also giving me the first of Nov... WHY???????

When I use an append query on a table of 1000 records, the new fields are added ok. When I use the same append query in table of 300000. Not all the records are brought over. I am using Access 2000. Is there an option in Access that allows me to change the Deafult Max records. Or can I program...

When I use an append query on a table of 1000 records, the new fields are added ok. When I use the same append query in table of 300000. Not all the records are brought over. I am using Access 2000. Is there an option in Access that allows me to change the Deafult Max records. Or can I program...

This is my query in Access: SELECT Table1.DateEntered, Table1.LName, Format(CDate(nz([Table1].[DateText])),"yyyy\/mm\/dd") AS Expr1 FROM Table1 WHERE (((Format(CDate(nz([Table1].[DateText])),"yyyy\/mm\/dd"))>=Format(#1/1/2004#,"yyyy\mm\dd"))); In design view, there is a criteria field, here I...

I am importing a txt file into my mdb. Only problem is the date value on my import is taken as a text field. If I change the text field to a datetime field it tells me type conversion error. On an Access report, is there a way that I can convert the text value to a date value? Will this be done...

I would like to use the SendObject (macro) and send the email VIA Lotus Notes. If this cannot be done, is there a workaround? I need to run it as a macro..

I have two fields, lname and dateentered. I want to have a query in Access 2000 that will display only the names where the DateEntered is dated yesterday... somthing like currentdate -1

My report is created in Crystal Reports ver 8.5 and when I save the report in Crystal Report ver 9 and I run the report I get the err msg: error 723: failed to open rowset

I have a textarea box and I want to have a second text box that takes whatever is in the textarea box and adds a * after the last word before 60 characters. Is this possible?

How do I send out 4 emails at one time using ASPMAIL SMTPsvg.Mailer? Set Mailer = Server.CreateObject("SMTPsvg.Mailer") Mailer.RemoteHost = "mailhost.localisp.net"" Mailer.FromAddress = Request("txtEmailAdd") Mailer.AddRecipient "", Request("txtEmailAdd") Mailer.Subject = "Email 1"...

I have a html that is displaying two frames. Page1 and Page2 In Page1, I have a table of 2 rows and 2 columns. In Column1 Row1 I have an image. In Page2 (within the frame) I have a check box, one check box to change the picture in row1 column1 and a second checkbox to change the picture in row2...

I have an Access 2000 database that contains a macro. Does anyone know of any schedulers that I can use to run the macro every hr and daily?

I have a text box and I want the function to run only if the text box is active. (user has clicked or tab over to the TxtBox1) and the user presses F9 on their keyboard document.onkeyup = handleKeyUp; function handleKeyUp(e) { if(!e) var e = window.event; key = e.keyCode; Frm.txtBox1.value...

Here is my code: document.write(' <table border="1" width="100%">'); document.write(' <tr>'); document.write(' <td width="50%">Bureau of Child</td>'); document.write(' <td width="50%">Development</td>"'); document.write(' <tr> '); document.write(' </table>'); How Do I add this line to 4th line...

This displays the image under my text... Ex: News Flash Img I want to put this img to appear after my text. Text will appear in cell1 and right next to into a split cell will display the img.. Ex: News Flash Img how can I modify this line to do this: document.write("<IMG...

I have a drop-down list that is displaying the values taken from a Access 2000 database. How can I get the first item in the list to be the value contained within a variable.. Variable = Mike List: (when loaded up) Allan Bruce Sean Mike David I want the firs item to be the item in my...