Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



VB working in Microsoft Access

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 31-01-2010
Member
 
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.

Reply With Quote
  #2  
Old 31-01-2010
Member
 
Join Date: Apr 2008
Posts: 1,947
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.
Reply With Quote
  #3  
Old 31-01-2010
Member
 
Join Date: May 2008
Posts: 2,007
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 .
Reply With Quote
  #4  
Old 31-01-2010
Member
 
Join Date: Apr 2008
Posts: 2,000
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 .
Reply With Quote
  #5  
Old 31-01-2010
Member
 
Join Date: May 2008
Posts: 2,290
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..
Reply With Quote
  #6  
Old 31-01-2010
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "VB working in Microsoft Access"
Thread Thread Starter Forum Replies Last Post
Microsoft Network Inspection System Has Stopped Working after updating Microsoft Security essential DYlAaN Networking & Security 4 28-08-2011 11:02 AM
Connectivity between the vb8 and microsoft access Ekaparana Software Development 3 06-09-2010 10:18 PM
How to Use BETWEEN in Microsoft Access SQL? shivendra Software Development 4 04-02-2010 04:42 AM
How to Use NULL in Microsoft Access? Soumen Software Development 4 04-02-2010 04:17 AM
Error 429 while working on Microsoft Access Bansi_WADIA Windows Software 3 11-11-2009 08:24 PM


All times are GMT +5.5. The time now is 04:02 PM.