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!

  • Congratulations bkrike 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: *

  • Users: vza
  • Content: Threads
  • Order by date
  1. vza

    Trouble with anchor colors

    div.navMenu a:active { color: #000000; background-color: #FFCC00; background: #FFCC00; } I currently have created a <div> tag within my jsp page which contains numerous links to Navigate around my site. I have inserted the following style definition in my CSS style...
  2. vza

    MySQL unix_timestamp woes...

    I have a MySQL query used to compute the total time a device is within a expected location. The loglocations table contains a history of every device's location history within the DB. the starttime/endtime are datetime fields which represent how long a device is in a partcular location for that...
  3. vza

    SQL Query

    Question: I am creating an Java Application which takes in a text file with Wireless Devices and Locations these Devices are supposed to be in, and compare it to device history data stored within within a SQL database. A feature of the Application is to compute the total percentage of time the...
  4. vza

    Reading/Writing to a file

    I want to store connection properties (URL/Username/Password) for a DB to a file and also have the ability to access these properties as needed. What would be the best way to do this? -vza
  5. vza

    TransferSpreadSheet Function

    I have an VB app which transfers converted Excel spreadsheets to a format acceptable foe insertion into a Access database. I use the TransferSpreadshet Function to transfer the spreadsheet (once it has been altered) into the DB. Everything worked fine when inserted into a test (temporary)...
  6. vza

    I am trying to update a field value

    I am trying to update a field value within a table using an ADO recordset Here is my code: [code] ' Connections to Access Database Dim CnAX As New ADODB.Connection CnAX.Provider = &quot;Microsoft.Jet.OLEDB.4.0&quot; CnAX.Open ConvertForm.AccessText.Text, &quot;admin&quot...
  7. vza

    Utilizing Change Event in Loop

    Is there a way to use the change event within a Loop? For example, If the change event occurs then do something else?? I dont think it is possible..just thought I'd ask... Thanks -vza
  8. vza

    Add new Event - Enumerating Record ID

    I am currently working on an front end user application for an Access DB. An ADO bound datagrid is used to display/alter/add records to the DB. Each record has an Entry_ID Field which is used to numerate the records as a record ID. Within the OnAddNew event of my grid I sent a Currentval...
  9. vza

    Excel Worksheet Range

    Quick question...Say I have a line of code like the following: rsXL.Open &quot;Select * From [Sheet1$A1:G100]&quot;, CnXL, adOpenStatic If I don't know the exact range of the worksheet i needed during runtime is there any way I could represent it in code?? Any responses would be greatly...
  10. vza

    Excel 2000 and vb - text &amp; NumberFormat method

    I am currently working on a VB application which transfers data from an Excel spreadsheet to an Access DB table. I am able to transfer most of the data except for a few cells in one of the spreadsheet columns. The problem is that most of the values within the column have number...
  11. vza

    Excel to Access

    I am in the middle of creating a Import VB application which is used to alter Excel spreadsheets into a particular format and then import them into an Access database. I am able to import the spreadsheet data onto an Access table with no problems, but for some reason numerous (about 50-100)...
  12. vza

    Windows ME AutoLogin

    I am having problems autologging in Windows ME. I inserted the following String Values into the following Registry Key: (actually also tried using TweakUI but it still will not work) HKLM > Software > Microsoft > Windows > CurrentVersion > WinLogon AutoAdminLogin &quot;1&quot...
  13. vza

    Windows ME AutoLogin

    I am having problems autologging in Windows ME. I inserted the following String Values into the following Registry Key: (actually also tried using TweakUI but it still will not work) HKLM > Software > Microsoft > Windows > CurrentVersion > WinLogon AutoAdminLogin &quot;1&quot...
  14. vza

    Runtime error - &quot; is not a name

    I want to create a program which transfers all data from a selected Excel Spreadsheet (selected ussing the CommonDialog Control) to an Access DB (also selected using a CommonDialog Control). Here is the code I have for my &quot;Convert&quot; button: [code] Private Sub ConvertButton_Click()...
  15. vza

    .RecordCount = -1 ???

    i have a question with the .RecordCount method... Private Sub UsernameCombo_Change() ' Variables Dim Partial As String Dim i As Integer ' RecordSets Dim rsSelect As New ADODB.Recordset Partial = UsernameCombo.Text If Partial <> &quot;&quot...
  16. vza

    VB6 &amp; SetLogOnInfo Method

    I am currently working on a Administrative User application in vb6. I have created a report using Crystal Reports (which came with vb6) to display all usernames and passwords listed within an Oracle table. This Admin User tool will be utilized on numerous diferent databases. The program...
  17. vza

    Excel Add-In

    I have recently installed an Excel Add-in for a third -party software package needed to retrieve data. I want to be able to automate/run this Add-in from a Macro written within VBA. I know that VBA can be used to Load Add-Ins, but is there any way VBA code can be used to physically run an...
  18. vza

    Type Mismatch

    I am creating as HTML page with VbScript. I have an ADO recordset created and opened with the following lines: The recordset basically returns a count of records existing for a specific field within a Table Dim RsCount RsCount.Open &quot;Select Count(Field) As FLDCOUNT From Table&quot;, Cn...
  19. vza

    Connection.Execute method error

    I am trying to execute a SQL statement from VBScript. The statement works in Oracle (SQL*Plus) but creates a Oracle Error within my HTML/ASP page Error: ORA-00900 Invalid SQL statement. If this same statement works within Oracle, why not within an ADO connection Execute statement?? I don't...
  20. vza

    Connection.Execute Method Error

    I am trying to execute a SQL statement from VBScript. The statement works in Oracle (SQL*Plus) but creates a Oracle Error within my HTML/ASP page Error: ORA-00900 Invalid SQL statement. If this same statement works within Oracle, why not within an ADO connection Execute statement?? I don't...

Part and Inventory Search

Back
Top