Search results

Hello, I have been working on a split database and one of my forms involves copy data from one table on the back-end database to another back-end table. Prior to copying the data to the destination table I copy it to two temp tables to modify and insert new data. My issue is that when I am...

I would try testing the DB on 2010; where I work we went from 2000 to 2010, and most of the databases ran fine unchanged. You might not need to do anything. -Ed

Lloydyboy, You might want to look into Access's built-in user-level security. Here is, at least to me, a decent tutorial that walks you through the basics: http://databases.about.com/od/tutorials/ss/usersecurity.htm.Good luck with your project. I just finished my first Access database that...

Thanks for the help. I was able to resolve my issues with the form with your help.

I am trying to write a series of queries that are activated by a form button; however, when the first query results two entries (the form is in not in data entry) in the "Downtimes" table, and unless all of the fields are filled in on the form most of the data will not be entered into the either...

I resolved the problem. In the process of editing a relationship somewhere, the System field in the System_Steps table was changed to numeric. As you are probably aware, I am very new at this, so sorry for using so much of your time. Your assistance was invaluable though.

Here are the results of the Debug.Print functions. The first one is the Debug.Print you requested, and the second is a copy of the query. Thank you for all of your help.

Following your advice resolved the syntax errors; however, whenever I run the query, it will not append any records, but when I remove the "WHERE" clause, it will copy the whole table over. That, I think, would rule out any structural issues with the tables and the "SELECT" and "FROM" clauses...

I tried the code that you gave me, but I am still receiving errors. Now I am getting following error: I tried changing the last set of quotes to double quotes, but that did not resolve the problem either. The WHERE clause is reading data I copied from a listbox; the code I used to copy from...

Hello, I am having a lot of problems writing a query to run in a vba module. I am trying to use an insert-select statement for all of the values except for one, and for that exception, I am trying to use a variable value or another query. Here is the code: strDwnSystemsSQL = "INSERT INTO...