Search results for query: *

I have tried a bunch of stuff on this one including putting the table names in with the field names most recently. I can do a select statement and get values from one table but when I try to join two I get nothing. Please let me know if you see something I don't, thanks in advance. sql="SELECT...

This second login page works when the Username Password combination is correct but when it is incorrect, the response.redirect in the else part of the if statement fails. It goes to an error page Classic ASP Any ideas? ================================ <% Response.Expires = -1 Dim strUserId...

I have a helpdesk asp form that invites our users to quickly point and click issues that they may be having and quickly exit the little app/utility. I would like to add an email component to this asp app so I can be informed when a user sends an issue. I tried to configure smtp on our IIS 6.0...

Thanks guys both got me going in the right direction but I somehow by luck wound up on this query and it seemed to do the trick. I went back and designed on table with 3 name fields and on staff table with just a name field and a name id field. I could'nt tell you how I wound up with what I...

I have a STAFF table that has a pk called staff_id and I have another table EVENTS that has 3 staff fields because on any given transaction up to 3 people from the STAFF table could be involved. I can run this query in sql server but I can't get it right in Access. Here is my sql server query...

First thanks jbenson001 for getting right back to me. I have a table called staff with the following fields Staff_ID (primary Key) Fname Lname email_add active I have another table that has a column called staff_id which is a foreign Key to the staff table If I insert a new record in the...

I have a main table(PC) with foreign keys from several tables such as Staff, OS, Devices. If I run an insert statement that adds a record to each of the tables, I know that the primary key/identity key for each table will be incremented. How do I get this new value to be reflected in the foreign...

Can I use Termainal Serivce to provide a different desktop for 6 users so that each user would have the Office Suite and some internally developed Visual Basic apps that use our sql server as a backend, or do I have to use Metaframe on top of Terminal Service like I did several years ago at a...

use rs.MoveLast after your update Then have the value in the primary key column of the current record brought back as a variable or display it in a text box such as this TxtRes_id = rs!res_id aspvbwannab

I would like to know as well. When I tried to open up a vb project file an error popped up saying that it couldn't open that kind of file (vbp) thanks aspvbwannab

Billybunter I just got this also. Can you let me know how/if you resolved this issue. Thanks aspvbwannab

Thanks, I am not sure where I go to change it to run in admin mode vs app mode. aspvbwannab

I am getting a message that says my temporary ts license is about to expire. I have a windows 2000 domain and this 2003 server is just a member server. I thought 2 license's came with the server for admin puposes. It does for w/2000 server. Or at least I have never bought any TS licenses for...

Using Windows Server 2000 native backup I would like to be able to restore a folder from a tape from another server that is unavailable right now, namely an NT Server 4.0. Is this even possible. When I open up the restore tab all I see are the prior backup jobs completed by that Server/tape...

Have you resolved this issue. If so what did you do. We are experiencing it now. Thanks. aspvbwannab

Alright Gmmastros took your advice. Thanks. aspvbwannab

I certainly do not need 2 gig of data and I know there is an overhead associated with this but I am not sure which datatype I should use if not this type. Thanks, aspvbwannab

gmmastros and AEtherson, that is exactly right. Earlier this morning I changed the data type of the field from varchar at 500 to Text which defaults to 16 ( it won't let you put anything else in there )not sure what the 16 means but... it worked. I hope it doesn't come back later to take a...

I have done it before and don't remember running into this issue. Here is the error and code and thanks for checking it out, maybe a second set of eyes... ========= run-time error '2147217887(80040e21) Multiple-step operation generated errors. Check each ole db status value, if available. No...

For some reason when I try to save/update a form with a multi-line text box on it I get oledb errors. Then I simply change the text box back to NOT multi line and it saves/updates just fine. The backend database is sql 7 the field is varchar set for 500 characters. aspvbwannab