Search results for query: *

I have an ASP application with the following security setup: 1. (3) global groups created at the domain level that are given full rights to all the web folders on my application server. 2. For the ASP application to work and groups to be validated, the individual logging in must be in the...

Good morning, I currently have a form with fields that posts data to a SQL DB. It works great but bombs on a tic mark (" ' "). I created the following function(in asp include file..) to filter the fields but I cant seem to get it to work: function FilterQuotes(strSQL) if not isnull(strSQL)...

Good afternoon everyone, I’ve got a security issue that needs some recommendations. Here’s the scenario: All my users login to access the company domain which is managed by active directory. I’ve written ASP applications that allow access to the user only if the domain\username...

Good afternoon everyone, I’ve got a security issue that needs some recommendations. Here’s the scenario: All my users login to access the company domain which is managed by active directory. I’ve written ASP applications that allow access to the user only if the domain\username...

Good afternoon, I'm getting the dreaded "expected end of statement" error on the GetDetails function. Can anyone see where the syntax needs to be fixed? if Request.QueryString("CRUD") = "C" then RW "Entry successful" & RW GetDetails("empNameFirst","tblUser",Session("USER")) & RW "your Document...

Good morning, i'm currently trying to migrate and Access db to a SQL 2k environment. Everything transfers except one table which consists of mostly text columns but has (2) date columns. I've tried changing the date format before I DTS it over but once I execute I get this error: "status 6: Data...

Hello everyone, I'm trying to create an update query that doesnt erase all my data and leave just a ",". My goal is to create/run a query on a keyword column(text(255)) that has data with no space after the comma and then add the space. Check out an example of my data...

How do I lock a table into staying one size horizontally? Here is my code for the search page that works properly. THe problem is that when I search in the "keyword" column the search results explode horizontally outside my limits I've set in the table specs. I just want the results to wrap...

How do I lock a table into staying one size horizontally? Here is my code for the search page that works properly. THe problem is that when I search in the "keyword" column the search results explode horizontally outside my limits I've set in the table specs. I just want the results to wrap...

Hello, I'm currently working on a Access XP Db that needs input validation. I've got a Main form for Shop orders and then a subform that deals with defects associated to the shop order in question. This subform is basically a column view of the ShopOrderDefects table. The operator has the...

Good Afternoon everyone, Well here goes, this is my TSQL used to generate the following results: SELECT ShopOrderDefects.DefectCode, ShopOrderDefects.PartNo, ShopOrderDefects.DefectLocation, ShopOrderDefects.Qty, ShopOrderMain.ClosedDate FROM ShopOrderMain INNER JOIN ShopOrderDefects ON...

Does anyone know if there is any current or soon to be future support for importing or linking Paradox 7, 8 or 9 tables into an Access 97 environment? snappy

I currently administer a Paradox 8 dB that is approaching 100,000 records. Does anyone know the max for a RAD tool like Paradox? We are trying to decide if moving to MS SQL is the right thing to do considering the time it takes to run the extensive scripts that generate our result sets. Our...

Definition of Winsock: "The Winsock control shipped with Visual Basic is the very powerful tool. It allows implementing any Internet network protocol inside of your application. In comparance with any other ActiveX controls the Winsock control takes great deal of job. However the situation...

Hello, First of all, I have an Access 97 application I'm trying to document and I've hit a wall. I have a form that at the click of an "Update" button calls two ActiveX controls that are clearly seen in design view of the form. I'm trying to define functionality of these controls but...

Hello everyone, This tip was recieved from a friend and I thought I might pass it on to anyone building an .EXE VB program and then assembling a setup package for it. If your location changes for your program after it goes .EXE, just change the .INI. Here goes: The blue text is the code you...

Hello everyone, First of all, i have a form with it's data source being the result set of the following query. SELECT Silo_Clientelle.*, TANDEM_DLT.SER_NUM, TANDEM_DLT.PT_NUMBR, TANDEM_DLT.STATUS FROM Silo_Clientelle INNER JOIN TANDEM_DLT ON (Silo_Clientelle.TSIOrderNumber =...

Hello Everyone, First of all, I have a tracking_no table and a tracking_no form that displays all the records from this table. This table is populated with new data dependent upon each records stage in the record life cycle. For example, a form is filled out and a new id is generated at the...

Hello everyone, I recently assembled a setup program for a VB EXE through the deployment wizard. Before I made the VB program an exe., I defined all my connect strings in INI files so I could change any of them in the future due to any change in the network folder location. VB 6.0 is installed...

Hello everyone, Let me give you the lowdown and then you may be able to give me some recommendations. First of all, my company network is setup with a number of Access DB's on a main drive. All of these DB's are "ghost" DB's, in that they link or import tables from a main product...