Search results

What is the E-mail Address Format? I would like to generate e-mail addresses that contain a Name with an e-mail address; What is the proper way? I did a web search and could not come up with a definite answer as to what format i should use so that this new e-mail address would be accepted by...

Can't one use the SHELL Function? In VBA, on can do: Dim ShellFunction ShellFunction = Shell("msaccess.exe" & " " & "e:\temp\Test.mdb", vbMaximizedFocus) this will open a database in full screen mode; Llyal

How can one tell if a database has been opened or not? How can one tell if a database has been opened or not; i am creating a compact utility and need to know if a database is open or not; Any help? Thank you! Llyal Gordon

The reason i need "some" of this information is because i am making a database documenting application and need to be able to search through database objects for information; however, i would like to know the "full deal" on all these tables for future reference; the Microsoft website has been...

Information on Access 97 Default System Tables When a new Access97 is created, 6 system tables are created; MSysACEs MSysModules MSysModules2 MSysObjects MSysQueries MSysRelationships What is each of the tables used for? What information is stored in each table? Thank you! Llyal

Using Infared port to Control PC in VB I am having trouble getting good information on using the Infared port on a PC with VB; has anyone come across any resources that gives the basics of this? I want to be able to read the signals from a infared remote control to control a custom music...

Need Music MP3 Example Using Multimedia MCI Control I have tons of documentation on using the MCI with WAV and CDAudio files, but zero on using the MCI with MP3 files; what is the basic information i need to make this control work with MP3 files? Thank you! Llyal

Outlook Recipients.Add only allows single email address Using VBA, Outlook won't let me add more than one Recipient at a time; I cannot do: objMail.Recipients.Add ("person1@domain1.org; person2@domain2.org; person3@domain3.org") but then i can do: objMail.CC = "person1@domain1.org...

What Can Go Wrong With Access? I would like to gather a list of limitations that cause data corruption in Access (documented and undocumented); the purpose is to educate myself and others about the stranger behaviors of this product, so measures can be taken to minimize data corruption problems...

Maximize Property in InternetExplorer Object? I am controlling the InternetExplorer Object remotely from VBA in Access; my goal is to open internet explorer Maximized (not full-screen); the InternetExplorer object allows me use a full screen property, but using this will only show the browser...

How to Open Mutiple Instances of Internet Explorer I would like to open multiple instances of the Internet Explorer and do different activities in each instance from VBA code. I currently use Application.FollowHyperlink but this will only open one instance of the Internet Explorer. I do not use...

There are also programs available (at a price) that will convert Access DBs to VB code so that you can then treat you application as a VB project; I don't have additional info; i mention it so that you are aware of possibilities. Llyal

Dave, If the input is from a pop-up box or form field, I find the easiest solution is to "build" a query. You breakdown the User input string and then build a query from this breakdown such as (in Pseudo-code): strSQL = "SELECT * FROM tblTable WHERE " strSQL = "tblTable.Field Like '" &...

*** TOP TEN *** VB/VBA Code Websites !!!!! A anonymous poster mentioned a great VB Code website: http://vbcode.com/ I did not know sites like this existed! What other awesome websites are out there? Calling all those In-the-Know-Who-got-the-Flow, please do not hesitate to post a few of you...

Getting Access Database Object Info by VBA for Documenting Can i use VBA code to access information about Access database objects so that i can make my own customized documenting? What is the low-down? (a few tips is all i ask!) Thank you! Llyal

String Search Through Access Database Objects How can one search through database objects for a string; for example, say i renamed an object; how can i search the DB for all references of this object in the forms, modules, etc, with VB code? I know there are database products that do this...

On Error Resume Next Fundamentals How does On Error Resume Next work? Does it affect ALL code after it? How does one reset On Error Resume Next so that this type of error trapping only affects a range of code (say a small loop routine that checks to see if files exist or not by). I would like...

Close Access97 Open Sessions and Then Close Database- new twist I need to automatically close a Access97 database so that Compacting can be done from a maintenance program. I cannot use the On Timer() Event to automatically close the database because the Users often close all database objects...

Some Good Sources to Learn the Properties of the Outlook Objects I searched the MS website and found general info about the Outlook Objects but did not find info on all the properties of the objects (such as): AddressResolveUI SentOnBehalfOfName etcetera I only knew the above properties...

Access97 does not have DriveListbox and DirListBox controls? I want to add VB file management enhancements to an Access application and find that the DriveListbox and DirListbox controls do not exist in the Access controls. What do i do? Do i need to add these controls some how or am i out of...