Search results for query: *

I'm trying to format an autogenerated column in a gridview and I'm not sure why my current code isn't working. My results display without error, but without any formatting. Please help! Here's the code: GridViewInceptionToDateExpenseReport_RowDataBound(ByVal sender As Object, ByVal e As...

I have three tables in a relational database: User, Expense, and ExpenseDescription. User Table Fields: UserID, Name, Age Expense Table Fields: ExpenseID, Amount, ExpenseDescriptionID, UserID ExpenseDescription Fields: ExpenseDescriptionID, Description Problem: I need to write a summary...

Hi All, I'm considering setting up an internal website for my department at work. This site would be used for retrieval of data from databases throughout the company's infrastructure and other odds and ends. I'm trying to get an idea of what kind of hardware and software I would need to budget...

Here's the situation: I have two DB connections ConnA (DB2) and ConnB (SQL Server). I need to bind a datagrid to the results of a query which joins a table from ConnA to a table from ConnB. Can someone please tell me how I should be going about this? I'm relatively new to asp.net so I'm only...

I have two tables from unrelated systems. The only common field for the tables is an amount field. I would like to return a result set of which amounts match, without repeating any match. For example: Table A Table B ID Amount ID Amount ----------------...

I have a table that lists Golf round scores like this: Golfer Score -------------- 1 85 1 100 1 77 1 99 2 110 2 33 I need to create a query that results in the average of each golfer's lowest 3 scores. I'm at a loss with this. I was hoping...

I'm trying to create a support table that will be used to append a description field to rows in my main table. An example of what I'm talking about is below... Main table COMPANY | AMOUNT ----------------- Comp1 100 Comp2 200 Comp3 300 Support table COMPANY |...

I'm relativly new to ASP.net so I'm really just looking for some advice/direction. I have currently built a page that returns a summary report in a gridview control based on user input date ranges. I basically just set the datasource to an SQL statement and bound the columns to the fields. It...

When I am using Outlook I would like the following code to execute when I push Control+M. Can anyone help me out with this? Sub SendMessage() Dim Message As String Message = InputBox("Enter your message and press enter.", "Enter Message") Shell ("Command.com /c net send u54p37 " & Message)...

I've seen similar post to this when searching, but couldn't find an answer simple enough for what I'm looking for. I have webpage that accepts input for a query and outputs results in an HTML table. Is there a way to send these results to excel using Javascript? Any help is greatly...

Can anyone tell me why I'm getting the "Runtime error 13: Type Missmatch" when trying to run the following code... Public Sub CreateAuditTable() ' Dim MasterRS As Recordset Dim AuditIDs As Recordset Dim TranCounter As Recordset Dim db As DAO.Database Dim NumTrans As Integer...

I don't really know what direction to go with on this problem. Here is the situation: I have a list of transactions with the UserIDs of the employees that entered the transactions for a given month. for auditing purposes I need to retrive a random 10% of the transactions entered by each...

I have data in the following format. -32.90 +342.20 +0.01 +1,000.32 -405.23 Does anyone know the best way to input data from this format? Thanks.

I have to make around 1000 Outlook reminders for different users in our accounting department to record certain payments at certain dates. I have an excel spreadsheet with all of the information. It looks like this: User PaymentDate Payment Description Does anyone have a good...

I have a problem figuring out the following query: Initial table: Contains approvals for expense report submissions. Fields: ReportID, FirstName, LastName, ApprovalDate. Problem: There can be more than one record for each ReportID (i.e. Multiple approvers for a report). What I would like my...

Everytime I try to save the following query in Access I get an error message "invalid arguement". Does anyone know what I need to change to get this to work? SELECT dbo_traveltransaction.LASTNAME, dbo_traveltransaction.FIRSTNAME, dbo_traveltransaction.DEPARTMENT...

I have several Excel workbooks with multiple worksheets in a specific folder who's datasource is an Access database I update daily. Currently I have to open and refresh every worksheet for every workbook when I update the database. What I'm wondering is: is there a way in VBA that I could...

I'm writing a query that consists of an expense approval sumission table, an approver table, and an associative table connecting the two. Some submissions have two approvers, and some have only one. The way my query works right now, I get two duplicate rows, except for the approver field, when...

I'm in the process of writing a large query linking many tables and one table keeps tripping me up. SQL plus tells me this table doesn't exist, however when i use the Oracle Enterprise Manager Console, the table is there (I can see its structure and data). When running this simple line...

It is my responsibility to produce reports from an Oracle database. This would be fine except that the data dictionary that was given to me to write my queries seems to be way off. I'm using SQL plus and I am not very familiar with oracle. Is there a way that I can find out what tables are...