Search results

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...

slkasulke, I have seen this issue when an sql query is requesting a table field that is not part of the table structure. cplmckenzie

moishy, A couple of initial questions. 1. tblTransations, if is a depositor Transaction Type = Credit if is a borrower Transaction Type = Debit against Loan Balance is the GuarantorID Similar to a CoSigner if so do you have a table to...

johnsonsimon, Yes on Client Form the Contact subform shows all contacts from tbl_AddContact, as it is based on the table. Therefore, when you Add A New Client ... then click Add New Contact you can continue adding (as many) contacts for that particular Client and each added contact is...

johnsonsimon, Bear in mind that no actual changes, except disabling the save record feature on the Client Form, as the record is automatically saved to the underlying table. Also, on the Client form without the record scroll buttons, the contacts subform exist already that form also, it is...

Jaymin, Can you post the form, subform and underlying code? cplmckenzie