VBA to print to specific printer with print button
In Access 2007 how do I use VBA code in my print button to print to a “specific printer” for my report.

Answer Question   |  December 12, 2008  1:05 AM
Access 2007, Code, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications

Microsoft Access 2007: Using an IF statement
I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do that? Something like if [...]

Answer Question   |  December 11, 2008  1:00 AM
Access 2007, Database programming, IF statement, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications

Access/Word Mail Merge Currency lost digits
I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 …Even worse $700.60 appears as 700.6 How do I get the decimals to show?

Answer Question   |  January 27, 2009  8:42 PM
Access 2007, Database issues, Mail merge, Microsoft Access, Microsoft Word

Hotel database (Rooms availability) using Access 2007
Hi there… I’m working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?

Answer Question   |  November 24, 2008  1:55 PM
Access 2007, Database programming, Microsoft Access, Microsoft Access 2007

E-mail Notification
Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?

Answer Question   |  November 26, 2008  5:02 AM
Access 2007, Access 2007 alerts, Database alerts, Email alerts, Microsoft Access, Microsoft Access 2007

Export Attachmets
How do you export all attachments for all records from Access 2007 database?

Answer Question   |  November 19, 2008  6:44 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access

Need to modify an existing form in Access 2007
I have just migrated to ACCESS 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.

Answer Question   |  November 4, 2008  4:04 AM
Access 2007, Access forms, Database programming, Microsoft Access

Access 2007 Replace operation
In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.

Answer Question   |  November 4, 2008  5:33 PM
Access 2007, Microsoft Access

Creating pop-up reminders
I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a “Effective Date” column. Please keep in mind that I am not well versed in macros. Thanx for any help,

Answer Question   |  October 28, 2008  10:39 PM
Access 2007, Access 2007 pop-up reminder, Database programming, Microsoft Access

Microsoft Access query window
I use an Access program to record student records. The program has built in queries, but when I try to start one the popup window is tiny; all you see is border, no text, no restore or exit buttons. I can’t catch an edge with the mouse to enlarge it. Also, the program opens without [...]

Answer Question   |  October 28, 2008  11:02 PM
Access 2007, Microsoft Access

Microsoft Access printing
I had developed an application using MS Access 2003 and have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this application in MS Access 2007 and printing it via MS Access 2007. By the way my printer is HP Laser Jet 1022. [...]

Answer Question   |  September 26, 2008  8:05 AM
Access 2003, Access 2007, HP LaserJet 1022, HP LaserJet P2014, Microsoft Access, Printing

Creating a Form
I’m creating a form and have an dropdown combo field on my form. (dz, each, Bag, case etc.) I want to use the dropdown on each line independantly. What ever is selected on the first line goes on all the lines. How do i get each line to have different selections based on a new [...]

Answer Question   |  September 23, 2008  5:51 PM
Access 2007, Access forms, Microsoft Access

Importing Data GAL entries into Access 2007
Need to import outlook GAL entries into Access 2007 & have the database updated when I change a field in the GAL entry.

Answer Question   |  September 18, 2008  5:09 PM
Access 2007, GAL, Global Address Lists, Microsoft Access

Need Help Importing Data
Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships and populate [...]

Answer Question   |  September 9, 2008  6:05 PM
Access 2007, Microsoft Access

Access 2007 Report displaying the content of three different fields in one box?
I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & ” ” & [First Name] & ” ” & [Last Name] but in [...]

Answer Question   |  September 10, 2008  6:55 PM
Access 2007, Access reports, Microsoft Access, Office

Modifying a module in Access 2007
I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code: Function RunQueries() On Error GoTo RunQueries_Err DoCmd.OpenQuery “Query_1″, acViewNormal, acReadOnly DoCmd.Close acQuery, “Query_1″ DoCmd.OpenQuery “Query_2″, acViewNormal, acReadOnly DoCmd.Close acQuery, “Query_2″ RunQueries_Exit: Exit Function RunQueries_Err: MsgBox Error$ Resume RunQueries_Exit End Function It works fine, [...]

Answer Question   |  September 19, 2008  2:06 AM
Access 2007, Access Database

Can’t change Navigation Button Caption for subform
I’m following the instructions in the New Perspectives Comprehensive Access 2007 and can’t seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?

Answer Question   |  July 31, 2010  6:16 PM
Access 2007, Access forms, Microsoft Access

Highlight Query last executed
How do you modify Access 2007 access options to keep last query executed highlighted?

Answer Question   |  July 29, 2008  8:36 PM
Access 2007, Microsoft Access

Access 07 Database to Import to Outlook 07
Hi there, I would like to upload the database I have in Access (07) into my Outlook (07) contacts list. However I can’t seem to find a way to do this. Can any help me? CC

Answer Question   |  July 24, 2008  12:16 AM
Access 2007, Microsoft Access, Outlook, Outlook 2007, Outlook contacts, Outlook Import/Export

How to access and use subform data/calculations
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form…Then the main form does a couple calculations on those amounts…But I need to access that information in a report for each employee. Reports [...]

Answer Question   |  July 29, 2008  1:23 PM
Access 2007, Calculations, Database programming, Form, Microsoft Access, Parameters, Reports, Subform, Variable fields