Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Return to the record you were working on when you reopen an Access form
- If you get interrupted while working on a record in an Access form, finding your way back to it can be time-consuming. Here are two ways to bookmark the current record so that you can hop straight to it when you reopen the form. by Susan Harkins
- Tags: Microsoft Access, Command Button, Record, Form, varID, OrderID, vbOKOnly, Sub, Susan Sales Harkins, Databases, Microsoft Office, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware, Susan Harkins
- Blog posts 2008-08-28
- Quickly export Outlook e-mail items to Excel
- Exporting e-mail messages from Outlook to Excel is easier than you might think. This sample VBA code automates the process, allowing you to specify exactly which fields to copy. by Susan Harkins
- Tags: Outlook E-mail, Microsoft Outlook, Microsoft Excel, E-mail, Microsoft Office, Groupware, Office Suites, Software, Online Communications, Enterprise Software, Susan Harkins, MsgBox, Sample Code, Code, Error, vbOKOnly, Set, intColumnCounter, Susan Sales Harkins
- Blog posts 2008-10-20
- How to print multiple labels for a single record in Access
- Label printing is often more complex than generating a single label for each record. Users might need one label for multiple records or multiple labels for one record -- or something in between. Susan Harkins offers a VBA alternative that's more flexible than the Access wizard. by Susan Harkins
- Tags: Label, Microsoft Access, Report, Field, Code, Record, Form, Table, Susan Harkins, tblCustomerLabels, Design, Figure B, txtNumberOfLabels, vbOKOnly, LabelTotal, Listing C, Document Management, Programming Languages, Databases, Enterprise Software, Software, Finance, Managerial Accounting, Software Development, Software/Web Development, Data Management
- Blog posts 2009-02-02
Additional Resources
- Add a button to an Access form that tells you which version is running
- Users don't always know what version of Access they're using -- which can slow things down when you're helping troubleshoot a problem. Make it easy for them and for you by creating a convenient button that lets them know. If you support more than one...
- Tags: Microsoft Access, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2009-03-10
- How do I... Pass data over a network using disconnected recordsets?
- Retrieving data across a busy network can put a real cramp in your networking performance. Displaying the right data isn't enough -- you must display it promptly and on demand. Dragging only the data you actually need and only when you need it is the key to working efficiently across...
- Tags: Data Source, Microsoft Access, Network, Control, Change, Connection, Difference, Requirement, Form, Data, CustomerDisconnectedRS, Figure B Code, Databases, Microsoft Office, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware, Susan Harkins
- Blog posts 2008-01-17
- Ackowledge company policy at logon
- I need to have all of my user ackowledge the Computer policy at log on. I have never run a script of this sort and seet his question asked my many, but cannot view the answers? My user authenticate on a domain.AnswerOn your server...Open 'Active Directory Users & Computers'Right-click the...
- Tags: Error Resume Next, strDrive, strDomain, WinNT://
- Discussion threads 2008-11-19
- VBScript/HTA problem
- Due to space limitations I can't include the full HTA, but it only copies the user folder to c:doc and settings, no notes or fav's or desktop. Everything appears to work fine, I call the setup sub on a click event. All checkboxes are checked. It gives...
- Tags: ElseIf fromname.Value, JRod86, msgBox, Please Enter, programming, toFolder, toFolder2, true end, userName.Value
- Q&A 2005-08-10
- Two member-submitted scripts that automate network admin activities
- By Lee MasonTechRepublicrecently asked members to submit their favorite Network Administration scriptsfor possible publication. One of the first to make a submission was Lee Mason. For his effort, Lee earned $200and the satisfaction of seeing his scripts published on TechRepublic.Earn $100 for your admin scriptLet us payyou for your original...
- Tags: Â Â Â Â Â, Dim LocalService, Dim objComputer, Dim TimeOut, Guest Contributor, network, network administration, Nothing
- Technical articles 2005-12-21
- Using a system table to store application variables in Access
- In most Access applications, you maintain a set of system-wide variables in all of your forms and modules. Here's an easy way to make those variables available for editing by the end user.By Todd E. ParkerWhen you develop an Access application, you typically need to refer to a number of...
- Tags: Databases, Guest Contributor, SystemTbl, Error GoTo ErrorExit Dim txtName, Microsoft Access
- Technical articles 2000-05-15
- How do I... Print a label for an individual record in Microsoft Access?
- Printing labels is a common task and simple enough if you use the Microsoft Access Label wizard. You can print thousands of labels at one time. What isn't as easy is printing a label for a single record. You have to identify the record and pass it to a label...
- Tags: Database, Microsoft Access, Query, Report, Microsoft Corp., Record, Form, Printing Label, CustomerID, Productivity, Document Management, Databases, Microsoft Office, Storage, Enterprise Software, Software, Finance, Managerial Accounting, Data Management, Office Suites, Hardware, Susan Harkins
- Blog posts 2007-09-24
- How do I... Select records for a dynamic label report in Access?
- Generating reports is a big part of most database applications. Generally, a query or filter does a good job of passing only the data you want to see to the report. But it isn't always that easy. There might not be any apparent logic behind the records you want to...
- Tags: Database, Microsoft Access, Query, Report, Data, Field, Record, User, Downside, Form, Table, PrintLabel, Figure E, Storage, Productivity, Databases, Hardware, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2007-11-06
- How do I... Transfer Access data to an Outlook contact?
- How you use data often determines where you store it, which can create a bit of trouble down the line. For instance, you might store contact information in an Access database. If you want the same data available in Outlook, you could find yourself entering it again.Fortunately, such double entry...
- Tags: Folder, Solution, Microsoft Access, Contact, Sample Code, Data, Nz, Microsoft Outlook, Microsoft Office, Groupware, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2007-12-10
- How do I... Transfer data from a Word form to an Access database?
- Although Access forms are powerful interface objects, your users might not be familiar with them. In some cases, Access might not be installed on every users system, or you might prefer users not have access to your database. Here is how to use a Word form to...
- Tags: Technique, Microsoft Access, Sample Code, Data, Field, Difference, Form, Example Path, txtCompanyName, txtPhone, Figure G, Figure H, Microsoft Word, Word Processors, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-01-03
- How do I... Add items to an Access combo box on the fly?
- List controls in Microsoft Access, such as the combo box and list box, offer choices to the user. From their point of view, they don't have to enter anything -- they simply select an item. From the application developer's perspective, the database is protected from typos and other erroneous data....
- Tags: Box, Response, Solution, Microsoft Access, Item, Control, Property, Truth, Difference, List, Form, Table, NewData, acDataErrContinue, Limit, Yes, Iron, SQL Statement, Gold, Databases, Microsoft Office, Programming Languages, Enterprise Software, Software, Data Management, Office Suites, Software Development, Software/Web Development, Susan Harkins
- Blog posts 2008-02-07
- Microsoft Word "Template"
- I had a coworker ask me today if I knew how to make a template in Word. I said yes and he proceeded to tell me what he wanted it to do. Turns out he wants to have a template that will allow you to fill in a...
- Tags: Microsoft Corp., NAME:, InputBox, Please Enter, Microsoft Word
- Discussion threads 2008-02-19
- Help with macros?
- I have a workbook that is accessed by several users on ONE stand-alone computer. I need a way to track changes made on this book - basically the who, what, when, how it was changed. The sheets are hidden unless a valid username and password are entered on my "main"...
- Tags: Microsoft Office, xlSheetVisible Sheets, strPword
- Discussion threads 2008-04-14
- Having trouble with running this -
- I tried your code and it worked great as an exercise! However, when I tried to customize it a bit by adding additional fields, I get several error messages.Error 5941: The requested member of the collection does not exist.I've double-checked your codes against mine, and other than the additional fields...
- Tags: Chr, String Dim
- Discussion threads 2008-05-16
- Excel problem
- I have an excel spreadsheet, with about 50 colums of user data. On a second workbook, I made a small report form, that will contain the information from one of the 50 colums.I want to know how to automate having the form filled, with data from one of the fifty...
- Tags: Borg7of9, colum, Microsoft Excel, software
- Q&A 2005-09-07
- that feature
- that featurehas always annoyed the hell out of me...same goes for that start menu. when i first got xp at work it was kind of useful to group together 10+ my computer windows, although it still annoyed me after a while cos i was less inclined to close...
- Tags: taskbar, vbCR & vbCR Caption, group similar taskbar buttons, Bill_P, hardware, Microsoft Windows, Microsoft Windows XP, Caption, window
- Discussion threads 2006-05-25
- connecion of VB with Sql server 2000
- i don't know how o connec vb with sql server via code.send me the code. all are welcomeyou need to create a DSN. you can create DSN programatically too. Then Create a ADODB Connection object. and use Openmethod to setup the connection.create recordset object ans supply the query. you...
- Tags: Microsoft Visual Basic, DSN, cn.Dispose, Nothing GC.Collect, ADODB.Connection Dim strConnect, nizam8194@..., programming, strConnect, Nothing, Microsoft SQL Server, Microsoft SQL Server 2000
- Q&A 2006-07-09
- << Previous
- page 1 of 1
- Next >>
