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
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
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 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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
How do I implement a more custom look for a Microsoft Access database?
[more inside]
posted by benjh
on Mar 9, 2005 -
3 answers
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
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
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
