Recent content by justinpatters

Got it! Thanks so much! Here's the following code for the button release if anyone is looking for it: Dim LTotal As Long LTotal = DCount("studentID", "Query1", "[studentID]=[Forms]![Query1]![Text10]") Text19 = LTotal

Thanks, Minty. So when I put that in, Dim LTotal As Long LTotal = DCount("studentID", "Query1") Text19 = LTotal It gives me the total number of records searched with a studentID, not the total pulled into the database that match my search. Any ideas?

Hi Minty, Maybe I've explained it wrong. So if there are 13 items in the database, and 3 of them share unique studentID numbers, the search brings all three of them into the split form. I need a text box to also say that the total number equals 3. Does this help? I have the search and...

Hello, I'm trying to run a line of code after doing a Query Search that reports back the total number of results pulled from the search. I've dug around and found some useful code, but nothing that gives the results I'm needing. Most everything gives me the total number from the query. I'm...

Never mind! I got it...apparently the MACROS were giving my system a security risk...so...I enabled all of those and it's running fine now. Thanks so much for your help!

This is what I entered: Private Sub Command44_Click() MsgBox "Yep, I'm working" End Sub It produces nothing upon a button click. I have no idea why it isn't working. I'm saving after each edit, too. Also, thanks so much for your help GinaWhipp!

I changed the name to lastNameField and edited the code...still nothing. Is there a way to write a simple print statement for the debugger? It's like the code isn't even being attempted. Shouldn't I get an error if it's wrong?

I located the Control Source, but not the Control for the Form. Where would I locate that? Sorry, I program in Javascript and new to Access.

Thanks for the response...but that doesn't seem to work. I'm not sure if the code is just not going hand in hand with the database or what. Any ideas?

Hello! I have a very simple question that I cannot locate an answer to: I have all of my text fields disabled and I want the user to press a button to make them enabled. Seems simple enough. So for instance, I have a field that links to the database called, "lastName" Under the button's...