Search results for query: *

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...

...'set connection string Set complaint=Server.CreateObject("ADODB.Recordset") compSQL="SELECT * FROM complaints" complaint.Open compSQL,Connect,3,2,1 It stops when it gets to the open statement and says: Microsoft OLE DB Provider for SQL Server error '80040e4d' Login failed...

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.

I think I may have found the main problem. Two of the connector pins from the hard drive are broken. Looking for parts. now. Appreciate the assistance.

We acquired an HP Pavilion N5450 laptop running windows ME. It probably has a virus as when the machine starts up the first screen comes up and then just keeps rebooting from there. I tried F8, but I don't think the boot process is getting that far so I can use safe mode. I tried a bootable...

Solved - I created a recordset clone and if BOF and EOF are true then I close the form and then use DoCmd to open the form again. Thanks Tom

I have a form that uses a query for its data. The query uses a parameter input of a single letter to select records that begin with that letter. If the user selects a letter that is not in the database it returns with nothing. When the form starts the parameter reqeust opens up and when a...

No. Unknown why it started doing it. Right now my only work around is putting the code into each page. Tom