Search results for query: *

I have created a number of jobs that call SSIS pacakges to import data and stuff. In Excel I've set up an interface that lets me run these jobs by calling stored procedures that call the jobs, etc. Works perfect. Yay! But... When I had another user test this out it fails. Well it turns out that...

I have a table that lists a business code and then 5 fields of business information. Other tables will refer to that table using the business code to get business information. Once in a while one or more of those 5 fields will have a change. When we make a change we only want it to apply to new...

As I was double checking some of my queries I discovered an oddity. An update query I have updates 12831 records, but the identical select query shows 13022 records. Aroo?? The query updates one field to "X" based on some criteria. There's nothing special about the field. It's set as...

Oophda, this is a tough one to explain. The little gerbils in my brain are squeaking their wheels in a way that makes me think I can do this but I think they need a few nudges. We have a table with account numbers, status codes, status dates, and a number of flags. Part of our metrics involves...

Hi everybody! We're upgrading from an Access 2003 database to SQL Server. I'm a complete neophyte to SQL Server but of course have a passing knowledge of SQL from Access and VBA. Currently one step in our project is to remove duplicates. What I do right now is go through the recordset and...

Hi, is there a way to create folders in the "Tables" or "Stored Procedures" groupings? We're going to have a number of tables and procedures and it'll start to get very confusing if it's all just one big long list. Even if we do something like...

Hopefully this is the correct forum for this question. I've recently been designated to be the developer for a large project that will eventually involve some data analysis and reporting. We started out using Access as that is the only tool currently available to us and we quickly learned that...

Hi, we're in the process of moving from a bunch of Access databases to a SQL Server environment. I have no experience with SQL Server (we use a lot of Excel, Access, and VBA here), but I'm managing to figure things out so far except for one issue. I've built the tables and made some queries...

So I have an Access 97 database that some of my users need, and the database needs data from Access 2000. In A2000 I link to A97 and pass data to A97. I have vbscript that can be run outside of access that'll run A2000 code, but it's annoying for the user to have to run the script and then go...

Is there a way to disable the "Print..." button in the Print Preview screen? In VBA I tried to use "ActiveSheet.PrintPreview EnableChanges:=False", but that didn't do anything. We are using Excel 2000. Thanks! Shane

I'm new to HTML, ASP, etc. so I hope someone can offer some suggestions! I'm trying to create an order web page for my company. So far I've managed to figure out how to access my Access database, create a log-in page, and a dropdown list populated from my database by reading tons of various...