Lon-
What is the structure of the table and the SQL of your query?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lon
Sent: Friday, March 29, 2013 4:54 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Query not working properly
I have a 3,600 record database split into front and back ends. Users have
the front ends on their PCs. The database itself is in Access 2000 format on
a Windows 2003 server box.
I also have a Microsoft Word 2010 document with multiple fields linked to a
query in my database. To find the correct data to use in the Word document,
I used a filter based on an indexed code that is assigned to each customer
for which I want information.
Starting yesterday (March 28), any new customer entered in the database will
not show up in the Word document. If I change information in an customer's
record that existed prior to March 28, that information shows.
I finally have determined the query itself is at fault. If I run the query
itself with the new customer's ID code, the query won't find it.
I've never run into a query that quit working like this. Anyone have any
ideas? If you need more info to respond, ask away.
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar