Chennai VBA

RSS Feed Homepage

MS Access Database Limitations
2008-02-15 13:35:00
MS Access Database Limitations:o Access database can be up to 2 GB in size.o Access database doesn?t support more than 255 fields in a table. Only 255 fields are allowed in a table.o Only 32 Index es are allowed per table. (Indexes:- for retrieving or filtering the records faster)o Only 10 fields are allowed in multiple field indexes and sum of fields length should not exceed 255 Byteso No limitation on the number of records in a table.o A memo field can store up to 1 GB of characters.o It can?t display a Memo larger than 64 KB in a form or datasheet.o An ActiveX objects can be up to 2 GB in size.o A row of the table should be lesser than 4 KB of size (exception for ActiveX and memo fields).Above limitation is appliable to MS Access 2003 database.I have gathered this information from various sources, hope this will be knowledgable for you.
More About: Fields

MY Lot Verification
2008-02-15 07:06:00
MY Lot Verification myLot User ProfileThis post is for my purpose, after verification from mylot, i will delete this post

Indexes in MS Access
2008-02-13 10:47:00
Hello Everybody,This article is just to give an idea about indexes in MS Access database.Index es in MS AccessWhy we need Indexing? Indexes in any database (MS Access, Sql server, Oracle) are most important thing to deal with. Especially more the data in the tables of our database, it?s hard for DB to search or refine (filter) the data?s. To overcome this there is some thing called Indexing in the database. Indexes of fields in the table, will able to find data?s in those fields very quickly. Index can drastically increase the performance of DB application. Indexing here is similar to indexing of book contents. How to create an Index in MS Access? For creating an index on a field, first you need to open a table (not linked table) in design view. Select the field that you want to create an index. Then go to ?General? tab, there you will find the ?Indexed? property. Select the property value as ?Yes (Duplicates OK)? or ?Yes (No Duplicates)?. ?No? value means no indexing. By changing th...
More About: Fields

Clock in Scatter Chart
2008-02-13 06:12:00
Hello Everybody,Clock (without using Timer) created in Scatter chart (Excel Chart ), yeah its true. I got inspired from the work ?Fireworks in Scatter chart? done by Excel MVP ?Andy Pope? (Chart Genius).I have used the same logic to create clock in scatter chart, that I was used in ?JAVA? language Clock in Java Applet?. Here I have used sine and cosine function to draw the outline for the chart, which is based on radius value in the sheet ?Scatter Clock? (in the Attached file).Please download the file ?Download Scatter Chart? here.Based on X and Y series, i have acheived the thing here.If any queries, please free to mail me or add comment to this post.Thanks & Regards,Karthick

My First VBA tips
2008-02-08 07:36:00
Hello VBA developer,From now onwards, am going to post topics (tips) related to VBA (Access & Excel ).Before that, am greatfully thankful to my Boss Naresh Nichani (Access MVP) and Virtual Boss Brian Reilly(Power Point MVP), who are giving more oppotunities to learn, develope and design the stuffs in VBA (Excel and Access).Here is my first Tip in Excel.Without using the conditional formatting, we can customize the format (Font Color), based on cell value (applicable to number)[Red]"Export";[Blue]"Import";[Blac k]"Balance"First Copy the above line (in brown color) and then right click any one of the cell in excel sheet (where do u need to format),Select "Format Cells" --> "Number" tab --> Click "Custom" --> paste it in "Type " text box.For Eg:Lets assume, you assigned the above custom format in cell "A2",Then if Cell value is + ve then Export text will be displayedis - ve then Import text will be displayedis 0 then Balance text will be displayedHope you understand that, If any quer...
More About: Tips