Search:
Type: Posts; User: Glenn
Search:
Search took 0.09 seconds.
-
I agree with Cander. Just because Microsoft created the Migration tool that doesn't mean you have to use it. This is a great time to take the opportunity to reengineer your applications to take...
-
When you open the add components box the version and service pack number is usually list on the same line as the component.
-
Are you attempting to get the recodset to point to the new last row ? (the one that you just added). If that's what you are trying to do try:
adodc1.movelast
This will move the recordset to...
-
What data access technology are you using RDO, ADO, DAO ? My guess is that whatever technology you are using the appropriate DLL's are not on the machine that you are trying to run it.
-
If I read what your trying fo correctly you need to swap these two lines of code:
For Each item In ListView1.ListItems
If item.Selected Then
cmdAccount.Parameters("MemberID") =...
-
I tend to use ODBC when I don't want to put the location of the database or server in my program or in the registry or ini file.
By using ODBC I can usually talk a user through the control panel...
-
Crystal reports is a 3rd party for generating reports from many different database types. The reports can be integrated into vb by using an activex control or activex dll. A slim downed version used...
-
Are you trying to do preserve and expand the 2-D array ? As you have found out thats not possible.
I never tried it, but maybe you can replace you 2-D array with a one dimensional array of a...
-
No reason to get snippy , Joacim is just trying to help you. By telling people what part isn't working allows them to help you.
Why don't you post the code your using for the Savesetting and...
-
I'm running out of ideas. One last thought is to make sure that when you install mdac and possible your app that you install under account that has local administrator privleges. If you don't you...
-
You will also need the msado15.dll file in the distribution. This file is not part of MDAC.
-
Regarding Item 2, there is no problem installing MDAC on NT 4.0 or any other O/S for that matter. What version of MDAC do you try to install. I have had enormous success with version 2.5
:) :)
-
Are you planning on using ODBC, or SQL OLEDB ? Either way make sure you have the correct SQL drivers loaded.
:) :) :)
-
Is your datagrid bound to a database using dao or ado ?
If it is, you will have to include the apropriate data access files as part of your installation. Install shield should have an option for...
-
I agree with everything that has been said. In addition:
ADO is more universal you don't have to learn multiple methods for accessing differrenent database types. For instance RDO for SQL-Server...
-
The follwing code will compact a access database:
Set JRO = New JRO.JetEngine
lssourcedb = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" &...
-
Please post your code for we can take a look at it.
One thought is, if you are using a stored procedure to perform the insert you can return the new record id by using the @@IDENTITY variable in...
-
What database access menthod are you using RDO or ADO ?
The format depends on the method.
-
If issue a query to a server, the server has to compile that query before it can execute it.
Stored procedures are precompiled on the server which makes them run faster.
They also allow...
-
From access online help:
Print the criteria for a report in the report header
1 Create the criteria parameters in the report's underlying query.
How?
2 Open the report in Design view....
-
Check you version of your JET OLE DB provider. I've been able to do it successfully using the same logic with version 4.0 of the same provider.
-
What database are you using MS Sql Server or ?
If you are using MS SQL Server then what version 6.5, 7.0 ?
I've been able to read large text fields using the getchunk methods. It's kinda of...
-
I think you need to set the datasource property equal to the recordset RSMAIN
Set FlexMain.DataSource = RSMain
-
I think this is what you want:
[Code]
For x = 1 To 4
If firstofsequence(1) = secondofSequence(x) Then
Picture1.Print firstofsequence(1) & ",";
End If
Next
-
Classes allow you to share code easily among multiple projects (assuming their compiled into COM objects).
If you encapsulate your business logic into the classes it then easy to update the...
-
There is also a application on the included with the Windows NT resource kit that will run any EXE as a service.
:) :) :)
-
All the DSNs are stored in the registry under:
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC Data Sources
Each DSN is listed as a value under this key. If you need more information on each...
-
Unless you require a clock with seconds you don't need to use a timer with the status bar. Just set the style property of the panel to sbrTime.
:):)
-
You can concatenate fields by using something like the following:
SELECT FirstName + LastName AS FullName FROM table
This will return a single column named FullName
This works for SQL...
-
The problem with the date/time picker is that it doesn't allow blank dates without the use of that nasty checkbox.
I use that date/time picker when I have a default date that I can load into the...
-
If your class modules are included as part of your EXE (not in a DLL) you do NOT have to register them. The fact that your app loads, typically means that the OCX's are register correctly. The...
-
If you just want a clock. Add a status bar control and set one the panel to be a clock.
:):)
-
You could use an ini file and then use VB's functions to Read and write to the file.
You should probably think twice about using a file for security. Unless the file is encrypted it would'nt take...
-
Unfortunately MS in it's infinite wisdom has seen not to provide the same combo box to VB as it does for Access. Combox boxes in VB only support 1 field. The only way to get multiple fields into a VB...
-
I started out writing Fortran in college. 2 years
At my first job, I wrote Fortran, C, Pascal and VB 3.
13 years
Current Job VB 5 - VB 6 3+ years
Total: 18+ years
I guess I've been...
-
In the compile tab you want to set the OCX to binary compatibility. When this is set, VB checks your OCX with a previous version of the OCX for compatbility. As long as you haven't removed any...
-
One way to do it is to declare a flag that you set before you "click the button in code". Then in the click_event of the button, check for the flag and don't do anything if it's set. Reset the flag...
-
Heres how to do it. I did'nt write this code but it should work.
Compact and repair databases via ADO's JRO
In a previous tip (Compact and repair Jet databases with DAO), we showed
you how to...
-
JHausmann you are correct (give that man a cigar :)). Undeclared variables are treated as variants. They tend to be slower because VB has to figure out the storage at runtime, instead of compile...
-
I was able to do it by writing 2 queries in Access. The first queries determines which price is higher. The second query references the first one and simply counts the records. Here's the SQL for the...
|
Click Here to Expand Forum to Full Width
|