VB working in Microsoft Access

Access is fascinating. It is both simple and complex. It is simple compared to powerful management programs databases like SQL Server or Oracle, but it becomes complex when compared to Word and Excel. I am not so much advance in Microsoft Access usage and implementation but I do need to work on this everyday. what about runtime support in access. And can I get a pdf file in Access. Also does anyone has worked with HTML on Access. How to make table Invisible. And the last thing how get used to VB.

You can develop an Access 2007 application, and install it on as many PCs as you want for free. To do this, you have Access 2007 on your PC and download the add-Access RunTime (57Mo). Access 2007 can now export to PDF. No need to buy Acrobat Distiller. To do this, visit this page from Microsoft, download and run the add. Once that is done, when you are in a database, you now have in the Ribbon "External Data" icon "PDF "which lets you create PDFs from any Access object.

Access 2007: You can now define memo fields in HTML (Property "Format Text": "Rich Text"). However, if you set the color, bold, etc.. in such field, it will go very well, including when to copy and paste to Word or Excel. By cons, if you export to "Text File", HTML tags will be visible. To avoid this, you create a query based on the table to export, and instead of putting the field "Note" (Who is a memo field HTML) you put: Expr1: PlainText .

Yes it is right that you can get the tables in HTML too. Suppose a table with 1000 records, but when entering data, there have been cancellations, of factoring. In short, the AutoNumber This table has holes. The last record (just one thousandth) is for example the number 1000.Access simply refuse to perform this trick, first Delete the AutoNumber field of the table and then Recreate .

You can, of course, click the right button of your mouse on the table in question and choose Properties, check "Hidden". But another interesting technique is to simply rename your table, starting with USYS. The table will be invisible but very real. To make them reappear, it will go to the menu Tools / Options, View tab, check "System Objects". So if you've opted for the first technique (right button / properties / Hidden) is "hidden objects" that will check. This prefix USYS works only with tables, not queries, forms, etc..

A good way to learn Visual Basic for Access 2007: Create a macro that contains some actions, and how to write the same thing in Visual Basic, close the macro, save it and select it by clicking once it (unopened). On the Ribbon, click on "Tools Database," and the "Macro", click "Convert Macros to Visual Basic. The macro or macro group where you will be transformed into VBA functions.