Access 2003: I have this database that is truly awesome along with some equally awesome queries. Co-workers have recognized this awesomeness and want to start running their own queries but know nothing of Access. Is there a user-friendly option? [more inside]
posted on Jul 1, 2008 - 4 answers
What books / reference materials / training resources for Access 2003 can you recommend for a n00b? [more inside]
posted on May 14, 2008 - 3 answers
How can I mail-merge data from MS Access to Word from two different database tables? [more inside]
posted on Mar 5, 2008 - 6 answers
At work, I'm being asked to maintain an older Access 2003 database. The database sits on a network drive, but it requires that network drive to be mapped to Y:/. This is a problem because all of the users have it mapped to different drives. How can I get it to stop referencing a specific drive letter? [more inside]
posted on Mar 3, 2008 - 3 answers 
I need to query data from another table that I'm already writing to. [more inside]
posted on Feb 6, 2008 - 6 answers
I want to make a dictionary database of words, where I can query part of speech, spelling patterns, pronunciation patterns, number of syllables, definitions, etc. Is Access best for this? Or are there other smaller, free applications you would suggest? Ideally I would like a lot of control over query output layout. Ease of use is important. (I never felt Access was so user-friendly [maybe that's true of all databases in general], but I'm a whiz at Excel. Unfortunately, using XL as a DB isn't very pretty.)
posted on Jan 29, 2008 - 4 answers
Help me design a small Access application to run a prize drawing. As I see it, the MC will open the application and click the Draw button, which will select from the available prizes for that month. Once drawn, that prize becomes unavailable. MC will then type in the winner's name and click Save, setting the form ready for the next contestant.
Specs and examples follow. [more inside]
posted on Jan 16, 2008 - 8 answers
Good, inexpensive, (preferably free) online course or certification in MS Access or other database software? [more inside]
posted on Dec 6, 2007 - 1 answers
Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted on Nov 19, 2007 - 12 answers
Forgive me for asking such an embarrassingly basic MS Access question. I have two voter lists. Each one has a list of voters, and each voter has a unique identifying number as well as some other fields. There are some voters who appear on both lists (having identical voter numbers on both lists) and some voters who appear on only one. I am only concerned with the voters who appear on both lists: how do I import some fields from one list to the other so that the unique identifying number for each voter is matched by that voter's data from the other list?
posted on Sep 9, 2007 - 7 answers
Rather continue to work with Microsoft Access, I'd love to move a few old databases I continue to maintain into a www database app, if one exists. I'd like something that feels Access-like, with the ability to structure queries and forms as Access does. I'd happily accept a script package that I can easily install and maintain on my own web server, or a full service. Is there such an Access corollary, either free or available for purchase?
posted on Jul 2, 2007 - 10 answers
How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted on Jul 2, 2007 - 3 answers
Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this. [more inside]
posted on Jun 6, 2007 - 5 answers
How can I make Microsoft Access 2002 crank out organized web pages that conform to my design ideas? [more inside]
posted on May 14, 2007 - 2 answers
MS Access Question: I have two tables in a db file. One has a large list of single cell records and the other, a smaller list of records to be compared against the larger table. The issue is that I would like to use the values in the smaller table as wildcards to return like matches that are like the records in the larger table. Example follows. [more inside]
posted on Apr 27, 2007 - 3 answers
Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted on Apr 18, 2007 - 9 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted on Dec 13, 2006 - 3 answers
Help with MS Access needed please - I'm told it should be a fairly simple query to conduct, but I don't think I'm upto the task solo. Can the hive mind help? [more inside]
posted on Nov 18, 2006 - 12 answers
Need to figure out the best kind of database for a small but growing business. MS Access isn't cutting it anymore. Of course there's [more inside]
posted on Nov 5, 2006 - 32 answers
What is the easiest way to get this data into a MySQL database? [more inside]
posted on Nov 2, 2006 - 19 answers
I've got an interesting question about MS Acess. It involves using lat/long data... Anyone care to help? [more inside]
posted on Nov 2, 2006 - 15 answers
I got the job. Now I need a little help with it. Someone I briefly worked under while at this job has posed a Microsoft Access question to me. I understand a good amount of Access but this was immediately over my head. I told her that I would see what I could find out for her. [more inside]
posted on Oct 18, 2006 - 10 answers
How can I increment a value directly using SQL? [more inside]
posted on Jul 17, 2006 - 3 answers
OSX Databases: I have just migrated to Mac OSX from MS windows but have left behind several MS Access databases of varying complexity. [more inside]
posted on Jul 3, 2006 - 6 answers
Dealing with no-records cases in Access [more inside]
posted on Jun 14, 2006 - 6 answers
Infuriating Microsoft Access questionfilter: I have a database that I inherited in which queries are set up to pull records which have dates of birth between certain dates. It works right in one database but is not working right in another, for a very particular reason.. [more inside]
posted on May 2, 2006 - 7 answers
How can I print multiple MS Access Snapshot files (.SNP) in Windows 2000/XP at the same time? [more inside]
posted on Apr 26, 2006 - 1 answers
How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access? [more inside]
posted on Apr 19, 2006 - 6 answers
Access DB Filter: Help me figure out how to make a pretty report. [more inside]
posted on Apr 4, 2006 - 3 answers
We're outgrowing our 10 year old Progress database. We need some recommendations. [more inside]
posted on Mar 27, 2006 - 13 answers
How can I import selected fields from one database into another database? [more inside]
posted on Mar 16, 2006 - 6 answers
MS Access XP: Say I have 3 tables. [more inside]
posted on Mar 3, 2006 - 12 answers
What is the best and/or most efficient website design software these days? [more inside]
posted on Feb 27, 2006 - 11 answers
What is the best alternative interface for an SQL server? [more inside]
posted on Jan 12, 2006 - 6 answers
How difficult is it to switch from MS Access programming to Delphi? [more inside]
posted on Dec 12, 2005 - 17 answers
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted on Dec 9, 2005 - 9 answers
I need to become a database-design expert ASAP! [more inside]
posted on Nov 11, 2005 - 20 answers
How do I import data into a table in an Access database in such a way that the new table will retain all of the relationships currently extant in the database? Is there a way to make a new table and overwrite the old table (say the table is called 'users') and preserve the relationships?
posted on Nov 3, 2005 - 6 answers
Is there any program that runs natively on OS X that would allow me to work with a Microsoft Access database? Or am I doomed to run SoftPC? [more inside]
posted on Sep 28, 2005 - 5 answers
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
posted on Sep 2, 2005 - 5 answers
Isn't there some simple way to list out all the fields in all the tables in an MS Access database? [more inside]
posted on Apr 28, 2005 - 3 answers
Visual Basic 6.0 and Access 2003 question.....(more inside)
posted on Jan 26, 2005 - 4 answers
Database Query [+]
posted on Jan 24, 2005 - 11 answers
I am a freelance journalist, and a document freak. But also I am very chaotic. I would like to use some sort of database to keep track of the articles, documents, web snippets, references, quotes, URLs, bibliography that I use in my work. But I have many questions and doubts [more].
Should I use a database that it is linked to the external documents (which I keep nonetheless), or should I go for a database that has all of these documents embedded? I work in a Windows / OSX environment (desktop PC and a G4 Powerbook), so this keeps me from going all the way to Access (which I hate) or Filemaker (which I don’t know very well). I’ve been thinking of keeping a MySQL database server, maybe powered with a modification of something like Everything, and accessing the data via web browser, but I fear that the thing wouldn’t escalate well. (Keep in mind that I am not a programmer, I can install Movable Type or GeekLog in my webserver, and tinker a little with php files changing little things here and there, although I have friends that can help me)
I don’t know if there are built-in solutions for what I need, or if you can point me to a database template (for Access or FileMaker) already built for journalist research. The fact is that I have tons of information and documents (some of them already stuffed in CD and DVD backups), but I have a hard time keeping track of everything, and very often it is very difficult for me to retrieve information that I know I have saved but I can’t tell where it is.
posted on May 11, 2004 - 9 answers
Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
posted on Apr 17, 2004 - 15 answers
