INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

FAQ Index

Access 2007

FAQ Title Author Date Rating/#
Where have the "more" controls in the toolbar gone?   faq702-7193 genomon 28 May 09 9.0 / 1
 

Access 2010

FAQ Title Author Date Rating/#
How do I add images with transparencies to button controls   faq702-7541 1DMF 1 Feb 12 2.0 / 2
 

Calendars

FAQ Title Author Date Rating/#
Calendar using dynamic form   faq702-4601 gol4 17 Dec 03 3.9 / 8
Create your own calendar   faq702-838 gol4 27 Jul 02 8.2 / 37
Keep getting Error 2501?   faq702-2638 Andino 25 Oct 02 8.3 / 8
Pop-Up date retrieval calendar  faq702-639 jimmythegeek 17 Oct 06 7.8 / 34
Simple Calendar for entering data  faq702-640 jimmythegeek 17 Oct 06 6.1 / 16
 

Combo Boxes

FAQ Title Author Date Rating/#
Combo Box - dependant on another Combo Box   faq702-4289 KenReay 10 Oct 03 6.4 / 33
Combobox - Add New Item to List   faq702-4283 KenReay 9 Oct 03 6.0 / 24
Comboboxes - Using Multiple Columns   faq702-4284 KenReay 9 Oct 03 8.1 / 8
Find As Your Type Combobox  faq702-6304 MajP 15 Apr 15 9.5 / 6
Five Ways to Move to a Record in a Subform based on a Selection in a Combo Box  faq702-4933 Vie 11 Mar 04 7.0 / 6
GLOBAL Not In List Event Handler  faq702-5205 TheAceMan1 7 Nov 04 7.2 / 5
How do I add an <All> selection to my combo box drop-down?  faq702-4538 Eupher 19 Jun 06 7.9 / 10
How Do I Set Up Find As You Type In A Combo Box?   faq702-6295 tomh1 11 May 06 8.5 / 4
How to use Combo box as a Navigation tool   faq702-4398 KenReay 6 Nov 03 5.8 / 8
Multiple linked combos - each dependant on each other.   faq702-4640 Darrylles 28 Dec 03 5.4 / 7
 

Data Access Pages

FAQ Title Author Date Rating/#
How do I make a Find box in a DAP?   faq702-3032 SMerrill 15 Jan 03 4.8 / 4
 

Data Loss

FAQ Title Author Date Rating/#
Loosing data from MS Access. If you enter data & 2 hours later it is gone   faq702-7122 assets 11 Jan 09 --
 

Emailing From Access

FAQ Title Author Date Rating/#
Emailing from Access using Docmd.SendObject   faq702-4509 nat1967 27 Nov 03 7.8 / 13
Emailing using CDO   faq702-6504 hwkranger 9 Jan 07 5.5 / 2
How to Email From Access using Outlook   faq702-2921 nat1967 27 Nov 03 7.0 / 37
 

Form Basics

FAQ Title Author Date Rating/#
Add Current Date with a Button   faq702-1811 Garridon 5 Nov 02 7.8 / 17
Are there shortcuts to designing forms??? You betcha!   faq702-1743 WildHare 6 Apr 02 8.3 / 32
Better Looking Forms   faq702-1397 Garridon 25 Jun 03 8.0 / 77
Check only one checkbox in a subform   faq702-5159 enuf4u 24 May 04 6.0 / 1
Compile errors in forms   faq702-4457 davem1958 19 Nov 03 10.0 / 3
Edit Button   faq702-3756 Kherozen 20 Jun 03 8.0 / 4
Filter a report from a form button with no query   faq702-3431 guitardave78 14 Apr 03 10.0 / 1
Form - looping thru the controls  faq702-5010 RoyVidar 12 Aug 04 8.3 / 28
Format a continuous form (an alternative)   faq702-2382 gol4 13 Sep 02 6.6 / 5
How do I filter combobox based on other combobox/control value  faq702-3924 Hasu 4 May 05 4.3 / 3
How do I Sync a Main by clicking a record on a subform  faq702-410 DougP 12 Jan 01 4.1 / 11
How to change form properties w/o saving changes.   faq702-4389 Mabjro 8 Nov 03 6.0 / 1
How To Check If A Form Is Loaded - The Right Way   faq702-7362 Emtucifor 2 Jul 10 9.0 / 1
How To Check If A Form Is Loaded?   faq702-5318 Schof 21 Jul 04 7.0 / 3
How to create your own Navigation without error messages   faq702-4655 adamroof 2 Jan 04 9.3 / 3
How to have a button appear on form only when other form NOT open  faq702-5443 assets 27 Sep 04 8.0 / 1
How to open new form to same record as old form   faq702-2006 chdavisjr 9 Jul 02 5.5 / 6
Icon on forms A2K/AXP(A97)  faq702-5429 hermanlaksko 27 Mar 06 --
Moving Between Main Form and Subform with TAB or Enter Keys   faq702-1064 tlbroadbent 30 Aug 01 7.1 / 14
Solve Slow Form Loading Issues   faq702-4401 Alabaster 6 Nov 03 7.9 / 10
Suppress Property Sheet in Form View   faq702-5924 Walkinman17 17 Jun 05 10.0 / 1
Tip Text not working on Button   faq702-6494 assets 21 Dec 06 --
Update or CancelUpdate without AddNew or Edit  faq702-7501 hermanlaksko 11 Jul 11 --
Using Hyperlinks Instead of Buttons   faq702-2618 Garridon 23 Oct 02 6.9 / 7
 

General Information

FAQ Title Author Date Rating/#
Call Proc (By Value / By Reference)?  faq702-5309 CajunCenturion 16 Jul 04 8.8 / 5
Finding FileName in FilePath   faq702-6898 MikeC14081972 17 Mar 08 --
General sites with sample database's   faq702-6907 nim180 31 Mar 08 8.0 / 1
Use of Autonumber   faq702-5106 mph1 5 May 04 5.0 / 14
 

How to

FAQ Title Author Date Rating/#
Capitalize first letter in sentences in a string  faq702-6510 TheAceMan1 18 Jan 07 10.0 / 1
Carry a value forward to the next record   faq702-4852 Terpsfan 16 Feb 04 6.3 / 8
Code a form with combo boxes to report queried data   faq702-5598 ChewDinCompSci 4 Jan 05 5.0 / 2
Create a Custom Auto Tab feature to speed data entry   faq702-2099 SBendBuckeye 28 Jun 02 2.3 / 4
Create a tool box that lets user enter special characters   faq702-4943 randysmid 15 Mar 04 --
Create Large Check Boxes   faq702-2255 SgtJarrow 30 Jul 02 7.6 / 13
Custom Command Buttons   faq702-5307 Beard36 14 Jul 04 10.0 / 1
Export data to an Excel form   faq702-7171 NXMold 24 Apr 09 --
Find the working days between Dates   faq702-4851 Rolliee 16 Feb 04 2.0 / 2
How and why to code Access Reports   faq702-2727 munger 7 Nov 02 4.8 / 5
How can I find the days/months/years between two dates   faq702-3928 Rolliee 23 Jul 03 9.5 / 2
How do I get minimum and maximum vlaues   faq702-2333 thornmastr 16 Aug 02 10.0 / 2
How do I get the name of the user logged into the PC ?   faq702-4949 chris153 16 Mar 04 7.8 / 4
How do I set a control in a subform from the main form (and vice versa)?   faq702-2206 raymondo 22 Jul 02 8.4 / 14
How do I update a main form record counter while adding records in a subform   faq702-2584 SBendBuckeye 15 Oct 02 4.8 / 5
How to create a flexible report selection form in Microsoft Access   faq702-3619 jrbarnett 22 May 03 6.3 / 9
How to create large Checkboxes, a second method   faq702-6075 jedel 17 Oct 05 --
How to find run-time values   faq702-3969 Rolliee 20 Aug 03 1.0 / 1
How to Protect a Database with your own Security  faq702-5856 assets 9 May 05 7.0 / 1
How to Remove the Popup Message box when running Action Queries   faq702-4855 mgolla 17 Feb 04 5.5 / 2
How to retrieve the logged on username   faq702-5026 allsoapers 7 Apr 04 7.9 / 10
How to split a DataBase and relink tables.   faq702-3747 pavewayammo 18 Jun 03 7.2 / 5
How to work around the ROUNDing "problem" in Access ?   faq702-4019 Scanman999 12 Aug 03 2.5 / 2
KISS way to force users to click a command button to exit a form regardless of menu or toolbar options   faq702-2071 SBendBuckeye 22 Jun 02 9.5 / 19
One way of Locking Records in a Multi-User Scenario   faq702-3571 Ogart 12 May 03 4.9 / 11
Opening a Word Document and filling it with data from an Access Form   faq702-2379 grtammi 26 Aug 02 8.8 / 21
Print Reports Using Option Group   faq702-2028 Garridon 27 Jun 02 9.7 / 3
Print table and field names into Immediate window   faq702-2856 randysmid 24 Mar 03 6.0 / 2
Quick and Easy way to Create a Custom Auto Tab feature to speed data entry   faq702-2144 SBendBuckeye 6 Jul 02 5.0 / 2
Search/Filter Form DB Sample   faq702-3702 jfgambit 11 Jul 03 8.2 / 11
Set Colors in Forms and Reports   faq702-2711 randysmid 6 Nov 02 6.3 / 9
 

List Boxes

FAQ Title Author Date Rating/#
Filter using a textbox and display results in a listbox.   faq702-6917 nim180 17 Apr 08 --
How can I format my ListBox?   faq702-5329 SiJP 27 Jul 04 6.8 / 6
Move Items From One Listbox to Another Listbox  faq702-6326 MajP 17 May 08 7.3 / 3
Working with List Boxes   faq702-4750 TheAceMan1 23 Jan 04 5.7 / 6
 

ListView & Access

FAQ Title Author Date Rating/#
ListView & Microsoft Access - Part 1 - (Load Data)  faq702-6025 ZmrAbdulla 12 Aug 05 7.4 / 12
ListView & Microsoft Access - Part 2 (Master-Sub & Column total)  faq702-6026 ZmrAbdulla 21 Jan 06 9.0 / 1
ListView & Microsoft Access - Part 3 - (Conditional Formatting)  faq702-6027 ZmrAbdulla 14 Aug 05 5.3 / 4
 

Mega Search

FAQ Title Author Date Rating/#
Power Search Simply   faq702-2039 leobaby 15 Jun 02 6.4 / 15
Search multiple fields simultaneously and set form to record found  faq702-1177 DougP 12 Apr 07 7.1 / 20
 

Office 2003

FAQ Title Author Date Rating/#
Error in registry for extension "Exchange Extensions;?"   faq702-6264 Snug 24 Mar 06 --
 

Running Sum In Forms

FAQ Title Author Date Rating/#
How to get a Running Sum In Forms  faq702-5248 TheAceMan1 28 Mar 11 6.1 / 7
 

Security Permissions

FAQ Title Author Date Rating/#
Control Closing Of Form Or Database  faq702-1870 SgtJarrow 27 Jun 02 8.3 / 20
Trap Permissions Error   faq702-1595 Garridon 6 Mar 02 7.0 / 1
 

Troubleshooting

FAQ Title Author Date Rating/#
"object or class does not support the set of events" error on form events in Access 2007 and likely other versions as well  faq702-7765 MacroScope 18 Feb 15 2.0 / 1
Having Trouble Getting Your Events to Work At All?   faq702-1443 Sameal 11 Jan 02 6.6 / 12
How can i improve the performance of comboboxes,listboxes and subforms ?   faq702-5513 Chance1234 9 Nov 04 --
Making User-Friendly Applications   faq702-1631 WildHare 13 Mar 02 8.5 / 43
Option Group Disabled   faq702-4121 Garridon 5 Sep 03 --
Path/File Access Error during Setup   faq702-2957 Magellan 31 Dec 02 10.0 / 1
Strange or undocumented error message???   faq702-2877 randysmid 12 Dec 02 4.0 / 1
 

User Interface Techniques

FAQ Title Author Date Rating/#
Continuous Form / Combobox Filter   faq702-3679 redapples 3 Jun 03 6.0 / 3
How Can I completely hide Access so only my forms are visible   faq702-5449 Chance1234 29 Sep 04 8.4 / 8
How can I create a record navigation pick list on a form   faq702-3765 RickSpr 22 Jun 03 7.8 / 4
How can I provide a form to let users change their passwords?   faq702-4282 RickSpr 14 Oct 03 9.8 / 8
How do I create WinXp style Password Characters?   faq702-3904 nexcar 21 Jul 03 6.3 / 4
How do I let the user create a dynamic filter for my form?   faq702-777 jflachman 31 May 01 7.6 / 11
How do I limit the contents of one combo box based on the selection in another?   faq702-681 RickSpr 25 Apr 01 8.2 / 82
How do I select items using dual list boxes?   faq702-4246 RickSpr 2 Oct 03 9.7 / 6
How to insert text into a textbox at the current cursor location  faq702-3157 HFloyd 8 May 06 --
How to prevent users from leaving current record by scrolling the Mouse Wheel  faq702-5263 jollygood 4 Oct 04 8.0 / 12
How to run queries through forms?   faq702-1251 Kckronic21 7 Nov 01 6.3 / 22
How to Synchronize Forms . . . Your Way!  faq702-5860 TheAceMan1 8 Jun 05 7.2 / 9
Simulating a Control Array   faq702-6904 MajP 29 Mar 08 --
Slow opening form?   faq702-3742 pavewayammo 18 Jun 03 7.2 / 15
Text to Speech   faq702-6737 ProgramError 25 Sep 07 --
 

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close