Recent content by MG101

Hi All, I currently have a small database which contains part return information. I have had help from others on this forum and have been able to create a cascading filter form. This form takes the users inputs and creates a custom report. Currently, it will create a report with three...

Hi All, I currently have a small database which contains part return information. I have had help from others on this forum and have been able to create a cascading filter form. This form takes the users inputs and creates a custom report. Currently, it will create a report with three fields...

Reference File for Billmeye:

OHHH OK I was confused for a second. I thought the code you posted was one you looked at and fixed to help me... I get what you were saying now. haha sorry. and thanks! Ive been wanting to know how to do that! I will definitley use in the future!

Hi accessblaster, I tried placing the code in the custom3 form page under a click command. But it didnt work. Is it supposed to go somewhere else? Thanks!

Here is the filter code I tried adapting. I had troubles. Any advice? File is also attached. Private Sub Report_Open(Cancel As Integer) Me.Text1.ControlSource = Forms!custom3!Combo1 Me.Text2.ControlSource = Forms!custom3!Combo2 Me.Text3.ControlSource = Forms!custom3!Combo3...

Thanks! That worked perfect! Is it easy for you to explain the use of " and & like that in coding, I am not very fluent at all and was just curious if it was easily explainable. If not, Thanks anyways :D

Hi Pbaldy, I tried your code and I received a compile error. I added a quotation before SELECT and it seemed to resolve the error but when I go to try the code out, the listbox remains blank. Here is my file for reference if you like. I left the code in the after update and on change of the...

Hi All, I am currently trying to make a form which will generate a report for the users. Currently the form has 3 combo boxes where users select which fields they want displayed from the table in the report. They also have sorting options next to them (Asc or Desc). I am now trying to put in a...

Hi Billmeye, I am just now getting to this custom report function. I got busy with some other stuff to work on haha. I have been able to get to filter part and was about to attempt it. I created a list box with the multi select function. I am having trouble getting the possible values to...

Hi Billmeye, Thanks for the reply! I do have the full version of Access and will try to adapt this code. I will probably have anywhere from 1 to 4 filters for the report based on how many fields there are. The date functions feels straight foward and should be quite easy to implement...

Hi Billmeye, Sorry to bother you again, but Is it also possible to have an additional combo box as a filter for each field selected. For example, If a user selects part type as a field, maybe they only want the report to display the DCV3's and ELCM's. Could they select which ones to include...

That makes sense! Thank you again! I wish I knew basic VBA functions, the coding for this isnt very complex, If I only knew some of the main functions that were available. Haha. I spent about 3 hours googling for the VBA you did in a few minutes. Thank you thank you thank you!

Do you think I could create a additional combo box that goes underneath each combo box on the form so that the user may decide how field is sorted (Asc or Desc or Not at all)?

Thats exaclty what I wanted! Thank you so much! Is it possible to also control the sorting of the fields? First by.., second by..., etc.? Thanks again! :D