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

Microsoft: Access Other topics FAQ Index

FAQ Index

Using Tek-Tips

FAQ Title Author Date Rating/#
How can I maximize my chances of getting an answer?   faq181-2886 RickSpr 15 Dec 02 7.7 / 79
 

Choosing the Correct Forum

FAQ Title Author Date Rating/#
Make the Switchboard Title = the Swithcboard Caption   faq181-2720 RobPotts 7 Nov 02 4.6 / 5
Transaction Log for Ms. Access  faq181-291 MichaelRed 26 Nov 02 8.8 / 23
Which Access forum should I choose for my question? Why?   faq181-1655 tlbroadbent 28 Feb 03 8.7 / 33
 

1. ASCII Table

FAQ Title Author Date Rating/#
ASCII Characters   faq181-3632 Bullschmidt 23 Jun 03 8.0 / 2
How do I hide the database window in Access XP?   faq181-1309 jgoodman00 30 Nov 01 6.0 / 12
Where can I find all of the ASCII characters  faq181-330 DougP 12 Dec 00 7.2 / 10
Why do I get "Error?" with a Report TextBox Control Source That's Correct  faq181-340 Quehay 16 Dec 00 6.3 / 3
 

97 and 2000

FAQ Title Author Date Rating/#
How to Install Access 97 and Access 2000 on the Same Computer?   faq181-496 troyu 16 Feb 01 5.9 / 9
Link Outlook '97 and Access '97   faq181-642 DougP 11 Apr 01 5.0 / 2
Mixing Access 2000 and Æ97 (work around)   faq181-1152 DougP 10 Oct 01 6.4 / 13
Runtime Error with MS Access 2000 Runtime not with Full Version   faq181-868 Petercl 27 Jun 01 8.3 / 3
 

A scrolling text box

FAQ Title Author Date Rating/#
How do I make text scroll like a marquee  faq181-86 gol4 14 Jun 04 7.9 / 40
 

Access & Word

FAQ Title Author Date Rating/#
Alternative Mailmerge In Word Using Access Database That Does Not Use Words Mailmerge.  faq181-453 mdav2 5 Feb 01 1.0 / 1
 

Access 101

FAQ Title Author Date Rating/#
4 main components of Access =Table, Query, Form, Report  faq181-79 DougP 14 Jun 00 6.0 / 20
Create Custom Desktop Icon for different Macros   faq181-1154 DougP 10 Oct 01 8.0 / 4
Error Message "Too many fields defined"  faq181-114 rhicks 6 Jul 00 8.4 / 7
How do I make an .MDE file  faq181-90 DougP 23 Mar 02 8.5 / 22
How Do I Speed My Database Up...?   faq181-4947 Harlequin007 16 Mar 04 3.5 / 4
How to use the Status bar to your advantage.   faq181-1851 RemyS 30 Apr 02 8.3 / 12
More than 255 characters of text in a field?   faq181-903 simmerdown 11 Jul 01 7.7 / 18
Null Values and How Access/Jet deals with them.   faq181-3884 jrbarnett 12 Jul 03 7.5 / 8
Receiving "Errors" when using common functions in Access 97  faq181-107 rhicks 5 Jul 00 7.4 / 7
syntax for subforms ....  faq181-447 Psychpt 1 Feb 01 8.6 / 9
Troubleshooting is the key to being a good Programmer  faq181-338 DougP 23 Mar 02 7.9 / 22
What is an .MDE and why do I need it?  faq181-91 DougP 24 Jun 00 8.2 / 32
 

Access 2010

FAQ Title Author Date Rating/#
How do I hide the database application background shell so only my forms are displayed  faq181-7522 1DMF 3 Jan 12 6.7 / 3
 

Access Howto:

FAQ Title Author Date Rating/#
Activity Monitor - Have you ever needed to view what form(s)/report(s) a user currently has open?  faq181-5070 AJParkinson 2 Jun 04 10.0 / 1
Animation In Access - Using animated GIF's  faq181-108 rhicks 6 Jul 00 9.0 / 31
Automatically logging out idle users   faq181-1432 nashman 8 Jan 02 8.8 / 26
Can I create a field in a query which auto-increments?  faq181-15 JimConrad 17 May 00 5.3 / 9
can I make a dynamic autonumber?  faq181-158 samara 25 Jul 00 7.1 / 9
Capitalise Names including Macs and Mcs   faq181-659 AyJayEL 18 Apr 01 9.1 / 8
Change PivotChart Legend   faq181-5491 NewJob 22 Oct 04 --
Combo Box that looks at 2 or more tables   faq181-855 DougP 23 Mar 02 7.7 / 10
Convert dollar amount (numeric) to Words  faq181-1776 jimmythegeek 27 Sep 07 8.6 / 8
convert numbers to portuguese word  faq181-242 JaSintoHenriqueSido 2 Oct 00 7.0 / 4
Convert String to ProperCase, UPPERCASE, lowercase   faq181-790 JoeMiller 4 Jun 01 8.8 / 14
Copy data from Windows clipboard to Access  faq181-374 DougP 27 Dec 00 9.8 / 4
Create a Autonumber with a Suffix   faq181-1179 bobbster2000 16 Oct 01 10.0 / 3
Create Combos with Tens of Thousands of Records   faq181-1202 bobbster2000 24 Oct 01 8.2 / 9
Dependent Combo Boxes   faq181-3617 Bullschmidt 23 Jun 03 4.5 / 4
Determine old AD Users and Computers  faq181-4645 SgtJarrow 21 Sep 06 10.0 / 1
Disable Design View on a Database   faq181-1021 Maquis 21 Aug 01 9.1 / 55
Disable Design view through VB coding   faq181-1172 Maquis 5 Jun 02 8.5 / 17
Fill a Combo Box with the database objects   faq181-690 Tzokas 27 Apr 01 9.1 / 11
Finding ascii values within strings or fields  faq181-459 mdav2 6 Feb 01 5.5 / 2
Function to reverse the characters in a string   faq181-778 WarrenTheWindmill 1 Jun 01 2.0 / 1
Function to translate numbers (like 100) to words (like "one hundred")  faq181-76 JimConrad 13 Jun 00 8.7 / 7
How can I add a search to a form  faq181-54 DougP 2 Jun 00 5.9 / 19
How can I attach sounds to my events?  faq181-41 jimmythegeek 17 Oct 06 6.8 / 11
How can I auto-prefix my autonumber field?  faq181-1725 jimmythegeek 27 Sep 07 10.0 / 7
How can I change text to capitalize only the first letter in a word.  faq181-52 DougP 1 Jun 00 8.6 / 5
How can I convert a whole table of string dates to a date format  faq181-40 jimmythegeek 27 Sep 07 8.2 / 6
How can I disable the shift key at startup?  faq181-143 rhicks 19 Jul 00 8.7 / 43
How can I do an automated back-up of my attached Back-End db using FileCopy?  faq181-38 jimmythegeek 27 Sep 07 9.4 / 12
How can I do an automated back-up of my attached Back-End db using FileSystemObject?  faq181-1543 jimmythegeek 27 Sep 07 7.4 / 8
How can i make a EXE from an MDB   faq181-1074 JoaoTL 6 Sep 01 6.6 / 13
How Can I parse a Full Name into Last, First, MI when I receive it different ways?  faq181-37 jimmythegeek 27 Sep 07 7.8 / 6
How can I test to see if an object Exists in the database  faq181-36 jimmythegeek 27 Sep 07 8.8 / 16
How do I add data to more than one Table  faq181-89 DougP 24 Jun 00 8.2 / 11
How do I Close Access after (x) amount of time of no use  faq181-1305 jimmythegeek 27 Sep 07 6.2 / 5
How do I create a form that opens on a new record but allows edits?  faq181-326 Quehay 8 Dec 00 9.4 / 5
How do I get different background colours for records   faq181-1478 Frink 21 Jan 02 8.3 / 6
How do I get different coloured text for records   faq181-1484 Frink 22 Jan 02 8.0 / 1
How do I make a report Print to the same Printer everytime regardless?  faq181-14 DougP 16 May 00 7.3 / 8
How do I refresh table links in code?  faq181-305 huzza 27 Nov 00 5.5 / 2
How do I use a Browse button to Open and Save files?  faq181-152 jimmythegeek 27 Sep 07 7.8 / 14
How to autonumber date values in a control.   faq181-1129 mirirom 11 Dec 02 2.0 / 1
How to calculate age  faq181-55 jgarnick 3 Jun 00 4.0 / 3
How to calculate age (another method).  faq181-85 elizabeth 20 Jun 00 9.8 / 8
How to connect a web page to MS ACCESS Database   faq181-5270 AccessGuruCarl 4 Jul 04 1.0 / 1
How to Delete All Relationships   faq181-837 Tzokas 19 Jun 01 --
How to highlight the selected record in a continuous form  faq181-1804 Frink 14 Apr 08 7.8 / 4
How to Load a picture in Access form  faq181-279 DougP 14 Nov 00 8.4 / 38
How to lock records in a collection individually from editing?  faq181-77 HIM 14 Jun 00 1.0 / 4
How to Open a Parameter Query or Report from a Selection Form  faq181-120 Quehay 9 Jul 00 7.5 / 8
How to restore menus and toolbars   faq181-6133 randysmid 8 Dec 05 --
How to use the "SendObject" Method to send E-mail  faq181-493 DougP 8 Apr 04 5.0 / 19
Importing Excel 97 Files From Changing Locations  faq181-30 famousb 24 May 00 5.8 / 4
Importing Excel 97 Files Into Access Using VB Code  faq181-29 famousb 24 May 00 9.0 / 9
IsNull ..... or not   faq181-3948 hermanlaksko 29 Jul 03 6.0 / 3
Launch DB At Night (or unattended)   faq181-1378 GingerR 20 Dec 01 10.0 / 1
Link Outlook 2000 folder in Access 2000  faq181-175 DougP 6 Aug 00 6.5 / 11
Locate Last Character Occurrence in String..   faq181-1716 smedvid 2 Apr 02 10.0 / 1
Mail Merge to Word using Access query and form  faq181-271 DougP 7 Dec 05 5.3 / 8
Make an intelligent autonumber field?  faq181-159 samara 25 Jul 00 7.3 / 3
Print Linked Images in a Report  faq181-399 AirPro 8 Jan 01 7.0 / 1
Select birthdays within the next 30 days ...   faq181-1374 Advocate 6 Dec 03 10.0 / 3
send multiple mails  faq181-5705 hermanlaksko 14 Feb 07 --
Shell to Word, Open a Doc and run a Macro  faq181-28 DougP 23 May 00 5.8 / 12
Show criteria in a report even if no records in recordset?   faq181-1197 paron 24 Oct 01 2.0 / 1
Use UNION statement in SQL to create a dummy record.   faq181-1862 Klopper 2 May 02 --
What version of Access is the user running?   faq181-2664 randysmid 27 Nov 02 --
Who has my database open?  faq181-7838 FancyPrairie 15 Apr 15 --
Working with Specifications without the Wiz   faq181-4651 coders4hire 31 Dec 03 10.0 / 1
Zoom Report   faq181-3618 Bullschmidt 23 Jun 03 10.0 / 1
 

Access Recovery

FAQ Title Author Date Rating/#
Recovering a Database That Won't / Can't Open   faq181-2790 MFFL 21 Nov 02 6.7 / 10
Recovering Acces 97 Corrupt DB's   faq181-3041 ALEKSJAY 17 Jan 03 5.0 / 2
 

Access Web Resources

FAQ Title Author Date Rating/#
Access Database on the Web   faq181-3637 Bullschmidt 23 Jun 03 6.5 / 4
Web resources featuring Access hints, tips, FAQs, articles and source code   faq181-750 tlbroadbent 2 May 02 8.9 / 24
 

Admin Utilities/Tools

FAQ Title Author Date Rating/#
What tools/Utilities are there for Administrating Access Databases?   faq181-4127 LogicalmanUS 6 Sep 03 --
 

Connect Access to SQL Server

FAQ Title Author Date Rating/#
How to connect to SQL Server database on the WEB   faq181-687 DougP 26 Apr 01 8.0 / 4
 

Error Messages

FAQ Title Author Date Rating/#
3075-Function Not Available   faq181-936 GingerR 24 Jul 01 8.6 / 14
Access communicating with OLE server or ActiveX Control error msg   faq181-2843 paron 4 Dec 02 8.3 / 3
Disk or Network Error: sporadic on networked Access db   faq181-5249 NorthNone 29 Jun 04 --
How do I get Access to display a message if Errors occur while Importing Data?   faq181-2879 BillPower 12 Dec 02 10.0 / 3
Unexpected State. Microsoft Access can't open database   faq181-1005 JoyInOK 10 Jul 02 5.2 / 6
 

Forms

FAQ Title Author Date Rating/#
Adding (text) items to listboxes and getting/setting text in textboxes   faq181-736 bujin 18 May 01 6.3 / 3
Combobox - Allow a user to add values to the underlying table  faq181-66 elizabeth 8 Jun 00 9.4 / 16
Combobox - Allow a user to add values to the underlying Value List  faq181-110 rhicks 6 Jul 00 8.9 / 7
Date stamp records and capture User name when data is added or changed  faq181-74 elizabeth 12 Jun 00 9.2 / 31
How do I allow users to easily link graphics to records.  faq181-432 DaveSH 28 Jan 01 9.0 / 6
How do I check that subform has no records ?  faq181-258 WP 18 Oct 00 5.0 / 2
How do I check to see if a form is loaded?  faq181-320 Rohdem 5 Dec 00 9.3 / 12
how to eliminate the horizontal scroll bar in a subform   faq181-517 Doylet 28 Feb 01 1.0 / 2
Matching the Default Background Color   faq181-3151 perrymans 10 Feb 03 --
No Mouse Wheel Scrolling   faq181-871 katiekat 27 Jun 01 4.0 / 3
 

General

FAQ Title Author Date Rating/#
Expression Builder in A2K and A2K2   faq181-2179 thornmastr 15 Jul 02 7.5 / 4
Find and/or Replace: How to make Global Searches and/or Changes to your Database  faq181-138 Geekette 16 Jul 00 --
General Access FAQs from Microsoft  faq181-84 elizabeth 20 Jun 00 4.7 / 20
How do I get a list of objects & types for my db?   faq181-4570 jgoodman00 12 Dec 03 10.0 / 1
Maximizing a form without effecting other forms and reports  faq181-198 BeffyMar 21 Aug 00 8.5 / 6
Unsticking Database Window   faq181-845 katiekat 21 Jun 01 9.0 / 3
What is DAO, VBA and Jet?  faq181-185 nrjhano 16 Aug 00 3.7 / 3
Why don't my breakpoints stop the code anymore?  faq181-313 ahdkaw 30 Nov 00 10.0 / 1
 

Installing Runtime

FAQ Title Author Date Rating/#
Installed runtime application doesnt work on some machines   faq181-1626 StuMunro 18 Mar 02 5.5 / 2
Why can't I install Access Runtime without error?  faq181-229 Phooey 19 Sep 00 9.3 / 3
 

Login security

FAQ Title Author Date Rating/#
How do I get a user to only see there sections records   faq181-4888 assets 26 Feb 04 3.2 / 5
 

Mailmerge

FAQ Title Author Date Rating/#
'Native' mailmerge reports - as painless as possible  faq181-5088 psemianonymous 30 Apr 04 8.0 / 13
 

Module Stuff

FAQ Title Author Date Rating/#
Calculate working days between two dates  faq181-261 MichaelRed 25 Feb 11 8.3 / 60
Ever needed to convert a Number into a Roman Numeral  faq181-111 rhicks 6 Jul 00 9.3 / 3
Ever needed to convert a Number into a Roman Numeral  faq181-112 rhicks 6 Jul 00 9.5 / 2
 

multi-user ACCESS environment

FAQ Title Author Date Rating/#
How can I make sure the user has the most up to date front end ?   faq181-5559 Chance1234 2 Dec 04 9.0 / 1
How can many users be provided with current front-end?  faq181-7215 GKChesterton 5 May 10 --
How do I log users off a database and keep them off?   faq181-2145 thornmastr 7 Jul 02 6.6 / 5
How many (max) users can Access support?   faq181-4462 psemianonymous 22 Dec 03 8.3 / 12
 

Packaging & Distribution

FAQ Title Author Date Rating/#
Language file problem fix for Access 2003 Developer Extensions   faq181-6183 tman72 20 Jan 06 --
Why do I always get 'Invalid Procedure Call Or Argument'?  faq181-226 ahdkaw 15 Sep 00 --
 

Queries

FAQ Title Author Date Rating/#
Get selection criteria from a form  faq181-68 elizabeth 8 Jun 00 9.4 / 11
Get selection criteria from a form  faq181-69 elizabeth 8 Jun 00 3.5 / 2
How do I fill in a value in a field that is the same in every record?  faq181-1448 Kckronic21 14 Jan 02 1.0 / 1
How do I use SQL to create a query?   faq181-3317 johnnymac43 11 Mar 03 5.8 / 5
Like Options   faq181-3638 Bullschmidt 23 Jun 03 9.0 / 1
Yes/No Totals using SQL.  faq181-209 Amiel 29 Aug 00 4.0 / 3
 

Replacing AutoNumber

FAQ Title Author Date Rating/#
What can I use besides AutoNumber   faq181-1023 mac318 15 Jul 03 7.5 / 11
 

Replication

FAQ Title Author Date Rating/#
How to get a replicated database back to a normal database   faq181-2421 HFloyd 10 Sep 02 7.0 / 1
 

Security

FAQ Title Author Date Rating/#
Access Security FAQs from Microsoft  faq181-83 elizabeth 20 Jun 00 4.8 / 52
Explaining MDW files  faq181-3950 psemianonymous 7 Apr 04 7.3 / 6
Gauging your security needs; alternatives to Access/JET security  faq181-3893 psemianonymous 26 Apr 04 7.7 / 22
How can I limit users to seeing only their own data on a form?   faq181-641 RickSpr 15 May 03 9.6 / 5
How do I get and use the Windows Login ID?  faq181-93 Chopper 26 Jun 00 8.2 / 18
More Help for Setting up Access Security  faq181-1131 tlbroadbent 17 Nov 05 6.7 / 22
Remove the Access Bypass (Shift) Key   faq181-1429 GeekGirlau 7 Jan 02 7.1 / 8
Replacing The Secured Database Login WIndow  faq181-2912 SgtJarrow 21 Sep 06 7.0 / 7
Security System Set-Up Checklist   faq181-1164 Lightning 14 Oct 01 5.0 / 10
What are the security concepts I need to understand to learn Access Security?   faq181-6670 lameid 25 Jun 07 5.5 / 2
Who's in the database? User List and Passive Shutdown  faq181-99 elizabeth 28 Jun 00 9.0 / 4
 

VBA and Custom Functions

FAQ Title Author Date Rating/#
Age Calculation Function   faq181-3769 Bullschmidt 23 Jun 03 10.0 / 1
Basic Error handling - hide an Access error message or substitute your own  faq181-172 elizabeth 3 Aug 00 7.5 / 8
Build Report Criteria via a Form w/list box, text box, date range  faq181-5497 FancyPrairie 15 Aug 05 9.3 / 14
Can data from an Attachemate EXTRA! (CICS) session screen be captured directly into an MS Access database?  faq181-4619 CautionMP 3 Dec 05 7.0 / 2
Getting all types of Usernames in Access  faq181-3779 psemianonymous 5 Aug 03 8.4 / 13
How to Get the String Representation of a Numerice Value (Check Writer)   faq181-1740 MichaelRed 7 Apr 02 8.5 / 12
How to retreive from, and write to .ini files from Access  faq181-217 jimmythegeek 27 Sep 07 8.9 / 7
Rounding functions   faq181-1317 Craig0201 4 Dec 01 6.3 / 3
Search through all Access queries for text in SQL string   faq181-2229 GeekGirlau 23 Jul 02 6.2 / 5
Windows Calculator by Hitting the F12 Key   faq181-3636 Bullschmidt 23 Jun 03 9.0 / 1
 

Version or Conversion Related

FAQ Title Author Date Rating/#
Access 2000 'Run time error '13': Type mismatch' When Opening Recordset   faq181-946 Rohdem 27 Jul 01 10.0 / 1
Can I distribute an Access application to users who don't have Access Licenses?  faq181-105 elizabeth 5 Jul 00 8.0 / 8
Overview for Conversion to Access 2000  faq181-166 elizabeth 1 Aug 00 9.0 / 4
Why am I getting a "No License" error?  faq181-48 elizabeth 1 Jun 00 9.2 / 6
Why am I getting this compile error on my DAO code?  faq181-47 elizabeth 1 Jun 00 --
 

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