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...
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("PeopleIDNumber") = "" Then %>
<script language='vbscript'>Msgbox("Test")</script>
<% Response.Redirect...
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...
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...
Do you have any error handling on this page? If you have the line "On Error Resume Next" 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...
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...
You can turn it off by running your query in a macro. Create a new macro and for the first line, select "Set Warnings" from the Action drop down list. In the lower half of the screen, under Action Arguments, the "Warnings On" field should show "NO".
On the...
In an update query, the field to which you want to write the new calculated value should be selected in the "Field" drop down list. The formula I gave to you should be entered in the "Update To:" field.
Rich
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 "Field" in your query grid, type in...
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("d", -7, [DateField])
The "d" parameter tells it to use days.
The -7 is telling it to add negative 7 days...
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 '" & strValue1 & "', " &...
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...
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...
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
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...
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...
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?
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 =...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.