DD's Stats

Members
Total Members: 160
Latest: drakopp
New This Month: 10
New This Week: 3
New Today: 1
Stats
Total Posts: 888
Total Topics: 452
Most Online Today: 1
Most Online Ever: 52
(May 02, 2020, 05:24:19 pm)
Users Online
Members: 0
Guests: 1
Total: 1

Recommended Posts

DD Approved Members group Added by DD Admin
05-06-2020, 12:48:35


Posting Additions or alterations rules by DD Admin
27-02-2020, 10:33:01


A Trip Down Memory Lane by DD Admin
24-08-2019, 14:17:16


Todays Birthdays

DD's Top Posters

DD Admin
Posts: 923
borobutch
Posts: 70
Carol
Posts: 12
Ram
Posts: 8
Clarissa
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

Author Topic: Task management errors and corrections  (Read 33 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 923
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Task management errors and corrections
« on: March 29, 2020, 07:13:22 pm »
If you find a error then please tell us about it.

Thanks mick

Share on Facebook Share on Twitter


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 923
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Task management errors and corrections
« Reply #1 on: March 29, 2020, 08:56:53 pm »
I noticed today when working on the charitable Contributions On the customer Contacts form I have not added any way of entering a new job type so add the code below in the JobTypeID NotInList event

Code: [Select]
On Error GoTo HandleErr

    Response = FillListsOne(NewData, "LtblJobTitleLookup", "JobTitle")
    If Response = acDataErrContinue Then
        DoCmd.RunCommand acCmdUndo
    End If

HandleExit:
    Exit Sub
   
HandleErr:
    Select Case Err.Number
        Case Else
            MsgBox Err.Number & vbCrLf & Err.Description
            Resume HandleExit
        Resume
    End Select

I will add some other items for this including a lookup form and subform and a double click you could add these from the Charitable Contributions Template

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 923
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Task management errors and corrections
« Reply #2 on: April 08, 2020, 07:58:55 pm »
Just noticed while working on another template the navigation buttons on frmTasks are not required but should you wish to make it into an entry screen you will need an auto lookup query.

if you don't know what one is please let me know and I'll post the SQL and a description of how to update the screen.

mick

 

Related Topics

  Subject / Started by Replies Last post
5 Replies
432 Views
Last post December 29, 2019, 09:33:04 am
by DD Admin
0 Replies
23 Views
Last post October 14, 2019, 09:47:50 am
by DD Admin
0 Replies
25 Views
Last post March 15, 2020, 07:13:20 pm
by DD Admin
0 Replies
130 Views
Last post March 26, 2020, 11:06:22 am
by DD Admin
0 Replies
11 Views
Last post November 16, 2020, 06:55:45 am
by DD Admin

DD's Social Media

DD's Programs


Development Schedule

DD's Freeware

Apollo

DJ 2020

Chart Tracker Elite

Works Manager

Contact Manager

Simple Home Accounts

Book Library

Picture Library

Project Manager (accde)


Developer Tools

Project Manager (accdb)

Style Manager

Code Library


Open Code Templates

Master Template

Task Management

Charitable Contributions

Bug Tracker Template

Time And Billing Template

Real Estate Template

Household Inventory V1


Open Code Examples

DD's Northwind V1

Employee Example V5

Grid Demo Example V1

Employee Example V4

Small Examples


Recent Topics

Apollo Project Status by DD Admin
January 20, 2021, 05:42:43 pm

Please welcome drakopp to DD by DD Admin
January 20, 2021, 03:06:42 pm

UK Singles/Albums Charts 08 Jan 2021 to 14 Jan 2021 Analysis by borobutch
January 20, 2021, 02:58:50 pm

Apollo Manual: Other Items by DD Admin
January 19, 2021, 09:46:46 am

Please welcome aaronsql2019@ to DD by DD Admin
January 18, 2021, 09:09:47 pm

Apollo Manual: Recordings by DD Admin
January 18, 2021, 01:40:58 pm

Apollo Manual: Preferences by DD Admin
January 18, 2021, 11:36:26 am

Database Dreams is not affiliated with Microsoft