ms access related question?

I presume by automatic you mean that for the main switchboard you have set up macros so that everything runs automatically. Apart from reports though, have you created subreports so that when you open one report (or even form and subforms) the contents of all tables can be seen at one glance so if it is a customer database, the main report or form would be customer details i.e. name, address etc. then one sub form/report would show orders placed,another invoices to them etc. etc.

How about creating pretty reports? Or a SQL Server? You can download MySQL (free) and create a database from it and then link your Access Database to it. That would make it look very impressive. Creating relationships for your tables makes it look more organized. Good luck on it.

i attempted to make a macro disable a administration on a sort I call Contacts. The administration replaced into named LastName. i replaced into waiting to do it in VB code: varieties![contacts]![LastName]. Enabled = fake Create a sort utilising the wizard. It lets you choose the table and makes it for you. you are able to then alter the product and you in many cases do would desire to alter it some way. the form heavily isn't sparkling, you are able to have controls appropriate to fields on the form with the intention to seek on those fields. Use a sort to go with the factors for the question. Unlinked controls that permit techniques from a itemizing, possibly in accordance with table archives. furnish a button that executes a question. go away the form working. interior the question's standards placed references to the form alongside with varieties![contacts]! [SelectedLastName] be conscious: areas extra in long names above to rigidity solutions to demonstrate the full call. SelectedLastName may be the call of the administration on the form 'contacts.' you additionally can want a button to close the form after the question is closed. yet another component you're able to do is placed bracketed names interior the question and purely run the question. it is going to on the spot for the archives, regardless of the undeniable fact that it could basically be person entered, no longer chosen from lists or table archives. i admire bracketed names like [enter date: (MM/DD/YYYY)] placed that bracketed call interior the critera component of a question and run the question.

uum create some records of the data...use fancy things in your forms like drop down boxes and sub forms ( forms within forms which show the data from another form in it - if that makes sense) you could do a mail merge if thats appropriate...can't think of anything else hope that helps :D