Recent content by Paladine

have you tried the webinar series? http://www.mysql.com/news-and-events/web-seminars/mysql-essentials.html _________________ Paladine

Thanks lespaul, any help is appreciated. I know that it breaks normalization. The reason it does is because the date is an import from an excel spreadsheet. I need the query inorder to sort the data based on criteria we specify. And by So I would like the query to return those rows with...

Hoping someone can help me. I would like to do this in a query rather than VBA code. I have a column (Column A) with string/text values what are lab test abbreviations, and I want to search another column (Column B) for instances of column A data. The data in column b is basically varying...

Thanks AtomicChip! _________________ Paladine

Hi folks, I have set the appSettings Tag in the web.config file to hold my database connection string. Like so: ______________ <appSettings> <add key="strConn" value="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Northwind.mdb;User ID=Admin;Password=;" /> </appSettings>...

You &quot;add&quot; the item price(s) as you add items to the listbox. For example: Private Sub Add_Click() Dim varItem as Variant Dim curExtPrice as Currency ' The price per item * quantity of that item. Dim curSubTotal as Currency ' Each item selected from the stock Listbox (assuming you...

What are you doing exactly when you get this message? Accessing your ASP Page? Or creating the DSN? _________________ Paladine &quot;Doing what others find difficult is talent.....

Ok, MAX is used in to retrieve the Highest Non-null value from a specific column. Now I would recommend this, you must obtain the MAX value inorder to add 1 to it and then insert it. Right? So to do this I would use a statement like this; INSERT INTO mytable(rowOrder) SELECT MAX(rowOrder) +...

Ah, that one I will need to look into a little more. But I would definitely look through the KB articles at Microsoft for the hows and whys. As this is their baby. I will let you know if I find anything, but at the moment I am unsure how to transfer the constraints/keys and access it...

If you have SQL Server 7 or Greater you can use the DTS Import Export Utility that is built in. Just follow the prompts and select a blank access database and export the SQL DB you want to that Access database. Easy as that. Just did it for the PUBS database in SQL and it took 30 seconds...

ASP.NET is faster by far. IMHO. Why? Well, let me first say that ASP.NET initially is slower, or appears to be. This is do to compiling of the code on first pass. Once the page(S) are accessed once, each subsequent time will be faster than initally. This is because the code has...

VBSlammer is correct. Debug.print just displays the result in the &quot;Immediate window&quot; (under view in VBA Editor), so using his code will work! _________________ Paladine &quot;Doing what others find difficult is talent.....

I have been playing around with Mozzila, and find it too be a rather nice speedy browser, but I do ASP.NET programming and such and seem to have some issues with ASP.NET pages displaying properly. It seems to be with regards to coloring, I guess ASP controls as well , since those are the things...

Ok, maybe I am going about this all wrong, but I am reasonably experienced with VBA/Access but I am trying to reproduce a form from it in VB.NET (after having read a VB.NET book...thought this would help me explorer my lack of knowledge) - I want to do the simple task of enabling and...

Ok, maybe I am just really green at VB.NET but with their being no Variant datatype, what would the basic code be for doing a multi-select listbox?