Recent content by EndersG

:confused: I have a Microsoft Access table with the following columns: A,B,C,D,E,F. In first row of Column A, I have the following string value: "Al,Peggy,Kelly,Bud,Buck" What I would like to do is parse this string as such: Column B:"Al" Column C:"Peggy" Column D:"Kelly" Column E:"Bud" Column...

I would like to know how to send the results of a stored procedure in SQL Server 2000 to an email. Is there any code out there you are aware of to accomplish this?

Much appreciated bob, especially the visual aids. You're a lifesaver!

Thanks bob, but is it possible you can give me an example using the data I've provided? Thanks.

Using a table named Table1 with the following values: SizeUnit 24.67 sy 26.84 sf I created a query that returns the following results: SELECT SizeUnit, Val([SizeUnit]) AS [Size], Mid([SizeUnit],InStr([SizeUnit]," ")+1) AS Unit FROM Table1; SizeUnit Size Unit 24.67 sy 24.67 sy 26.84 sf 26.84 sf

I have a table in MS Access named Invoices containing the following values: Name Invoice Jim 101 Jim 102 Jane 103 John 104 Jane 105 John 106 John 107 Jim 108 Jim 109 Jim 110 The following query gives me the results you see below: SELECT Name, Count(Invoice) AS CountOfInvoice FROM Invoices...

Is there a way to return the Created Date, Modified Date And Accessed Date of a file? Can I use the Dir function or something similar to this? Thanks.

I'm using ASP.NET 2.0 menu control. The menu is populated against an xml file called MenuItems.xml. One of the menu items is for a logout page. The syntax is as follows: <category title="Log Out" description="Log Out" url="LogOut.aspx"> Everything works fine and as expected. However, I...

Paste this snippet of HTML into a VS 2005 .Net Web Form: <table style="border-right: black thin solid; border-top: black thin solid; border-left: black thin solid; border-bottom: black thin solid;" > <tr> <td style="border-right: red thin solid;width:100px;">...

Determine what the Access error number is and then capture it in an ErrHandler, like so: ErrHandler: If Err.Number Then If Err.Number = ???? Then 'user clicked CANCEL Resume Next End If End If

Does Access 2000 have the MaxLength property for its textboxes? For example, if I want to limit the number of characters you can type in the textbox to 10, shouldn't it be as simple as Me.TextBox1.MaxLength = 10 (like in VB6). Or is MS Access limited in this regard. Thanks for sharing.

Thanks for the information, pdx. It makes sense when you explain it that way. What's interesting is that the same example works when you use a temporary table instead of a table variable. Is this because temp tables exists throughout the session whereas temp variables exists throughout the batch?

Can someone explain to me why this does not work? I declared a table variable as follows: DECLARE @sqlSTRING varchar(3000) DECLARE @MyTable TABLE (EmpName varchar (50), EmpAge int, EmpJobID varchar(10)) I tried to run the following EXEC: SET @sqlSTRING = 'INSERT INTO @MyTABLE (EmpName...

Is there any way to increase the time it takes to process a MS Access query before it times out? Is there a default setting I can adjust under the database properties? The problem occurs when I try to run the query from a remote location using a virtual private network. Accordingly, MS Access...

I'm using VS.NET 2005. I have 2 web pages (PageA.aspx and PageB.aspx). PageA has data fields (i.e, textboxes and dropdownlists) with values in them. I want to submit a request from PageA (via a button) that will either Server.Transfer or Response.Redirect to PageB and populate the values from...