Search results

Definitely, I’ll try this out and let you the output. 👍🏻

Hi Team, Good evening. I have a bounded form with about 34 fields and I have a "Save" button (to just save the details to the master table) and a "Home" button (to go back home without saving the record when there are any changes made after it is saved). But some users are messing it up by just...

Yeah, @Minty that correct, I'm not saving it as it is a bound form, any changes made, directly reflect into a Table. Sorry for that. Anyways this issue is solved with Me.Dirty=False. Thanks a lot!! :)

Hi Team, I have a bounded form with many fields and I have inserted the "Save" button to save the changes with the help of MsgBox (Yes/No). The problem is when I save it, it saves the form, but later if I change/modify one field and click on "No" to undo the changes, it is reversing all the...

Hi @RuralGuy and @ogg13, I have a similar question. If I would like to select the list box items like 1,4,5,8,10, etc., Is there any possibility that we can use an array of numbers to select the items in the ListBox on Onload event of the form? I tried the below code, it is showing a type...

@Minty , Is there any update on the PPM file? Meanwhile, I have tried a bit on it. But I ended up getting some weird errors like Run-time error 3075 and etc., Thank you :)

@Minty I have provided Nz function because, if the Combo Boxes are selected with some values, the records get filtered based on them and of the combo boxes are left empty, then all the records to be displayed without any filters based on Combo boxes

SELECT Master_DataBase.Function, Master_DataBase.Project_Lead, Master_DataBase.Project_Name, Master_DataBase.Project_Type, Master_DataBase.Certification, Master_DataBase.Manager_Name, Master_DataBase.Sponsor, Master_DataBase.Champion, Master_DataBase.Project_Start_Date...

Yes @Minty, I would like to pick the fields based on the type of report I require. If I would like to pick Completed Projects, I would select almost all the fields and If I would like to pick Project Documentation Status, I would pick a little lesser fields as compared. It is just based on user...

In Form 1, I have the ListBox with the list of Field Headers taken from Master_DataBase Table. And 2 other combo boxes for the Function and Year to be filtered while producing the results.

@Minty I'm extremely sorry and I was completely out while sending you the file. Here's is the revised file and the Login form does not have any restrictions. I have already bypassed it. Form1 is the one I'm looking for.

@Minty I have tried checking the StrSql, it is throwing the positions of it like 2;3;4;5; etc., for the selected items. I'm very new to access and facing these issues. please help!!

Hi @Minty I have tried the below code to get the things done, but I'm still stuck somewhere while opening the report with the selected headers. Private Sub Command6_Click() Dim LstBox As String Dim CmbFunction As String Dim CmbYear As Variant Dim StrSql As String 'LstBox = Me.List7.Value Dim...

Hi Team, Please help me build this up! I have a Master DB Table with about 34 fields and I have specific requirements filtering out the data and export the fields to Excel or PDF. I have built the queries with the requirements of the criteria. The requirement is to create a form with ListBox of...

Thank you @MickJav

@neuroman9999 Thank you so much. :) and sry for the delayed response.

Thank you :)

Thank you :)

INDIA :)

I'm new in exploring the depth of MS Access. Hope this forum would be of help for both sides by more exploration and contribution. :)