Search results

I had this idea, just not sure how to make it work An unmatch query to determine if there are records in the ODBC table (source) that are not in the local. Use this to add to the local table. Problem is there is only one criteria available in the wizard and I would like to check against three...

Scratch that, there is not a data entry date in the data that I am working with.

Well, the records are not being updated by a form that I am able to edit (not access but another program). Our EMR is not editable by us (as far as forms). There is a data entry date for the records, I think, but that does not help if a record has been deleted (which happens occasionally)...

Why?: We have an electronic medical record. The problem is it does not meet all of our needs so we have to improvise. There is a dump daily from the record to an ODBC table. This is access via secure WAN (not an option, no matter how stupid it may seem). This is not a backup but our...

Reading that, I realized that I was kinda unclear. Let me clarify. First Databse: This is the source. Kept updated by various Users. Users add records, delete records, and update records to a table in this database Second Database This is the database I want to be updated based on the...

I have a database which has a table with Patient Information. Another database has a table with the same information, but this table is constantly updated by users. Records changed, records added, records removed. I want to update the first database based on the second. I believe that I can...

Much appreciated, I can definately see how this could be modifiedfor my needs. Thanks.

Ok. I'll keep looking and hope there are more replies

By list, I have a table, in which one field is the name.extension and another field is the path, so, concatenated, yes I have the full path. I just have no Idea how to do what you said below. I have been doing access programming for about 1.5 yrs, but it is all things that I learn in books or...

I have a table, in what I call my "catalog" database, with a list of access databases that we have at our facility. Is there a way with VBA to loop throught this list and determine if each database has linked tables or passthrough queries and then store these "links" as paths in another table...

Sorry to be dumb. If you could delineate how you figured out the embedding of the Word Doc in reports it would be very helpful. I want to do the same thing and have been unable to "figure it out myself" Cannot find any help either. btw I know that you can "search the forum". I have and am...

Most people only input data. They do not mess with structure or anything that I think would throw a wrench in what I'm doing. I am currently the only "Access guy" at our facility, so I "think" I will be ok on this. I understand that there is a lot of footwork here. Some of the things output...

Yes in the US How do I Know? Doing a *.mdb and *.accdb search with FileLocator Pro brings up 435 databases. Around 100 are in a "Trash" folder I set up for databases I know are not in use and won't affect any others. The rest are spread around our server. What Versions Involved? 2003...

I work for a state government agency. This is an inherited mess. It is a problem of multiple people over many years overseeing with no oversight. I'm tasked with cleaning up the mess, Moving all into a central location (they are spread among many different folders), removing redundant...

We have 200+ databases that interlink. I want to catalogue how they interlink so that when I begin to move them, I can make corrections in the databases that are gonna break becuase they can't find the database I moved.

I have been tasked with cataloging our databases at my place of employement and then moving them into a centralized location. There are over 300 databases and they are interlinked. If I move one, it breaks many. Is there an easy way to begin cataloging the interlinking of these databases. Can I...