Dear all,
bagaiman cara membuat menubar/toolbar/ribbon pada access agar saat user masuk dlm aplikasi saya mereka tidak bisa melihat table/query/macro atau apapun yang saya buat didalamnya,,mereka hanya bisa memanfaatkan aplikasi tsb dari menu2 yang saya tampilkan di menubar/toolbar. (---> hanya saya yang bisa mengakses database,dkk). Saya ingin memanfaatkan fasilitas seperti toolbar untuk aplikasi access saya supaya user tidak bisa melihat "all object access" yang saya buat. apakah bisa? mohon bantuan
trims
Minggu, 30 September 2012
[belajar-access] Menu Bar/ Tool Bar/ Ribbon Access 2007
[belajar-access] prosedur insert/update
Dear Suhu & Master belajar-access@yahoogroups.com,
Mohon pencerahannya atas case dibawah ini, ini ceritanya daur ulang aplikasi bengkel dan spareparts. Pada saat bagian partman input data pengurangan stock barang di gudang, kadang ada barang yang ready stok dan ada barang yang kosong, nah yang ready stok langsung bisa di input, tetapi yang kosong otomatis harus di order terlehih dahulu ke pusat, kemudian barang datang di kemudian hari dientry stok barang masuk baru bisa di transaksikan. Nah otomatis ini akan menjadi data baru / No penjualan baru. Misalnya 12-10-00086, dan 12-10-00087.
Bagaimana agar data yang telah di input oleh partman, dgn no 12-10-00086, dan 12-10-00087 bisa dibuatkan prosedur insert/update agar sekali klik bisa masuk ke form KASIR berdasarkan nama pelanggan, sehingga KASIR tidak perlu entry ulang atas data yang telah di input oleh bagian Partman/Gudang.
Atas attensinya kami ucapkan terima kasih.
Salam,
Sumiyanto Surabaya
Re: [belajar-access] Salam kenal & Tanya Kenapa lambat
Dear All,
ikutan komentar di waktu shubuh,
Pengalaman saya juga nih
- Lokasi Database di PC lokal dengan Jumlah data 380ribu record, 20 field
- Lalu membuat select query yg di dalamnya menggunakan fungsi IF, untuk memilah2 data kuisioner
- Dari select query kemudian dibuat summary/Total Query
- Ketika dijalankan maka membutuhkan waktu 40 detik.
Menurut saya sih ini termasuk lambat, tampaknya saya salah dalam merancang Querynya
Salam dan Selamat Beraktifitas
Farhan
Kemungkinan yang lain yakni selain kualitas jaringan, kompleksitas data unik (penentukan data input diprimary key-makin ruwet makin lelet) dan juga beda OS kadang dapat juga mempengaruhi real time data.
Salam,
Roland
Playgroup Access
Mas Afrizal.
Cepat dan lambatnya tergantung kondisi jaringannya.
misalnya skenarionya sbb:
aplikasi dijalankan di cikarang.
data diletakkan di share folder.
share folder ini lokasinya di jayapura, irian jaya.
kecepatan jaringannya sangat bagus, maka prosesnya akan cepat juga.
atau share folder ini lokasinya di banten.
kondisi jaringan lambat.
maka kecepatan prosesnya juga akan lambat.
kalau hanya menampilkan data
tanpa operasi CRUD (Create Read Update Delete) umumnya pembacaan akan cepat jika data yang diambil tidak terlalu banyak.
Apakah Access tidak bisa dijadikan client? tergantung konteks kata katanya ini.
Client itu apakah membuat aplikasi dengan MS Access dgn database MS Access atau
membuat aplikasi dengan VB dengan database MS Access.
mungkin bisa di sharing lebih jauh skenario mas Afrizal dengan aplikasinya.
kalau mungkin kode programnya di sharing juga, untuk kita cermati bersama-sama.
Salam Hangat dan Jabat Erat,
Murid Belajar Access.
On 9/28/2012 16:20, Afrizal wrote:
Assalamu'alaikum
Salam kenal kpd para guru semua, saya Afrizal, domisili di Cikarang.Mau tanya, saya develop aplikasi pakai access dan VB6.Saya coba jalankan di Client kenapa lambat ya?Kalau menampilkan hasil query lumayan cepat tapi kalau ada proses insert data jadi lambat.Kalau dijalankan di satu pc, cepat sekali proses insert nya.Tapi kalau saya jalankan di client jadi lambat.koneksi nya pakaistrAkses = "PROVIDER=MSDataShape;Data PROVIDER= microsoft.jet.oledb.4.0;Data Source=" _
& strPubDBLokasi & "\" & strPubNamaDB & ";Jet OLEDB:Database Password=xxx"kalau di Form program saya pakairs.Open strSQL, koneksiDB, adOpenDynamic, adLockOptimisticApa ada yg kurang pas dgn program ini?Mohon penjelasan nya?Apa memang access tidka bisa utk client...Wassalam,
Afrizal
Gudang : Jl Kelinci Raya NO 23, Jababeka 2, Cikarang Baru, Kab. Bekasi
www.bajupoeti.comAS 085217650454, AS 085283868428, Xl 087779005073, esia 02198293128, flexy 02133877086. 085716530963, SMS Center 085284461663.
Rek Mandiri 1560001593567, BCA 5150019127, BNI 0023446709. BSMandiri 3927004506(Saudagar Baju Muslim Anak dan Dewasa POETI, KEILA, DAFAS, AHSANA, MOTIF, ARDANO DLL)
(Sedia Perlengkapan Muslim seperti kaos Kaki Kanik, SOKA, Sajadah, Pakaian Ikhram DLL)
Sabtu, 29 September 2012
RE: [MS_AccessPros] Re: can I hide overlapping field dependin gon field value in continuous form.
Andre
Whether or not the short text box has data has nothing to do with if it shows or
not. Did you set the ControlSource to the right field? Is there data in that
field?
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of koshacc
Sent: Saturday, September 29, 2012 4:24 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: can I hide overlapping field dependin gon field
value in continuous form.
Yes, there appears to be no conten in teh text box of short contacts.
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "wrmosca" <wrmosca@...>
wrote:
>
> Andre
>
> By "blank", do you mean the text box is not showing?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "koshacc" <andreandpaula@>
wrote:
> >
> > Hi
> > Bill
> >
> > Sorry for long delay, but I was ill and then busy. This code is not quite
working. What it is doing is keeping the short fields blank all the time.
> >
> > Private Sub Form_Current()
> >
> > Me.Short_contact.visible = _
> > ((Len(Me.Parent_report) & vbNullString) = 0)
> >
> >
> > End Sub
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
wrote:
> > >
> > > Andre
> > >
> > > You could use the form's Current event to show or hide the short field
depending on if there is anything in the complex field.
> > >
> > > Private Sub Form_Current()
> > > Me.ShortField.Visible = _
> > > (Len(Me.ComplexField) & vbNullString) = 0)
> > >
> > > End Sub
> > >
> > > The short field's visiblitiy is dependent on whether there is anything in
the complex fiels or not.
> > >
> > > Private Sub Form_Current()
> > > Me.ShortField.Visible = _
> > > (Len(Me.ComplexField) & vbNullString) = 0)
> > >
> > > End Sub
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "koshacc" <andreandpaula@>
wrote:
> > > >
> > > > I have a continuous form which displays details of client contacts.
There are two types of contact -short and complex. To make the layout work I
have placed the short field on top of the complex field (memo fields) to make
the viewing easier. This works fine and I am happy with this layout. (naturally
the short field is completely blank when data is in the complex field.)
> > > >
> > > > Problem is the short and complex fields can be long and will have a
scroll bar but because the short field is on top of the complex field when ever
you click in the area the short field is activated not the complex field.
> > > >
> > > > Is there anyway I can push the short field to the back or not have it at
all when the complex field has data.
> > > >
> > > > I was hoping the paint event would help but it does not.
> > > >
> > > > Andre (MSAccess 2010)
> > > >
> > >
> >
>
[Non-text portions of this message have been removed]
RE: [MS_AccessPros] Re: Many to Many question
Jim
In a word, yes. That is how m-to-m relationships work.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Thursday, September 27, 2012 2:56 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Many to Many question
Bill
We had a database here that tracked Workers comp. When we went to redesign it we laughed for days on seeing the freehand entries on how the person was injured. They told us to go to an enclave because we were too loud with our laughing. We quickly made it a drop down. I worked in risk management in a hospital, so I was able to get the drop down to a better place.
I have taken the tables and broke them out into a spreadsheet. I am going to try and look at what you said about the FK"The Association table should not have a Management foreign key" So the way they will be connected will be the many to many junction table?
Jim Wagner
________________________________
________________________________
From: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Thursday, September 27, 2012 2:29 PM
Subject: [MS_AccessPros] Re: Many to Many question
Jim
Think of it as a learning experience. The more databases you design, the easier it is to see what the relationships are and how they work in real life.
I've been doing this for so long I can see what the client either can't see or doesn't think is important enough to pass on to you.
For example, something that could never happen always does eventually. The number of locations can change even if the client has no plans on expanding. Or "oh, freehand entry is fine. Our data entry folks all know how a customer should be entered." Right! then you get "San Francisco Freight" or "SFF" or "S.F." or "S F Freight". All that could have been avoided with a combo box instead of a text box.
Bill
--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@...> wrote:
>
> Bill
>
> I just talked to my client. They agreed with you about the HOA employing the mgt co. That did not come out before.Â
> I will discuss with them about the history of the two entities. I am sure they would like to see that. In any case, this redesign will be massive.Â
>
> Thank You
>
>
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Thursday, September 27, 2012 1:24 PM
> Subject: [MS_AccessPros] Re: Many to Many question
>
>
> Â
> Jim
>
> It could actually go either way, I suppose. You need to determine if this is a management application or an HOA application. What is the purpose of the database?
>
> I guess I'm not explaining myself properly. The Association really has only one management company at a time. The only need for a m-t-m relationship is to keep a history of the management companies it's used in the past.
>
> The management company has (hopefully) several HOAs. So your setup would have a management table, an HOA and a table with BOTH foreign keys and whatever data that applies to the HOA's agreements.
>
> The projects table needs a foreign key to the HOA's table.
>
> So what I'm saying is you can still have the management form as the main and the HOA as the sub.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@> wrote:
> >
> > Bill
> >
> > I am confused a little. Are you saying that the tblAssociation should be the highest level of the hierarchy, not the tblManagementCo? Right now I have the form with the ManagementCo at the top and then a subform with the Association table and inside the Association form is a subform linking the Projects table.ÂÂ
> >
> > If I set up like that, do I need a many to many relationship?
> >
> > If I do not have a foreign key in the associations table to the management co table they will not be linked.ÂÂ
> >
> > Thank You
> > ÂÂ
> > Jim Wagner
> > ________________________________
> >
> >
> >
> > ________________________________
> > From: Bill Mosca <wrmosca@>
> > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Sent: Thursday, September 27, 2012 7:48 AM
> > Subject: RE: [MS_AccessPros] Re: Many to Many question
> >
> >
> > ÂÂ
> > Jim
> >
> > Feel free to ask. You know youâۉ„¢ll get lots of help here. I love working on re-designing. But not as much as designing from scratch.
> >
> > Regards,
> >
> > Bill
> >
> > From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jim Wagner
> > Sent: Wednesday, September 26, 2012 1:43 PM
> > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: Re: [MS_AccessPros] Re: Many to Many question
> >
> > Bill
> >
> > When the database was first designed, the question of the HOA's moving to another Management Co was defined as "That has never happened". But then it became common place and the information did not come from someone who knew the data very well. So I designed it without the many to many as an option. I put the ManagementCoID in the projects table because I thought possibly I might need to. I over thought it I guess.
> >
> > I will make some changes and let you know how it goes. I will have some additional questions afterwards
> >
> > Thank You
> >
> > Jim Wagner
> > ________________________________
> >
> > ________________________________
> > From: Bill Mosca <wrmosca@ <mailto:wrmosca%40comcast.net> >
> > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Sent: Wednesday, September 26, 2012 8:25 AM
> > Subject: [MS_AccessPros] Re: Many to Many question
> >
> > Jim
> >
> > You need to rethink your design in this area. The Association table should not have a Management foreign key. Think of the fields in a table as elements of an entity. The Management company works for the HOA just like an employee works for a company. The employee is not a property of it. It does not make up a piece of it in any way. The management company could fold and the HOA would still exist.
> >
> > And as I suspected, you need a linking table with the Assoc ID and Mgmt ID. That table's Primary key should be an AutoNumber.
> >
> > You can fill that table by using the two existing fields in the Assoc table.
> >
> > INSERT INTO tblAssocMgmt(AssociationID, ManagementCoID)
> > SELECT AssociationID, ManagementCoID FROM tblAssociation
> >
> > And There is no need to have a ManagementCoID in the projects table. You can always get that by joining the Association table to the projects table and then join the linking table to the project table.
> >
> > Then join the management table to the linking table.
> >
> > Capeesh?
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@> wrote:
> > >
> > > thanks Bill
> > > Ãâ€Å¡
> > > Jim Wagner
> > > ________________________________
> > >
> > >
> > >
> > > ________________________________
> > > From: Bill Mosca <wrmosca@>
> > > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > Sent: Tuesday, September 25, 2012 2:52 PM
> > > Subject: [MS_AccessPros] Re: Many to Many question
> > >
> > >
> > > Ãâ€Å¡
> > > Got it, Jim. But my work day is over and my commute is about to begin so I'll loo at it tomorrow.
> > >
> > > Bill
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@> wrote:
> > > >
> > > > Bill
> > > >
> > > > I uploaded it to assistance needed and named it many to many help
> > > > ÃÆ'âہ¡ÃƒÆ’â€Å¡
> > > > Jim Wagner
> > > > ________________________________
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: Bill Mosca <wrmosca@>
> > > > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > Sent: Tuesday, September 25, 2012 1:35 PM
> > > > Subject: [MS_AccessPros] Re: Many to Many question
> > > >
> > > >
> > > > ÃÆ'âہ¡ÃƒÆ’â€Å¡
> > > > Jim
> > > >
> > > > Sure. Use my Comcast address. It might be a couple days until I can get to it.
> > > >
> > > > Did you zip it? That might reduce the size enough to squeak it into our Files here.
> > > >
> > > > Bill
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@> wrote:
> > > > >
> > > > > Bill
> > > > >
> > > > > Even with no forms and reports and empty tables the database is too large to upload. I compacted and repaired and still to big. Can I send it to you?
> > > > > ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > Jim Wagner
> > > > > ________________________________
> > > > >
> > > > >
> > > > >
> > > > > ________________________________
> > > > > From: Bill Mosca <wrmosca@>
> > > > > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > Sent: Tuesday, September 25, 2012 12:54 PM
> > > > > Subject: [MS_AccessPros] Re: Many to Many question
> > > > >
> > > > >
> > > > > ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > Jim
> > > > >
> > > > > How are you storing the HOA-Management connection now? If it is in a single table you can run an append query to load the linking table with those two fields.
> > > > >
> > > > > Without knowing your table structures I can't be more specific than that. If you'd like to upload a sample with just the empty tables I could take a look.
> > > > >
> > > > > Bill
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@> wrote:
> > > > > >
> > > > > > BillÃÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > >
> > > > > > I will give that a try. What about the other part of my question
> > > > > >
> > > > > > ÃÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡ I can not find out how to populate the junction table without manually adding the records.ÃÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡ ÃÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > >
> > > > > > ÃÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > > Jim Wagner
> > > > > > ________________________________
> > > > > >
> > > > > >
> > > > > >
> > > > > > ________________________________
> > > > > > From: Bill Mosca <wrmosca@>
> > > > > > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > Sent: Tuesday, September 25, 2012 11:23 AM
> > > > > > Subject: [MS_AccessPros] Re: Many to Many question
> > > > > >
> > > > > >
> > > > > > ÃÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > > The Associations table should have the demographics for each HOA. A second table would have demographics for management companies.
> > > > > >
> > > > > > The AssociationManagement table would have a foreign key to each table. This table would have the duplicate HOA keys if it has had more than one management company in its history. This is your linking table for the many-to-many relationship.
> > > > > >
> > > > > > Bill
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@> wrote:
> > > > > > >
> > > > > > > The Database is for a CPA firm. The projects are those projects dealing with the Associations only. They track the things they do for them in regards to billing the Associations.ÃÆ'Æ'Æ'ÃÆ'â€Â 'ÃÆ'Æ'Ãâ€Å¡Ãƒ‚¢ÃƒÆ'¢Ã¢Ã¢Ã¢€Å¡Ã‚¬Ãƒ…¡Ãƒâ€Å¡Ãƒ‚¬ÃƒÆ'â€Â¦ÃƒÆ’â€Å¡Ãƒ‚¡ÃƒÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > > > There is a field currently that indicates whether the association is a current client.ÃÆ'Æ'Æ'ÃÆ'â€Â 'ÃÆ'Æ'Ãâ€Å¡Ãƒ‚¢ÃƒÆ'¢Ã¢Ã¢Ã¢€Å¡Ã‚¬Ãƒ…¡Ãƒâ€Å¡Ãƒ‚¬ÃƒÆ'â€Â¦ÃƒÆ’â€Å¡Ãƒ‚¡ÃƒÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > > >
> > > > > > > It seems that if I create this field, I would still have duplicate Associations in the tblAssociations table.ÃÆ'Æ'Æ'ÃÆ'â€Â 'ÃÆ'Æ'Ãâ€Å¡Ãƒ‚¢ÃƒÆ'¢Ã¢Ã¢Ã¢€Å¡Ã‚¬Ãƒ…¡Ãƒâ€Å¡Ãƒ‚¬ÃƒÆ'â€Â¦ÃƒÆ’â€Å¡Ãƒ‚¡ÃƒÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > > > ÃÆ'Æ'Æ'ÃÆ'â€Â 'ÃÆ'Æ'Ãâ€Å¡Ãƒ‚¢ÃƒÆ'¢Ã¢Ã¢Ã¢€Å¡Ã‚¬Ãƒ…¡Ãƒâ€Å¡Ãƒ‚¬ÃƒÆ'â€Â¦ÃƒÆ’â€Å¡Ãƒ‚¡ÃƒÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > > > Jim Wagner
> > > > > > > ________________________________
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ________________________________
> > > > > > > From: Bill Mosca <wrmosca@>
> > > > > > > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > Sent: Tuesday, September 25, 2012 10:54 AM
> > > > > > > Subject: [MS_AccessPros] Re: Many to Many question
> > > > > > >
> > > > > > >
> > > > > > > ÃÆ'Æ'Æ'ÃÆ'â€Â 'ÃÆ'Æ'Ãâ€Å¡Ãƒ‚¢ÃƒÆ'¢Ã¢Ã¢Ã¢€Å¡Ã‚¬Ãƒ…¡Ãƒâ€Å¡Ãƒ‚¬ÃƒÆ'â€Â¦ÃƒÆ’â€Å¡Ãƒ‚¡ÃƒÆ'Æ'Æ'ÃÆ'¢Ã¢Ã¢Ã¢‚¬Ã…¡Ãƒ‚¬Ãƒ…¡ÃÆ'Æ'âââ€Å¡Ã‚¬Ãƒ…¡ÃƒÆ'âہ¡ÃƒÆ’â€Å¡
> > > > > > > Jim
> > > > > > >
> > > > > > > I'd set up an AssociationManagement table with a field Named Current (Yes/No).
> > > > > > >
> > > > > > > That way if an HOA changes management companies you can keep the old record but unmark it as Current.
> > > > > > >
> > > > > > > Are projects related to Management in any way? The HOAs I've dealt with use the Management to deal with the contracts, billing, etc. That would be handed over to the new Management so they are not really tied to the projects. Just to the HOA.
> > > > > > >
> > > > > > > Regards,
> > > > > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > > > > http://www.thatlldoit.com
> > > > > > > Microsoft Office Access MVP
> > > > > > > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> > > > > > > My nothing-to-do-with-Access blog
> > > > > > > http://wrmosca.wordpress.com
> > > > > > >
> > > > > > > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , "luvmymelody" <luvmymelody@> wrote:
> > > > > > > >
> > > > > > > > Hello all,
> > > > > > > >
> > > > > > > > I am recreating a database that should have had a many to many relationship set up. There are 2 tables one with Management Companies and the other is the Home Owners Associations which are managed by the Management companies. A third table is called Projects where this table is linked to the Home Owners Association table, as there is 1 to many projects.
> > > > > > > > The issue is that Home Owners Associations are now moving to and between Management companies. I have studied on how to define and set up the many to many relationships but I can not find out how to populate the junction table without manually adding the records.
> > > > > > > >
> > > > > > > > And how do the history of projects for associations not go away when the associations move to a new Management companies?
> > > > > > > >
> > > > > > > > So my question is how do I set up this many to many relationships?
> > > > > > > >
> > > > > > > >
> > > > > > > > Thank You
> > > > > > > >
> > > > > > > > Jim Wagner
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Re: [MS_AccessPros] Tab control form
Thanks- Stuart and Jma for your guidance. I understood the method and got the desired results.
Regards,
Kumar
--- In MS_Access_Professionals@yahoogroups.com, "Stuart Aitchison" <saitchison@...> wrote:
>
> Kumar, Hi:
>
>
>
> I'm not one the Access gurus, but I have done this in several situations
> now, involving stock, contacts and one or two other things.
>
>
>
> One caution. The more tabs you have on a form, the longer it takes for the
> form to open.
>
>
>
> You can use either the main form as the controlling form, or include a list
> sub form which can be used as the controlling form.
>
>
>
> Whichever you use, do not forget to requery the linked forms from the main
> form whenever the user changes whatever record it is on the main form that
> is the main item being looked up.
>
>
>
> Regards,
>
>
>
> Stuart Aitchison.
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sw@...
> Sent: Sat, 29 September 2012 17:44 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Tab control form
>
>
>
>
>
> 1) main form -> main table as source.
> 2) make solo form for each sub-table and name it as like as subformXY.
> 3) in main form put on each tab one sub-form as subform-control.
> 4) in properties of each subform control set LinChildFields and
> LinkMasterFields property.
> More you find sure by google
> -jma-
>
> ----- Original Message -----
> From: "access_kri" <access_kri@... <mailto:access_kri%40yahoo.com> >
> To: <MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> >
> Sent: Saturday, September 29, 2012 4:06 PM
> Subject: [MS_AccessPros] Tab control form
>
> > Dear Group,
> > Can tabbed control editable form can have data from only one table or
> multiple tables can be used? I am trying to make an
> > tabled form for Equipment specification. As equipment specification can
> have several sections such as Name plate details, Design
> > parameters, Operating parameters, constructional details, material of
> construction etc. I created separate tables for each of
> > these categories and linked them together with EquipmentID field. Thus all
> tables are having one-to-one relationship with
> > equipmentID in the NamePlate table. I am then basing my form on query that
> pulls information from all the tables. However, the
> > query is not editable and It only displays the records but I cannot add
> new records. How I can create a tabbed form which contains
> > information from all these tables?
> >
> > Thanks and Regards,
> > Kumar
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> > http://help.yahoo.com/help/us/groups/messages/messages-23.html
> >
> >
> >
> >
>
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by Pinpoint, and is
> believed to be clean.
>
>
>
> [Non-text portions of this message have been removed]
>
[MS_AccessPros] Re: Tab control form
Thanks Jma. I was able to follow your method and get the desired results.
Kind Regards,
Kumar
--- In MS_Access_Professionals@yahoogroups.com, <sw@...> wrote:
>
> 1) main form -> main table as source.
> 2) make solo form for each sub-table and name it as like as subformXY.
> 3) in main form put on each tab one sub-form as subform-control.
> 4) in properties of each subform control set LinChildFields and LinkMasterFields property.
> More you find sure by google
> -jma-
>
>
> ----- Original Message -----
> From: "access_kri" <access_kri@...>
> To: <MS_Access_Professionals@yahoogroups.com>
> Sent: Saturday, September 29, 2012 4:06 PM
> Subject: [MS_AccessPros] Tab control form
>
>
> > Dear Group,
> > Can tabbed control editable form can have data from only one table or multiple tables can be used? I am trying to make an
> > tabled form for Equipment specification. As equipment specification can have several sections such as Name plate details, Design
> > parameters, Operating parameters, constructional details, material of construction etc. I created separate tables for each of
> > these categories and linked them together with EquipmentID field. Thus all tables are having one-to-one relationship with
> > equipmentID in the NamePlate table. I am then basing my form on query that pulls information from all the tables. However, the
> > query is not editable and It only displays the records but I cannot add new records. How I can create a tabbed form which contains
> > information from all these tables?
> >
> > Thanks and Regards,
> > Kumar
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> > http://help.yahoo.com/help/us/groups/messages/messages-23.html
> >
> >
> >
> >
>
[MS_AccessPros] Tab control form
Kumar, Hi:
I'm not one the Access gurus, but I have done this in several situations
now, involving stock, contacts and one or two other things.
One caution. The more tabs you have on a form, the longer it takes for the
form to open.
You can use either the main form as the controlling form, or include a list
sub form which can be used as the controlling form.
Whichever you use, do not forget to requery the linked forms from the main
form whenever the user changes whatever record it is on the main form that
is the main item being looked up.
Regards,
Stuart Aitchison.
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sw@tuzka.cz
Sent: Sat, 29 September 2012 17:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Tab control form
1) main form -> main table as source.
2) make solo form for each sub-table and name it as like as subformXY.
3) in main form put on each tab one sub-form as subform-control.
4) in properties of each subform control set LinChildFields and
LinkMasterFields property.
More you find sure by google
-jma-
----- Original Message -----
From: "access_kri" <access_kri@yahoo.com <mailto:access_kri%40yahoo.com> >
To: <MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> >
Sent: Saturday, September 29, 2012 4:06 PM
Subject: [MS_AccessPros] Tab control form
> Dear Group,
> Can tabbed control editable form can have data from only one table or
multiple tables can be used? I am trying to make an
> tabled form for Equipment specification. As equipment specification can
have several sections such as Name plate details, Design
> parameters, Operating parameters, constructional details, material of
construction etc. I created separate tables for each of
> these categories and linked them together with EquipmentID field. Thus all
tables are having one-to-one relationship with
> equipmentID in the NamePlate table. I am then basing my form on query that
pulls information from all the tables. However, the
> query is not editable and It only displays the records but I cannot add
new records. How I can create a tabbed form which contains
> information from all these tables?
>
> Thanks and Regards,
> Kumar
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> http://help.yahoo.com/help/us/groups/messages/messages-23.html
>
>
>
>
--
This message has been scanned for viruses and
dangerous content by Pinpoint, and is
believed to be clean.
[Non-text portions of this message have been removed]
Re: [MS_AccessPros] Tab control form
1) main form -> main table as source.
2) make solo form for each sub-table and name it as like as subformXY.
3) in main form put on each tab one sub-form as subform-control.
4) in properties of each subform control set LinChildFields and LinkMasterFields property.
More you find sure by google
-jma-
----- Original Message -----
From: "access_kri" <access_kri@yahoo.com>
To: <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, September 29, 2012 4:06 PM
Subject: [MS_AccessPros] Tab control form
> Dear Group,
> Can tabbed control editable form can have data from only one table or multiple tables can be used? I am trying to make an
> tabled form for Equipment specification. As equipment specification can have several sections such as Name plate details, Design
> parameters, Operating parameters, constructional details, material of construction etc. I created separate tables for each of
> these categories and linked them together with EquipmentID field. Thus all tables are having one-to-one relationship with
> equipmentID in the NamePlate table. I am then basing my form on query that pulls information from all the tables. However, the
> query is not editable and It only displays the records but I cannot add new records. How I can create a tabbed form which contains
> information from all these tables?
>
> Thanks and Regards,
> Kumar
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> http://help.yahoo.com/help/us/groups/messages/messages-23.html
>
>
>
>