Search results

Hi, I want to use MS Forms tree view for one of my folder and used span folder option to populate the tblFileFolder using demo shared by @MajP at Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assis. No of records in the table are 3000. I am then using TreeViewRecordLoader...

Hello, Find attached accdb file to emulate Bootstrap like alerts. See screenshot below: Best Regards

Hi, This is a request if anyone have office 2007 and can convert these mdb files to accdb files for me as I have office 2019 and it doesn't support it. I'll be highly grateful. These are downloaded from Leban's site. Best Regards

Hello, I am using Team-Moeller Better Access Chart for fulfilling my needs related to charts and I must admit it is a great effort by the Team-Moeller which made my life easier. When I want to save and use the chart as picture, it takes too long to complete. On digging up, I found that the...

Hello, I need to print self adhesive barcode labels/stickers just like those which hematology labs use to stick on the blood sample vials. I jave searched for suitable printer and someone suggested that TSC TTL 244 Pro will be suitable but also told me that it require software. I have neither...

Hi, I have a form frmMeeting bound to a table tblMeeting. Structure of the table is below: MeetingID: PK, Long MeetingDate: Date Time MeetingDesc: Text ClientID: FK, Long EmployeeID: FK, Long I want to know the primary key name on form OnLoad event using VBA. The reason why I need this...

Hello, The attached db contain two class module used to highlight active control with colored border like forms on webpages. Idea to highlight active control originally came from Daniel Pineault (DevHut). I wrote the class modules to get the highlighting of active controls. To use, just declare...

Hello, I want to build a database for our workshop tools along with issue and return record so that equipment could be managed in effective way. Issue is, I am not able to understand/get an idea that how to manage components with it. For instance, I have a main equipment say grinding machine...

Hello, Hope you are doing well. I have a pdf/word form which has description text to be entered into three lines therefore I want to split the description string into multiple lines where each line consist of fixed number of characters say 30chrs. Is there a function available which can split a...

Hello, I am trying to write following property procedure in a class module but I'm getting error message that Definitions of property procedures for the same property are inconsistent, or property procedure has an optional parameter, PramArray, or Invalid Set final parameter. Where am I doing...

Is it possible to lock a VBA project with VBA instead of doing it manually by going to the Tools menu, select <Database Name> Properties and protection tab? Best Regards

Hello, I was using this code by @isladogs to open external password protected database in separate window. It works fine in full Access but when gives error for those users who are using Access runtime version. The line of code that gives error is Set App = New Access.Application. How can I...

Hello, I want to create new main page of my app which I want to make like ribbon. I wanted to use custom ribbons but since my app is in Urdu/Arabic language and font supporting good readability of these language is reauired to be applied for labels etc in the ribbon. From this post, it seems...

Hello, In a student database, result of subjects is entered as numeric data and same is the data type of ObtainedMarks field in the tblResult. Then marks of are summed up using either Sum formula or using Total row in query. What it is desired that when a student was absent in a specific paper...

Hello, I am getting subject-mentioned error on execution of both Set sysText = CreateObject(SYS_TEXT_UTF8) and With CreateObject(SHA512_MANAGED). This error is resolved when I install .Net FW 3.5 however there are few PCs with my users on which we are unable to install .Net FW 3.5 as those PCs...

Hello, There is a color option from which we can change whole color scheme of our database. My question is, can we change that color scheme in runtime by having a combo box on a form to change the theme? Best Regards

Hello, I'm working on an Urdu/Arabic project and want to build custom ribbon for navigating for different forms. Ribbon labels will ne in Urdu/Arabic so need to set a font which have better readibility. I search over internet but couldn't find an answer to my query. How can we change font for...

Hello, Is there a better alternative to CDate function which can convert a string to a date and also asks for format of string date being input. For instance, a string "01/07/2021" can be January 7, 2021 and can also be July 1, 2021 depending upon what was the formatted when this date was saved...

Hello, I'm the demo database attached, records are being entered into Hijri dates. Date 1 and date 2 are two unbound textboxes used to filter records. I'm trying to filter records between certain Hijri dates, for instance between 06/01/1443 and 06/13/1443. If records are entered in Gregorian...

Hello, I'm using following code to transfer a table along with its data into other db (backend db of another FE) which already has a table with same name. I intend to replace that table with the transferred one. Also a field in the table is an OLE Object data type. Dim db As dao.Database...