Recent content by Mljohn

Thank you Boblarson but that is way over my head. I don't know what that means or how to use it. I'm not there yet. Thanks though for the explanation of Dcount's benefit of giving the user better understanding of what to do and a way out if they can't continue. I guess I'm using the...

What is the benefit of using the DCount to not allow an update in the form's Before Update event over using a "multi-field index"? How do I use Dcount? I don't understand expressions well yet. Matt

Question: How does a autonumber primary key keep out duplicate records? For example. My sales contact table has a "company" field. Say I have a company named "Wendy's". There are lots of Wendy's. How do I get my database to allow companies with the same name and different locations but not...

Thank you everyone for your help. This is what I understand from what you all have said. Primary key should use the autonumber. Numbers are faster than text fields for the database to process. With autonumber as the primary key there are no worries about future changes in a text field primary...

I'm new to access. I understand some basics but I am having a hard time understanding keys and relationships. I'm working on a sales management database. I understand that a primary field in a table is to keep the data unique. For example the "company" field could be the primary field to keep...

I have a contact manager form with all the contact info of my client. I want to create a list box in that form that shows the info in a query. The query contains dates and times of people I'm supposed to call back. I want to be able to double click on the person in the list box that I want to...

I have a notes "memo" table. What to do with it in the form I don't know. The reminder download looks good but I don't know how I would use it. There aren't any table with it.

I'm newer to Access. Using Access 2007. I want to create a form that has the contact info for my clients. I want to be able to look up data and enter data that goes back to my customer table. On this form I want to have a memo box that I can keep notes in about each client and have a date of...

Thank you ajetrumpet and boblarson for your help. Please remember that I am a newbie on Access so I will need more detail. I created a test table and a test form from that table. 1) I had 3 fields: Company, Item and Qty 2) I added in design view a combo box and linked it with the "company"...

Is it possible to create a form or report that allows me to look at one record at a time? It needs to be read only (doesn't affect any table data). Also it allows me to type in a box and as I type it tries to out guess me. I just want to look up info in an organized form. If there is a way...

I want to take my customers activities from the past 8 years and find how often they buy on average of days. I then want to create a program to forecast when I should expect to hear from them. I use QuickBooks. I then export the data from quickbooks to Excel. Is this best with Excel or Access...