Posts by vb5prgrmr

Well that is an entirely different animal. Try adding an if statement to check for the existance of a valid recordset...

If rs.BOF = False AND rs.EOF = False AND rs.RowCount <> 0 Then
  'we have a valid recordset with at least one record
End If

it is possible? if the user in the running time, click the close button or the X button that we can see in the top of the form and then if the user click the close or X button message box will appear "you cannot log out"? how can i do this? thanks. .

yes this is possible

Private Sub Form_Unload(Cancel As Integer)
Cancel = True 'set to any none zero number could be cancel=1
MsgBox "Running, cannot close form now!"
End Sub

If the API instructions are above your head, check out the MMC (Multimedia control). Right click on your toolbox, select components, scroll down and select the Microsoft Multimedia Control 6.0 (SP3). Once it is on your form press F1 for help and read all about it.

Good Luck

Use the Name operator

Name OldFileName As NewFileName

Good day.!

What a frustration drives me just this day.! Last night we got power lost. Just this day when i open my vb project, ive got an error message says that project1 cannot be loaded. When i try to open one form on that project it also returned, form1 cannot be loaded. Im stuck with this until now.I dont have any back up yet. How can i recover my project or just the form.! I try to open it in notepad but i ve just see unreadable information. Please help

Thank you

Copy offending file to another directory.
Open with notepad and do a save as.
If prompted for saving unicode characters, don't. Save as text only.
Dbl click on new file in explorer and VB should open up and start a new project for you. If form is still unreadable by VB or in notepad you may be out of luck, but...
If you find that it is now ledgable but seems to be missing carrage returns, well then... I hope there is not a lot of controls and code located in that file.
(Meaning you will have to add them manually)

Good Luck