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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing Params to Access Query with VB.Net
For those that want to know the VB.Net portion (or for when I forget and have to come back here)... Dim DS As DataSet Dim oCmd As New OleDb.OleDbCommand("SuppliersTest", oConn1) oCmd.CommandType = CommandType.StoredProcedure Dim myParm As OleDb.OleDbParameter =...- msmith425
- Post #5
- Forum: Microsoft: ASP.NET
-
Passing Params to Access Query with VB.Net
Never mind. I figured it out. Had to get away from it for a few minutes to see past all those trees! [sunshine] PARAMETERS Supplier Text ( 255 ); SELECT tSuppliers.SupplierID, tSuppliers.SupplierName FROM tSuppliers WHERE (((tSuppliers.SupplierName)=[Supplier])); Thanks.- msmith425
- Post #4
- Forum: Microsoft: ASP.NET
-
Passing Params to Access Query with VB.Net
Thanks for the info. I'm not quite getting the Access query part. I've added the parameter but when I run the query it still gives me all of the suppliers (see code below). What am I missing? PARAMETERS Supplier Text ( 255 ); SELECT tSuppliers.SupplierID, tSuppliers.SupplierName FROM...- msmith425
- Post #3
- Forum: Microsoft: ASP.NET
-
Passing Params to Access Query with VB.Net
I have a query in Access that I would like to pass parameters to from VB.Net. I don't know how to... 1. Designate the variable in Access 2. Designate the variable in VB.Net 3. Pass the variable to the Access query via VB.Net/ADO.Net Does anyone have links to something that would help me...- msmith425
- Thread
- Replies: 4
- Forum: Microsoft: ASP.NET
-
Printing to Web Server Printer
I'm developing a small web app that takes the users name from a web form and prints it out to a label printer. My problem is that I don't know how to go about printing. I do not want to print the web form just the data that the user has entered. The printer is a special label printer but it...- msmith425
- Thread
- Replies: 1
- Forum: Microsoft: ASP.NET
-
Date Query in Access DB
Problem Solved! Thank you all for your input and nudging toward the answer. What I eventually did was as follows: Dim myDate as Date = Calendar1.SelectedDate Dim strSQL As String = "SELECT * FROM Table1 WHERE (DateEntered Between #" & myDate & " 0:1:0# And #" & myDate &...- msmith425
- Post #4
- Forum: Visual Basic (Classic)
-
Date Query in Access DB
I'm trying to do a SQL query against an Access 2002 DB with a Date/Time field. The format of the field is "mm.dd.yyyy hh:mm:ss AM" I'm using a calendar control to get a date to search the database. My SQL statement looks like this: Dim strSQL As String = "SELECT * FROM Table1...- msmith425
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
Display data from DB in table other than DataGrid
I'm trying to display data in a hand made (a la old asp) table so that my table headers and data are displayed vertically rather than horizontally. Is it possible to bind data from a database to a text label in a cell? Is there another way of doing what I want with the DataGrid that I'm just...- msmith425
- Thread
- Replies: 2
- Forum: Microsoft: ASP.NET
-
How to Format ItemTemplate True/False as Yes/No
You know, it worked like a charm. A charm I tell you. Much Thanks. Marc [thumbsup2]- msmith425
- Post #3
- Forum: Microsoft: ASP.NET
-
How to Format ItemTemplate True/False as Yes/No
I'm reading information from a database and trying to format the boolean true/false as a yes/no. Below is the code that I came up with but this is as far as I have gotten. <asp:DataGrid id="DataGrid2" runat="server" AutoGenerateColumns="False">...- msmith425
- Thread
- Replies: 2
- Forum: Microsoft: ASP.NET
-
Adding quotes/double quotes to Access DB
Hi Tarwn, Thanks for the tip. It works great!- msmith425
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
Adding quotes/double quotes to Access DB
Thank you JuanitaC! That works great! Now I have a problem displaying a double quote in an input text box. If I have something like: 5/8" dia. tube When it is called from the DB it looks like: 5/8 Seems like everything from the double quotes on is removed. It is still in the DB...- msmith425
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Adding quotes/double quotes to Access DB
I have a form that the user enters info into and sometimes that info might contain a quote or double quote. I'm trying to find out how to enter these quotes into an Access db so that the information viewed in the database looks normal. I have been able to change the quotes to a character code...- msmith425
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
-
Passing a variable from ASP/VBScript to a JavaScript function.
Gearhead, Thanks! It works great. I just have a question about the line: response.write "<tr><td><a href='#' onclick='openwin(" & CStr(oRS.Fields("ID").Value) & ")'>" & oRS("LNAME") & "</a></td></tr>" If I want to change the database...- msmith425
- Post #4
- Forum: Javascript
-
Passing a variable from ASP/VBScript to a JavaScript function.
I'm having trouble passing a variable from ASP/VBScript to a JavaScript function. I'm trying to pass the var_URL to the openwin() function. But keep getting a "Line: 22 Error: 'var_URL' is undefined" in the ASP portion of the code (points to <body> line). Below is my code: Any...- msmith425
- Thread
- Replies: 4
- Forum: Javascript
