Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Brush up on option statements in VB.NET
- Needs More DetailIt would be nice if you filled in some detailed examples of what each option statement will do. For example, the code:for x = 1 to 100 'do somethingnextwould be ok if option is off, otherwhise you would need to do:dim x
- Discussion threads 2006-11-10
- Brush up on option statements in VB.NET
- In this tip, Irina Medvinskaya looks at the three option statements that are supported in VB.NET: Option Explicit, Option Compare, and Option Strict. If you want to properly utilize VB.NET, it is very important to understand option statements. The following is a quick overview of the three ...
- Technical articles 2006-11-09
Additional Resources
- Creating Access VBA subs and functions: Using arguments and public variables
- To unleash the power of VBA in your Access applications, take this lesson in passing arguments to these subroutines or functions.By Todd E. ParkerIf you have started to discover the power of Microsoft Visual Basic for Applications VBA in your Access applications, I’d like to help you bump your game...
- Technical articles 2000-05-29
- Robust SQL Server Compare 1.2.1 (Windows)
- Compare two sql server databases on any local or remote servers. Has the ability to filter on any phrase in the stored procedures, views, tables or functions. You can choose to show all objects or just ones that are not equal. You also have the option to ignore comments and...
- Software downloads 2006-09-19
- MicroSoft Access - Is there a place for public variables and functions?
- Hi,I am confused as where the public variables and functions should reside within Access 2007. Here's my problem:Using an example about this subject matter posted by a TechRepublic guru, I created a form with two unbound fields named MyInteger and ResultInteger respectively. There is also a push button...
- Discussion threads 2008-02-26
- Compare workbook data side-by-side with Excel 2003
- open two different .xls filesMake sure you have two different .xls files open, then try it.Helpful Feature, but....Comparing two different workbooks is very helpful, particularly with the scrolling feature... now can someone explain how to compare two or more sheets within the same workbook? I find a need for this...
- Discussion threads 2006-08-23
- Compare records in 2 tables and move data from one table to the other
- I have two tables with 3 columns in common: FirstName, LastName, Department. Table A Access table has additional columns (RecordID, Address, Phone, etc. This table is missing data in the some of the records in the Department field.Table B an Excel spreadsheet is missing no data in any...
- Discussion threads 2005-08-11
- Tech Tip: AutoFormat Word dashes/Compare Excel text values/Publish an Access report
- Word: AutoFormat dashesYou don't have to memorize complicated shortcutkeys to insert dashes into your documents. Word's AutoCorrectfeature lets you insert them by typing one or two hyphens. First,activate the feature in AutoCorrect by following these steps: In Word 2002, go to Tools | AutoCorrect Options (or AutoCorrect...
- Technical articles 2003-12-08
- Compare two sets of Excel chart data using transparent columns
- Only works for Bar Charts?I have done this in the past, and have come to the conclusion that the ability to make charts transparent ONLY works with bar charts. I have tried to make any other type of charttransparent(i.e. pie chart, area chart) and have had no luck. ...
- Discussion threads 2007-08-22
- Using Activex control inet
- I have written an MS access module that uses the inet activex control to ftp a file from one of our mainframes to a pc.The file is a consecutive file with a record lenght of 350 chars. If I use ftp through the dos prompt the file downloads fine....
- Q&A 2005-07-26
- Displaying file properties from within VB6
- over my headI liked the concept, but the description was far too deep into geekspeak for it to be usable for me. I don't do heavy programming in VB6, just complex macro work in XL. Would've needed to hold my hand, explaining each piece of the coding, for this to...
- Discussion threads 2005-08-19
- Access 2003 Forms
- I copied the "Employee's" form and table along with all the modules and code from the Northwind Database into a test database. Everything seems to work ok, until I select the jpeg from my folder. Once I select "open" I get the following error. "run-time error '2135': This property is...
- Discussion threads 2008-01-23
- Option Profit Calculator 2.1.0 (Windows)
- Easily compare stock or option transactions for various time periods and various investments. Input transaction information such as purchase and sale or execution dates, prices. Gives actual profit from the transaction and the potential loss. Also gives annualized profit, in dollars and as percentage of your investment, and annualized potential...
- Software downloads 2009-02-23
- having problems when logging on
- i am getting a "method connetion of object_ current project failed" on the following liners.Open str_sel, CurrentProject.Connection, adOpenKeyset, adLockOptimistic when i want to logon to an Acces database. this is happening on some XP and Access 2003 and running on other machines. HAve installed Mdac2.8 but its not working.Below is...
- Discussion threads 2007-04-17
- MSAccess Refresh Active record
- Hello all. I would like to ask if anyone knows how i can refresh my form without the focus being changed to the first record, essentially refreshing the form and subform while keeping my cirrent record as the active record.I am entering data into a form, I have a command...
- Discussion threads 2007-07-17
- Ideas abound for the option of MCSE continuing ed
- Should Microsoft consider a continuing education approach to certification? Some 166 of you said yes, but two said no. Check out TechRepublic member feedback on the issue in this week's IT Certification Corner.It’s unanimous. Well, almost. Out of 168 e-mails responding to my column suggesting that a continuing education model...
- Technical articles 2001-06-22
- Decision Support: Which option is best for Remote administration for Windows?
- Bone up on two popular remote administration packages Virtual Network Computing and pcAnywhereOne fact of life for every server administrator is remote administration. For UNIX and NetWare users, this task is properly built into the operating system and generally provides all of the functionality required to administer the server. For...
- Technical articles 2001-09-24
- MS Access Compare Two Tables & Find (Combine, Join) Differences Software 7.0 (Windows)
- Find content differences between two tables in a MS Access database. Furthermore, you have the option to create a new table based on the differences of your choosing. Thus, you can selectively merge two tables together.
- Software downloads 2006-11-11
- Data field loses focus using AcroPDF in Access 2003
- Hello,I use the following VBA code to pick up PDF's from a folder and show it in an Access form.code:--------Option Compare DatabasePublic strImageFile As StringPrivate Function GetImageFolder As String Dim DBFullPath As String Dim I As Integer ...
- Discussion threads 2008-05-31
- Access Form error: Update or cancelupdate without addnew or edit
- THE SETUP: I have an Access form with several bound controls, a sub-form, a bound text box txtRMANum for an RMA#, and one unbound combo box cboRMAnum for record navigation. The combo box is populated with an index and RMA# from each record in the table. When the user edits...
- Discussion threads 2009-03-19
- << Previous
- page 1 of 1
- Next >>
