Search results

  1. C

    Adding watermark in word using Access VbA

    aman, add a new bookmark called "UserName" in your word document, the best place would be on the bottom section. then Place this code in a module : Public Sub InsertBookMarkText(strBookmark As String, varText As Variant) On Error GoTo ErrorHandler Dim BookmarkRange As Range Set...
  2. C

    Open report from another report

    Try this one: DoCmd.OpenReport "Order_Details", acViewReport, , "Order_ID=" & Me.txtOrder_ID", acNormal
  3. C

    How can I replace the access icon in the taskbar?

    Like David said before google is your friend. how to create a shortcut : http://windows.microsoft.com/en-us/windows7/create-or-delete-a-shortcut how to change a shortcut icon (and others) : http://www.howtogeek.com/howto/13631/ success,
  4. C

    Running a Macro inside a macro in excel

    Hi, I presume that "ResetFromRecorded" is a sub in a module like "restoreMainTable". so you can do the following : Sub restoreMainTable() Sheets("recordedPositions").Select Range("A4").Select Call ResetFromRecorded End Sub Success
  5. C

    Adding watermark in word using Access VbA

    Hi Aman, Sorry for late response, Public Function InsertHeaderLogo(fnBackGroundPic As String) Dim Shp As Word.Shape On Error Resume Next 'Background Picture If Not fnBackGroundPic = "" Then Set WordLogo =...
  6. C

    Adding watermark in word using Access VbA

    Hi aman, Which type of paper size are we talking, A4, us Letter,.... ?
  7. C

    Updating date when modifying data

    Hi David, Your advice is better :) then mine
  8. C

    Updating date when modifying data

    you could use on change event for each field. for example : Private Sub txtField_Change() Me.[Modified Date] = Now() End Sub
  9. C

    GoToRecord

    Below right on my last post you can find the Thanks button :) See attachment
  10. C

    GoToRecord

    hi Reburton, I still have your Orginal db, I have looked at your problem that you can not create a new record and found that you have entered on the control "cbobilName" an inputmask. And i have removed it so now it works properly I think. This was causing an error. I will attach both db's so...
  11. C

    GoToRecord

    Hi, for example : you have a invoice n° 126 and in that invoice you have 4 detail records. When you add invDetail to your query it creates 4 lines for the invoice n° 126 instead of 1 contrcator
  12. C

    GoToRecord

    Hi, Just remove the table "tblInvDetail" on your qryInvoice and that should do the trick. Contractor
  13. C

    Adding Windows username in a new record?

    Cronk, The only code that i have provided was to get network username, the other part belongs to himself...
  14. C

    Open Form to Specific Record

    Indeed, remove embedded macro on the form "Ticket Entry" load event, if you want to add a new data just use the following line DoCmd.OpenForm "Ticket Entry", , , , acFormAdd contractor
  15. C

    Adding Windows username in a new record?

    Check via form design view if the button code is on click event. see attachment contractor
  16. C

    Adding Windows username in a new record?

    This code cmdFind_Click() should be placed behind the button, and not in a module ! contractor
  17. C

    Scanning Documents To Get Counts

    Hi, Maybe this link will help you to get an idea http://www.vbaexpress.com/kb/getarticle.php?kb_id=1101 contractor
  18. C

    Open Form to Specific Record

    hi, I think that you have a syntax error, DoCmd.OpenForm "Ticket Entry", , , "[Ticket Number] =" & Me.Ticket_Number contractor
  19. C

    create values from other subform

    Hi tubar, Can you post a example db? so i can help you out contractor
  20. C

    Report name as variable

    Hi chris, Example : Reports(srReport_Name).Caption = "TESTING REPORT" success Contractor
Top Bottom