Recent content by rickaddison

Paul, I'm having difficulty knowing how and where to use DMAX plus 1. I have a table with a date field called "MailDate", and a second field called "FiscalYear". I want to be able to calculate the "FiscalYear" using the "MailDate". Beginning with July 1 of each year I want to add "1" to the...

I have one table called inquiries that has a primary key (an autonumber) for each type of product a customer inquiries about. I have a second table called disclosure contracts that has a primary key (also an autonumber) for each contract issued to a customer. I want to issue only one contract...

Thanks Paul. I'll check it out. Rick

Hello, Since I'm not certain how to search for an answer to my question, I'll ask it. I have a database that uses a field for the year (but I'm using a fiscal year that will end June 30, 2013) and another field as an autonumber. I use the year and autonumber as my reference number (i.e...

Hi everyone, I created an access report from a Word document (I'll be creating several) and I used my database fields to populate the variables in the report. I was wondering if it would be better to make the variables parameters requiring user input? Also, I'm looking for some code that will...

I think I'm going to use mail merge based on queries. I've created one query already that seems to work fine. Is there anything I may need to be aware of? Thanks, Rick :)

Thanks for your reply but I'm not certain that I gave a good explanation of what I'd like to do. I have several letters in Word that are mailed to clients we will be using our Access database to track. I'm trying to determine the best way to use the letters with the database. I'm hoping to not...

I've looked at some threads that have been posted and none seem exactly on point for what I need to do. We've created a 2010 Access Database to track information and produce various reports. We have several Word documents that we used prior to the database for requesting and sending information...

My name is rick addison. I work for the State of Louisiana in the United States of America. I've had some exeperience with Access but I'm new to Access 2010. Some of my colleagues and I are creating a database as a work assignment. I look forward to getting to know some of you who can help us...