Search results for query: *

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

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

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

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

I'm using this code from Sheco for the array. <% myvalues=Split(Recordset1.Fields.Item("Resolved_by").Value, ",") For i = LBound(myvalues) TO UBound(myvalues) Response.Write myvalues(i) Next %> Using (Response.Write myvalues(i)) temporarily for debugging. Here's the menu code. <select...

I'm using this code to send an email when a ticket is placed, except objMessage.TO was my email address. I can't seem to get a variable to work in that line. <% If Request.Form("submit").Count > 0 Then Set objMessage = CreateObject("CDO.Message") objMessage.Subject = "TSR Form"...

Is there a way to have a header in a drop down menu that isn't selectable? I have a menu with "Select a Link" as the first option, First to give some direction and second to use as a spacer to keep the menu the right width. I could do it in javascript but that's not foolproof. Thanks Dan

I have a drop down menu being dynamically populated from a recordset. Then I applied a delete behavior. The problem is when I select a record in the menu and hit submit the very first record is deleted instead of the record I chose. (like the variable isn't being passed) TO test I created a new...

What I'm trying do is populate a drop down list with pagelinks that aren't already assigned to a user I have three tables USERACCESS (userid, username, userpassword, userlevel) , LINKDETAIL (id, userid, pagelinkdetail) , and PAGELINKS (pagelinkid, pagelinks). USERACCESS userid(1) inner join...

Is there a way to replace the [Request.QueryString("pagelinkiddetail")] with code that will allow me to insert data from another recordset with several lines? example; table (linkdetail) has 6 entries in the pagelinkid column 1,2,3,4,5,and 6 <% Dim Recordset2__MMColParamm...

I started this in another section but was told it was in the wrong place so here goes. =) The code was done in dreamweaver and I just played around with it. Anywho, I've built a detail page that gets the userid from a querystring. That string populates a text field (username) and list menu...

Help!!! I'm trying to populate a drop down list with the output from recordset2 and dynamically limit the data in recordset 2 with recordset1. What I'm trying to accomplish is. recordset1 = pagelinks that also = userid 1 recordset2 does not equal userid 1 and does not equal pagelinks from...

To start off, I'm not even sure If that's the correct question. Anywho, I've built a detail page that gets the userid from a querystring. That string populates a text field (username) and list menu (pagelinks) by referencing the recordset. Recordset = SELECT useraccess.UserID...

I have a list box set to accept multiple. I have three names in it...Justin Jeff Dan. When I click on the dynamic button and select value equal to <%= (Recordset1.Fields.Item("Res_By").Value) %> , I get 1 name returned(highlighted) but not when I select multiple names. I assmue it's because the...

I have a list box set to accept multiple. I have three names in it...Justin Jeff Dan. When I click on the dynamic button and select value equal to <%= (Recordset1.Fields.Item("Res_By").Value) %> , I get 1 name returned(highlighted) but not when I select multiple names. I assmue it's because the...

Hi All, I've come across the need to have a single checkbox supply values to 2 hidden form fields to submit to the database. [code] <script language="JavaScript"> var temp var vari1active var variFin_Date function finished() { if (form1.temp.checked == true) {...

I've put together a couple of sites with the same type of Search / Results pages with Recordset Navigation. The search page uses several parameters including first name, last name, and dates (between). While working on the second site I noticed a problem. If you enter a name as a parameter...

I have a "submitted" field in the database being propigated by a checkbox on an update page. The checkbox is numeric 1,0. The search page is using <%=(Recordset1.Fields.Item("Submitted").Value)%> to populate the "Ad Status" section of the repeat region. What I'm trying to do is switch the 1...