Search results

  1. arnelgp

    Solved Print only Selected Item in a List box

    here is a demo, view the code on the Button on form1.
  2. arnelgp

    Fast 5th Generation SSD Transfer Rate

    i have just Returned the external drive i purchased, it's made of china and what inside is just like a small pendrive. the drive is 4T. i needed it to backup my files 90G. it copied alright, but the problem is all the copied files are not readable or not in expected format.
  3. arnelgp

    Solved Problem with the format property of a combo box.

    if you have already a solution just ignore the sample db. the demo db is for others, who will find your post and will find it useful for them.
  4. arnelgp

    Solved Problem with the format property of a combo box.

    here is another demo, the code provided by Mr.DougSteel.
  5. arnelgp

    Solved Problem with the format property of a combo box.

    you can add 2 dummy textbox in front of those comboboxes.
  6. arnelgp

    Solved VBA blocking the saving of foreign key and line numbering in the subform and child table

    test your form and check out the code on AfterUpdate event of txtProductCode.
  7. arnelgp

    Pat Hartman has left the building

    Oh no.. I will miss my Grand School Teacher. We have many quarrels on the past (even on PMs). But not enough, I supposed for her or Me to leave.. anyway, Farewell my friend (just follow the light and the end of the tunnel..) you will have more time with your Amigas playing your favorite card...
  8. arnelgp

    Access File Recovery

    you put it on onedrive or dropbox and share the link, so anybody can try to recover your db. I also have S. Repair for Access.
  9. arnelgp

    Free lancing on weekends for Excel VBA projects? Possible? Reality? Legal?

    most that i know are looking for someone who can work on google sheet (with script). so they want their sheet available over the net. plus, if you are very good in making outstanding dashboard in google sheet.
  10. arnelgp

    Hello From Saudi Arabia

    i got the translation from Google translate, so pardon me. i have worked, during my early days, in saudi arabian army in tabuk.
  11. arnelgp

    Hello From Saudi Arabia

    بسم الله هير الرحمن نير رحيم
  12. arnelgp

    How to always set focus on the control on parent form after entering data in the subform

    on the AfterUpdate event of txtProduct, I Activate the Timer Event and on the Timer Event, I clear TxtProduct and Setfocus to it.
  13. arnelgp

    Solved Position form to added record

    When you Requery the form, all Bookmarks are reset (invalidated), and the Bookmark that you saved will not guarantee to put you on correct record.
  14. arnelgp

    How to Populate a Control in Code and Make it Behave As Though Populated in the GUI

    you call VendorIDBeforeUpdate() again on the DblClick Event: Private Sub cboDefaultVendorNo_DblClick(Cancel As Integer) On Error GoTo cboDefaultVendorNo_DblClickErr ' Populate cboDefaultVendorNo in code MakeFormPick Me.Parent.Name, "frmCrdVendor-Pick", "cboDefaultVendorNo"...
  15. arnelgp

    Solved How to add text to a null value field in an access report

    if you can share a trim down version of your db, so we know what is going on.
  16. arnelgp

    Multiple member List

    are you sure that the Denomination is Christian? Christian don't allow multiple marriage when his/her partner is still alive. Muslim can have 4 wifes the max. anyway, there are two queries on the demo db. qryMarriedMen only list all men that are married. qryHusbandAndWives is the one you need...
  17. arnelgp

    Solved Position form to added record

    maybe you can test this: Public Sub AddItem(ID As Long, strITPath As String) Dim strCriteria As String Dim lDocNo As Long Dim strSql As String Dim rst As DAO.Recordset Dim strBookmark As String...
  18. arnelgp

    Set focus to textbox in subform after clicking command button

    are there "other" codes on your main/subform aside from the Load event of your main form? are there other subforms on Main form?
  19. arnelgp

    Set focus to textbox in subform after clicking command button

    what code does you have? i strongly suggests post #5 code. on the Load Event of your MainForm: Private Sub Form_Load() With DoCmd .GotoControl "yourSubformName" .GotoControl "textboxNameOnYourSubform" End With End Sub
  20. arnelgp

    windows 11, cant see hidden files in folder

    if there are system files, you can remove their System attribute: Attrib *.* -s -h -r attrib switches are command-line options used with the attrib command to display or change file attributes, such as +r to set a file as read-only or -h to remove the hidden attribute. Switches like /s and...
Back
Top Bottom