+ Reply to Thread
Results 1 to 9 of 9

JobCard Printing in VBA

  1. #1
    Registered User
    Join Date
    11-14-2018
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2016, Office 2010
    Posts
    26

    JobCard Printing in VBA

    Dears,

    happy to be here as new bee. I hope I can learn a lot in this sites. hope you help me.

    I have JobCard to print with 9 different data for all 31 days. I have more than 850 cards to print.
    How can I create a new card, move previous and next card, edit and update in the attached file.

    I have sample file and the data.

    This will be great to you if you could help me to get rid of this.

    Regards,
    paul
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-14-2018
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2016, Office 2010
    Posts
    26

    Re: JobCard Printing in VBA

    Hai,

    Regarding my earlier request, I did almost 90%. I coded to move the record to Last, Next, Previous and First record. It is successful.
    The problem I am facing is when I Saving a record as New and Update.

    It saves but it is not storing on right cell. The data are shuffled and stored in different cells.

    Kind help required. Advance Thanks.

    Regards,
    Paulc
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-14-2018
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2016, Office 2010
    Posts
    26

    Re: JobCard Printing in VBA

    Is it possible for vlookup formula for such entry?

  4. #4
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513

    Re: JobCard Printing in VBA

    hi your code is have most repeat same as code
    try change to this
    YOU MUST RIGHT KLIK your button and remove makro then right klik choose new
    then you call ModButton and ModPrint1

    Please Login or Register  to view this content.
    THIS IS modbutton
    Please Login or Register  to view this content.
    and this modPrint1
    Please Login or Register  to view this content.
    Last edited by daboho; 11-19-2018 at 06:17 AM.
    "Presh Star Who has help you *For Add Reputation!! And mark case as Solve"

  5. #5
    Registered User
    Join Date
    11-14-2018
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2016, Office 2010
    Posts
    26

    Re: JobCard Printing in VBA

    Thanks for your help, the code to move the record is fine (First, Previous, Next and Last).

    But I am stuck in Saving the record as NEW and Update the record for any change.
    I cannot save New record and cannot update after edit.

  6. #6
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513
    Quote Originally Posted by paulc869 View Post
    Thanks for your help, the code to move the record is fine (First, Previous, Next and Last).

    But I am stuck in Saving the record as NEW and Update the record for any change.
    I cannot save New record and cannot update after edit.
    You can use modPFD to save all data to folder

  7. #7
    Registered User
    Join Date
    11-14-2018
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2016, Office 2010
    Posts
    26

    Re: JobCard Printing in VBA

    But there is no modPFD code in the macro.

    The code you helped is just change record back and forth. I don't find macro to save a New Record or Update old Record.
    Last edited by paulc869; 11-19-2018 at 11:26 AM.

  8. #8
    Registered User
    Join Date
    11-14-2018
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2016, Office 2010
    Posts
    26

    Re: JobCard Printing in VBA

    modPFD is code or comes inbuilt in Excel Application? Please I don't really understand.

  9. #9
    Registered User
    Join Date
    11-14-2018
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2016, Office 2010
    Posts
    26

    Re: JobCard Printing in VBA

    I tried this code but not success. It saves the record data but id different cells and it get mixed.

    Please Login or Register  to view this content.

    Can you help me regarding modPFD, Please.
    Last edited by paulc869; 11-20-2018 at 01:54 AM. Reason: clear reason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. next jobcard number
    By Calvin13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2018, 04:10 AM
  2. printing page number while printing entire workbook
    By shakir1401 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-23-2015, 06:06 PM
  3. I need guidance on programming an excel spreadsheet for a jobcard
    By pkwee25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2015, 04:21 PM
  4. Replies: 1
    Last Post: 06-11-2014, 09:23 AM
  5. Replies: 0
    Last Post: 02-27-2014, 01:31 PM
  6. Replies: 0
    Last Post: 07-18-2012, 03:57 AM
  7. WHERE CAN I FIND N JOBCARD TEMPLATE
    By MARTHIN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2005, 04:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1