Search results

Hi @isladogs, First of all thanks for reply. The video isn't playing and giving error "An error occurred. Please try again later. (Playback ID: sBxjSyYeGaxa6QWh)". Can you recheck the link and post updated one? As that of edge browser control, all of the users of my project are below office...

Thanks a lot @The_Doc_Man for such a detailed reply. As 1, 2 are out of options, I am left with option 3 and 4. Sledgehammer will be my last resort if 4 couldn't be applied. Can you share some code or guidelines by which I can get process id of IE that is just created and then terminate the...

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

Thanks for explanation. I look further into it.

How do you print using these printers? Can you share VBA Code?

Yes, I have been using it for atleast two and half years without any problems. Yes the code handles add/edit and deletes. Algorithm being used as below: When the form is fully loaded, code create each form's (including subforms) recordsource table as Temp_TableActualName and copies the data from...

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