Search results for query: *

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...

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...

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()...

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

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...

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...

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...

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...

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...

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...

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...

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 <...

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

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...

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...

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))...

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

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...

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

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