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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg
on Sep 4, 2012 -
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 -
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 -
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 -
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 -
How do I obtain newer Foreign Service Institute language learning coursework and education materials? [more inside]
posted by andendau
on Mar 31, 2012 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
How do I efficiently pull this data from an Access 2003 database. [more inside]
posted by VTX
on Oct 25, 2011 -
I want to learn Visual Basic and Microsoft Access. Where do I start, what resources and special tricks can you recommend and how do i learn it quickly and efficiently?
posted by freddymetz
on Oct 2, 2011 -
What's the best way to upload an Access DB using PHP and read its contents into MySQL?
posted by monkey closet
on Sep 22, 2011 -
I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such: [more inside]
posted by thankyoumuchly
on Sep 8, 2011 -
I "don't have permission" to go into the desktop XP folders on my network from my Windows 7 laptop, but the reverse is fine. Help me? [more inside]
posted by droplet
on Sep 1, 2011 -