Search results

That's great!! Thank you. Now let me be a real pain and ask you what is the dateadd function? And do I use both in the Criteria box on the query window?

I am using Access 2007 and run a newsletter for a local Elks club. Each monthly issue must contain a list of people's names who have their birthday on that given month. I am trying to generate a query to make this happen but am confused while trying to use the date function. Any help would...

I cleared the check boxes on the MISSING: lines and now have complete access to the database Thanks for your help

Access was installed on the network with version 2003 while I am using Access 2007 on my computer.

I forgot to mention that in the list of checked Available References, I have the following: MISSING: Microsoft DAO 2.5/3.5 Compatibility Library MISSING: utility.mda

Microsoft Visual Basic for Applications Extensibility 5.3

I am having a problem entering my Access database. After clicking on my Desktop shortcut, I see the following error message: Your Microsoft Office Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5. When I click on the "Show Help >>" button...

Thanks a lot for the quick and accurate reply. I am off the hook! :)

I am trying to add a textbox to my form that will show the string --- City, State ZipCode. I am using the expression builder and cannot seem to get what I want. I am using =[City],&' '&[State]&' '&[ZipCode]. The error message states that I have improper syntax. I am using XP Access. Thanks...

Many thanks for the tip!

Either way is OK. Code would probably be better as I am trying to set up a system for a data entry person who is not that experience with computers. If the code is transparent and she need only feed in the appropriate fields, that would work fine.

Anyone have a good online resource for generating a single thank you letter, eg. by way of a mail merge using MS Access 2003 with Word 2003? I know you need to write a form letter first with various fields that conincide with fields in Access. I have done this many times with large mailings...

Quick Way to Find All Records with Same Last Name Thanks, Wendy. You're the best!

Quick Way to Find All Records with Same Last Name Thanks for the feedback. You were right on with making a different choice in the combo wizard. Is there a way when you type the last name into the combo control to have the drop down list automatically sorted alphabetically or does one have to...

Easy Find Method I have loaded a combo box on a form that has as its recordsource the table where all the records are contained. When I want to find someone, I type the last name of that person in the combo box and click on the down arrow to its right to display all the people with that last...

Quick way to find a name in a form Absolutely loved your suggestion about the combo box idea!! Of course, you know you created a monster with that suggestion. I would now like to be able to click in the drop-down record of choice and by doing that automatically go to the full display of that...

I have designed a data entry form in MS Access 2003. One function I find frustrating is when I want to find a particular record while using this entry form. If I use the Edit>Find facility, for instance, looking for someone with the last name "Jones", eg, I must page through all the Joneses in...

I have designed a data entry form in MS Access 2003. One function I find frustrating is when I want to find a particular record while using this entry form. If I use the Edit>Find facility, for instance, looking for someone with the last name "Jones", eg, I must page through all the Joneses in...