Recent content by cplmckenzie

johnsonsimone, the attached zip file contains the originial database, uploaded by you, before any modifications. Suggest you keep the original and the up to this point the Modified version, read through the post since May till Present to get back on track of process. I am currently...

Ok. Then let me know.

moishy, just touching bases with you. did you get around to running the last uploaded database? cplmckenzie

The first textbox Account Type allows you to Manually select what type of account this is. Pardon the addeum. I work in Emergency Management Services ... 911 responders where I live. Been a busy week. cplmckenzie

moishy, To began entering data Manually place the cursor in the GuarantorID textbox and click all this is updated automatically from the previously enter data. Then enter the other account data. cplmckenzie

moishy, pardon the delay. Been putting out life's little fires. You are already aware of the client - Guarantor function and what they do. Now run the Account Transactions functons by Starting with opening form UserBoard selecting the button for Accounts function and then Presently select...

moishy, Not really. Just want to be certain that the data that we are saving for tblAccounts is all that you want for each Client Account. cplmckenzie

moishy, Just posted some more mods to your database. In Particular, have made the "Create New Account" Functional enough to test and see if it will provide the info you want. Start by selecting "Get Customer" button. Once customer is selected click "update Account", the Form will be...

moishy, Yes, this only tracks accounts within the Foundation. cplmckenzie

themurph2000, if the smaller form that pops up is not a subform then try this. In the Form Open type... Me.searchidnumber.setfocus Where Me refers to the main object ... the small form. cplmckenzie

whohstall11, The attached zipped database is an application provided by Microsoft which provides numerouse Form example applications. Although written for Access 2003 I have successfully modified versions for use with 2007 and 2010. Once the application is installed, launch the .mdb and...

moishy, This is just a quick test of the table layouts (with modifications and additional tables added) that you provided. Forms have been created to permit the creating, adding and editting basic informations tables. MainForm --- User Board will open another form with 4 buttons. 1...

mosihy, Yes, there should be one MASTER table that has all persons basic contact info such as name, address, city, state, zip, phone#, etc. But tblAccountHolder could have more than 1 entry for "John Doe", depending on how many different account types he has. tblGuarantor will hold other...

mosihy, Yes, there should be one MASTER table that has all persons basic contact info such as name, address, city, state, zip, phone#, etc. But tblAccountHolder could have more than 1 entry for "John Doe", depending on how many different account types he has. tblGuarantor will hold other...

moishy, I am looking at the table data to be stored. Firstly, I will rename tblContact to tblGuarantor, so as to avoid confusion when access table data. You will need, at the very least..... tblAccountHolder ... the person that actually has the credit\debit account tblAccountsDebits...