Senin, 31 Desember 2012

Re: [belajar-access] Meng-append tabel secara berkala

 

Mas Farhan,

Anda tidak perlu mengcreate record untuk keperluan tersebut, tetapi cukup menggunakan query.
Dengan query, anda bisa menampilkan jumlah yang dibayar oleh anggota. Jika jumlah ini diselisihkan dengan jumlah yg seharusnya dibayar, maka ketemu jumlah yang masih harus dibayar.

Jika data yang masih harus dibayar ini ingin disimpan sebagai data (ke dalam table tertentu), bisa menggunakan append query.
Dalam hal ini sih tergantung kebutuhan, apakah ingin disimpan atau tidak, karena informasi seperti ini selalu bisa dihasilkan dengan query.

semoga memberi inspirasi.... :)

HAER
"Diam bisa jadi EMAS, tapi kalau ditanya orang jadi TIDAK SOPAN"


2012/12/31 Sofyan Efendi <sofyanefendi@gmail.com>


Dear Mas Farhan,
 
Dari table Master Anggota, dibuat querynya, dimana dijoinkan terhadap table Iuran Bulanan. Beri syarat Iuran Bulanan yang ditampilkan berada pada range bulan tersebut. Maka akan ditemukan ID Anggota yang sudah membayar cicilan. Maka klik 2 kali tali penghubungnya, kemudian diganti tipe joinnya menjadi ke no 3, lalu beri syarat pada ID Anggota pada table Iuran = Is Null. Maka akan diketahui pada bulan tersebut siapa saja yang belum iuran.
 
Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
----- Original Message -----
Sent: Monday, December 31, 2012 11:32 AM
Subject: [belajar-access] Meng-append tabel secara berkala

Kawan-kawan user access yang baik,

Saya sedang merancang database yayasan sosial di RW tempat tinggal saya, yang mengurus dana sosial kematian warga. Uang yang dikelola adalah iuran bulanan rutin. Setiap orang/anggota berkewajiban membayar iuran tersebut kepada petugas yang sengaja ditugaskan menagih dari rumah ke rumah.

Dalam kenyataannya, tidak semua anggota  membayar rutin tiap bulan, ada yang terlambat, ada yang membayar untuk beberapa bulan disamping tentu ada juga yang tepat waktu. Dalam database saya mencoba menerapkan sistem akuntansi, yakni setiap akhir bulan yayasan mencatatkan adanya tagihan (piutang) sejumlah anggota dikalikan dengan nilai iurannya, dengan harapan agar selalu dapat diketahui berapa saldo tagihan.

Pertanyaan: Bagaimana caranya agar aplikasi dapat meng-create sejumlah record yang mencatat hal ini setiap di akhir bulan.

Selamat menyambut tahun baru,

Farhan Holizain





--


Haer Talib

RumahAccess Indonesia
Tempatnya Belajar Microsoft Access
Artikel | Forum | Milis | Download | Training | Links | Blog | Event


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] query problem

 

Happy New Year!

I'm going to be spending this holiday on Access. I've been at a stalemate so decided to ask for help. As Poirot would say "the little grey cells, they are having difficulty" :-)

I have a query that pulls all the people that have bought using our agency or have bought one of our properties. If a couple has bought a house, there is one line for that transaction. If a single has bought there is one line for that transaction. If one half of a couple has bought there is one line for that transaction.

The part I'm having problems is where one person from a couple has bought. If the main person has had only one transaction and the spouse has not been entered in any transactions, there's no problem. But if there are several transactions and the spouse/partner was involved in one of them but not in all of them, the query does not have the transaction in which he/she was not involved.

I believe the problem originates from the joining of the qCustomerList_2ContactNameSpID.ContactID1.SpID to the SalesBuyers_1 table. Since the spouse/partner is not null in one instance (SalesBuyers_1.ContactID) and the criteria says that it is null, it does not show up. But... what do I do .. ? Can't get my head around this.

This query is one of 4 similar queries that feed into a Union query (Buyers, Sellers, ClosedBuyers, ClosedSellers), so whatever is done here will be duplicated in three other queries. I'd love it if there's a way to minimize the opening of tables since I've encountered the "cannot open databases" table here in the past and have repeated tried to simplify these queries and remove the subqueries.

The query is below.

Thanks much!
Connie

SELECT Sales.SalesID, Contacts.LastName, Contacts.FirstName, Sales.ListID, Listings.ListingAgency, Sales.BuyerAgencyID, qCustomerList_2ContactNameSpID.SpID, SalesBuyers_1.ContactID, SalesBuyers_1.SaleID
FROM (Listings INNER JOIN Sales ON Listings.ListID = Sales.ListID) LEFT JOIN (Contacts RIGHT JOIN ((SalesBuyers LEFT JOIN qCustomerList_2ContactNameSpID ON SalesBuyers.ContactID = qCustomerList_2ContactNameSpID.ContactID1) LEFT JOIN SalesBuyers AS SalesBuyers_1 ON qCustomerList_2ContactNameSpID.SpID = SalesBuyers_1.ContactID) ON Contacts.ContactID = SalesBuyers.ContactID) ON Sales.SalesID = SalesBuyers.SaleID
WHERE (((Listings.ListingAgency)=1) AND ((SalesBuyers_1.ContactID) Is Null)) OR (((Sales.BuyerAgencyID)=1) AND ((SalesBuyers_1.ContactID) Is Null));


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

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Re: Help with report

 

The records displayed for me. Are you using the Print Preview mode?

Duane Hookom MVP
MS Access

----------------------------------------
> From: no_reply@yahoogroups.com
>
> Duane,
>
> I took out the EDA field in the Link Master/Child, and it still doesn't display the records. The main reports displays the records based on the date selection I made on the frm_cargo; however, the same records should be displayed for those same dates in the subreport, and the subreport comes back blank. I'm not sure what else to do.
>
> Your help is greatly appreciated!
>
> Thanks!
>
> Katrina
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
> >
> > I think your issue is that you have the Link Master/Child properties of the subreport set to the EDA field. I expect you want these blank.
> >
> > Duane Hookom MVP
> > MS Access
> > ----------------------------------------
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: no_reply@yahoogroups.com
> > > Date: Mon, 31 Dec 2012 17:51:43 +0000
> > > Subject: [MS_AccessPros] Help with report
> > >
> > > Hello all!
> > >
> > > I have a database I'm working on, and have run into a problem. I have a report that displays certain fields based on a query. In that report I have a subreport that I want displayed at the bottom of the report. The top portion of the report is filtered based on the date selection made on the frm_cargo. What I would like is to also have the fields in the subreport filtered based on that same selection. I entered the filter in the subreport; however, it does not display the information once the dates are selected. If someone could please look at my report and tell me what it might be I'm missing I would greatly appreciate it. I have uploaded the database into the Assistance Needed folder under Austin Tracker - New Working2.
> > >
> > > Thanks so much for your help!
> > >
> > > Katrina

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

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: Help with report

 

Duane,

I took out the EDA field in the Link Master/Child, and it still doesn't display the records. The main reports displays the records based on the date selection I made on the frm_cargo; however, the same records should be displayed for those same dates in the subreport, and the subreport comes back blank. I'm not sure what else to do.

Your help is greatly appreciated!

Thanks!

Katrina

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> I think your issue is that you have the Link Master/Child properties of the subreport set to the EDA field. I expect you want these blank.
>
> Duane Hookom MVP
> MS Access
> ----------------------------------------
> > To: MS_Access_Professionals@yahoogroups.com
> > From: no_reply@yahoogroups.com
> > Date: Mon, 31 Dec 2012 17:51:43 +0000
> > Subject: [MS_AccessPros] Help with report
> >
> > Hello all!
> >
> > I have a database I'm working on, and have run into a problem. I have a report that displays certain fields based on a query. In that report I have a subreport that I want displayed at the bottom of the report. The top portion of the report is filtered based on the date selection made on the frm_cargo. What I would like is to also have the fields in the subreport filtered based on that same selection. I entered the filter in the subreport; however, it does not display the information once the dates are selected. If someone could please look at my report and tell me what it might be I'm missing I would greatly appreciate it. I have uploaded the database into the Assistance Needed folder under Austin Tracker - New Working2.
> >
> > Thanks so much for your help!
> >
> > Katrina
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>

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

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Change text box backstyle to transparent

 

John,

Thank You. That works great now. 
 
Jim Wagner
________________________________

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, December 31, 2012 10:33 AM
Subject: RE: [MS_AccessPros] Change text box backstyle to transparent


 
Jim-

I think it's the BackColor property you want to set.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Monday, December 31, 2012 5:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Change text box backstyle to transparent

Hello all,

I have a text box with a click event that opens a query. The reason the text
box has a click event is because I have a dCount expression for the query
and wanted to know how to change the backstyle to transparent after the user
clicks the text box. Right now when I click the text box the query opens up
but the text box has a white backstyle. The text box is set to be
transparent as a default.

Any help would be appreciated.

Thank You

Jim Wagner

I have this code currently.

Private Sub txtqryFindDuplicatesForSCHEDULEDATA_Click()
DoCmd.OpenQuery "qryFindDuplicatesForSCHEDULEDATA", acViewNormal
Me.txtqryFindDuplicatesForSCHEDULEDATA.BackStyle = 0 End Sub

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

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

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Print table field specifications

Thanks, Duane. I don't see a path like this but will keep poking around.
I'm using Windows 7 Pro in a virtual machine on a Mac, and that may make a
difference.

James
www.james-mc.com
Words To Live By


On Mon, Dec 31, 2012 at 2:09 PM, Duane Hookom
<duanehookom@hotmail.com<javascript:_e({}, 'cvml',
'duanehookom@hotmail.com');>
> wrote:

> **
>
>
> James,
>
> You can link to or import the table created by the documenter and then use
> it as the base for a crosstab query. The table name is doc_tblObjects and
> you can find it in a folder like:
> C:\Users\<your user name>\AppData\Roaming\Microsoft\Access\ACWZUSR12.ACCDU
> (your folder may vary).
>
> The SQL view of the crosstab is:
>
> TRANSFORM Min(Left([doc_tblObjects_2]![Extra1],100)) AS Expr1
> SELECT doc_tblObjects_1.Name AS TableName, doc_tblObjects.Name AS
> FieldName, doc_tblObjects.Extra2 AS FieldType, doc_tblObjects.Extra3 AS
> FieldSize
> FROM doc_tblObjects AS doc_tblObjects_2 INNER JOIN (doc_tblObjects INNER
> JOIN doc_tblObjects AS doc_tblObjects_1 ON doc_tblObjects.ParentID =
> doc_tblObjects_1.ID) ON doc_tblObjects_2.ParentID = doc_tblObjects.ID
> WHERE (((doc_tblObjects.TypeID)=11))
> GROUP BY doc_tblObjects_1.Name, doc_tblObjects.Name,
> doc_tblObjects.Extra2, doc_tblObjects.Extra3
> PIVOT doc_tblObjects_2.Name;
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > From: forums01@james-mc.com <javascript:_e({}, 'cvml',
> 'forums01%40james-mc.com');>
>
> >
> > I'm trying to use the built-in database documenter in Access 2010 to
> print
> > the field specifications for one of my tables for a meeting. All I really
> > need to see are the field name, type, size and description, but the
> > documenter gives far more detail than this. Is there some other way I
> might
> > get to just the name, type, size and description?
> >
> > Thanks!!
> >
> > James
>
>
>



--

James
www.james-mc.com
Words To Live By


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Help with report

 

BTW:
It looks like you are storing lots of data as field names. 139 fields seems a bit un-normalized to me. I assume this works ok for you.

Duane Hookom MVP
MS Access

----------------------------------------
> To: ms_access_professionals@yahoogroups.com
> From: duanehookom@hotmail.com
> Date: Mon, 31 Dec 2012 14:18:49 -0600
> Subject: RE: [MS_AccessPros] Help with report
>
> I think your issue is that you have the Link Master/Child properties of the subreport set to the EDA field. I expect you want these blank.
>
> Duane Hookom MVP
> MS Access
> ----------------------------------------
> > To: MS_Access_Professionals@yahoogroups.com
> > From: no_reply@yahoogroups.com
> > Date: Mon, 31 Dec 2012 17:51:43 +0000
> > Subject: [MS_AccessPros] Help with report
> >
> > Hello all!
> >
> > I have a database I'm working on, and have run into a problem. I have a report that displays certain fields based on a query. In that report I have a subreport that I want displayed at the bottom of the report. The top portion of the report is filtered based on the date selection made on the frm_cargo. What I would like is to also have the fields in the subreport filtered based on that same selection. I entered the filter in the subreport; however, it does not display the information once the dates are selected. If someone could please look at my report and tell me what it might be I'm missing I would greatly appreciate it. I have uploaded the database into the Assistance Needed folder under Austin Tracker - New Working2.
> >
> > Thanks so much for your help!
> >
> > Katrina
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

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

__,_._,___
Diposting oleh di Tidak ada komentar:

[belajar-access] Menggunakan Cloud Computing

 

Assalaamu'alaikum Wr. Wb.

Sebelumnya saya ucapkan Selamat Tahun Baru 2013. Semoga di tahun ini kita lebih sukses dan lebih baik lagi, Amiin YRA...

Mohon petunjuk dan pencerahannya,
Saat ini saya sedang menangani Program Aplikasi Inventori Toko, kebetulan program yang sejenis sudah pernah saya buat, tinggal revisi sedikit.
Tapi program ini ingin bisa dipakai juga ditoko dan ditempat lain (Cloud Computing). Supaya tidak banyak merubah lagi program yang ada, maka datanya saya simpan di DropBox. Kemudian aplikasi DropBoxnya saya install di Server (Toko), Komputer Rumah Owner dan di Laptop Nya.
Dan supaya data tidak terjadi tumpang tindih data, maka Untuk Komputer rumah atau laptop (salah satu), hanya dipakai jika toko sudah tutup.

Yang menjadi pertanyaan saya :
- Waktu saya mau periksa data, ada file 'DataInventory (new-PC's conflicted copy 2012-12-28).accdb' dan 'DataInventory (new-PC's conflicted copy 2012-12-31).accdb', Nama File Datanya 'DataInventory.accdb.
  Apa penyebab munculnya file tersebut? Beresiko kah cara yang saya lakukan ini terhadap data?

- Apa ada cara lain yang lebih aman dan tidak beresiko? tapi tidak banyak merubah program.

- Bagaimana caranya untuk mengecek konek tidaknya komputer ke internet pada Access.


Terima kasih.


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Re: Report with alternate rows shaded

 

Thanks John,

It works a treat!

Peace, Health and Happiness in 2013

With Wishes for a fabulous New Year full of great achievements and experiences.

Robin Chapple

At 1/01/2013 01:09 AM, you wrote:
>Sorry I hadn't logged into this forum for awhile.
>
>Robin,
>Is that what you were looking for?
>
>John F
>
>--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
><robinski@...> wrote:
> >
> > Thanks John F and Clive,
> >
> > I returned to the project and it works for me now without any changes!
> >
> > Regards,
> >
> > Robin
> >
> > At 29/12/2012 06:57 PM, you wrote:
> > >Hi Robin,
> > >
> > >That works OK for me.
> > >
> > >Make sure that the controls in the Detail_Controls
> > >have BorderStyle set to Transparent.
> > >
> > >If that does not fix it could you show a Screen
> > >capture of Report as you see it?
> > >
> > >Regards, Clive.
> > >
> > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> > ><robinski@> wrote:
> > > >
> > > > G'day John,
> > > >
> > > > Many thanks.
> > > >
> > > > I am out of my depth here. I have added your code to the code page
> > > > and attempted to show it in the properties field but failed.
> > > >
> > > > There are screen captures here:
> > > >
> > > > http://www.rotary9790.org.au/test/demo.asp
> > > >
> > > > What have I missed?
> > > >
> > > > Peace, Health and Happiness in 2013
> > > >
> > > > With Wishes for a fabulous New Year full of great achievements
> > > and experiences.
> > > >
> > > > Robin Chapple
> > > >
> > > >
> > > > At 29/12/2012 06:50 AM, you wrote:
> > > > >Robin,
> > > > >I have a report with the following code under the On Format setting
> > > > >and it works for me.
> > > > >
> > > > >Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
> > > > >Const vbLightGrey = 12632256
> > > > >
> > > > >If Me.CurrentRecord Mod 2 = 0 Then
> > > > > Me.Section(acDetail).BackColor = vbLightGrey
> > > > >Else
> > > > > Me.Section(acDetail).BackColor = vbWhite
> > > > >End If
> > > > >
> > > > >End Sub
> > > > >
> > > > >John F.
> > > > >
> > > > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> > > > ><robinski@> wrote:
> > > > > >
> > > > > > Thanks Clive,
> > > > > >
> > > > > > I have made the changes that you suggested. The results have been
> > > > > loaded here:
> > > > > > http://www.rotary9790.org.au/test/demo.asp
> > > > > >
> > > > > > What have I missed?
> > > > > >
> > > > > > Peace, Health and Happiness in 2013
> > > > > >
> > > > > > With Wishes for a fabulous New Year full of great achievements
> > > > > and experiences.
> > > > > >
> > > > > > Robin
> > > > > >
> > > > > > At 26/12/2012 10:51 PM, you wrote:
> > > > > > >Hi Robin,
> > > > > > >
> > > > > > >Change the 'no color' to the colour that you want.
> > > > > > >for pale grey try,
> > > > > > >Alternate back color: #C0C0C0
> > > > > > >
> > > > > > >There may be named colors like RED, GREEN, etc. but
> > > > > > >you can always find a colour by opening a Form in
> > > > > > >DesignView and using the color selector.
> > > > > > >
> > > > > > >Hope that helps.
> > > > > > >
> > > > > > >Regards, Clive.
> > > > > > >
> > > > > > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> > > > > > ><robinski@> wrote:
> > > > > > > >
> > > > > > > > I am using Access 2010'
> > > > > > > >
> > > > > > > > I plan to have alternate rows of a report shaded to make
> > > > > reading easier.
> > > > > > > >
> > > > > > > > I have the detail properties:
> > > > > > > > Back color: Alternate Row
> > > > > > > > Alternate back color: No color.
> > > > > > > >
> > > > > > > > I have the fields property set to transparent.
> > > > > > > >
> > > > > > > > I have all lines shaded.
> > > > > > > >
> > > > > > > > What have I missed?
> > > > > > > >
> > > > > > > > Peace, Health and Happiness in 2013
> > > > > > > >
> > > > > > > > With Wishes for a fabulous New Year full of great achievements
> > > > > > > and experiences.
> > > > > > > >
> > > > > > > > Robin Chapple
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

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

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Help with report

 

I think your issue is that you have the Link Master/Child properties of the subreport set to the EDA field. I expect you want these blank.

Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: no_reply@yahoogroups.com
> Date: Mon, 31 Dec 2012 17:51:43 +0000
> Subject: [MS_AccessPros] Help with report
>
> Hello all!
>
> I have a database I'm working on, and have run into a problem. I have a report that displays certain fields based on a query. In that report I have a subreport that I want displayed at the bottom of the report. The top portion of the report is filtered based on the date selection made on the frm_cargo. What I would like is to also have the fields in the subreport filtered based on that same selection. I entered the filter in the subreport; however, it does not display the information once the dates are selected. If someone could please look at my report and tell me what it might be I'm missing I would greatly appreciate it. I have uploaded the database into the Assistance Needed folder under Austin Tracker - New Working2.
>
> Thanks so much for your help!
>
> Katrina
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

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

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Print table field specifications

 

James,

You can link to or import the table created by the documenter and then use it as the base for a crosstab query. The table name is doc_tblObjects and you can find it in a folder like:
C:\Users\<your user name>\AppData\Roaming\Microsoft\Access\ACWZUSR12.ACCDU (your folder may vary).

The SQL view of the crosstab is:

TRANSFORM Min(Left([doc_tblObjects_2]![Extra1],100)) AS Expr1
SELECT doc_tblObjects_1.Name AS TableName, doc_tblObjects.Name AS FieldName, doc_tblObjects.Extra2 AS FieldType, doc_tblObjects.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_2 INNER JOIN (doc_tblObjects INNER JOIN doc_tblObjects AS doc_tblObjects_1 ON doc_tblObjects.ParentID = doc_tblObjects_1.ID) ON doc_tblObjects_2.ParentID = doc_tblObjects.ID
WHERE (((doc_tblObjects.TypeID)=11))
GROUP BY doc_tblObjects_1.Name, doc_tblObjects.Name, doc_tblObjects.Extra2, doc_tblObjects.Extra3
PIVOT doc_tblObjects_2.Name;

Duane Hookom MVP
MS Access

----------------------------------------
> From: forums01@james-mc.com
>
> I'm trying to use the built-in database documenter in Access 2010 to print
> the field specifications for one of my tables for a meeting. All I really
> need to see are the field name, type, size and description, but the
> documenter gives far more detail than this. Is there some other way I might
> get to just the name, type, size and description?
>
> Thanks!!
>
> James

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

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Mac Air

That's what I do as well: Access 2010 with Windows 7 Pro running in
Parallels Desktop 8 on an early 2011 13" Macbook Pro. I've never had any
problems.

James
www.james-mc.com
Words To Live By


On Mon, Dec 31, 2012 at 1:40 PM, John Viescas <JohnV@msn.com> wrote:

> **
>
>
> Rkulez- (name?)
>
> You csnnot run MS Access on a Mac unless you install Parallels running a
> copy of Windows. That's what I do.
>
> John Viescas
>
> -----Original Message-----
>
> From: rkulez
> Sent: 31 Dec 2012 18:32:50 GMT
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Mac Air
>
>
> Dear members,
> I wish a happy new year to you.
> I want to buy a Mac Air or pro. I want to ask:
> 1) Is there any problem at installing and using msaccess with mac?
> 2) I am using msaccess 2003 already. Does it be causing any problem?
> 3) My db is being used by my employee in the week and I copy it to my
> computer at the last day of the week to study on it at the weekend. Will
> there be any problem with copying?
> 4) My db is small and it is about 16 Gb. I do not use other complex
> programs,plays etc. So I think mac air will fit to me? Would I to buy mac
> pro instead?
> Thanks for your answers in advance.
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)