Search results

Wayne: Thanks so much. I will try that. I don't understand it fully, but I will mock up a dummy DB and give it a try. Thanks again. Tom

All: Thanks for your replies. I apologize for not getting back on here right away, but I spent four days in the hospital after a "mini-stroke." It happened just a few hours after I posted the thread. Doc says I'm fine for now, but need to take anti-coag for a while. Weird weird experience, and...

I have been asked this question and do not know the answer. All help is appreciated!!! Can a choice on a dropdown cause fields in a form to become active/inactive? In the alternative, can a subform be automatically shown in a new window based on the choice in a dropdown? My client has to...

I have been asked if the following is possible and, if so, to implement it, but I have NO idea how to do it. Any help is GREATLY appreciated!! The database tracks various service activities for each client for each year. Each year has a start date (contract date) that can be anytime...

Doc_Man: Do you relaize that you are apologizing to me for not helping me fast enough?? Please... know that I am SO grateful for this help, regardless of when you take time from your schedule to give it. You are doing me a HUGE favor here, for which I will probably never be able to repay you...

Doc_Man: I tried to follow your instructions as well as I could, and I had a couple problems. The biggest one is that there are subtables related to the main data, and when I try to enter a new record in my main forms, choosing the SSN, it does not then enter the data into the new-related...

GREAT IDEA with the 'old data' flag. Just gotta get back to basics sometimes!! Thanks SO much! Tom

Guys: Thank you SO much! I will try these suggestions out on some practice data first... but I am pretty sure I get where it's headed. Thanks again! Tom

Dave: I am SO glad to pass that information along. I learned it right here on this forum myself!!! Good luck to you! Tom

RV: I think I understand the principle, but I'm not familiar with DCount. What is the syntax for that command? I am intrigued by the "*" portion. Thanks so much for the help!!! Tom

I have encountered a database that has an occasional duplication because existing customers are occasionally entered as new. Sales and Service activity on the new record's related tables needs to be moved to the original main record and the new erroneous one deleted. The customer records and...

Try this... and you'll see where it leads. Take any two tables related by a one-to-many relationship. Create a query that includes ONLY the related field from the "many" table and ALL of the "one" table's fields EXCEPT the related field. Run the query, and then make a valid entry into the...

Doc_Man: Couldn't a formula using "SerialDate" be used for this field? I have used it in the past... mostly because I don't know any VBA... well, only enough to destroy the thing!

Doc_Man: I cannot tell you how much I appreciate the thorough reply. I don't quite understand all of it, though, like the part where you said: "Now write a query that copies the autonumber field value from the parent table to the corresponding new field in each child table. Since the existing...

I have inherited a database that has a problem I do not know how to fix. The database holds the demographic information on individuals and has related tables with one-to-many relationships. The key field is the SSN. This has not created any problems until it was discovered that a couple of...

I have a client info table (name, address, etc.) with about 3,000 records. I have just been given a spreadsheet with about 100 new addresses for clients withing the database, which I successfully copied to a new table in Access and formatted all the field consistent with the main data table...

Any help here, folks? I really need to get this done. Any help is GREATLY APPRECIATED!!!!

Well, each year there will be new entries made into the fields. At the beginning of each contract year, the fields need to be blanked out after being given a final checkover. I am not sure if I know how to write a query to find data in a table that would be the "last entry of a certain type...

There are many threads on archiving... many of which involve VBA code and are beyond me. Many others address moving the data to another database, which is also not what I need to accomplish in my small application. I am tracking five customer annual service activities. Each year, these...

Paul: I think we need a little more info to help you. Tom