Search results for query: *

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

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

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

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