Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LongFeiFengWu

    HELP! Time Conversion

    I have a collection of fields in a database that are input as text (trying to change the field type to date/time or number causes the db to erase the data in those fields). The format is hh:nn:ss. I need to turn those fields into minutes. So if I have 60:10:00 I need it to say 3610. Any help...
  2. LongFeiFengWu

    HELP - Item cannot be found in the collection

    I have a SELECT statement that I'm using to generate a table. One of the variables in the statement comes from a form field "item". The form field is carrying the value to this page correctly and the column in the table does exist, but I'm getting the following error message when the code runs...
  3. LongFeiFengWu

    Help Copying and Pasting a table

    The objective is to copy a table on button click and then remove it from the page. When a 2nd button is click, I want to put that table back on the page with everything intact. This includes all entries users may have placed into the forms. What I have so far: SUB ResolutionOFF_onClick()...
  4. LongFeiFengWu

    Help Adding Records To Table

    I'm using an Access 2000 DB...does a Create Table statement work in an Access 2000 DB? "If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo." ~ Bruce Lee
  5. LongFeiFengWu

    Help Adding Records To Table

    What I'm attempting to do is cycle through one table and use the values there to write to another table. The problem is that It's not looping. I only get the first record to write and none of the records that follow. Any help is greatly appreciated. <!--#Include...
  6. LongFeiFengWu

    Help with dividing by time

    I need some help with dividing by time. What I have is as follows: Value A: 31027 (Contacts) Value B: 4507:17:03 (4507 hours, 17 minutes, 3 seconds) I need to take Value B and format it in hours, so that it reads (example) 4507.25 hours. Then I need to divide the contacts by the hours to...
  7. LongFeiFengWu

    Need Help Transferring Data From Excel To Access

    I have never done this and don't even know where to begin. What I need to do is write a script that copies an entire Excel Spreadsheet to an access table without over-writing the existing data. Also the Excel sheets I'll be pulling from lack consistency from cell to cell. The first several...
  8. LongFeiFengWu

    Copy Data from Excel to Access using Script (HELP)

    I have never done this and don't even know where to begin. What I need to do is write a script that copies an entire Excel Spreadsheet to an access table without over-writing the existing data. Also the Excel sheets I'll be pulling from lack consistency from cell to cell. The first several...
  9. LongFeiFengWu

    Exporting an Excel Spreadsheet to an Access Table

    This is something new to me that I've been challenged with by my superiors. I've been able to set up an ODBC connection to an Excel spreadsheet on my server, but don't know how to call the data from the spreadsheet since there are no column headings. Do I just reference A,B,C,D like I would...
  10. LongFeiFengWu

    Error in CASE statement...HELP!!

    Ok, I fixed Error # 1 - [JAN]=SUM('CASE [EntryMonth] WHEN "& 1 &" THEN [Instance] END ') Had to add the ' around the Case statement. Ooops. Error # 2 - Too few parameters. Expected 12. &quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like...
  11. LongFeiFengWu

    Error in CASE statement...HELP!!

    ThisYear = Year(Now()) SQL = "SELECT " SQL = SQL & "[JAN]=SUM(CASE [EntryMonth] WHEN '1' THEN [Instance] END), " SQL = SQL & "[FEB]=SUM(CASE [EntryMonth] WHEN '2' THEN [Instance] END), " SQL = SQL & "[MAR]=SUM(CASE [EntryMonth] WHEN '3' THEN [Instance] END), " SQL = SQL & "[APR]=SUM(CASE...
  12. LongFeiFengWu

    Receiving an error on post - shouldn't be as far as i know

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. /money/save.asp, line 6 <% IF request.form("Dollars") > 0 THEN objrec.open "Money",objcon,3,3 <...
  13. LongFeiFengWu

    Math is wrong...I know it's my fault, but I don't know how to fix it

    The YTD values are fabulous the way they are. All the other values need to be 2 decimal places. &quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo.&quot; ~ Bruce Lee
  14. LongFeiFengWu

    Math is wrong...I know it's my fault, but I don't know how to fix it

    I think my Access 2000 DB is changing the numbers that get entered. I think it's rounding them up or down to the nearest whole number and I can't fix it for some reason. The data type is Number and the properties are set to Long Integer with 2 decimal places, so I don't know what's going on...
  15. LongFeiFengWu

    Math is wrong...I know it's my fault, but I don't know how to fix it

    Ok, I'm lost. The changes I made didn't work. Execute(vars(v) & "=" & vars(v) & " + FormatNum(objrec(""" & months(m) & vars(v) & """),2)") Didn't make it 2 decimals. I wonder if there's something else that needs changing that I'm missing. &quot;If nothing within you stays rigid, outward...
  16. LongFeiFengWu

    Math is wrong...I know it's my fault, but I don't know how to fix it

    This is what it looks like now. I changed it a bit based on what you told me before. Dim months, vars months = Split("JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC",",") vars = Split("AHTC,AHTE,AHTO,CPH,ATT,TIPS,OBS,REV,MEET,DEV",",") FOR v=0 TO ubound(vars) Execute("Dim " & vars(v))...
  17. LongFeiFengWu

    Math is wrong...I know it's my fault, but I don't know how to fix it

    thank you very much! &quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo.&quot; ~ Bruce Lee
  18. LongFeiFengWu

    Math is wrong...I know it's my fault, but I don't know how to fix it

    Ok, having a slight problem with this. It needs to be able to display out to 2 decimal places, but it's rounding the numbers to the nearest whole number. Where in this script can I fix that? &quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like...
  19. LongFeiFengWu

    Generate Querystring Item From Array

    sure did. the page is all done. thanks for all of your help! &quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo.&quot; ~ Bruce Lee
  20. LongFeiFengWu

    Updating A Column Based On A Form Value

    Nevermind, I fixed it. Yay Me! &quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo.&quot; ~ Bruce Lee

Part and Inventory Search

Back
Top