Join 3,421 readers in helping fund MetaFilter (Hide)

353 posts tagged with access. (View popular tags)
Displaying 1 through 50 of 353. Subscribe:

Related tags:
+ (105)
+ (46)
+ (37)
+ (35)
+ (34)
+ (27)
+ (23)
+ (20)
+ (14)
+ (13)
+ (13)
+ (13)
+ (12)
+ (11)
+ (11)
+ (10)
+ (10)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)
+ (6)
+ (6)
+ (6)
+ (6)
+ (6)
+ (6)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)


Users that often use this tag:
desjardins (9)
benjh (5)
Jimbob (4)
dy (4)
dance (4)
JonnyRotten (4)
strangelove (3)
monkey closet (3)
SirStan (3)
diode (3)
jeather (3)
Just this guy, y'know (2)
charred husk (2)
Admira (2)
Proginoskes (2)
ctmf (2)
doomtop (2)
JeremiahBritt (2)
Foam Pants (2)
Servo5678 (2)
Brainy (2)
sandra_s (2)
mtstover (2)
mecran01 (2)
horseblind (2)
bigmusic (2)
By The Grace of God (2)
elgilito (2)
keep it tight (2)
Anonymous (2)
rosswald (2)

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

A Microsoft Access Class

At work, I have been deemed the person in my group who should learn Microsoft Access. I am allowed to take a class. Can anyone recommend a good Microsoft Access class in NYC? [more inside]
posted by millipede on Jun 18, 2014 - 7 answers

What's going on with my girlfriend's wifi/LAN?

Recently my girlfriend switched internet providers, from Verizon to Time Warner. Since installing the new Time Warner-provided router, we've both been having problems with our phones seemingly not being able to use certain apps or services. [more inside]
posted by Venadium on Jun 11, 2014 - 10 answers

Looking for an advanced Excel/Access crash course

VBA and Macros and VLookup, Oh My! I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start. Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
posted by firechicago on May 19, 2014 - 2 answers

*shakes fist at Elsevier*

I'm heading into the Army for OCS in August, but I'm still very interested in keeping current on science and the current research papers. I've devised a contrivance to keep myself plugged in and reading - a personal blog where I summarize the papers that interest me, more simply to give me a place and a reason to do it. [more inside]
posted by Punkey on Mar 23, 2014 - 10 answers

How do I create a multivalue column from delimited text in Access 2010?

I want to take a comma delimited list of values e.g. "bacon, sausages, eggs" stored as a single text field and store these as selected values in a single multi-value lookup field. [more inside]
posted by tsh on Feb 24, 2014 - 6 answers

All my base stations belong to someone else

Lately when I turn on my Mac, it detects an Airport Extreme base station. I don't know where the station is; I don't have one and I don't know the password to the one being detected. The Airport Extreme is chosen instead of my home network for internet access, and even when I manually cancel it and choose my own network, I sometimes lose connectivity as the computer returns to the Airport Extreme as a default connection. Lately, this is also happening with a PC and a Kindle, making it hard on all devices to choose my home network and keep it as a default.
posted by layceepee on Feb 15, 2014 - 2 answers

Boosting my Wifi Network

I just moved into my first multistory home. Time Warner Cable installed their wifi modem on our second floor, and we have a very weak wifi signal in our (finished) basement. I'd like to know how to boost our wireless signal with minimal sacrifice of bandwidth/speed, and without having to have TWC come in again and move our modem to the first floor. Details within. [more inside]
posted by zarq on Feb 15, 2014 - 11 answers

Convert rich text field in Access or Excel into plain text

I have thousands of rich text message message fields currently formatted in RTF (rich text format) that need to be stripped of their formatting and converted to plain text. Currently the field is in a Microsoft Access database. But if needed, the database could be sent to Excel if that would ease the conversion of the RTF to plain text. [more inside]
posted by Jackie_Treehorn on Nov 12, 2013 - 16 answers

Changing manual timetabling to electronic

I receive timetabling data in Excel spreadsheets and want to map it out automatically, rather than working out the timetable/grid by hand every time because the data changes, and I'd also like to filter it to show certain groups - teacher for example. [more inside]
posted by b33j on Oct 14, 2013 - 5 answers

Ideas for helping elders get access to Internet music

Are there any good resources for helping a low-income senior get Internet access? [more inside]
posted by steinsaltz on Oct 7, 2013 - 4 answers

Access Training similar to Excel Everest?

Is there a good Access training option where you learn it by working in the program interactively rather than just watching videos or reading text?
posted by ewiley28 on Jul 25, 2013 - 2 answers

Looking to extract more info from this database

We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira on Jul 17, 2013 - 11 answers

Can't reach one particular website/domain

Asking for a friend: Despite not having changed hard- or software, my friend can't access a website that is up and running normally. He can access it (and his account) from other locations (i.e. friend's place), just not from home. What's going on and how does he fix it? [more inside]
posted by MinusCelsius on Jul 8, 2013 - 14 answers

Which Selling Platform is Best?

I am working on a list since 2004 that I think would be salable. It's publicly available contact information for radio, TV, magazines, syndicates, newspapers, book publishers and agents. I'm a freelancer and I originally started it because I wanted to be able to reach these sources to interest them in my content. But I realized it could be a product. [more inside]
posted by CollectiveMind on Jun 27, 2013 - 4 answers

Solutions for 'renting' internet while in a remote location?

I will be renting a cabin in a remote area in the US (mountains outside of Asheville, NC) and need to have internet access from my laptop for one day. I looked at maps of coverage and it seems like only 1 local carrier has a nearby tower. What are my options? (more inside) [more inside]
posted by NikitaNikita on Jun 20, 2013 - 8 answers

Advice on getting 88 yr old into a car/sedan who can't lift her feet.

We will be needing to drive an elderly relative to various locations over the next few months to help her find and relocate into a new retirement home.. She has had extensive spine surgery and is unable to life either foot up more than about one inch and maybe not even that. I have been looking for a temporary device (under $100.00) that we can use on these occasions but have no idea what to look for. She uses a walker - refuses a wheelchair. She's tried the "bottom in first" then swinging her feet in but that still involves lifting them. She used to be able to do that but no more. Maybe the only solution is to get a cab with sliding doors that opens down on the street level and she follow behind us in the cab but that would be expensive and time consuming as we would have to have the cab wait while she is inside being interviewed, taken on inspection, etc.
posted by Tullyogallaghan on Jun 18, 2013 - 15 answers

MS Access Combo Box Fields behaving strangely.

I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
posted by Jimbob on Jun 9, 2013 - 1 answer

Assigning a keyboard shortcut to a macro in Access 2007

Is there a simple way to assign a keyboard shortcut to a macro in Access 2007? I understand that macros behave differently in Access than they do in Excel (which I'm more familiar with). I have written a sub called "ImportAll" in Module1. I'd like it to run when I push Ctrl+I. How would I go about achieving this?
posted by Proginoskes on May 10, 2013 - 4 answers

Learning to use VBA

I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes on Apr 6, 2013 - 3 answers

Help me Access my SQL!

Ok, I have an application that is using a back end of MS Access...I have another application that needs to get some of the data in the Access db but it is only SQL compatible. So...how do I set up an ODBC connection that will pull data from the Access db and write it out to a SQL db? This data needs to be updated hourly... Thanks for your assistance!
posted by keep it tight on Mar 14, 2013 - 11 answers

Best practices for software development documentation

I do some developery-type stuff at work and the more complicated it gets, the less organized I am. I often find myself wondering why I did this or that or what I was trying to accomplish with it. I reuse a lot of the same functions and bits of code but I don't have a good system of keeping track of them. I know about commenting within code, and I do that, but I'm looking for a larger system of general best practices more than a specific solution. [more inside]
posted by desjardins on Mar 12, 2013 - 15 answers

Flying tips with a baby

My Wife and our 1 year old and I are about to embark on a 3 leg trip. I'm after generic airport/airline tips for babies but I have a few specific things to address. [more inside]
posted by Admira on Mar 4, 2013 - 15 answers

Building a house to accommodate pain and disability

Everything I do, all day, every day, hurts. The more I do things that are painful, the more the pain snowballs. We're going to build a house that we hope will help reduce the accumulation of pain, and maybe even let me recover a little. Help me make sure I'm covering all the bases in house design accommodations. [more inside]
posted by galadriel on Feb 13, 2013 - 35 answers

Data Driven Clinical Care - Dynamic Graphing Website

I would like advice on creating a dynamic graphing website to display clinical data on a intranet website to better aide clinicians. What my superiors are seeking is a "Data Mall." My programming/server-admin. experience is minimal, but my Linux-hobbyist mentality hates the MS Access solution that is being built. [more inside]
posted by rosswald on Jan 16, 2013 - 4 answers

Comma delimited list to multiple lookup values in Access 2010

Is there an easy way of turning a comma-separated list into multiple lookup values in access 2010? [more inside]
posted by monkey closet on Dec 14, 2012 - 1 answer

Advice needed: moving a MS Access DB to the cloud..

Our small office uses a MS Access database daily for non profit work. The database is small enough where I'm not certain it warrants upgrading to SQL. Most of the work done in the database is remote (7 users total) so we are looking to move from a standalone PC w/remote access to the cloud. I would greatly appreciate any advice with regard to moving the DB to a cloud service provider that supports MS Access. One that is reliable, is relatively easy to admin e.g., backups and lastly, inexpensive.
posted by Sagres on Dec 3, 2012 - 4 answers

Printing one form

Access - trying to get by with the easiest way. There's a form and a table. After the form is filled out it needs to be printed and go to the table. Going to the table is fine. The problem - if the exact sequence of clicks is not followed then you print all the forms. Macro? Other ideas?
posted by notned on Nov 26, 2012 - 2 answers

MS Access remains not user friendly for printing

I've switched my Access 2010 database from using Switchboard to using a Navigation Form. It's prettier and faster and it makes it impossible to print reports properly. [more inside]
posted by jeather on Nov 7, 2012 - 6 answers

What sort of database for a non-profit training organisation?

I need to organise some kind of database for my non-profit training organisation, to track students, courses taken, etc in Moodle, and possibly to integrate with a Joomla site as well. I've been told that Access will not work for us. Will a Customer Relations Management thing suit us, or is something more required? If so, what should we be looking for? Requirements and constraints inside. [more inside]
posted by harriet vane on Sep 18, 2012 - 4 answers

Relational database on the cheap

I'm looking for a free/cheap alternative to Access or Filemaker for simple relational database work. [more inside]
posted by philosophygeek on Sep 13, 2012 - 9 answers

Seeking on-line training in MS Office

Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg on Sep 4, 2012 - 8 answers

Access Concatenation Crazy!

In Access 2010 I've come across a need to concatenate fields from one column in one table into a single, comma delmited value in another field in the same table (or in another table if I absolutely must). [more inside]
posted by horseblind on Jul 25, 2012 - 13 answers

Accessible Access Training?

Microsoft Access Training/Classes in New York City (Manhattan), or your best suggestion of online materials. [more inside]
posted by rosswald on Jul 20, 2012 - 4 answers

Help me Normalize

I need to split a field in a database into lots of fields, in order to normalise the database, but I can't figure out how to do it. [more inside]
posted by Just this guy, y'know on May 4, 2012 - 6 answers

Web front end for SQL Server?

Are there really no web front end design environments that are as stupid simple as MS Access form design for a SQL Server back end? I can write a real clever stored procedure for SQL Server and assign cute and short aliases to every element of the result set and crank out an Access form or forms in no time and distribute it as a light weight front end with only execute permission required. Is there some analog for a web front end? [more inside]
posted by Rafaelloello on Apr 24, 2012 - 4 answers

Excel keeps unreferring my references

Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]
posted by jeather on Apr 18, 2012 - 2 answers

How to obtain recent Foreign Service Institute learning materials?

How do I obtain newer Foreign Service Institute language learning coursework and education materials? [more inside]
posted by andendau on Mar 31, 2012 - 3 answers

Where did my DAO go?

Microsoft Access programming problem - what do I have to configure in my database to make use of the DAO object? [more inside]
posted by tdismukes on Mar 26, 2012 - 2 answers

Formatting MS Access report with subreports and subforms in pivot views

Microsoft Access: Help me streamline (or completely automate) creating weekly reports that include tables and charts. I'm almost there, but I just can't wrangle the formatting. Is it me or is it Access? [more inside]
posted by GPF on Mar 17, 2012 - 6 answers

Why does Access change my pivot chart view?

A Microsoft Access issue: When I try to add a new variable to a pivot chart, the chart goes to a weird zoomed-in view. In this view, I can't add any new variables, nor see any trends. If I change to a different view, then back to pivot chart, everything appears as it should. [more inside]
posted by BevosAngryGhost on Mar 8, 2012 - 1 answer

Better Living Through Queries

Help me help myself- Please recommend books or websites that will help me to better understand SQL. [more inside]
posted by bluejayway on Mar 1, 2012 - 11 answers

Need some pointers on creating a simple inventory database

Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
posted by smoothvirus on Feb 22, 2012 - 8 answers

MS Access Query Query

Complicated (or probably not complicated) MS Access question that I'm not sure how to google for. [more inside]
posted by Just this guy, y'know on Feb 20, 2012 - 5 answers

my virtual desktop

I'm a low- to medium-grade computer techie. I've recently fallen in love with the remote desktop concept (I've been using TeamViewer). I have my main PC with all my data and the software I use, setup how I like it, and then remote into that from mobile devices, friend's computers, work computers, etc., even my laptop I now prefer to use as a portal into my main PC. [more inside]
posted by Xhris on Feb 13, 2012 - 14 answers

Designing a gradebook database

MS Access / relational database question. I'm trying to set up a database for a gradebook for multiple classes, that I can maintain indefinitely. I've got the basics in terms of tables for students, classes, etc. But in my ideal world, I'll be able to do item analysis, too -- like seeing what proportion of students got Question 17 correct on a certain exam, or pulling up the specific items that a student missed on Exam 3. The only way I can think of to get this level of detail is with a junction table that has a separate record matching up each test item with each student for each exam. Of course this will eventually swell into hundreds of thousands of records (students * test items * exams * classes * years). Am I thinking about this correctly? Is there a better way of designing this? Are there any examples you can point me to of databases that accomplish similar things? Thanks!
posted by svenx on Feb 10, 2012 - 15 answers

Connect to access with php

How do I connect, dsn-free, to a passworded Access (.mdb) database with php (5.2.4)? Google throws up lots of methods - none seem to work.
posted by monkey closet on Jan 9, 2012 - 5 answers

MS Access newbie needs advice!

MS Access 2010 Help - I need to create something that allows a small group of people to add records and search records within a database and after much googling I'm thoroughly confused. [more inside]
posted by heavenstobetsy on Dec 30, 2011 - 5 answers

3G Access for My MacBook?

Can I get 3G access on a new Macbook Pro? If not, what is the least expensive alternative for my situation? [more inside]
posted by kmel on Nov 18, 2011 - 9 answers

puzzling over a query

I'm trying to write a SQL query on an 8 year old broken Access database that I didn't build, now on Access 2007. It's fun, I tell you what. I'm having trouble with a left outer join. [more inside]
posted by hotelechozulu on Oct 28, 2011 - 5 answers

Page: 1 2 3 4 5 6 7 8