Search results

Actually I don't have one. We have the hardware present with us physically and are just logging issue/return on register so that we know if an equipment is not present in workshop, we should know who has borrowed it.

Hi, thanks for the reply. I haven't built the database yet other than the three tables as suggested by @GaP42 two of which with the following fields: TblEquip (tblCmp) EqID (CmpID) EqName (CmpName) EqSrNo (CmpSrNo) EqTag (CmpTag) EqBrand (CmpBrand) EqPurchaseDate (CmpPurchaseDate) While third...

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

We have a form in the office with fixed format/pattern (with predefined documented formatting like font style, size etc) in which have a field "Document Description" which is split in 3 lines. I want to create the same in access so I have to keep the same format. The code you provided fulfill my...

Here is the updated code that can hyphenate the words if the words are greater than certain length (passed as parameter): ' ---------------------------------------------------------------- ' Procedure Name: SplitString ' Purpose: To restructure long lext into shorter strings of ' less or equal...

Because these is limit of characters in the form I'm inserting data in. Characters above that limit go beyond the visible area.

Hi, I was trying to put another possibility by modifying code by @jdraw in #11. Possibility to hyphenate the next word if it is larger than 7 characters and by adding it make the line length longer than the limit but I'm not successful yet. I'll post it if succeeded.

Thanks @Josef P. This code also gives the same results as that of the code provided by @jdraw. Thanks a lot.

Thanks a lot @jdraw . It works as required.

Thank you very much everyone for sparing time to reply. Yes this is exactly what I want. Split the text in multiple lines just like you you demonstrate in the example. It would be so kind of you if you could post it. Sorry but I didn't understand this question. Thanks for the code. I'm on...

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

Thanks everyone for explaining. @isladogs yes, If module and variables could be seen then it is not worth the effort.

Hello again, Can I use this method to perform the same operation on VBE project in other db? I could find a way to set active VB project to other db VB project. Best Regards

I'll check when on PC.

When VBA project is password protected, modules amd procedures are not visible until password is entered or password is removed by any method. I am concered about keeping safe my app from being cracked and data as well. I am isong BE encrypted with password.

I thought it might make it more secure. Can we see module names in accde?

Yes I know how. But I do it along with other security measures like hiding navpane, setting allowbyoas to false, converting to accde and encrypting it.

Yes, it is another property in the class module to create property in database.

Thanks, removin byval and switching positions of Let parameters solved the issue. Thanks again.

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