Getting Started

How to make sequential date from non-available date data
I have a table of which the data is imported from Excel. I receive the Excel file from my colleague only if she has activity on that day, in other words, the activity data will append to the existing table. One of the field in my table is "ChangeDate". There may be a couple of rows (more than one customer) fo... 29 Jul 2008 09:33

Adding months to a date
I am trying to calculate the expiration date for automatically renewing contracts. I want the final form to calculate the current expiration date by calculating renewal periods but just showing the final one. The contract is first signed for a 12, 18, or 24 month period while the renewal period is usually for... 2 Aug 2008 11:30

Relearning and Barcodes
I am getting back into Access and I have been tasked with finding something that will help with reading a barcode. Has anyone had any success with not just printing barcodes onto documents or labels, but actually using a device that will interact from the product barcode into an Access DB? If so, what is it? ... 28 Jul 2008 19:16

Need Help Building Database Table
I am very new to Access and I need a database for our list of company contacts. At each company, we may have 1 contact or 15 contacts. I want a button on the main page that displays the name of the other office (if there is one) that you click on and it shows all of the contacts in that office. I'm not sure ... 28 Jul 2008 19:16

How can I export a report to Word and retain images?
Hi all, I have a database and I'm working on creating a report for my employees to summarize their activities. The Access report summarizes information entered into the database about meetings and partnerships, etc. However, the employees will need to be able to add more details which are not captured in the d... 28 Jul 2008 19:16

query to retrieve most recent information
i need to create a query that will return the most recent information for a given person. each person may have multiple name, address, telephone, and/or event records. the event record will contain an entry date. so my questions are: what's the best way to keep these records in sync and how to build a query to... 28 Jul 2008 17:13

Understanding Relationship Logic of Multiple Tables
Hello, I am working on an issues database as a personal goal and I am attempting to understand the logic of table relationship links. I've accomplished quite a bit of reading on this via various sources such as this forum, Access Help and the Complete Access Reference book (maybe too many!) and I think I've ... 29 Jul 2008 10:35

DLookup Help Needed
I am trying to autofill a form based on a drop down menu. I want the price and description of an item to autofill. I have looked through all the posting, tried them, and still cannot get the darn think to work. Here is what I have: =DLookUp("[ContainerSize]","Chemicals","[ProductName] = ' " & [ProductName] &... 29 Jul 2008 20:55

MsJet40.DLL
How do I know if the MSJet40.DLL is the latest on my PC ? There is a KB - Article ID : 239114, but confused if I would need to install MS Jet SP 8 as the version shown on my PC is 4.0.9511.0 Windows XP SP3 and Security Bulletin MS08-028. ... 28 Jul 2008 14:07

Keeping Relational Table Current-Access 2007
I am creating my first database in Access 2007 and found when completing certain fields, my data is redundant. I thought a good solution to avoid typing was to create a new single field table, linking it to my primary table in my database with a many to one relationship, and then simply clicking the appropriat... 29 Jul 2008 08:31