Recent content by Felix314

This post is directed to the genius, boblarson. Of course, I would really appreciate any other help. Hi Bob, I am really stumped with this "Send2Excel" module, as I have checked everything numerous times to make sure the code is written and called correctly with the proper reference. I...

Bob, I'm not sure why this is, but whenever I try to do the same thing and I click on my main form button to send a subform's results to Excel using your "Send2Excel" module code, an error pulls ups saying: "Compile error: Sub or Function not defined" It then highlights the top line in my...

Thanks for the link John. However, I am already familiar for doing basic exports of Access objects to Excel. This situation is bit more specific though since it is a filtered subform, which is dependend on what is typed in the text box control. I am hoping for users to type in the box to...

Hi John, I'm sorry, please ignore what I asked just recently. All I am left to figure out is if there any way to then export the filtered results to an excel sheet? I will trust your genius.

Hello everyone, Just wondering if anyone can help solve this problem. This forum is awesome, and I thank all who can help. It is much appreciated. So, here's my issue... I would like to export a filtered subform on a main form to an excel file by clicking a command button with VBA code...

Hello again, So I actually got the code to work for filtering a subform using the text box. I went back to the code I posted and realized that for ADP files, you must use % instead of *. When I did that it worked. Here's the updated code: Option Compare Database Private Sub...

I would post a copy, but it is an ADP file, as the db is connected to a SQL Server backend. It wouldn't work for you since all the tables are stored on my work server database. I believe the problem is simply that I am working with an ADP project. The query process is just not the same as...

Sorry, I will use the code tag from now on. Yes, I changed all the references when I put it in my DB. Something must be wrong with the subform itself. I'm not sure what, because it's pretty simple. It's based on 3 tables, with the bulk of the data coming from a foreign key table. For some...

When I try the version from the sample db, it keeps pulling up the Run-time error '7874' and when i hit Debug, it highlights "Me.Refresh" with a definition that "Identifier under cursor is not recognized". Thought this would help. I probably should give up though.

Hello John, Thank you so much for your help. I looked at the sample db, tried out the method, and it would not work at all. I put in the code for the On Change event to fit my db, and when I tried to type in the text box, it said access can't find the object 'SELECT (All Fields) FROM (Tables...

Hello everyone, I have researched and tried just about all I can on this subject, but I understand my situation is different since I am working on ADP file, using Access on the front end and SQL Server on the back end. The biggest problem is that my query designs are not as sophisticated as...

Hey JBB, any advice you can give me?

Ok, well that is good to know. Appreciate your guidance and time JBB :D I'm eager to see what you come up with.

Jeez sorry again, ignore that one. I didn't make the primary keys for the course tables. Here it is.

Sorry, in my haste, I forgot to include my two master tables and the relationships between primary and foreign keys. I have updated it now... I assume it is normalized fine?