Recent content by tburrows

Administrator installs program and when you go to explore, the program is visible with you go to C:/documents and settings/all users/start menu/programs. But when the user logs in the program does not show when the user goes to Start and Programs. If they go into explore they can find it that...

We have an Internet side and an Intranet side. On our internet side, I have a form for the public to fill out and the info goes into a sql database on a seperate sql server. On our intranet side I have a data access page that connects to the internet sql database through a firewall so that our...

No, there is no criteria of filter for DateCleared. I have solved part of the problem in that I turned off warning messages for the page, that takes care of the message box that pops up. If I can find somehow to refresh the DAP after a date is put in DateCleared, I think that will end up...

When I made up the DAP I just inserted the field and made no changes to it. The other two fields that are available for editing are text fields and there is no problem with them. Just the date field. Tom

I have an Access Project accessing a SQL database. One of the fields in the database is DateCleared and it is formatted as datetime and shortdate. On a Data Access Page I have the DateCleared field and it is also formatted as short date. However whenever I put in a date in this field I get the...

Not sure if this is right forum. I have an Access Project accessing a SQL database. One of the fields in the database is DateCleared and it is formatted as datetime and shortdate. On a Data Access Page I have the DateCleared field and it is also formatted as short date. However whenever I put...

Worked great. Thanks Tom

I am using Access to access a SQL table. What I am trying to do is that I have a date field called DateCleared. I have another field called Cleared. What I want to do is that if DateCleared is empty then Cleared is No and if DateCleared has a date in it then Cleared is Yes. I am familiar with...

Here is my connection: If Request.ServerVariables("REQUEST_METHOD")="POST" Then Connect="Provider=SQLOLEDB;Data Source=KCISQL;Network Library=DBMSSOCN;Initial Catalog=complaintSQL;UserID=IUSR_PUBLIC;Password=;" 'set connection string Set complaint=Server.CreateObject("ADODB.Recordset")...

Right, iuser_public is the guest account on the sql server and I am getting the error message that Login failed for the production web server. There are other forms on the website that use the same connection string as I am and are not having a problem.

I have created a web form and have a database on a sql server. That server is seperate from the web server. The connection string is: Conn="Provider=sqloledb;" & _ "Data Source=<database server name>;" & _ "Initial Catalog=<database>;" & _ "UserID=IUSR_PUBLIC;" & _...

I'm running access 2002 which has ADO Ext 2.8 for DDL & Security. Most of the machines which run the applications I do are running access 2000 with ADO Ext 2.7. What I'm doing now is that when I load a new application I get an error message and I have to go in and uncheck the missing 2.8 and...

It worked great!! I had tried something similiar except I didn't know about the curly brackets around the concat statement. Thanks Tom

I am trying to use an xml file that has 2 tags that are the name of a thumbnail jpg image and the other is for a large version of the thumbnail. The other tags are name, age, etc. What I want to do is make a table with all the info on one person. One of the cells has the thumbnail and when...

I know they are missing as they were broken off into the female connector on the motherboard.