I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is messy. [more inside]
I am trying to summarize a table of thousands of values into simple year ranges. It should be simple. So basically, there is a table that looks something like this: PIPE_PLR_Y MILES 1912 0.06 1914 0.48 1930 1.43 1942 1.32 1929 0.85 1925 2.00 1914 0.95 1929 0.42 ... The table has many, many values between about 1900 and today. I would like to make a table like this: Year_Range MILES 1900 - 1909 23.6 1910 - 1919 64.3 1920 - 1929 73.1 ... Again, I'm using Access 2010. Any help would be massively appreciated.
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]
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]
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]
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?
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]
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]
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.
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]
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]
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]
Are there any good resources for helping a low-income senior get Internet access? [more inside]
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?
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]
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]
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]
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]
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.
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]
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?
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.
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!
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]
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]
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]
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]
Is there an easy way of turning a comma-separated list into multiple lookup values in access 2010? [more inside]
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.
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?
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]
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]
I'm looking for a free/cheap alternative to Access or Filemaker for simple relational database work. [more inside]
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
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]
Microsoft Access Training/Classes in New York City (Manhattan), or your best suggestion of online materials. [more inside]
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]
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]
Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]
How do I obtain newer Foreign Service Institute language learning coursework and education materials? [more inside]
Microsoft Access programming problem - what do I have to configure in my database to make use of the DAO object? [more inside]
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]
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]
Help me help myself- Please recommend books or websites that will help me to better understand SQL. [more inside]
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]
Complicated (or probably not complicated) MS Access question that I'm not sure how to google for. [more inside]
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]
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!
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.
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]