Search results

I have an example of my data set in the two tables attached below. The data set is a table of drills where the ID field lists unique drills performed. The ProgramTable lists all the locations and their drill requirements. I'm trying to create a report or query that would, according to today's...

What my dataset looks like: It's a bunch of fire drills. A field called ID is the key, and associated with each is the Program which performed the drill, the day, etc. Every program runs multiple drills throughout the year I want the report to show the name of each program and a calculation of...

Search function for continuous form keeps asking me to "Enter Parameter Value" Ok, there is some background info necessary to understand the problem. Sorry for it's length: Division, Center, and Program. You can think of these as being like Country, State, and Town respectively. (imagine for a...

I have a continuous form here which lists records. You are unable to edit the records on the continuous form which is what I want. To edit records, the user should click the "Edit Record" button next to the record the user wishes to edit. This takes you to a form called "Data Editor" where you...

I have a data entry form which uses vba to loop over some stuff and enters multiple records. This works, except for one problem. It generates an extra record (appearing first, before the others) where the list box field looped over is blank. This is fixed by setting the data entry property of...

I have a data entry form where users submit drills all our locations are required to do by law. You can see the combo boxes/fields in the image attached. Users hit the button to submit the information to the database. Our programs can do multiple types of drills at once. For example, they can...