Minggu, 31 Desember 2017

[belajar-access] Tanya runtime ma acces

 

Master saya mau tanya:
1. kalau saya buat aplikasi dari acces 2007, kalau saya copy ke client tapi acces misalkan 2010, 2013, 2016 apakah jalan ?
2. Kalau sebalinkya gimana ? saya buat dari access 2016, tapi client acces 2007,2010, 2013 apakah jalan?
3. Masalah windows 10 nih kalau saya lihat windows 10 support hanya acces 2013 dan 2016, kalay saya develop pake acces 2007, 2010 itu aplikasi saya copy ke windows 10 punya client jalan gak ya ?

Maaf banyak nanya, soalnya masih baru belajar coding nih, mau lihat karakteristik aplikasi acces, seperti apa


__._,_.___

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

SPAM IS PROHIBITED

.

__,_._,___

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

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

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

.

__,_._,___

[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 (162)

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.

.

__,_._,___

Jumat, 29 Desember 2017

Re: [MS_AccessPros] Importing Excel Data into a temporary table

 

you're welcome, David ~ happy to help

 °~ hApPy NeW YeAr ~°~

have an awesome day,
crystal

On 12/19/17 7:41 AM, david.pratt@outlook.com [MS_Access_Professionals] wrote:
Thank you for the reply Crystal.

I spent most of yesterday reading books and doing internet searches and came up with the VBA code necessary to import my Excel file.  I just got it working late last night so I am good now.

That is good to know about the internal tables.  I would never have thought to have even looked at them.

David


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

Hi David,

as for controlling the wizard dialog boxes, you cannot do that ... but you can use the specifications you can create there.

The tables that store import/export specs are:

MsysIMEXspecs
MsysIMEXcolumns

While you cannot modify the tables directly, you can use APPEND queries to add records to those tables -- and you can delete records from them directly. You can probably use UPDATE queries on them too, but what I usually do is

1. make-table from the columns of a spec using MsysIMEXcolumns
2. delete rows from MsysIMEXcolumns for a particular spec
3. modify specs
4. use APPEND query to write records back to MsysIMEXcolumns for a particular spec

---

> "the temporary table has the same field names as the columns

in the Excel sheet"

I think they need to be in the same order too -- you can use a query to do that if you don't want to change the table.

have an awesome day,
crystal


On 12/17/17 11:55 PM, david.pratt@... [MS_Access_Professionals] wrote:
Is there a way to view the import wizards background code so I can program a command button to perform the same steps the wizard is performing?

I am importing an Excel file with a single worksheet into the same temporary table each time.  the temporary table has the same field names as the columns in the Excel sheet.  

I have some code from a Programming by Example book, but I cannot get it to work.

Thank you, David




__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.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.


.

__,_._,___

Rabu, 27 Desember 2017

RE: [MS_AccessPros] Getting records with highest date which less than the specific date

 

Hi Nimish,

 

You can check with this sql statement:

 

SELECT tblPrjMTORevision.ProjectCode, tblPrjMTORevision.MTORevision, tblPrjMTORevision.MTORevisionDate, tblPrjPipeClassMaster.PipeClass, tblPrjPipeClassMaster.PipeClassRevision, tblPrjPipeClassMaster.PipeClassRevisionDate

FROM tblPrjMTORevision INNER JOIN tblPrjPipeClassMaster ON tblPrjMTORevision.ProjectCode = tblPrjPipeClassMaster.ProjectCode

WHERE tblPrjPipeClassMaster.PipeClassRevisionDate <= tblPrjMTORevision.MTORevisionDate;

 

Bye

Davide

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, December 28, 2017 12:12 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Getting records with highest date which less than the specific date

 

 

Hi,

Merry Christmas and Happy new year to all.

It is difficult to describe my problem, but, I will try to my best to delineate it.

I have following two tables –

tblPrjMTORevision

=============
ProjectCode Text Primary Key
MTORevision Text Primary Key
MTORevisionDate Date
MTORevisionDescription Text

 


tblPrjPipeClassMaster

================
ProjectCode Text Primary Key
PipeClass Text Primary Key
PipeClassRevision Text Primary Key
PipeClassRevisionDate Date

 

We revise our material take off (MTO) quarterly and it is tracked through tblPrjMTORevision and its child table. Between two revisions of MTO may revise PipeClass as well. What I need to is a query that generates a report showing every PipeClass and PipeClassRevision having PipeClassRevisionDate less than or equal to MTORevisionDate against each revision of MTO.

As an example, if the tables have following values –

tblPrjMTORevision

=============
ProjectCode    MTORevision    MTORevisionDate
A            A                Dec/01/2016
A            B                Mar/01/2017

 

tblPrjPipeClassMaster

================
ProjectCode    PipeClassRevision    PipeClass        PipeClassRevisionDate
A            A                    AAA            Nov/01/2016
A            B                    AAA            Dec/27/2016
A            A                    ABA            Nov/19/2016
A            A                    BAA            Nov/21/2016

 

 

Based on these two tables, I need a query that produces the following result

ProjectCode    MTORevision    MTORevisionDate    PipeClass        PipeClassRevision  PipeClassRevisionDate
A                A            Dec/01/2016            AAA            A                Nov/01/2016
A                A            Dec/01/2016            ABA            A                Nov/19/2016
A                A            Dec/01/2016            BAA            A                Nov/21/2016
A                B            Mar/01/2016            AAA            B                Dec/27/2016
A                B            Mar/01/2016            ABA            A                Nov/19/2016
A                B            Mar/01/2016            BAA            A                Nov/21/2016


Any help will be greatly appreciated.

Nimish

 

PS: I've posted this question to other discussion group as well.

 

__._,_.___

Posted by: Davide Franceschini <bigcat_21@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] Getting records with highest date which less than the specific date

 

Hi,

Merry Christmas and Happy new year to all.

It is difficult to describe my problem, but, I will try to my best to delineate it.

I have following two tables –

tblPrjMTORevision
=============
ProjectCode Text Primary Key
MTORevision Text Primary Key
MTORevisionDate Date
MTORevisionDescription Text


tblPrjPipeClassMaster
================
ProjectCode Text Primary Key
PipeClass Text Primary Key
PipeClassRevision Text Primary Key
PipeClassRevisionDate Date

We revise our material take off (MTO) quarterly and it is tracked through tblPrjMTORevision and its child table. Between two revisions of MTO may revise PipeClass as well. What I need to is a query that generates a report showing every PipeClass and PipeClassRevision having PipeClassRevisionDate less than or equal to MTORevisionDate against each revision of MTO.

As an example, if the tables have following values –

tblPrjMTORevision
=============
ProjectCode    MTORevision    MTORevisionDate
A            A                Dec/01/2016
A            B                Mar/01/2017

tblPrjPipeClassMaster
================
ProjectCode    PipeClassRevision    PipeClass        PipeClassRevisionDate
A            A                    AAA            Nov/01/2016
A            B                    AAA            Dec/27/2016
A            A                    ABA            Nov/19/2016
A            A                    BAA            Nov/21/2016


Based on these two tables, I need a query that produces the following result

ProjectCode    MTORevision    MTORevisionDate    PipeClass        PipeClassRevision  PipeClassRevisionDate
A                A            Dec/01/2016            AAA            A                Nov/01/2016
A                A            Dec/01/2016            ABA            A                Nov/19/2016
A                A            Dec/01/2016            BAA            A                Nov/21/2016
A                B            Mar/01/2016            AAA            B                Dec/27/2016
A                B            Mar/01/2016            ABA            A                Nov/19/2016
A                B            Mar/01/2016            BAA            A                Nov/21/2016

Any help will be greatly appreciated.

Nimish

PS: I've posted this question to other discussion group as well.


__._,_.___

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


.

__,_._,___

[MS_AccessPros] Access query with specific date and earlier

 

Hi,

Merry Christmas and Happy new year to all.

It is difficult to describe my problem, but, I will try to my best to delineate it.

I have following two tables –

tblPrjMTORevision
=============
ProjectCode Text Primary Key
MTORevision Text Primary Key
MTORevisionDate Date
MTORevisionDescription Text


tblPrjPipeClassMaster
================
ProjectCode Text Primary Key
PipeClass Text Primary Key
PipeClassRevision Text Primary Key
PipeClassRevisionDate Date

We revise our material take off (MTO) quarterly and it is tracked through tblPrjMTORevision and its child table. Between two revisions of MTO may revise PipeClass as well. What I need to is a query that generates a report showing every PipeClass and PipeClassRevision having PipeClassRevisionDate less than or equal to MTORevisionDate against each revision of MTO.

As an example, if the tables have following values –

tblPrjMTORevision
=============
ProjectCode    MTORevision    MTORevisionDate
A            A                Dec/01/2016
A            B                Mar/01/2017

tblPrjPipeClassMaster
================
ProjectCode    PipeClassRevision    PipeClass        PipeClassRevisionDate
A            A                    AAA            Nov/01/2016
A            B                    AAA            Dec/27/2016
A            A                    ABA            Nov/19/2016
A            A                    BAA            Nov/21/2016


Based on these two tables, I need a query that produces the following result

ProjectCode    MTORevision    MTORevisionDate    PipeClass        PipeClassRevision  PipeClassRevisionDate
A                A            Dec/01/2016            AAA            A                Nov/01/2016
A                A            Dec/01/2016            ABA            A                Nov/19/2016
A                A            Dec/01/2016            BAA            A                Nov/21/2016
A                B            Mar/01/2016            AAA            B                Dec/27/2016
A                B            Mar/01/2016            ABA            A                Nov/19/2016
A                B            Mar/01/2016            BAA            A                Nov/21/2016

Any help will be greatly appreciated.

Nimish

PS: I've posted this question to other discussion group as well.

__._,_.___

Posted by: Parikh Nimish <parikhnd@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.


.

__,_._,___

Sabtu, 23 Desember 2017

Re: [MS_AccessPros] Re: Write all items in a list box to a table

 

You were correct.

Here is the final code.

For i = 0 To Me.lsteSubFolder.ListCount - 1
    
       rstSubFolder.AddNew
       rstSubFolder!SubLevelOneKey = Format(Now(), "mmddyyhhmmss") & strCurrentUserName & "SUB"
       rstSubFolder!SubFolderName = Me.lsteSubFolder.ItemData(i)
       rstSubFolder!CAbinetID = Me.txtCabinetID
       rstSubFolder!SL1NextLevel = "No"
       rstSubFolder.Update
      
    Next i
 

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

"Valar Dohaeris"







From: "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Saturday, December 23, 2017 6:05 PM
Subject: RE: [MS_AccessPros] Re: Write all items in a list box to a table

 
Hi Art

Your loop control variable is i, while the index variable you are using is itm.  You should be using .ItemData(i)

This also suggests that you do not have Option Explicit in this module, which is the best way to introduce this kind of bug!

Best wishes,
Graham
 
From: MS_Access_Professionals@yahoogroups..com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Sunday, 24 December 2017 12:59
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Write all items in a list box to a table
 
 
 
OK Getting closer


For i = 0 To Me.lsteSubFolder.ListCount - 1

rstSubFolder.AddNew
rstSubFolder!SubLevelOneKey = Me.txtSubLevelOneKey
rstSubFolder!SubFolderName = Me.lsteSubFolder.ItemData(itm)
rstSubFolder!CAbinetID = Me..txtCabinetID
rstSubFolder!SL1NextLevel = "No"
rstSubFolder.Update

Next i


This almost works but not quite. If i put 3 items in the list box then its repeating the the first item in the listbox 3 times in the table, so instead of giving me APPLICANT, DATE, COMPANY it is writing APPLICANT,APPLICANT,APPLICANT in the table/
 


__._,_.___

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 (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.


.

__,_._,___