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
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
I teach at a language training school, at which there are a few hundred students. My boss recently distributed a questionnaire to all of those students to determine the best times to schedule classes for each level of language proficiency. Unfortunately, it turns out that his plan for efficient scheduling ended at the point where we got those questionnaires back. Also unfortunately, I've developed a reputation as the local computer guy (because I can replace a broken mouse and make a chart in Excel), and so the job of making sense of the data has fallen to me.
[more inside]
posted by Acetylene
on Jul 3, 2011 -
9 answers
MS Access: I have responsibility for a large database in Access 2007. How can I create a dev copy to experiment with changing forms/layout/queries, etc. which shows record data, but does NOT link to and make changes to data in the tables in the "real" original database? I do not know SQL.
[more inside]
posted by cuddles.mcsnuggy
on Jun 9, 2011 -
4 answers
i need to print an access report to pdf and have it spit out a file for each company in the report. help please.
[more inside]
posted by elle.jeezy
on Jan 5, 2011 -
1 answer
Microsoft Access 2007 form creation question. Hopefully not-too-wrongheaded and clearly described inside.
[more inside]
posted by jsturgill
on Aug 4, 2010 -
2 answers
I'm working on an Access database that collects various metrics and numbers weekly. I've used week numbers as the primary key in each table since that's the only thing that can reliably group them together. If I were to build a form to input data into more than one table at once, is there a way to enter the week number only once on the form, but have it insert the number into multiple tables? Or am I doing this wrong altogether?
[more inside]
posted by speeb
on Jan 5, 2010 -
9 answers
Microsoft Access query problem - Comparing two similar tables that don't match up well. It's lists of classes in a collection of locations from two consecutive years, and what I need is to show the class fees side by side for any class that happened in the same location both years.
[more inside]
posted by dnash
on Feb 5, 2009 -
13 answers
I have a particular propriety database application that has a great feature for users to document notes and changes to the db. Annotated screenshot
here.
Basically, you click on the little yellow sticky note and the documentation window pops up and users can enter notes about changes, etc. Its so useful I would like to use it all the time.
[more inside]
posted by buttercup
on Apr 27, 2008 -
3 answers
SQL WTH: various examples given on websites and in a small stack of books don't work.
[more inside]
posted by Tuwa
on Apr 15, 2006 -
9 answers
Database filter: I have a Microsoft Access application that is split into two .mdb files for the interfaces and data. This app is distributed on a CD to be used on computers that have no internet access. When someone needs an updated dataset the backend .mdb is refreshed from a load of Oracle tables and sent on CD so that the user only needs to replace a single file. The front end links to the tables in the back end.
[more inside]
posted by NsJen
on Dec 12, 2005 -
10 answers
I'm stuck instancing a Microsoft Access form. According to Litwin, Getz and Gilbert (Ch 8), the statement 'Set frm = New Form_frmMyForm' should create a new instance of frmMyForm, referenced via the 'frm' variable. However, when I try this I get a compile error "User-defined type not defined", and it highlights the code 'New frmMyForm'.
[more inside]
posted by Ritchie
on Feb 20, 2005 -
6 answers
