Search results for query: *

MastermindSQL thanks for the help. Worked perfectly.

All, I have written some SQL code to create a database then 2 tables and after that insert some records into the new tables in the new database. Everything works if I execute each SQL statement by itself. However, when I put all the SQL statements in one file and try to execute statements in...

stefanwagner, Thanks for the replies. That was exactly what I was looking for. It seems so simple now that you have shown how it is done. Thanks again

All, I need some help regarding the color class and reading files. I have a text file that lists various colors such as magenta, blue, red, yellow. I can read the file no problem to get the color names. The problem is how do I convert these names to a meaning color to display objects in whatever...

LonnieJohnson You can use the command Excel.Application.Quit to close Excel. So in your case it should look something like: xlsApp.quit Hope this helps.

If the column is based on a table or anything that has more than 1 value you will need to hide the first column or the column that you do not want to see. You can do this by viewing the combo box properties and setting the column count to 2 and then setting the column width property to 0";3" or...

pbrown77, Here is a function you can use to pass the startdate and enddates to and it will return the number of weekdays between the 2 dates. Public Function WeekDays(StartDate As Date, EndDate As Date) As Integer Dim DaysDiff As Integer 'Get the total number of days between the 2...

zeveck, The problem is that the users account is being locked after a single attempt. Active Directory is set to currently allow 3 bad password attempts before locking a user out. However, as soon as someone enters 1 bad password into outlook it locks their AD account. Do you have any idea why?

Hello, First, I am not sure if this is the correct forum or not. I am having a problem setting up outlook on a common pc utilized by a bunch of people. The problem is that everytime outlook opens it needs to prompt the user for their username and a password. This is not a problem and works fine...

qajussi, Just download the file from the link I provided. That will restore all your objects back to version 2.5. Or you can download the newest version and install that as well. That version is 2.8. The reason you are getting the error is because the MDAC version 2.6 must not have been...

Here is a link that will take you to a microsoft download page that will allow you to download and install all of the MDAC 2.5 version files. http://www.microsoft.com/downloads/details.aspx?FamilyID=c57692e9-dde7-4a60-b586-5d4fd6794db6&DisplayLang=en This should solve your problem. Just...

Hello, First, I am not sure if this is the correct forum or not. I am having a problem setting up outlook on a common pc utilized by a bunch of people. The problem is that everytime outlook opens it needs to prompt the user for their username and a password. This is not a problem and works fine...

All, I have just normalized my database and I have created a form to display data from 4 different tables. The data displays fine on the form however when I try to edit the data I receive a message stating that there is a write conflict. However, the database is only on my pc and is only used by...

I do not have them pointing to the ISP dns. I do however have the clients configured to Obtain DNS servers automatically. As I stated before when I type nslookup from a client computer it returns the name of the my server and the ip address of my server. I am relatively new at this so maybe I am...

I have a small office network in which there is one server utilizing Windows SBS 2003 and 5 workstations all using windows xp. The server has the following roles and is using Active Directory: dns, dhcp, and dc. 4 of the workstations all had windows 2000 on them and were able to login in mere...

Does anyone know of a way to import excel data into an access database using vba and not by using the transferspreadsheet method. I already know how to open excel from access but how do I get the data from the worksheet and import it into a table or recordset?

When I try to run the following Append Query I keep getting error message 3075. "Syntax Error(missing operator) in query expression. Here is the code: DoCmd.RunSQL "INSERT INTO tblErrors ( ErrorNumber, ErrorDescription ) VALUES(" _ & " '" & strErrNum & "', '&quot...