Recent content by DSJ1967

I have an incoming text file that is in the format of CustomerId|Product1 Sales|Product1 Share of Sales|Product2 Sales|Product2 Share of Sales| ... which continues on for about 15 products. The product names are actually in the column names. I need to normalize this into...

We have recently released a program that invokes a third party control inside of a custom control. The problem is that our client also released an application that used the same 3rd party control with the exception being that is was a slightly newer version. There installation of the 3rd Party...

If someone wants to look at the code, send my your email address and I can send it to you. davidst.john@home.com

Has anyone used the InfoZip DLLs. I have seen a couple of instances around the web and have created an interface in VB which incorporates one of the classes that uses this Zip DLL. My problem is that in some instances I am getting an error "zip warning: name not matched: " yet if I...

I had a very similar problem and was resigned to the fact that I was not going to load the entire table into the grid. Instead load my record set by 'pages' (i.e) the number of records that are actually visible in the flexgrid. Using the absolute position of the recordset + the number of...

Alternativey, there is a MouseDown event on a textbox. Depends on what you want to allow the user to do. If you simply do not want them to use the mouse to ensure that they follow the tab order the mousedown event will capture this. If, on the other hand, you do not want them to be able to...

You can also use the LastModified property of a recordset (DAO) to set the bookmark. i.e. rs.bookmark = rs.lastmodified should work nicely.

When you open your search form, open it modally. On the search form, when the user clicks the list box, transfer the Id of the record which was select to a property on the search form. When the user clicks OK or Cancel, Hide the Search Form which will return you to the calling module. Then...

How about putting a property (boolean flag) OK_To_Run on the form that gets set at form_load and form_close. At the beginning of your activation procedure, check the flag to see if it is true or false

I am trying to merge the contents of a textbox into a Word document. My problem is that I do not want to overflow the page. If the contents of the textbox are larger than the space that I have provided on my Word Doc, I want to either create another page, head it with 'Description Continued'...

Micheal,<br><br>Sometimes it is usefull to have a fixed length text file where all the records are consistent in length.&nbsp;&nbsp;The other option would be to have a variable length file but then you would have to have a delimiter at the end of each field.&nbsp;&nbsp;Either way works...

Ivax,<br><br>Not sure... tried it at home and it seems to work.&nbsp;&nbsp;Like you, defined a UDT in a module then created a new variable based on the UDT in my form<br><br>ie.<br>Option Explicit<br><br>Public Type client<br>&nbsp;&nbsp;&nbsp;&nbsp;codbar As String *...

Motto,<br><br>Would it be possible instead of having the form as your startup have a module as the startup instead i.e. Sub Main() in a module.&nbsp;&nbsp;Then in the module, use Login.Show vbmodal ?<br><br>Hope that helps.

Joe,<br><br>First, I don't think that you can setfocus to an object in the form-load if that is what you are trying to do.<br><br>Maybe what you could do is load the form and then wait for the User to click a cell and then using the mouse events and properties, figure out which cell you are...

Edrest<br><br>You just need to tie the fixed portion of your string and the variable portions together with an '&'<br><br>you should check to make sure that the variable &lt;&gt; &quot;&quot; but none the less should look something like<br><br>myString=&quot;Create Table &quot; & text1.text &...