38 posts tagged with access and Microsoft.
Displaying 1 through 38 of 38. Subscribe:

How can I summarize quantities by ranges in Access 2010?

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.
posted by rybreadmed on Aug 1, 2014 - 4 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

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

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

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

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

Microsoft Access and VBA

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 - 8 answers

Best practice in implementing a two-part unique identifier?

Best way to implement a two-part unique identifier in Access? [more inside]
posted by jsturgill on May 9, 2011 - 14 answers

Data connections btwn Access 2002 and SharePoint 2007, how do they work?

I need to pretty quickly get up to speed on how to integrate an Access database with SharePoint. I know Access well, but I don't know SharePoint at all and don't understand how data connections work. The really fun part: I have Access 2002. [more inside]
posted by desjardins on Jan 11, 2011 - 8 answers

Teach me access

What is the best way to learn how to use Microsoft Access 2007 quickly? [more inside]
posted by maxg94 on Sep 7, 2010 - 9 answers

My users don't like personal visits, Microsoft!

Microsoft is going to do BAD THINGS to my users' desktops when I release this month's patches. I could use some input from the hive mind on how to proceed. [more inside]
posted by charred husk on Jul 14, 2010 - 11 answers

Access and Replication

Sharing an Access database among several small groups using replication. Doable? Am I on the right track? [more inside]
posted by Simon Barclay on May 3, 2010 - 20 answers

enhance...rotate, now uncrop!!

[CSIfilter] Need to find out who has modified certain records in Office Access. [more inside]
posted by jstarlee on Jan 2, 2010 - 7 answers

MS Access - Limit to # of shared users

Is there a limit to the # of users who can share a Microsoft Access database across a network? [more inside]
posted by cg1 on Nov 23, 2009 - 12 answers

MS Access...Access Problem

Microsoft Access question: I have an Access 2007 database hosted on a server. I have 10 staff members who use the database. I can get in the database even if someone else is in it. One of my coworkers cannot. Is this typical? [more inside]
posted by bibbit on Jul 14, 2009 - 9 answers

Alternatives to MS Access?

MS Access Alternatives? I have a user that needs to keep data in a relational database, but I'd like to advise her against Access because of it's various limitations. She has no programming knowledge. Any suggestions? [more inside]
posted by SpecialK on May 19, 2009 - 13 answers

How do I replace a Visual Basic 6 runtime file killed by a Windows security update?

A Visual Basic 6 (ugh) runtime file distributed with our internal Access database has been killed by a recent Windows security update. It's hard to gather support information (especially since VB6 is about 8.7 million years old) and so I was wondering if anyone out there can help me track down a more recent copy of the runtime file in question—msflxgrd.ocx—or otherwise fix the problem? [more inside]
posted by bcwinters on Mar 9, 2009 - 8 answers

Access to access

I need a one-time conversion of a Access 2003 database file (.mdb) to an Access 2000 database file. I tried OpenOffice to no avail. [more inside]
posted by sandra_s on Feb 10, 2009 - 2 answers

How do I record multiple options in Microsoft Access

I can't believe I don't know how to select many checkboxes in Microsoft Access... [more inside]
posted by Foam Pants on Oct 7, 2008 - 9 answers

Running Queries in MS Access for non-Access Users?

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 by Smarson on Jul 1, 2008 - 4 answers

Microsoft Restrict-Access

Microsoft Access: How do I save a 'global variable'? [more inside]
posted by SirStan on Sep 11, 2007 - 2 answers

Help me merge Excel with Access:

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus on Jul 2, 2007 - 3 answers

Dynamically save automagically generated word document!

VBA assistance needed. I've got the automerge and print down, now to save it as a unique file... [more inside]
posted by TomMelee on May 15, 2007 - 11 answers

How do I get MS Access to create organized web pages?

How can I make Microsoft Access 2002 crank out organized web pages that conform to my design ideas? [more inside]
posted by Servo5678 on May 14, 2007 - 2 answers

How do you access MS Access in a different domain?

I'm trying to get my head around some Microsoft Access security issues, and could use some help. [more inside]
posted by chill on Mar 15, 2007 - 4 answers

Selecting the MODE of a group of data in Microsoft Access

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 by Jimbob on Dec 13, 2006 - 3 answers

Error When Exporting Access Report to Excel

Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted by ao4047 on Nov 6, 2006 - 4 answers

Does anyone know where I can download television episode guides converted to Microsoft Access format?

Does anyone know where I can download television episode guides converted to Microsoft Access format? [more inside]
posted by feelinglistless on Aug 9, 2006 - 4 answers

Using MS Access files with my Mac. How?

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 by jonesor on Jul 3, 2006 - 6 answers

Help me figure out how to make a pretty report.

Access DB Filter: Help me figure out how to make a pretty report. [more inside]
posted by nulledge on Apr 4, 2006 - 3 answers

Why is MS Access coloring all my text fields grey?

Working on an MS Access 2000 record-browsing form; the text fields all display as dark grey text on light grey background, no matter what colors or transparency are specified in the design. I've never seen this before. I've been running in circles for 2 hours. What am I missing?
posted by Tubes on Mar 2, 2006 - 12 answers

What is the best and/or most efficient website design software these days?

What is the best and/or most efficient website design software these days? [more inside]
posted by Servo5678 on Feb 27, 2006 - 11 answers

Access VB to Delphi switch

How difficult is it to switch from MS Access programming to Delphi? [more inside]
posted by elgilito on Dec 12, 2005 - 17 answers

Data Overload, How Do I Manage?

How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted by benjh on Dec 9, 2005 - 9 answers

Microsoft Access Applications

How do I implement a more custom look for a Microsoft Access database? [more inside]
posted by benjh on Mar 9, 2005 - 3 answers

How do I use Access to get information from Access databases and merge them into a series of reports?

Microsoft Access: I might be asked to use Access to get information from a series of online EU databases, merge them and produce a series of reports. I know very little about this, and would have to get up to speec very quickly as the reports are time critical, and if they are not done well, there would be problems for the NGO who have approached me. Could anyone recommend some low cost books or other resources that could help me?
posted by quarsan on Feb 8, 2005 - 2 answers

XP SP2 and WebDav

i have some of my remote users in the office connect to our fileserver using webdav as a means to quickly (though admittadly not-securely) access and change documents, etc. it seems though, that since using windows xp SP2 it's been dirt slow. my user will click on a directory, and it will take no less than 10 seconds for the directory to be highlighted. that's not even attempting to open the directory - that'll take another two minutes or so. i'm trying to figure out what's exactly going on here. ideally i'll be switching to VPN soon, but in the meantime, i need to get this working properly again.

thanks!
posted by quadrinary on Sep 28, 2004 - 2 answers

How can I replace every occurrence of a drive letter with a different drive letter in a table in an Acess database?

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. [more inside]
posted by Grod on Apr 17, 2004 - 14 answers

Page: 1