Search results for query: *

OK Darrylle, I now have this for a query SELECT tblversionnumber1.version1, tblversionnumber2.version2 FROM tblversionnumber1 INNER JOIN tblversionnumber2 ON tblversionnumber1.version1 = tblversionnumber2.version2; when the #'s in version 1 & 2 match then i get a return otherwise it's blank...

Darrylle, Thanks for the qiuck response. I do have this SELECT versionnumber1.version1, versionnumber2.version2 FROM versionnumber1 INNER JOIN versionnumber2 ON versionnumber1.ID = versionnumber2.ID WHERE...

We currently have a large access database that is being created by a program called MPC. This database is loaded on 20 local user computers. I want to make sure that all the users are using the same version of the database. Is it possible to add a "version" table in the MPC database, link it to...

I found that when the higlights don't work it's generally because the strings don't match. You should start a new thread, and I'll go look for that page to copy the code for you. Dan

I suppose... We have an exchange 5.5 server (smtp server) with about 150 mailboxes. only half of them have an smtp entry. which means half the company can receive outside mail and the whole company can email each other. When the page uses objmessage.to it acts like an outside email so half the...

Let me know if I should post on the exchange 5.5 forum. I have an intranet site being used for help desk requests. When a ticket is comlpete it's submitted to the database as nonactive and an email is sent to the person who started the request. Here is the code for the email; <% If...

very helpful thank you DAn

Yes, works great Thanks, Dan

I'm trying to format a textbody to include an approved with the time or just a not approved. I made an if then statement that uses a field from the recordset (approval) and sets it to the variable (variapproval), then I have a hidden field that's named testapproval and that value is the...

Not sure I understand. Cerfformprint is the popup page and my issue is getting form data to it. Are you saying pass a variable and pull from the database by that variable?? Dan

Hi all, I'm doing yet another "printer friendly" page. Instead of making it dynamic I would prefer to have a link that posts hidden form data to a popup window. And also a printer Icon in that window that inititates the print. I've gotten the popup to work and the form data to post, but not at...

I'm getting an error in my array when the database has a null value. Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'Split' /intranet/test/tsrformadmin1.asp, line 706 So I wrote this to substitute a value for any nulls <% Dim tempvalue If (Recordset1("Resolved_by") =...

I have another issue with this array. Let me know if I should start a new thread. I'm using dreamweavers recordset paging on the page. When the page first loads up the script for the array and the highlight works great. But if you try using the next link then the menu is empty.(the "first" link...

It was the spaces. I changed the split code from MyArray = Split(Recordset1("Resolved_by"), ",") to this MyArray = Split(Recordset1("Resolved_by"), ", ") now the output is ###dan###jeff###Justin### and the highlights are working great Thanks Tarwn

this is what I get from the array ###dan### jeff### Justin### Is it the spaces? Dan

Is this what you mean? <td width="133" valign="top" class="adstat2"><select name="Resolved_by" size="4" multiple="multiple" id="Resolved_by"> <% Dim MyArray MyArray = Split(Recordset1("Resolved_by"), ",") mystring = "###" & Join(MyArray,"###") & "###" %> <% While (NOT Recordset2.EOF) %>...

I've tried several ways to make this work but no luck so far. Recordset2 has currently 3 names in it. Recordset1 is the resolved_by field populated by the menu. Here is the code <td width="133" valign="top" class="adstat2"><select name="Resolved_by" size="4" multiple="multiple"...

This is what I have now. If I select one name form the dropdownlist and update then that name is highlighted, but multiple names doesn't work still. <td width="133" valign="top" class="adstat2"><select name="Resolved_by" size="4" multiple="multiple" id="Resolved_by"> <% Dim MyArray MyArray =...

I ran the code and got Username = dan myvalues = Type mismatch: 'CStr'... a little groggy just got back from the dentist. Since myvalues is the array name I thought I had to call it in my if then statment. HOw do I get the values from the array to equal...

Thanks for the response Tarwn, The myvalues in the first part of the code is my array. followed by Response.Write myvalues(i) which outputs the correct values. the second part of the code is just my dynamic menu, with the IF Then statement If (Not isNull(myvalues)) Then If...