Other Form/Subform


Comments

Post a Comment

Popular posts from this blog

HOW TO OPEN ACCESS IN FULL SCREEN: OPENING A FORM AS MAXIMIZED ?

Image
https://accessdatabasetutorial.com/open-access-database-full-screen-opening-form-maximized/ Once users get a grip on form design techniques in  Microsoft Access database , they normally want to jump ahead and customize forms in their applications that appear polished and professional. One technique they can use is to  open Access in full screen  view which hides other no essential screens keeping your database neat and tidy. It requires a combination of setting various form properties during the design time mode and optionally (but ideally) applying either macros or VBA code  to the form’s module too. The final touches to this process would be to create a desktop icon shortcut to load the database file and run the assigned AutoExec macro to the application which will  open  Access Database  in full screen  hiding non-essential components. How To Open Access In Full Screen: Opening A Form As Maximized Create your form in design view...
Read more

Message Boxes

Image
http://www.functionx.com/vbaccess2010/topics/msgbox.htm A message box is a special dialog box used to display a piece of information to the user. As opposed to a regular form, the user cannot type anything on the message box. There are usually two kinds of message boxes you will create: one that simply displays information and one that expects the user to make a decision. A message box is created using the  MsgBox  function. Its syntax is: MsgBox([ Message ] [ Buttons ] [ Title ] [ HelpFile ] [ Context ]) The  MsgBox  function takes five arguments and only the first one is required: the  Message . The Message of a Message Box The  Message  argument is the string that the user will see displaying on the message box. As a string, you can display it in double quotes, like this "That's All Folks". Here is an example: Private Sub cmdMessageBox_Click() MsgBox "Your credentials have been checked." End Sub This would produce: ...
Read more

Export Access Object to Excel ,PDF, RTF , etc. using DoCmd.OutputTo

Microsoft Access allows us to export access object like table, query ,etc to other formats like Excel, PDF, RTF , etc. Using “DoCmd.OutputTo” To know about DoCmd.OutputTo visit the below link http://msdn.microsoft.com/en-us/library/aa141534(v=office.10).aspx Syntax DoCmd.outputto ObjectType, ObjectName, OutputFormat, Output file, Autostart, Templatefile, encoding, ObjectType – acOutputTable( to output table), acOutputquery(to output query),acoutputreport(to output report),ascendform(to output form), acOutputModule(to output module) ObjectName – Name of table, query, Report etc. OutputFormat – acFormatHTML ,acFormatRTF ,acFormatSNP,acFormatTXT ,acFormatXLS, acFormatXLSX , acFormatPDF , etc. Output file – Complete path of output file eg. C:\ abc.xls  or d:\ abc.pdf  Keep it blank if you want to save at run time. AutoStart Optional Variant Templatefile – The full name, including the path, of the file to use as a template for an HTML file Encoding- Optional Variant  ...
Read more