Recent content by Timothy Andrepont

pr2-eugin, Thanks for the insight advice. It is helpful and seem to make since to me, a novice. Thanks. Timothy

pr2-eugin and JDraw, Thank you for looking into my simple issue. Eugin you are correct as far as the connection Query_11. I had caught that error somewhere along the way. One of JDraw's suggestions caused me to see this problem. Now for the good news. I could find nothing wrong with...

JDraw, Thanks for your help. I've looked at the query designs -- I get an error (data type mismatch) in Qry_11???? I've looked at the others and don't have an answer for you. I have correct the data mismatch and now the Qry_11??? has the 1:Many relationship as expected. The remaining 12 and...

JDraw, Thanks for you help. Let me try to give you a little history flow on this and the other databases. First the data base we are presently working on is full of non-working queries and reports. The current database was generated without any date reference. I am trying to re-doing...

JDraw, Thanks for your reply. A novice constructed these databases. I am barely more than a novice myself. These databases are not concerned with the business model. They are to be a starting point of tracking condition and ranking of capital assets. These databases score and textural comment...

JDraw, "What do the tables represent?" Each of the 13 numbered tables represent component condition. tblCatWeight carries component weighting factors. Let me know if you still need more clarity. Timothy

JDraw, I am getting ready to read through "Entity - Relationship" tutorial to verify I understand these relationships. Thanks for sending it to me. The underling business of this database is Condition Assessment of physical assets. This particular database is looking at all components...

I am in the process of cleaning up/normalizing databases that were built on the same system. The conversion database I am working with has little or no data in a few of the tables. I have come up with a simple challenge that has me stump. I have 13 data tables that are structured the same: Each...

Cronk, As I am optimizing the database-structure, may I ask another question? Table, tInspection, currently has two fields: Visit_ID and VisitNote. (Any other fields in this table will be removed.) I have so far made Visit_ID the Primary Key and it is a date field. All records in...

Cronk, Thanks for your learned wisdom. I plan this week to make the changes you suggested. Do you have any explanation for the relationships variance? 3. As I work to begin cleanup, I noticed that my numbered tables (01 through 13) do not all have the same relationship with the...

Cronk, 1. I seems the problem was generated by longer text field size in tAssets than in linked tables. The minute the field in tAssets was longer than text fields size than the linked tables the problem surfaced. I have made sure text field size were the same for linked fields. 2. "Is...

I have developed a Mainform with subforms. All is working except an auto-fill into a field that is not being recognized. I have attached a zipped fill with snap shots and the database. Can you explain where I went wrong placing commands? You help will be greatly appreciated. Timothy

Paul, Thanks Timothy

P, That is exactly what was wrong. Do you know the function of a field in that location is? Timothy

Paul, To recreate the problem, simply go to Reports: srpt02WS or any report between this 02 and 11. Thanks for looking into this for me. Timothy