Search results

I have a table that contains names of employees and the name of awards they received. tblEmployeeAwards EmployeeName, AwardName John,Nobel John, Pulitzer Michael, Fulbright Jane, Nobel Jane, Fulbright I would like to know the following: 1. How many employees received more than one award...

I am aware of the Outlook.Application functionality. Can VBA in Access be used to interact with other clients, such as Thunderbird, for example? What about email automation on a Mac? I know there is no Access for Mac, but what about Excel email automation in Mac with clients other than outlook...

I posted this in a couple other places but haven't been able to resolve it. I am not sure if I need an update query, VBA code, or a combination of both. I use a form (linked to tblCourses) and a subform (linked to the junction table tblCoursePeopleRoles). I am trying to update the field...

I am building a database that contains information relating to instructional staff in my program: instructors, teaching assistants, readers. The database helps keep track of contact information and generating contracts. It does not handle enrollment in courses. This is the general structure...

I am using code I pieced together from a few different sources online, but I am having trouble understanding how it works. The main idea is to merge data from an Access query into a Word template. This specific method required me to first set up the mail merge in Word (designate data source and...

I have two currency fields in a form: [Salary1] and [Salary2]. I would like VBA to take action only if both of them are null. I know how to do this for one field: If (IsNull(Me.[Salary1]) = False) Then But what is the syntax for checking if both fields are null? Thanks

I have a form linked to a regular table and a subform linked to a junction table. The subform has four fields, 3 combo boxes, and the currency field for manual data entry. The subform is set a Continuous Form. When I use the subform to create a new record, the currency field gets...

I am using VBA code to insert text from Access fields into bookmarked locations in Word. However, the code aborts when it reaches an empty field. The document is created and data is inserted, but it does not insert data in bookmarks listed in the code below the empty field. For example, if...

I am using VBA code to merge data from Access into a Word document. My code currently opens a Word template and inserts the data into it. However, is it possible to designate 3 different templates and include an IF clause that determines which template will be used? I have a field that...

I am using .TypeText to insert the contents of a field in Access (2002) into a bookmarked location in a Word (2002) document. One of my fields in Access is set as Currency and displays properly in Access (e.g., $2,500.00). However, once the VBA code inserts that into a Word document, the number...

I am building a database with information about courses and instructional staff in my school. Each course is comprised of a lecture (taught by Instructor); some courses have discussion sections (taught by a Teaching Assistant) in addition. The same person in some cases teaches both the lecture...

Hello, I need help with the Classroom Management Database template available on Microsoft's Web site: [I am not allowed to post links. You can find the template by searching Google for Classroom Management Database Template] This database allows adding students to class rosters from the...

Hello, Is anyone aware of a book that describes how to set up a course enrollment system in Access? If not a book, any other resources? Thanks.