Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jgroh9

    SQL Statement Help

    MastermindSQL thanks for the help. Worked perfectly.
  2. jgroh9

    SQL Statement Help

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

    Color Class

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

    Color Class

    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...
    • jgroh9
    • Thread
    • Replies: 4
    • Forum: Java
  5. jgroh9

    Run Excel Macro from Access

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

    Combobox Returns Row Values rather than text

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

    Number of Days

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

    Outlook - Active Directory Problem

    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?
  9. jgroh9

    Outlook - Active Directory Problem

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

    Missing or broken reference to the file "msado15.dll"??

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

    Missing or broken reference to the file "msado15.dll"??

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

    Outlook/Active Directory Problem

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

    Update Form Problem

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

    Slow login to Windows 2003 from Windows XP Pro

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

    Slow login to Windows 2003 from Windows XP Pro

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

    Importing Excel data into Access XP using VBA, Help!!

    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?
  17. jgroh9

    INSERT INTO Statement Syntax Error Message

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

Part and Inventory Search

Back
Top