Selasa, 21 Maret 2017

Re: [MS_AccessPros] Re: Using Bar Codes in Access

 

John,

One of the reports rptCustInvoice and there are others. I will send you a list. 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  







From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, March 21, 2017 3:46 PM
Subject: Re: [MS_AccessPros] Re: Using Bar Codes in Access

 
Art-

Yes, add a button and add:

     If Not Me.NewRecord Then
         ' Select the record
         RunCommand acCmdSelectRecord
         ' Delete it
         RunCommand acCmdDeleteRecord
    End If

There should be no missing forms.  What are you missing?

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Mar 21, 2017, at 10:30 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

I have also run across missing reports and forms, is that intentional or am I missing something? 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."   







From: "Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com> 
Sent: Tuesday, March 21, 2017 3:25 PM
Subject: Re: [MS_AccessPros] Re: Using Bar Codes in Access

John,

What would I need to do to incorporate a delete button? I know add the button... 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."   







From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com> 
Sent: Tuesday, March 21, 2017 3:18 PM
Subject: Re: [MS_AccessPros] Re: Using Bar Codes in Access

 
Art-

Note that all forms that edit major records have a record selector bar.  Click the bar and then press Del to delete the record.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Mar 21, 2017, at 9:42 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,
 I notice that you do not have an delete buttons on your edit forms. How are you deleting a let say a customer record? 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."   







From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com> 
Sent: Tuesday, March 21, 2017 6:31 AM
Subject: Re: [MS_AccessPros] Re: Using Bar Codes in Access

Art-

When you run the old Inventory app in 2007 or later, the custom menus and toolbars show up on the Add-Ins tab.  That tab appears only when a custom menu or toolbar is active - for example, when you open one of the main data edit forms like frmCustomers.

Ideally, those should all be converted to custom Ribbons.  See the Contacts app in the 2007 and 2010 books for an example of how that's done.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Mar 21, 2017, at 12:49 AM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



In your Inventory System you are using Custom Report Toolbars and a Custom Print Menu. Can you carry those forward to Access 2013 or where are they defined in your application?

Thanks Art

















__._,_.___

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (13)

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.


.

__,_._,___

Tidak ada komentar:

Posting Komentar