Microsoft Access

I haven't used Access in awhile and I'm not sure if this is possible. I looked through the tutorial but I can't find what I need.

I want to create a form for data entry. For some fields I have a set number of possibilities. For example, a supplier can be either foriegn or domestic. Instead of typing out foriegn or domestic everytime I enter a supplier is there a way to have a drop-down list and pick foriegn or domestic? 

Any help would be greatly appreciated.

Hi.

So, I'm pretty much in a nightmare, that makes no sense to me why it is a nightmare.

I want to do one simple thing: Join the entire information of two tables based on a field of like values. I have 41 sets of two tables to do this too. With some of these tables I am having the same problems in importing.

I should add, all the sets of tables have gone through considerable formatting and data cleaning in excel 2007 to make the values alike. Originally, I was using the "VLOOKUP" function in excel to join these tables...however, the huge size of these tables (some have over a million rows) means it needs to be done in a much more large-database friendly access format.

Behind the cut, I detail the problems I'm having from importing the tables, and with joining them the way I want (which is basically what I would accomplish using "VLOOKUP": a join of all the like values AND the inclusion of the data that did not have like values from the two sheets).

( Read moreCollapse )

Final Note: I'd say I'm like 20% familiar with Access, and 100% familiar with Excel. I've tried very hard to solve these dilemma's on my own...but it's getting me nowhere. Any help would be wildly appreciated!!

Do any of you geeky folks know much about or have experience with Open Office’s Base program? This is the Sun Systems freeware rip-off of Microsoft Access. I love MS Access and use it to do a ton of things – professionally, personally, and in my private charitable work. I’d love to become proficient at Base as well so that I wasn’t tethered by the Microsoft Access license. Free is always better, right? And Access is usually the priciest component of the MS Office Suite.

I’ve only been able to find one “Base for Dummies” type book online. I’ve ordered it and will see how helpful it is. I’m a bit wary that it doesn’t have any user reviews … but meh … it’s the only option. We’ll see.

Hello,

I am working on a project to track warehouse shipping and receiving through access. The warehouse has four distinct areas. I am looking for someone who knows about using queries, forms and reports in Access 2002 for a troubleshooting chat / e-mail setup.
If you like, e-mail me at blav_98@yahoo.com just be sure to put 'Access Help' in the subject so I don't delete it be accident.

Thanks in advance,
Dragon

Ok. I want be able to make a pop up window that when I enter in the highway number -it shows me what lights are on that highway number. Eg. - I enter number 9 and all the data for route 9 shows up. Id share the file -but you HAVE TO have a legit email.

Hi,

Sad to say, I'm brand new to Access. I've got Access 2000, and a "Comprehensive Enhanced" book for Access 97.

So far things are sort of making sense and I'm feeling it out..but I feel like I'm at a mental block for how to implement further.

My form will have the date, along with a list of items from a table. I want basically a list of checkboxes for each of these items. I want to track over time the frequency each of these items were checked.

Am I right to think this is a many to many situation..as the date is tied to numerous items for checking, and each item for checking can be tied to any number of dates?

There is all of one paragraph about many-to-many setups and I'm not sure their illustration works the same way I'm thinking. I feel fuzzy on this matter. If someone can let me know if I'm at least on the right track for what I'm trying to do, or provide some assistance on setting up a many-to-many relationship, I would be much obliged!

Thanks!

I have an Access Database that I am working on for my co-worker, that we use to track software licenses by user and system. Each system is assgined to a user in the database. On the form where this is done, there is a Combo Box that the user clicks to to select the Employee to assign to the currect record. The Combo Box currently displays the Employee number since that is the unique ID that I chose to use. My co-worker would like for it to display the Employee Name, but we still want the table to record their Employee ID.

What would the best way to do this be???

I'm building a database for work. I've got it built and functional and now I'm down to the nit-picky design things to make the reports more readable.

We're a real estate company and I'm tracking all of our properties and which agent(s) are working on each. (There's a lot more than that, but that's all that's playing into my aggravation right now) PropertyInfo table is linked to Agents by a PropCode field. There can be one or more agents per property so it's a one-to-many relationship.

I built a report that's currently grouped by property with the agent names in the "detail" section so it looks kinda like this:

Property A

agent a
agent b

Property B

agent c

And so on.

What I *want* it to do is give me something like:

Property A Agent A Agent B
Property B Agent C

Is there something I can do with the query or with the properties of the field/report to get multiple agent records to show up on one corresponding property line in the report?

I'm working with a membership database that includes two linked tables, one of the members and one of the memberships that they've purchased. I'd like to make a query that lists all the members for whom there is membership purchased. But some people like to submit multiple memberships, and I only want them to show up on the list once. What's the best way to do this?

I used to do a lot of work in Access and Filemaker, but I haven't been working with databases at all for the past few years. I work at a mosque, and right now we're keeping all of our membership records in Quickbooks. I'd like to set it up in Access instead, but one of the aspects of QB that I really like is that there's a very easy-to-use screen to add dues paid. We have each year set up as a "product" and then we can just enter a sales reciept where the person "buys" each year for which they were a member, and it's automatically added to their record. If at all possible, I'd like to replicate this in Access. As I said, I'm pretty rusty, but this is how I imagine it:

I'd have two tables, one tracking members and their contact information, and one tracking memberships sold. The memberships sold table would include a field for "sold to" where the person would have to choose from the members in table 1. Then, and here's the part I'm not entirely sure how to do, there would be a field/array/something in table 1 that tracked all of the membership years sold to each member.

Sorry if I'm not explaining this well, I haven't had lunch yet.

edit: And while I'm at it, if I have text fields for first name and last name, what's the best way of creating a field for full name that automatically combines the two?