Search:

The problem is that your connection string is not correct.

.ConnectionString = "Provider=SQLOLEDB;Data Source=" & sServer & ";Initial Catalog=Master;User ID=sa;Password=xxxx;Persist Security...

Indeed callbyname exists but remember that this is also compiled. I am not saying that a function / sub name is totally destroyed but you cannot necessarily expect that it is preserved in the...

As has already been said, you cannot do this. The main reason of course is that your source code is compiled into the application and the actual function names are not necessarily preserved in any...

There are third-party tools such as http://www.bit-arts.com/fusion which can incorporate all static objects and dynamically extract them as required from a single executable. This is not quite the...

If only this were easy.

There is a thread on another forum:- Here which pretty much gets there. This is however not for the faint-hearted!

As far as I can see, your code is fine for this part of it. However you need to understand the various interactions that take place. I would imagine that you have the .RThreshold property set quite...

Simply use ''

SELECT fname, lname, solfname, sollname, AccidentID FROM Accident WHERE lname LIKE 'o''*'

Access like SQL server will treat repeated ' or " characters as "escaped" ie only one...

Just use this when you load the grid:

MSFlexGrid1.LeftCol = 17

This will set the first visible column to 17, the preceeding ones can be viewed by scrolling left if required.

This example code shows how this can be achieved. You can modify this example to your specific needs:



'This program needs a common dialog box, named CDBox
' (To add the Common Dialog Box to...

There is an API Method:

Private Declare Function fCreateShellLink Lib "VB5STKIT.DLL" (ByVal lpstrFolderName As String, ByVal lpstrLinkName As String, ByVal lpstrLinkPath As String, ByVal...

I assume rather that you are referring to the SHAPE command as in Data-Shaping, this allows you to build hierarchical recordsets where you can mirror the grandparent, parent, child hierarchy of data...

There are two ways around this problem, (Three if you break it up into two seperate procedures).

The reason you get the problem is because there are two statements in the stored procedure, each...

Private Sub Command1_Click()
SetTimeFormat IIf(optTimeFormat(0).Value, "Medium Time", "Long Time")
End Sub

Private Sub optTimeFormat_Click(Index As Integer)
SetTimeFormat IIf(Index,...

?dateadd("d",1 - weekday("2002-11-01"),"2002-11-01")

Or whatever first day of whatever month of whatever year as appropriate.

Private Enum mtModTime
mtSeconds = 1
mtMinutes = 2
mtHours = 3
mtDays = 4
mtWeeks = 5
mtMonths = 6
mtQuarters = 7
mtYears = 8
End Enum

Nearly:

* and ? are supported on some platforms and are generally used with DAO.

% and _ are supported using ADO on *ALL* platforms including access where you would normally use the DAO...

You need to set the cominput mode to binary. This will allow you to do this:



Dim aryInput() As Byte
aryInput = MSComm1.Input


You can then read each byte and convert it to binary (you may...

You can, you would usually do something like this:

mnuZoom.Caption = "200%"

However this may get a bit confusing and doesn't necessarily follow the UI of most applications. It may be better to...

ADOX is the other solution that I forgot to include in the list of options, I can confirm that you can use this against SQL Server and you can then get slightly more information than you might be...

Certainly in SQL Server itself you can Generate SQL Scripts which will contain the statements necessary to drop/create the table(s), view(s), Stored Procedure(s) etc along with any appropriate index...

Check this out: http://www.btinternet.com/~vbadmincode/code/pdh.zip

combobox.ListIndex should be the one.

Can you post the declare as I don't have it, I am sure that we can work out the type declaration from that.

Open App.Path & "\Coffee.txt" For Input As #ff


Is all there is to it!

tangbing, this is a known issue. The reason is that you are either running Outlook 2002 or previous versions with the outlook security patch applied. This is designed to prevent virus software from...