Recent content by wniatbms

JSpicolli Do you know what I love about the Tek-Tips website? People like you!!!! You rock! Thank you so much for your help. You saved my @$$. I know all about the 2am thing. You have my support 150%. Thank you so much.

Good day. Let's say part of the registration process on my website includes your date of birth. I want to be able to show that users age. How do I do this? I am having the following problem: Lets say the users DOB is 15-Aug-1978. My first thought was to just subtract the DOB from the current...

Shatch. Thank you so much. It works just fine. Ciao

Good day How do I go about changing the value of the return or enter key when a user is typing in a 'textarea' on my form so that the return is display as <br> in the dbase? Thanking you in advance. William

gpzcrasher... Beautiful! It worked. THank you.

Good day In my table I have a column containing values with 2 decimal places. These values could be: 180.00 1.63 1.00 0.84 0.10 When I retrieve them on a web page, they display as such: 180 1.63 1 0.84 0.1 I really need them to display as...

Good day. I recently uploaded a MS Access 2000 Database to our webserver which has since collected a large number of records from visitors. I have made changes to the database and added tables to it. How do I upload the changes of the database to the online version without having to download...

Good day. I extract data from my DBase and I have managed to format the dates as "25-June-2004". How do I change the formatting to "25-Jun-2004"? I need to have all the month names three characters long. Thank you in advance.

Good day. Part of my website has a registration page. I want to include a hidden input field that captures the screen resolution of the visitor and then store that value in my DBase. The javaScript code is as follows: <script language="javascript"> document.write ((screen.width) + ' by ' +...

Good day all I have to pages (.php) to insert data into a MySql DBase. The problem is that it duplicates each new record, ie., it puts the same record in twice. Here's the code: (the page that receives the form and inserts) <? $usernameWS=$_POST['wsUsername']...

Good day master programmer Jedi's... I was just wondering if someone could help me with this little problem I'm experiencing. If I have an .asp page and part of it's functionality has to do with create an FSO, the system just hangs. I then have to close my browser window, stop the IIS, restart...

Thank you so much Tony. I have something else to ask. This column "OrderInLine" decides the order of items on a menu. So 1 will be at the top and say, 85 will be last. Now, let's say I want to insert an item in the middle, 44. How do I get the numbers to recalculate to fit in a new number...

Good day. Let's say in a table there is a column "OrderInLine". On a form I want to display the very last number inserted in that column so the user (me) can input the next number. I'm using asp and an MS Access 2000 DBase. Thank you in advance. William.

Good day to you all. To display the date like 24-May-2004 I use: <%Response.Write (Day(Date) & "-" & Monthname(Month(Date)) & "-" & Year(Date))%> Now if I have stored a date like that in my Access DBase, how do I retrieve it in that same format? Ie, the field name "myDate", if viewed in Access...

ChrisHirst: Thank you so much for that code. It will be most helpful. Tarwn: Thank you for that warning. Please excuse my lack of knowledge here - I am very new to all of this - but what are you refering to when you say "the Execute method"? It wouldn't be the code ChrisHirst has supplied...