The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
136 views

Does MS Access update the data on the clipboard from a query when the data in the database changes?

I was just debugging a macro in MS Access, and when it hit the breakpoint ran a query and I copied the data from it to the clipboard. Some of the values were null before stepping to the next step, ...
1
vote
1answer
624 views

Query data in Powerpoint

I would like to build an MS PowerPoint 2010 presentation where some of the displayed data would be queried from an external source (I am flexible - the simpler the better, I need to update that ...
2
votes
2answers
512 views

Matching similar records in a database with Group By

I have a database in which there are company names each matched with the company post code. However there are duplicates since the company names are written multiple ways, like this: Company Name ...
0
votes
3answers
766 views

Free Database Utilities / Tools for Mac OS X

If I were using Windows and wanted to use a database I would set up a WAMP server. What can I use for Mac OS X? I'm currently using SQLite via Mike's T Sqlite / Firefox addon for SQLite. I would ...
0
votes
1answer
3k views

Automating Access 2007 Queries (changing one criteria)

So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll ...
0
votes
1answer
5k views

Combine fields from multiple tables in Access query

As an example, I have two queries in Access. The first outputs two columns: | Cust ID | Revenue 1 | | A | 5 | | B | 10 | The second query is similar: | Cust ID | ...
0
votes
1answer
566 views

Graphical Decision Engine Framework - Any ideas?

Is there an open-source decision framework I could use? What I am looking to create is some kind of graphical interface to allow people to visually build a query based on a set of parameters, ie. ...
2
votes
1answer
874 views

How do I get Excel to run a query for each row in a spreadsheet?

Is there a way to run an MS Query for each row in a spreadsheet? For example, I have a sheet that looks like this: CustomerID 111 222 333 I have the customer's address in a database, and I'd like ...
1
vote
1answer
958 views

Where is a Web Query stored in an excel file?

I have a Web Query looking at a site for data, and it gets the table selection wrong. Viewing source of the linked to web page I am able to identify the correct table. In an Excel Web Query you are ...
2
votes
1answer
2k views

Embed microsoft query in excel with multiple parameters from spreadsheet

I am trying to embed a microsoft query within an excel spreadsheet, that passes several parameters from the spreadsheet to the query. I would like the microsoft excel query function to find a few ...
0
votes
2answers
657 views

Is there a way to query file names in a directory within Access 2010?

Is there a native function for this within Access? Or would I have to do this with a batch script somehow? Moreover, could I rename the files in a directory based on fields in an Access table?
0
votes
2answers
136 views

SQL/DB browser for DB2

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.
0
votes
1answer
826 views

Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?

I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.? The query has the globe to the left of ...
1
vote
1answer
375 views

Query dpkg for All Packages Installed/Removed from Default Image

Is there any way to query dpkg to tell what packages have been added/removed since the base install of a system? I am running Debian 5.
4
votes
2answers
4k views

Pass parameter from Excel to Access query

I have a Access (2010 but I've also tried Office 2003) database with a lot of tables, forms and nested queries which rely on data entered in a form, e.g. WHERE query1.year=[Forms]![Form1]![Text0];. I ...
0
votes
1answer
40 views

Managing records of bugs and notes

I want to create a knowledgebase for a piece of software. I'd also like to be able to track bugs and common points of failure in that application. Linking knowledgebase articles to bug records would ...
0
votes
0answers
473 views

Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today

I'd like to use Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today. Is there reserved name that I can use, like TODAY-30 under the filter criteria?