Selasa, 31 Juli 2018

[AccessDevelopers] File - Monthly_Notices.txt

 


Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (169)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


Please zip all files prior to uploading to Files section.

SPONSORED LINKS
.

__,_._,___

Senin, 30 Juli 2018

[MS_AccessPros] Re: Error on append query

 

Thank you.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

[MS_AccessPros] Re: Error on append query

 

When you turn off the warnings nothing triggers an error. It just fails silently. You could use VBA code to trap errors and leave the warnings on. See my respond in msg # 117742.



---In MS_Access_Professionals@yahoogroups.com, <no_reply@yahoogroups.com> wrote :

Hi..


I create an append query to add data from a form to a table. I use setwarning=false to hide the warning message. But I noticed that if I key-in invalid data, the query will not save anything to the table.


What I want is how I can get an alert/message when there is an error. Just a simple message like "Error!! Data will not be transfer to table." will do. Doesn't matter what ever the reason is.


Thank you in advance for any respond.

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

[MS_AccessPros] Re: Error Trapping for a Append Query

 

Jim - When an action query is cancelled it generates Err 2501 so you can capture the error this way:


Public Function Test_code() As String
    Dim strQuery As String
    

    On Error GoTo err_PROC

    strQuery = "Employees Query1"
    DoCmd.OpenQuery strQuery
    MsgBox "Process completed", vbInformation

exit_PROC:
    On Error Resume Next
    Exit Function

err_PROC:
    Dim strErrMsg As String
    Dim lngIcon As Long
    
    Select Case Err.Number
        Case 2501
            'Open cancelled.
            strErrMsg = "Action Cancelled."
            lngIcon = vbOKOnly + vbInformation
        Case Else
            strErrMsg = Err.Description
    End Select

    If strErrMsg <> "" Then MsgBox strErrMsg, lngIcon, _
        "Error!"
    
    Resume exit_PROC
    
End Function

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :

Hello all,


I have an append query being run from a button on a form. The user wants to see the Warnings pop up for the append query. But if she clicks NO to run the append query, the Message box appears stating that the process has run. How would I trap that error and not get a message box that states that a process was run when it really was not?


Right now it is in a macro which it will be moved to VBA.


the macro goes like this


SaveObject


qry_AppendVacancyRecordToTrackingComplete


message box "The Process has completed"


Thank You


Jim Wagner

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

Rabu, 25 Juli 2018

[MS_AccessPros] Error Trapping for a Append Query

 

Hello all,


I have an append query being run from a button on a form. The user wants to see the Warnings pop up for the append query. But if she clicks NO to run the append query, the Message box appears stating that the process has run. How would I trap that error and not get a message box that states that a process was run when it really was not?


Right now it is in a macro which it will be moved to VBA.


the macro goes like this


SaveObject


qry_AppendVacancyRecordToTrackingComplete


message box "The Process has completed"


Thank You


Jim Wagner

__._,_.___

Posted by: luvmymelody@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

[MS_AccessPros] Error on append query

 

Hi..


I create an append query to add data from a form to a table. I use setwarning=false to hide the warning message. But I noticed that if I key-in invalid data, the query will not save anything to the table.


What I want is how I can get an alert/message when there is an error. Just a simple message like "Error!! Data will not be transfer to table." will do. Doesn't matter what ever the reason is.


Thank you in advance for any respond.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___