Search results
-
V
difficulty using "Or" in Dlookup
I am creating a report that I want to design as a timetable to show which courses are offered in a particular classroom each day of the week. I want to have a number of textboxes in the report that represent the different time slots in the week. For the control source for these textboxes, I... -
V
Linking a query to a word document?
I have a query in my database for our list of courses. It lists the course number and name, who teaches it, the date and time it takes place etc. I am hoping to create a document based on this that would lay out the courses by room in a timetable format. Is there a way to like this to a word... -
V
Report – Can you calculate the sum of a field that is based off an iif function?
I’ve created a query that contains an “iif” function and have created a report based off this query. I am struggling to find a way to calculate the sum of the field that uses the iif function in my report Basically, I have my Courses table which contains a list of courses taught, the... -
V
Display description field instead of primary key in datasheet of a split form
I have a split form on my database where I have my combo boxes bound to a primary key but they display the description field so it's much easier to understand. Is there a way to do this with option groups? In other words, I would like the datasheet part to display the option group labels... -
V
Autofill forms?
I've made a student database and I'm creating a form for entering new student records. I have combo boxes set up with the different choices for major, minor, year, etc. Is it possible for these fields to have an autocomplete option? For example, there are about 30 different subjects that... -
V
Entering New Recordss in a Form Based on a Query
I've created a student database with multiple tables that all relate to my primary table. I do not want anyone adding new student records to the primary table, so to make it as user-friendly as possible, I've created a form for entering new records. This form is based on a query that shows all... -
V
Changing combo boxes to Option Groups
I've created a form using the form wizard and all of the fields show up as combo boxes. I would like to change a couple of them to option groups with radio buttons. Is there anyway to do this without deleting the fields and making the option boxes from scratch? The reason I ask is because... -
V
Help with option groups in a split form
Hello, I'm new to Access 2010 and I am building a database from scratch. I've created a form using the form wizard and changed it to a split form so I could see the information in a datasheet as well. All the fields in the form showed up as combo boxes by default but there are two fields that...