Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MaeJams

    DataAdapter Update Query

    I agree with alphanytz...you definitely need a primary key. If you plan to continue using the CRUD statements that were auto-generated, be sure to check these SQL statements in your DataSet.Designer.vb file. The Update Command that is autogenerated for a table is not one you should use...
  2. MaeJams

    getting a popup box

    You can use Microsoft VBScript (client side script) to pop up a message box. JavaScript is not the only way to do it. Try this: <% If Request.Cookies(&quot;PeopleIDNumber&quot;) = &quot;&quot; Then %> <script language='vbscript'>Msgbox(&quot;Test&quot;)</script> <% Response.Redirect...
  3. MaeJams

    is there anyway to have a msgbox in ASP page?

    Since a message box is a client-side control, you would need to insert client script code into your ASP page. Try inserting the following code into an existing ASP page: <input type='button' id='cmdShowMessage' value='Show Message'> <script language='VBScript'> Sub...
  4. MaeJams

    VBA sub for compressing a database

    I have a small VB app which I run to compact a database periodically. It uses a utility freely available on the Microsoft website called JetComp. My app is not automatically kicked off on the close of the database, but I'm sure you could modify it to do so. I actually use a form with a single...
  5. MaeJams

    Cookie Question

    Do you have any error handling on this page? If you have the line &quot;On Error Resume Next&quot; at the top of the page, you can comment that line out so you can see if any errors are occurring. That's usually my first step when trying to find out why something isn't working. It doesn't...
  6. MaeJams

    Moving records from one table to another !??

    You would first need to setup two queries. The first one would append the checked records from your source table into your destination table. Then your second query would delete all checked records from your source table. You could then put these two queries (in order) into a macro. Let me...
  7. MaeJams

    Table Autofill, is it possible?

    You can turn it off by running your query in a macro. Create a new macro and for the first line, select &quot;Set Warnings&quot; from the Action drop down list. In the lower half of the screen, under Action Arguments, the &quot;Warnings On&quot; field should show &quot;NO&quot;. On the...
  8. MaeJams

    Table Autofill, is it possible?

    In an update query, the field to which you want to write the new calculated value should be selected in the &quot;Field&quot; drop down list. The formula I gave to you should be entered in the &quot;Update To:&quot; field. Rich
  9. MaeJams

    Table Autofill, is it possible?

    When I said wrap the formula around your date field, I just meant your date field is one of the parameters in the formula. Here is what you do: 1. Create a new query. 2. Select the table that has the date field you want to use. 3. In the first &quot;Field&quot; in your query grid, type in...
  10. MaeJams

    Table Autofill, is it possible?

    You can write a query based on your table and wrap a formula around your date field. The formula to use is the DateAdd function. Use the following syntax: DateAdd(&quot;d&quot;, -7, [DateField]) The &quot;d&quot; parameter tells it to use days. The -7 is telling it to add negative 7 days...
  11. MaeJams

    Replacing all special characters before inserting into SQL

    Hi Rachel, I've used the following SQL statement to successfully input free text (complete with special characters) into an access database: Assume Field2 has the need to store any special characters. INSERT INTO Table1 (Field1, Field2, Field3) SELECT '&quot; & strValue1 & &quot;', &quot; &...
  12. MaeJams

    ASP updating dB with 200+ records

    Are you talking about 200 records a day? If so, you may want to consider using a different database tool. Access is good for rapid app development and small databases, but once you start using it as a heavy back end data storage tool, you run into issues. I would suggest using a SQL Server...
  13. MaeJams

    Multithreaded Application Crashed IIS HELP!!

    Do you have any error handling in your ASP page? A practice that we follow with respect to error handling is to put a check on Err.Number after any call to instantiate an object (Server.CreateObject) and any calls to methods or functions within the objects. So your ASP code could be modified...
  14. MaeJams

    Multithreaded Application Crashed IIS HELP!!

    Is this a VB App that runs on a client PC, or is it housed on the IIS server? If the ASP is triggering this to run on a client PC, I'd be interested to find out how you did it. Rich
  15. MaeJams

    How do I insert a jpg into a MS SQL 7 database ?

    I have found a solution for this on the microsoft site. Check out the following link: http:\\support.microsoft.com\default.aspx?scid=kb;EN-US;q258038 This details a way to save the image to a SQL Server database and a way to save the image file out of the same database. I'm working on a...
  16. MaeJams

    ADO Question

    I have an Oracle SQL statement running through a VB DLL. The Oracle SQL runs fine when running in a SQL tool, but when attempting to run through ADO in the VB DLL, the ORDER BY clause does not seem to function. The records are returned fine, but the records are not ordered as specified in the...
  17. MaeJams

    Logon_User will not pass into Dll

    The variable strUserName (on the ASP) should have the value returned by the DLL's function (Truncate_UserName). Did you set it up in the DLL as a function?
  18. MaeJams

    Logon_User will not pass into Dll

    Keep in mind here that I am using VB 6.0, Windows NT, IIS 4.0, and ASP 2.0. If you're using other technology, there may be something that I'm missing. Here's another thing I've learned...the hard way...debugging ASP is a real pain. I would try this... Set objDLL =...
  19. MaeJams

    Logon_User will not pass into Dll

    Code wrapped in the <script language=vbscript> and </script> tags are considered client side. The Request object, which contains the ServerVariables collection, and is housed on the Server, cannot be accessed from client side code - at least not directly. Your client code can be thought of as...
  20. MaeJams

    Logon_User will not pass into Dll

    There is a problem with the code snipet you included. Your subroutine is in client side script, but you are attempting to access a Server side variable. This won't work. I'm assuming your DLL is on the server, so you won't need any client code. You could have a function in your DLL that...

Part and Inventory Search

Back
Top