Search results

Yeah I know about this free 3 of 9 font. But thanks for sharing. However I am interested in is to use thermal barcode printer to print the tag.

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

Hello, The link I posted in my former reply is tested by me and I'm using it in my projects and it is quite simple. It uses a temp table to hold the record until the form is closed. If undo is required data from temp table is copied back into the main record to undo. If the changes are...

Hi, This is an old thread but I am posting in it so that if someone else is looking for undo in subforms, he might find this useful.

Thanks a lot for uploading 32bit version.

Thanks you very much @MajP, @CJ_London for valuable suggestions. I'm truly grateful. That will suffice my requirement.

Thanks a lot @MajP and @KitaYama for so quick response. I have one more associated question. I have a form who recordsource is a query which have main table that is being written plus one Inner join table to show names of emoloyees like: Table being written/modified in the form is tblMeeting...

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

If it could be made 32bit compatible, that would be great.

@jdraw, there were few issues in my code due to which skipped use of hyphen but the db that you provided in post#27 is working perfectly so I replaced code in my project with the one in your uploaded db (post#27) and now started using hyphen too as required. Thanks a lot.

Hi, Please find attached truncated database showing how string is split in the report. This is what I am using currently in my project. Best Regards

Hello, Sorry for late response. I'm away from the pc on which the code is present so I'm writing it down here. It is enum for getting output as array of lines of text after splitting or as a string with each line separated by vbCRLf. Public Enum ssOutputAs oaString = 1 oaArray = 2 End...

@Eugene-LS, modifying each control seems time consuming and harder one as compared to adding a single line of code in the form OnOpen event. Secondly for using method 1 (the less code one), you can select all controls and set OnGotFocus and OnLostFocus properties to =FnName() to run the code but...

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

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.