Recent content by Steve@trop

Thanks Pat, I actually copied the SQL code from the query into an entirely new query for troubleshooting and I get the same error. That probably rules out any saved actions on the object.

Thanks for trying Isaac, One weird thing is I have about 8 or nine other queries that are coded the same with tables linked to the same server database and they don't produce that error. Only difference is they are pointing to different tables. I wonder if it has something to do with the ODBC...

Sure, here you go:

Yes, all of the linked tables open fine.

Yes, the tables (ending with a "T") are linked sql server objects but the queries (ending with a "Q" are local.

I've been fighting with this problem for a while now. I have a union query that joins the results of about 10 select queries that are all structured the same way but for some reason, two of the select queries are causing an error. I can run all of the queries individually except two of them...

Thanks! That worked great! I knew there had to be a way to get the SQL of the query. Now I just have to figure out where the error is in this one and the other one that has the same problem.

I'm reverse-engineering an old Access database file I inherited. I'm basically just looking at the various components and trying to figure out what they do and how they do it. I've come across a couple queries that run fine (as far as I can tell) but won't let me go into design view to look at...

Thanks Jdraw, let me clarify. The way I prevent duplicates is by using a table index so that when they are on the customer information form if they save a duplicate customer (Last name and phone number exist in the table) the index will prevent the record from saving to the customer table. If...

Users enter customer information into a form I created. The underlying table has an index set up to prevent users from entering duplicate customers. The index is made of two table fields (last name and phone number). I've got error handling set up so that if they enter a duplicate customer it...

Thanks all for your help. I tried the last one first and it worked:). About the "nz": I'm curious (how would that work?) but pretty sure I won't need it in this case. This code is part of a script that opens an existing record if the user attempts to create a new record that duplicates one...

I'm trying to open a form to a specific record using the criteria in the docmd.openform command. I know the criteria are correct individually because they both work when I use them one at a time but when I try to put them together I get errors. Here is how I have it together in it's latest form...

I should probably elaborate a little on the situation: A user starts the FE, enters data etc. then leaves for the day forgetting to close the program or log off their account. The computer automatically locks. A user on the next shift comes along and logs in by using "Switch user". This...

Accessed locally: The FE file resides on the local computer. Specifically c:\Shared. This file is accessible to any user logged in to the computer and a shortcut to it is placed on the Public Desktop. What I meant by Accessed locally is that they don't access the file through a network...

We have a split database with an Access 2010 (runtime) front end and an SQL back end. The front end is accessed locally on several Windows 7 tablets that are shared across three shifts of users. We occasionally have trouble with our update process which is a batch file that overwrites the local...