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...
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...
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...
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
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)...
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 = "Microsoft.Jet.OLEDB.4.0"
CnAX.Open ConvertForm.AccessText.Text, "admin"...
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
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...
Quick question...Say I have a line of code like the following:
rsXL.Open "Select * From [Sheet1$A1:G100]", 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...
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...
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)...
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 "1"...
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 "1"...
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 "Convert" button:
[code]
Private Sub ConvertButton_Click()...
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 <> ""...
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...
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...
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 "Select Count(Field) As FLDCOUNT From Table", Cn...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.