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...

Ok, here is some sample data attached, and an image of how I want the report to look. As you can see, only the ProgramID is listed (uniquely), and a calculation based on that program ID. What the calculation actually is is irrelevant I guess, just know the calculation is going to be a count...

So do you simply want Program and count, or do you want all the other stuff? Oh, sorry, I should have elaborated on the calculation. Yes, I want each program listed, but the other textbox on the form is ultimately going to be a complex calculation, I just (misleadingly) used a simple count as...

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...

Re: Search function for continuous form keeps asking me to "Enter Parameter Value" Sorry but I'm not specfically seeing how to apply this to my problem. I am fairly new to access so forgive me. This code is mostly taken from someone else so I don't understand this stuff as well as you might...

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...

Sorry, but I just found the issue myself! The form for editing the data had the data entry property sent to yes. I changed it to no, and it works now. Issue is resolved. Thanks anyway

I just opened the embed macro to look at the code. This is the where condition: ="[ID]=" & [ListID] ListID is the name of the ID text box in the continuous form. Again, this button works properly - but only when the form this button opens is already open in the background. So I'm not sure that...

I didn't make it with VBA, I made it using the the command button wizard. This is the line of options I selected: Form Operations > Open Form > Data Editor > Open the form and find specific data to display > where ID = ID

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...

@June I unbound the boxes and renamed the Day box and now it works. Thanks

Really? The day data inputs fine from the form. Anyway, I've taken a picture and described it in MS paint, attached to this comment here, which explains the problem. I do not want that blank first row to be added, only n rows for n selected options in the "Drill Type" list box (in my image, 3...

Are you sure it is recognizing a null listbox item, even if some are chosen? Here is my code, I am new to VBA so not sure how to write this. Add If Not IsNull(varItem) after the "For Each" statement? That doesn't work. Wrong syntax?

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...

@Gina Thanks! I was able to implement that perfectly. It works fantastic

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...