11 posts tagged with access and MS.
Displaying 1 through 11 of 11. Subscribe:

MS Access Combo Box Fields behaving strangely.

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 - 1 answer

Help me Access my SQL!

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 - 11 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

MS Access Query Query

Complicated (or probably not complicated) MS Access question that I'm not sure how to google for. [more inside]
posted by Just this guy, y'know on Feb 20, 2012 - 5 answers

What are the ideal Relationships for my MS Access database?

MS Access Database Relationship Help. I am relatively new user of MS Access and need to figure out the ideal or proper relationship between the tables I have created for multiple company's financial statements that will provide the most flexibility when viewing and comparing the financial statements. [more inside]
posted by otto42 on Jul 10, 2011 - 8 answers

Newbie to MS Access deleted something essential. HELP!

[MSAccess Filter] HELP! I have been thrust into Access with no understanding of how it works beyond a 10-minute "use this" and "do that" session. Now I think I inadvertently deleted a couple of essential "forms." Can I get them back? Or rebuild them? I know the data must still be in there, but I don't know how to display it. [more inside]
posted by AnOrigamiLife on Sep 16, 2010 - 7 answers

Hike! Hike! Hike Your Pants Up!

I am wanting to enjoy some outdoor exploration this year in Washington state. The catch is, I have multiple sclerosis and my ability to walk is severely hampered (I can walk short distances- maybe about a city block or 2 at a time, sometimes I need a cane, but not wheelchair bound). Where should I go? [more inside]
posted by evilcupcakes on Apr 21, 2010 - 14 answers

Access Memo to Text, baby

Access Field question: On a linked ODBC table, I have part number information in a MEMO field, in this format: xx-xxx-xxxx. I would like to make this a TEXT field so that I can link it to another ITEM field that is associated with cost data. How can I do this in a query? Thanks
posted by strangelove on Oct 21, 2006 - 5 answers

MS Access Replacements?

I am wondering what the (free/cheap) options for uniting a database to templates for printing. Specifically I am worried about the ease of populating these templates, and how I could use regular sql queries to produce, for example, three invoices/page with addresses in the proper location for envelopes. [more inside]
posted by shownomercy on Aug 4, 2006 - 4 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

I need to become a database-design expert ASAP!

I need to become a database-design expert ASAP! [more inside]
posted by BigBrownBear on Nov 11, 2005 - 20 answers

Page: 1