Results 1 to 6 of 6

Thread: VB working in Microsoft Access

  1. #1
    Join Date
    Apr 2009
    Posts
    16

    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.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,949

    Re: VB working in Microsoft Access

    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.

  3. #3
    Join Date
    May 2008
    Posts
    2,015

    Re: VB working in Microsoft Access

    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 .

  4. #4
    Join Date
    Apr 2008
    Posts
    2,010

    Re: VB working in Microsoft Access

    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 .

  5. #5
    Join Date
    May 2008
    Posts
    2,302

    Re: VB working in Microsoft Access

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

  6. #6
    Join Date
    Nov 2005
    Posts
    1,323

    Re: VB working in Microsoft Access

    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.

Similar Threads

  1. Replies: 4
    Last Post: 28-08-2011, 11:02 AM
  2. Connectivity between the vb8 and microsoft access
    By Ekaparana in forum Software Development
    Replies: 3
    Last Post: 06-09-2010, 10:18 PM
  3. How to Use BETWEEN in Microsoft Access SQL?
    By shivendra in forum Software Development
    Replies: 4
    Last Post: 04-02-2010, 04:42 AM
  4. How to Use NULL in Microsoft Access?
    By Soumen in forum Software Development
    Replies: 4
    Last Post: 04-02-2010, 04:17 AM
  5. Error 429 while working on Microsoft Access
    By Bansi_WADIA in forum Windows Software
    Replies: 3
    Last Post: 11-11-2009, 08:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •