Search results

Hello, Hope you are all in good health. I am facing an unexpected issue. FE of my application is being used two locations where both locations have different encryption password for their Access BE database. I'm using following code to update password in the FE when rhe file load. First it...

Hi, I have two tables named as tblStudents and tblStudentClass and their structure is as below: tblStudents: StudentID (PK) StudentName tblStudentClass: RecordID StudentID (FK) ClassID (FK; from another table) DateOfAdmission DischargeDate tblStudentClass can have multiple records for a single...

Hi, I want to print a payment receipt whose width is 3" (width of the paper roll in thermal printer) and height can vary from 3-6". In access I am unable define custom paper size and page size is set to A4. See the following image in which I tried to present a an A4 paper in portrait...

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...