Search results for query: *

Use this, just remove #tblMan from your select: insert into #tblAdd ( ItemNum, totQty, ManagerNum, BasePrice) select F.ItemNum, F.totQty, F.ManagerNum, F.BasePrice from #tblFin F where F.ManagerNum = '0004' and F.ItemNum not in (select ItemNum from #tblMan)

Alright, thanks for everything. sorted it out.

Thanks one more thing, please what's the long variable for the constant SW_SHOWNORM. Thanks

The shell command only works for exe's. My project doesn't recognize The ShellExecute command, so what do I do?

Need help urgently. Please how can I launch and view a Text document in Notepad on the click of a button. Thanks don't want to have to use any forms or controls to read out the file and display it first. Thanks

I have an application, an exe, and I need it to run as a service so it starts up automatically when the system does and I can start and stop it from the services Console, pls how do I go about it? Thanks

The code in your Standard exe should be 'The difference is in the first line Dim MyYear As New CheckYear.LeapYear Private Sub Command1_Click() MsgBox MyYear.IsLeapYear("1999") End Sub This will work if your project has a reference to your CheckYear component...