Rabu, 30 November 2016

Re: [belajar-access] Re: Fwd: Privat Access

 

Pdf udh koq. Plz cek


Pada tanggal 1 Des 2016 12.19 PM, "hadis0678@yahoo.co.id [belajar-access]" <belajar-access@yahoogroups.com> menulis:
 

pdf nya dong engkong...


tqqqq


must hdi s

__._,_.___

Posted by: privat access <les.access@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

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.

SPAM IS PROHIBITED

.

__,_._,___

[belajar-access] Re: Fwd: Privat Access

 

pdf nya dong engkong...


tqqqq


must hdi s

__._,_.___

Posted by: hadis0678@yahoo.co.id
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.

SPAM IS PROHIBITED

.

__,_._,___

Selasa, 29 November 2016

Re: [MS_AccessPros] Finding and re-using code

 

Hi Duane

I downloaded a free version of MZ-Tools some time ago and haven't had the time to get to grips with it.  I've some time over the next few weeks, so I'll definitely explore it and possibly upgrade.
Thanks again.
Ray 

__._,_.___

Posted by: rayfrew@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

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.


.

__,_._,___

[MS_AccessPros] Re: Finding and re-using code

 

Hi Glen


Thanks for that.  I'll give it some thought and have it as a little Access project.
Thanks
Ray

__._,_.___

Posted by: rayfrew@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

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.


.

__,_._,___

Re: [MS_AccessPros] Finding and re-using code

 

You might consider MZ Tools. https://www.mztools.com/v8/purchase.aspx Earlier versions had been free but this handy tool is a real time saver for storing code snippets, adding error handling, and much more. You might find it well worth the cost.


Regards,

Duane

www.mztools.com
Note: prices do not include applicable taxes in some countries (EU VAT, etc.) Free upgrade for customers of MZ-Tools 7.0: you should have received an e-mail with the ...




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of rayfrew@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, November 29, 2016 12:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Finding and re-using code
 


Hi Everyone

I'm looking for your thoughts on this, any help appreciated.  I'm finding as I code more modules, I would like to re-use that little trick again.  Rather than rely on my memory that may or not remember that I solved that problem in database xyz, I'd like to save code to be found at a later date.  What I'm thinking is to copy the code into a OneNote page and give it a reasonable title.  I'd be able to search OneNote and copy and paste it into my new database.  Is there a slicker way to have a central code store?  I'm using Office 2016.

Many thanks

Ray



__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
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.


.

__,_._,___

RE: [MS_AccessPros] Finding and re-using code

 

Ray,

 

You could set up an Access file as a code library and import the module into it, then export code from it when needed You can also have a compiled version of the library and set up a reference to it in the VBA. With a code library, the code needs to be generic. That sometimes takes a while to design and write but having a code library can prove to be a worthwhile investment of your time.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, November 29, 2016 1:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Finding and re-using code

 

 

Hi Everyone

I'm looking for your thoughts on this, any help appreciated.  I'm finding as I code more modules, I would like to re-use that little trick again.  Rather than rely on my memory that may or not remember that I solved that problem in database xyz, I'd like to save code to be found at a later date.  What I'm thinking is to copy the code into a OneNote page and give it a reasonable title.  I'd be able to search OneNote and copy and paste it into my new database.  Is there a slicker way to have a central code store?  I'm using Office 2016.

Many thanks

Ray

__._,_.___

Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
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.


.

__,_._,___

[MS_AccessPros] Finding and re-using code

 

Hi Everyone

I'm looking for your thoughts on this, any help appreciated.  I'm finding as I code more modules, I would like to re-use that little trick again.  Rather than rely on my memory that may or not remember that I solved that problem in database xyz, I'd like to save code to be found at a later date.  What I'm thinking is to copy the code into a OneNote page and give it a reasonable title.  I'd be able to search OneNote and copy and paste it into my new database.  Is there a slicker way to have a central code store?  I'm using Office 2016.

Many thanks

Ray

__._,_.___

Posted by: rayfrew@gmail.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.


.

__,_._,___

Re: [MS_AccessPros] Automated Date Stamp

 

James,


In Access you will most likely do this in a form using code/vba in the AfterUpdate event of the PercentageComplete text box. Your code might look something like:


Me.AsAtDate = Now

Regards,
Duane Hookom


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of asanteza@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, November 29, 2016 5:17 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Automated Date Stamp
 


Hi

Help me with a function that performs the action below:

When a user updates "PercentageComplete" field then "AsAtDate" field should stamp current date and time.


Thanks.

James




__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
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.


.

__,_._,___

[MS_AccessPros] Automated Date Stamp

 

Hi

Help me with a function that performs the action below:

When a user updates "PercentageComplete" field then "AsAtDate" field should stamp current date and time.


Thanks.

James


__._,_.___

Posted by: asanteza@gmail.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.


.

__,_._,___

Jumat, 25 November 2016

Re: [MS_AccessPros] Using the OenFileDialog...

 

Art-


In your For Each varFile loop, do an insert to a "working" table that you've cleared out previously in your code with at DELETE *.  Then use that table as the Record Source for your continuous form.

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 Nov 25, 2016, at 9:05 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



I am using the OpenFileDialog to copy files around. Here is the code:


Private Sub cmdBrowse_Click()
  Dim fDialog As Office.FileDialog
   Dim varFile As Variant

   ' Clear listbox contents. '
   Me.FileList.RowSource = ""

   ' Set up the File Dialog. '
   Set fDialog = Application.FileDialog(msoFileDialogFilePicker)

   With fDialog

      ' Allow user to make multiple selections in dialog box '
      .AllowMultiSelect = True

      ' Set the title of the dialog box. '
      .Title = "Please select one or more files"

      ' Clear out the current filters, and add our own.'
      .Filters.Clear
      .Filters.Add "Access Databases", "*.MDB"
      .Filters.Add "Access Projects", "*.ADP"
      .Filters.Add "All Files", "*.*"

      ' Show the dialog box. If the .Show method returns True, the '
      ' user picked at least one file. If the .Show method returns '
      ' False, the user clicked Cancel. '
      If .Show = True Then

         'Loop through each file selected and add it to our list box. '
         For Each varFile In .SelectedItems
            Me.FileList.AddItem varFile
         Next

      Else
         MsgBox "You clicked Cancel in the file dialog box."
      End If
   End With

End Sub


Right now I have the results going to a listbox called FileList. What I would like to do is throw the results into a continuous form so I can manipulate them the further. I need to be able to either copy the file to a specific location which is set prior to this code running or delete the file from the continuous list.

Any ideas?

Thank you ,

Arthur Lorenzini
Sioux Falls, SD






__._,_.___

Posted by: John Viescas <johnv@msn.com>
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.


.

__,_._,___

[MS_AccessPros] Using the OenFileDialog...

 

I am using the OpenFileDialog to copy files around. Here is the code:


Private Sub cmdBrowse_Click()
  Dim fDialog As Office.FileDialog
   Dim varFile As Variant

   ' Clear listbox contents. '
   Me.FileList.RowSource = ""

   ' Set up the File Dialog. '
   Set fDialog = Application.FileDialog(msoFileDialogFilePicker)

   With fDialog

      ' Allow user to make multiple selections in dialog box '
      .AllowMultiSelect = True

      ' Set the title of the dialog box. '
      .Title = "Please select one or more files"

      ' Clear out the current filters, and add our own.'
      .Filters.Clear
      .Filters.Add "Access Databases", "*.MDB"
      .Filters.Add "Access Projects", "*.ADP"
      .Filters.Add "All Files", "*.*"

      ' Show the dialog box. If the .Show method returns True, the '
      ' user picked at least one file. If the .Show method returns '
      ' False, the user clicked Cancel. '
      If .Show = True Then

         'Loop through each file selected and add it to our list box. '
         For Each varFile In .SelectedItems
            Me.FileList.AddItem varFile
         Next

      Else
         MsgBox "You clicked Cancel in the file dialog box."
      End If
   End With

End Sub


Right now I have the results going to a listbox called FileList. What I would like to do is throw the results into a continuous form so I can manipulate them the further. I need to be able to either copy the file to a specific location which is set prior to this code running or delete the file from the continuous list.

Any ideas?

Thank you ,

Arthur Lorenzini
Sioux Falls, SD



__._,_.___

Posted by: dbalorenzini@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.


.

__,_._,___