Search results for query: *

I have a query that I'm working on which has the requirement that it calculates a netloss carryover (it's an accounting app, so accounting algorithms aren't my strong suit). The current netloss carryover field should add the income and netloss from the previous month. I found a running total...

I have code, found on the Internet, which can send an email to gmail (via an internal relay). How do I add an attachment of a report in the database? I can't use Outlook (I have code for this that has worked for years, but we're no longer using Outlook) due to switching to web-based email, and...

I have a datagrid that creates a dynamic linkbutton control if the column contains an attachment field. This linkbutton should download the file, but doesn't (The popup comes up, but then says unable to download file). I get different results on 3 different browsers. Ok, first, I have a...

I have an application which was written in .NET 1.1 that used a datagrid that I would dynamically change a cell into a link based on the column and security settings. For example: Column is an ID field and user has access to the record - Show a link. Column is an ID field, and user does not...

Note - I'd ask this on Microsoft's Technet Forums since it's more browser specific, but the firewall at work blocks Microsoft's live.com as a web-email service, so I can't log in... ("Security Wars"!!!) Anyway, Google Chrome recently disabled support for showModalDialog (version 37), and I've...

I have a query that I'm trying to create for Access, with limited success (data's not always correct, and can be very slow). Anyway, the query works in a similar way to this (only I was trying to change the Having clause to count if the item didn't say "close", and ignore those IDs)...

I created a simple test application that automatically sends an email (it's eventual use will be sending secure email based on what's in a table - yes, I know about SQL Server 2008's email capabilities, but it's not set up, and I'm not the one that sets the servers up). This application works on...

Maybe I'm asking or wording this wrong, but how do I loop through the fields that the report uses without running the query again? I have a report that gets data from a crosstab report for a survey(thus, the fields are dynamic). So, the results might look like this: Run1: Question1...

I have a few data projects (.adp) in Access that I need to not only change the server name, but make it not hard-coded. These are probably 10 years old, and the original programmer is long gone (the project was probably written in Access 97 or 2000). I'm not familar with project files since I've...

Not sure if this is more of an Access issue, or Windows issue, but it relates to Access. I have a vbscript which creates System DSN using an account with administrative rights. This script works fine in Windows XP computers, and Windows 7 computers. The ODBC connection is added to the System...

Not sure if this goes under MS Access or MS SQL... Not sure if this should go under SQL Server, MS Access, or even VB6 (if such a forum even still exists). Here's a brief history here - I have a client with a 15-year-old front end program (Asset Tracking) written in VB6, contains zero...

I'm using SQL Server 2000, and I have a query that gets names and locations, sort of like this - Name Location Mary Atlanta Sue Chicago Sue Seattle Jim Boston Jim Chicago Jim Miami I want to get the locations on a single line like below. I know SQL Server 2008 has wm_concat(), but the...

First, before you ask why we have old versions of software, we're in the process of upgrading. Long story short, complex applications, not enough programmers, limited State budget. Recently, we had a massive update (120 items!) be pushed through our network. This update caused issues with my...

I have a question on optimizing a query for MS Access. The database that is being used is an Access 2002/2003 database - with everyone using Access 2007 - accessing SQL Server 2000 (we're in the process of upgrading to SQL Server 2008 now). This database is a work review database, with local...

I have this old MS Access survey (created by another programmer) that's... let's just say I dread having to change or modify one question or more every year or so, which takes up to a month to do, not including testing. It has... - hard coded column names as the question (i.e., Q1, Q2, Q2A...

I have a search page in my application where the user enters one or more search options, and displays a datagrid. I put a "view detail" button which will pop up another page (using javascript) that shows a read-only version of the add/edit screen. Session("sqlDBSearch") gets a datatable with the...

I have a MS Access 2003 database whose forms have suddenly disappeared. I've tried re-importing, dragging and dropping, and even creating a new form, but nothing displays in the forms window, even after closing out and reopening it. The only thing I can think of is that someone was using MS...

I have an unbound (dynamic) datagrid which sometimes has a column with a date field that needs to be formatted to show as '1/1/2009' instead of '1/1/2009 12:00:00 AM'. This works, however, it's when I have another column with values like "11-10", "11-11" (these are special code fields that the...

Is it possible to set up Access 2007 options using a vbscript? There are 14 MS Access database applications, plus about 70 read-only databases (SQL backend) for querying that need to have options set on them that are in Access 2003 (some may be Access 2000 format) that aren't set in 2007. I...

I have a script which has been running fine for 3 years. It runs monthly, and on the 1st of each month, it copies the previous month's data to an archive folder and inserts the month and year into the filename. It works if I do it on my local computer, so I'm guessing it some sort of directory...