Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import text file into Access db
You can use the INSTR function to find where the slashes are and use the left/right/mid string functions to get the individual pieces of data that you require. Hope this helps Bill- guestuser
- Post #2
- Forum: Visual Basic (Classic)
-
A very simple Visual Basic Question about Playing sound
paste the following code in a new module and call the 'play' function : Option Compare Database Option Explicit Declare Function sndPlaySound Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long Const SND_ALIAS = &H10000...- guestuser
- Post #2
- Forum: Visual Basic (Classic)
-
Eliminating Spaces in a Field
If you put the line If KeyAscii = vbKeySpace Then KeyAscii = 0 in your 'On Key Press' event of the text box, the space key will not be allowed.- guestuser
- Post #16
- Forum: Microsoft: Access Other topics
-
On Click Visible Is Not Saving
How are you closing the form, you must set the option that saves the form to yes (acSaveYes) . e.g. DoCmd.Close acForm, [Name], acSaveYes- guestuser
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
