Search results

This works perfectly. Thank you so much for your help and patience!

I've adapted the code with my own form/field names, and when I go to open the report, no matter which checkboxes I check on the form, the report only shows the final field I checked, all the way over to the left. For example, if I check CollegeID, FullName, and Accuplacer, the only field I see...

That does make sense, and I'm trying to do something like that. I'm getting stuck on how to move each column relative to the others. For example, I have 18 columns that the user can choose from, and they are free to choose any combination of those columns. Let's say the user chooses Columns 3...

Thank you for your advice Mihail. The .Left property suggestion has helped me make progress. I just wanted to ask about this: AmountOfSpace = CountColumnsFromLeftThatShouldBeHidden * (ColumnWidth + GapsBetweenColumns). Is CountColumnsFromLeftThatShouldBeHidden a calculation also? Should I...

Access Version: 2010 Experience Level: Beginning/Intermediate-Comfortable with basic vba coding, but need a bit more guidance with anything advanced, though I'm good at following examples. Hi, I've been researching this issue for two days straight, and while I've read some posts that were...

That's a really good idea. Thanks so much for your help!

Hi, Thank you so much for answering. Would this solution change the way the listbox appears to the user, i.e. they wouldn't see all the rows in the beginning, just what was typed?

Hi, I'm using Access 2010, though am also familiar with Access 2007. I have a listbox populated with a query (concatenated last and first names with a bound ID field that's invisible). One of my users asked if it would be possible to search the listbox by more than the first letter of the...

Hi, The version of Access I'm using is Access 2010. I've been trying to work with the "Collect Data" tab to email a survey to 800 people and have the results be populated in the database. I know that's possible with the "Create Email" feature, but I want to take it a step futher. My survey...

Hi Simon, Thank you for responding as well. I'm happy to take all the advice I can get :). I think the whole web based database idea was a feasibility study; it would be a great solution if it were possible for me to build it in a reasonable length of time. Since I don't have a clue about...

Thank you so much for your response! Just a couple of follow up questions: I know building a web based database is in a different league of difficulty than building access applications. I'm concerned about how long it might take me to develop something workable, as I have no experience. I'm...

Hi, I've built an educational program database in Access 2010 and housed it on a shared network folder. Now I've been asked if I could possibly make it so our program's remote users could enter data in the database. They do not have access to the shared network folder where the database...

Hi, I’m building a form for one of my program databases (Access 2010). The business rules I’d like to set up are: A student can be enrolled in a program, exit the program and return at a later date, i.e.: Name --------- EntryDate----- ExitDate John Smith ---9/1/2010 -----8/31/2011 John...

That worked perfectly. I can't thank you enough!

Thank you! I've tinkered around with the code a bit, and this is what I've come up with. I know it's wrong because it gives me thousands of records with only the first studentID, but at least it's generating something. Would you be able to tell me where I went wrong or if I'm even on the right...

That makes sense. Yes, you're right. Sometimes I get an endless loop, and sometimes when I experiment with switching rst and rst1 just to see what would happen, I'd get no result. "You don't want to get the student ID from the form, you want to get it from the recordset." This was my...

Thank you so much for answering. That is exactly what I did. I created an unmatched query and put the students who appeared in one table but not the other in a temp table. I then created a form based on the temp table, so that the user could see which students were being added. Then of course I...

Hi Everyone, This question concerns an Access 2010 database I’m creating for one of my programs at work. I’m having an issue trying to get a nested loop to work. I am very new at loops, and at working with recordsets in vba. Here’s what I’m trying to accomplish: The user clicks a button, and...

EntryDAte and ExitDate are still unclear: are they tied to a specific student's participation only or given by program/subject? EntryDate and ExitDate refer to a specific student in a specific program in a specific subject. For a given program/subject, can student A have EntryDate 1 Sep...

Hi Spike, Thank you for responding. I’m always willing to reconsider if there’s a better solution. In terms of explaining the business rules, here’s a little background about the database: I’m designing it for an educational program, which is comprised of about 4 smaller programs. At any...