Recent content by Jennerizer7

Estuardo, What tables do you feel are missing or what is it that you possibly don't understand? Also, was just playing around with DB7.zip that you attached. How is it that you can add a new business record w/o entering in the table. If I try in the frmBuss, it gives me a VB error...invalid use...

I suppose I should rename lastContact as LastLetterSent perhaps. I know that the user is going to want to have a query to pull when the last letter was sent to the customer/business. I have attached the original form he wanted to use as data entry and have given a little more explanation. I...

Not sure if this looks a little better than the last DB I uploaded. Still not sure exactly how to create that form that the user wants to enter the data in. For now I am skipping the ODBC as our vendor hasn't given us the table that I would link to. Disregard the table called...

Jack Henry is our outside vendor that pretty much takes care of most things w/ the iSeries. We don't do much in house w/ this except data entry, running a few queries etc, ..everything else is pretty much outsourced. In any event the person that wants the DB showed me a screen from the iSeries...

Not sure if anyone is familiar w/ Jack Henry/as400/iSeries, but that is what we use as our "core" system here. It has all the info that is needed to correspond w/ the database. There is a screen for instance that has all the people related to the business and it also has the tax info..for...

Participation loans are only dealing w/ businesses.

Estuardo, Not every business will have Participation (it relates to loans). If there is no participation loan, then there will be no lead bank info necessary. If participation is marked Yes, then we would ask if we are the Lead bank. If we are the lead bank, then nothing else needs to be done...

Thanks Estuardo for your suggestions! Do you think I should make a table, say tblFinancials containing the Tax Return/Financials and the dates in it? Do you think it would be safe to put the Participation/Lead info in the company table or would you suggest creating a separate table for that...

Outside of a class 14 yrs ago, I haven't touched DB setup/design. We never started from scratch either. I was asked to create one for work and I have an insane deadline. Was hoping for a refresher course but not enough time for that. I am posting an attachment. The attachment is a form the end...

Hi all from the US! I took one Access class over 13 yrs ago and haven't seen it or touched it since. Work now wants some DB's created and I'm at a loss. Hobbies/activities? Love writing, snowmobiling, bowling, playing pool, etc. Love listening to most kinds of music, watching movies, hiking...