Selasa, 31 Mei 2011

Re: [belajar-access] Bahan Pertanyaan: How to Print to PDF with Security

 

Dear Mas Harry, ada sample bagus untuk report langsung ke pdf tanpa memperlihatkan gui nya, di:
 
Tinggal ditambah command line :
.SetValue "UserPassword", "Passwordnya"
.SetValue "OwnerPassword", "Passwordnya"
Sebelumnya harus diinstall dahulu BioPDF dan Ghostscript. Dengan demikian kita tidak perlu lagi membuat sendiri kode untuk export report ke PDF, tinggal memanfaatkan command line dari gui nya BioPDF. Setting command line nya bisa dilihat di: http://www.biopdf.com/guide/settings.php
 
Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi.
http://opi.110mb.com/
----- Original Message -----
Sent: Wednesday, June 01, 2011 9:51 AM
Subject: [belajar-access] Bahan Pertanyaan: How to Print to PDF with Security [1 Attachment]

 

Dear Senior,

Terlampir contoh sederhana, untuk membuat Report dari suatu Form,
berdasarkan Record yang aktif.
Bagaimana caranya padawaktu klik Button Report; maka akan mengKonvert kedalam
Format PDF
dan sekaligus dengan sekuritinya, (di Password to open PDF).
jadi padawaktu file Report PDF terbentuk, untuk membukanya harus memasukan
Password.
Password yang otomatis di Create adalah diambil dari NoKontrak
bagaimana yach Scriptnya...
pernah sih liat Program MsAccess jaman jadul (versi 2000 atau 97) juga udah ada
yg bisa convert ke pdf dengan sekali click. Tapi tetep blm Mudeng Scriptingnya.
apa perlu dipasang Acrobat Writer atau sejenisnya  terlebih dahulu, ?
kalo Print biasa, ke PDF sih bisa,
tapi yang saya inginkan disini, dalam bentuk Script dan otomatis menggunakan
password utk membuka file PDF hasil bentukannya.

Sebelumnya saya ucapkan terima kasih kepada Senior yang mau berbagi Ilmunya,
apakah mau dibawakan di acara Kopdar atau di Millist ini, saya tunggu
Informasinya

terima kasih

Harry

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

.

__,_._,___

RE: [MS_AccessPros] Re: Obtaining Data from a remote server

 

Walter-

I get it. What you got from that file is only a schema - no data. If you open
the XML file in Notepad, do you see any data?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
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 nkpberk
Sent: Wednesday, June 01, 2011 12:51 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Obtaining Data from a remote server

John;
What I posted is exactly what I got, No multiple columns.
Walter

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> Ah, I see you said 12 *records* not 12 columns. Are there multiple sets of
12?
> Can you post a sample of the data?
>
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> 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 nkpberk
> Sent: Tuesday, May 31, 2011 7:52 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Obtaining Data from a remote server
>
> John : Yes it is, but how do I ask for data based on ISBN or LCCN so I get
> actual info instead of the place holders?
> Walter
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Walter-
> >
> > Isn't the info you need in the Map table?
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > 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 nkpberk
> > Sent: Tuesday, May 31, 2011 6:26 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Obtaining Data from a remote server
> >
> > John;
> > I downloaded the xml and came up with 9 tables
> >
> > Configinfo; "Default" = 0
> >
> > DBInfo; "title"= LoC Gateway, "Description" = null
> >
> > Explain; "schemaInfo" = null
> >
> > ExplainResponse; "Version" = 1.1
> >
> > Index; (11 records under "Title") title, subject, creator, editor,
publisher,
> > description, date, name, ISBN, ISSN, LCCN
> >
> > IndexInfo; "Set" = null
> >
> > Map;(12 records under "Name") title, subject, creator, author, editor,
> > publisher, description, date, name, ISBN, ISSN, LCCN
> >
> > Record; "RecordSchema" =http://explain.z3950.org/dtd/2.0/ , "RecordPacking"
=
> > xml
> >
> > ServerInfo; "Host" = localhost ,"Port" = 7090, "database" = Voyager
> >
> > Quoted words are field names
> >
> > I am hoping to make this work by inputing The ISBN or LCCN (for older
> > publications without the ISBN.
> >
> > Any Idea how to make this work?
> >
> > Walter
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
wrote:
> > >
> > > Walter-
> > >
> > > In the latest versions of Access, you can Import an XML document into an
> > Access
> > > table. If you're able to download the XML document, try importing it to
see
> > if
> > > Access likes it.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > 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 nkpberk
> > > Sent: Monday, May 30, 2011 11:44 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Obtaining Data from a remote server
> > >
> > > Hello Group;
> > > I'm back with something a bit more complicated than usual. In my attempt
to
> > > build the(inventory) part of my application I want to be able to enter the
> > ISBN
> > > or LCCN from the Library of Congress to pull pertinent data for the
> > publications
> > > inventory table. I have the server link (z3950.loc.gov:7090/voyager) this
> > gives
> > > me an xml document but I have no idea how to query it or extract any
result.
> > > Any suggestions?
> > > Walter Griffin
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

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

Yahoo! Groups Links

__._,_.___
Recent Activity:
MARKETPLACE

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.


Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

RE: [MS_AccessPros] Re: Help with relationships

 

Joe-

The relationships that you have already looked fine to me. Any relationship should put the table with the Primary Key (key symbol) on the "left" and the table with the Foreign Key on the "right." You need to finish all the relationships from the L_ tables. You have one relationship between L_Results and Results that probably should have Referential Integrity defined.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
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 Joe HErnandez
Sent: Tuesday, May 31, 2011 10:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Help with relationships

Yes I will need all the assistance and suggestions you can offer. Right about now I need to know how to relate them to each other. This is the area where I am lost at. Can you please tell me where to place each table (right or Left of the main form) and which ones get attached to which ones.
Would you link them for me?

Joe

________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, May 31, 2011 3:00 PM
Subject: RE: [MS_AccessPros] Re: Help with relationships

Joe-

It landed in the main Files folder. You should have clicked 2_AssistanceNeeded, and then clicked the Add File link.

It looks pretty good now. I see you've also started to build some forms. Let us know if you need additional help.

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

P.S. You should delete your file to free up space in the amount alloted to the group.

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Joe HErnandez
Sent: Tuesday, May 31, 2011 8:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Help with relationships

John;
Where exactly do I find this folder?
I've tried to locate it but can't?

Joe

P.S. I don't know where the db landed but I sent it in a while ago.

________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, May 31, 2011 11:58 AM
Subject: RE: [MS_AccessPros] Re: Help with relationships

Joe-

You could compact / zip, and post it to the group Assistance Needed folder.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
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 Joe HErnandez
Sent: Tuesday, May 31, 2011 5:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Help with relationships

John;

I made the changes you suggested to the db.
Do you want me to re-send it to you so that you can look it over?

Joe

________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, May 31, 2011 12:58 AM
Subject: RE: [MS_AccessPros] Re: Help with relationships

Joe-

Wow! Freddy & Soraya must be pretty special people to have fields named after them in the database. <s> What happens if Soraya finds a better job and moves on? You'll have to redesign your table - and that's not a good idea. I have no idea how you plan to enforce security, but a Users table should normally look like:

tblUsers:
UserID (PKey)
UserName
UserPswd
UserAuth

Then you put rows in for Soraya and Freddie and set their authorization level. If another person comes on board, you just add a row. If someone leaves, you delete the row. No changes to the design necessary.

As for tracking patients and results, it might look something like:

tblPatients:
PatientID:
PatientName
.. other relevant fields such as address, phone number, referring doctor, etc.

tblPatientAppointments:
AppointmentID
PatientID
AppointmentDate
... etc.

tblPatientAppointmentTests:
TestID
AppointmentID
TestType
TestResult

If a particular test can have more than one result, then instead of putting TestResult in that table, you'll need:

tblPatientApptTestResults:
ResultID
TestID
Result

The database will have one row for each patient, one row for each appointment, one row for each test performed during an appointment, and one row for each result for each test. To track "next" appointment, you might need a FollowUpDate in tblPatientAppointments, but you'll create a new row in tblPatientAppointments for the follow-up.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
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 Joe HErnandez
Sent: Tuesday, May 31, 2011 12:57 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Help with relationships

John; thanks for getting back to me.

The purpose of this db is to track:
· Patient/clients'
visits (dates)
· When and
if they returned for results ,after each test (dates)
· When is
their follow- up appts .
Please keep in mind that these patients (most of them) will
return multiple times for re- testing and after each test they in turn will
return for results. Hence, the
repetition.

The two people who will be doing the tests (testers) are Soraya and Freddie.

________________________________
From: johnvmvp <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, May 30, 2011 11:43 AM
Subject: [MS_AccessPros] Re: Help with relationships

Joe-

I have your database, but the purpose of the database is not clear.

You have a bad problem with both the Tests and Results tables. In the Tests tables, fields like TestDt1, TestDt2 and 2ndTestAppt_DT and 3rdTestAppt_DT are repeating groups. Ditto Rslt1, Rslt2, Rslt3, etc. in Results.

The fields in L_AccessLevel make no sense. What are the Soraya and Freddie fields?

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

--- In MS_Access_Professionals@yahoogroups.com, "JoeH" <jomahe0143@...> wrote:
>
> I am trying to build a database for my daughter. So far I have identified the tables and built some of the forms I feel I need.
> I would like someone to help me connect the relationships and if at all possible provide any feedback deemed useful.
>
> If you need to see what I have done up to this point, please let me know how to attach the file.
>
> In advance I thank you
> sincerely
> Joe Hernandez
>
> P.S. I am using Access 2010 and my OS is Win 7.
>

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

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

Yahoo! Groups Links

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

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

Yahoo! Groups Links

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

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

Yahoo! Groups Links

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

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

Yahoo! Groups Links

__._,_.___
Recent Activity:
.

__,_._,___

Re: [belajar-access] Re: mematikan tombol dari form lain

 


Mas Sofyan, ini tidak ditambahkan dari Forms![TRumah_Tangga_add]![Tnomor_KK_add]![NamaTextBox].SetFocus jadi Forms![TRumah_Tangga_add]![Tnomor_KK_add].Form![NamaTextBox].SetFocus ??

regards,
Tio



"Sofyan Efendi" <sofyanefendi@gmail.com>
Sent by: belajar-access@yahoogroups.com

06/01/2011 10:35 AM
Please respond to belajar-access

       
        To:        belajar-access@yahoogroups.com
        cc:        
        Subject:        [belajar-access] Re: mematikan tombol dari form lain



 

Dear Mas Hadis,

Focusnya diset dulu di object control yg lain, misal di subform tsb ada text box, maka pindahkan dulu sementara focusnya kesana.

Forms![TRumah_Tangga_add]![Tnomor_KK_add]![NamaTextBox].SetFocus
Forms![TRumah_Tangga_add]![Tnomor_KK_add]![CmTambahKK].Enabled = False

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi.

http://opi.110mb.com/

--- In
belajar-access@yahoogroups.com, "hadis0678" <hadis0678@...> wrote:
>
> yang terhormat teman teman semua
>
> lanjut mas, kemudian kalau ingin mendisable tombol yang ada di sub form, dengan cara yang sama yang diberikan mas sofyan menjadi
> Forms![TRumah_Tangga_add]![Tnomor_KK_add]![CmTambahKK].Enabled = False
> dimna Tnomor_KK_add adalah subform dari TRumah_Tangga_add kemudian ketika dijalankan muncul komentar sebagai berikut :
> You can't disable control it has the focus
> apa yang salah dengan perintah saya ya mas.
>
> sebagai gambaran dalam form TRumah_Tangga_add terdapat subform TNomor_KK_add dan dalam TNomor_KK_add terdapat subform data_anggota_keluarga dan tiap subform terdapat tombol untuk menambah data.
>
> demikian permohonan bantuan saya, sebelumnya saya ucapkan terima kasih
>
>
> best regards
>
> must hdi s
>
> --- In
belajar-access@yahoogroups.com, "sudarsono" <jkssbma@> wrote:
> >
> >
> > expression.OpenForm(FormName, View, FilterName, WhereCondition,
> > DataMode, WindowMode, OpenArgs)
> >
> > openArgs akan digunakan oleh Form yang akan dibuka ,yaitu pada event
> > open :
> >
> > me.OpenArgs ---> dapat dimanfatkan untuk membuat apa saja yang
> > diinginkan , misal :
> >
> > form yang hanya untuk mencari data.
> >

> > misal saat memanggil form kita beri nilai ( parameter ke-7, openargs )
> > "SEARCH", maka data tak dapat di tambah dan edit. Hal ini di cek pada
> > event open, lalu cek niai me.openargs.
> >
> > semoga sesuai .....
> >
> > '============
> > --- In
belajar-access@yahoogroups.com, Sofyan Efendi <sofyanefendi@>
> > wrote:
> > >
> > > Dear Mas Hadis,
> > >
> > > 1. Syntaxnya :
> > Access_Object![Nama_Object]![Nama_Control].Nama_Property
> > > Berarti tinggal ditambahkan kode :
> > Forms![TRumah_Tangga_add]![CmTambahdata].Enabled =False
> > > Maka tombol nya menjadi disable.
> > >
> > > 2. Sebelumnya saya hendak memberi saran dahulu, bahwa link table
> > manager bawaaan Access sangatlah mencukupi kebutuhan kita. Bila karena
> > masalah bahasa, hal tersebut bukan masalah. Hendaknya dalam membuat
> > program kita tidak menggunakan cara yang sulit, sederhanakanlah,
> > permudahlah, karena selama disana masih ada cara yang mudah maka
> > janganlah membuang waktu untuk mengambil cara yang sulit. Bila Access
> > sudah menyediakan link table manager, maka kita tidak perlu membuang
> > waktu membuat sendiri form link table manager.
> > >
> > > Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
> > > Sofyan Efendi.
> > >
http://opi.110mb.com/
> > > ----- Original Message -----
> > > From: hadis0678
> > > To:
belajar-access@yahoogroups.com
> > > Sent: Tuesday, May 31, 2011 5:30 AM
> > > Subject: [belajar-access] mematikan tombol dari form lain
> > >
> > >
> > >
> > > met pagi sodara-sodara...
> > >
> > > sory kebiasaan jelek, nongol kalau nanya hehehhee..
> > >
> > > mohon bantuan rekan-rekan untuk masalah saya ini..
> > >
> > > 1. pengin mematikan tombol di form dari form lain
> > > saya dah buka form dalam edit mode dengan perintah
> > > Private Sub CmEdit_Click()
> > > On Error GoTo Err_CmEdit_Click
> > >
> > > Dim stDocName As String
> > > Dim stLinkCriteria As String
> > >
> > > stDocName = "TRumah_Tangga_add"
> > > DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
> > >
> > >
> > > Exit_CmEdit_Click:
> > > Exit Sub
> > >

> > > Err_CmEdit_Click:
> > > MsgBox Err.Description
> > > Resume Exit_CmEdit_Click
> > >
> > > End Sub
> > >
> > > kemudian di form TRumah_Tangga_add terdapat tombol CmTambahdata yang
> > digunakan untuk menambah data. bagaimana caranya untuk mematikan tombol
> > ini? (tahunya kalau pas diform yang bersangkutan, kalau dari form lain
> > bagaimanakah)
> > >
> > > 2. link table manager..
> > > ada gak ya vba untuk bikin link table selain menggunakan dari
> > fasilitas file di acces (hehehehe biar bisa ada bahasa indonesianya)..
> > >
> > > terima kasih rekan-rekan atas bantuannya...
> > >
> > > best regards
> > >
> > > must hdi s
> > >
> >
>



__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

[MS_AccessPros] Re: Open form using combo box and command button

 

John -

Did you get a chance to look at the database? Still can't figure out what I'm doing wrong... Please help! I've got a deadline and am in a bind.

Thanks!

Kat

--- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@...> wrote:
>
> John -
>
> I changed the combo boxes on the search form to the match the ones on my contract form, and I took off the quotes; however, it's still not pulling up the information. I've uploaded an updated database showing what I did. Also, now everytime I make a selection and hit the command button to pull of the information it creates a new record in my contract table, not sure why it's doing that now.
>
> Thanks!
>
> Kat
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Kat-
> >
> > Well, you have a Vendor ID on the Contract Form, so you need to change your
> > filter rather than add the Vendor Information table. The combo box on your
> > search form should be exactly the same as the Vendor combo box on the Contract
> > Form. That will bind the search combo to the ID, not the vendor name, and you
> > can search using that. Don't put quotes around the parameter value because
> > you'll be searching on a number, not a text value. You need to do a similar
> > thing to your Employee search - search for the matching ID, not the name. Your
> > search on "Category" (Type of Lease) should work because you're using the text,
> > not an artificial ID.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > 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 ka0t1c_ang3l
> > Sent: Tuesday, May 31, 2011 8:13 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Open form using combo box and command button
> >
> > John,
> >
> > I uploaded a new database that shows the arguments in the Find Contract Form.
> > I'm not sure how to add the vendor name into the record source of the contract
> > form. At this point I feel if I add anything I'll mess up my database.....
> >
> > Thanks!
> >
> > Kat
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > Kat-
> > >
> > > I found no argument in the macro to open the contract form. What is in the
> > > Where Condition? Note that Vendor Name isn't in the Record Source of the
> > > contract form, so perhaps that's why you're getting prompted.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > 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 ka0t1c_ang3l
> > > Sent: Tuesday, May 31, 2011 6:23 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] Open form using combo box and command button
> > >
> > > John,
> > >
> > > I do have an argument in the Where Condition; however, when I make a selection
> > > and click on the command button it pops up another small window asking me to
> > > type either the vendor name or employee name, depending on which command
> > button
> > > I'm using, instead of immediately taking me to the contract form and pulling
> > up
> > > the information i've requested. I'm not sure what's wrong with my argument.
> > >
> > > Thanks!
> > >
> > > Kat
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > > >
> > > > Kat-
> > > >
> > > > You need to add an argument in the Where Condition of the OpenForm action in
> > > > your macro. Depending on what you're filtering, it needs to look something
> > > like
> > > > the filter in the Embedded Macro in the Find Vendor form.
> > > >
> > > > John Viescas, author
> > > > Microsoft Office Access 2010 Inside Out
> > > > Microsoft Office Access 2007 Inside Out
> > > > Building Microsoft Access Applications
> > > > Microsoft Office Access 2003 Inside Out
> > > > 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 ka0t1c_ang3l
> > > > Sent: Tuesday, May 31, 2011 5:39 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: Re: [MS_AccessPros] Open form using combo box and command button
> > > >
> > > > John,
> > > >
> > > > Yes, I saw that, but what it should do is when you make a selection and
> > click
> > > on
> > > > the control button it should open up that record in the contract form, but
> > > it's
> > > > not working. I'm not sure what I'm doing wrong, and the reason for the
> > error
> > > on
> > > > the dates is because I didn't put in a contract end date. How do I get the
> > > > control button to work so that when I make a selection it opens up that
> > > record?
> > > >
> > > > Thanks!
> > > >
> > > > Kat
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> > wrote:
> > > > >
> > > > > Kat-
> > > > >
> > > > > The Find Contract form doesn't apply *any* filter in either the Find
> > > Contract
> > > > or
> > > > > Employee Find macros. If I try to use one of your search buttons, I get
> > an
> > > > > error in the Current event of Contract Form trying to subtract today's
> > date
> > > > from
> > > > > a contract that has no date.
> > > > >
> > > > > John Viescas, author
> > > > > Microsoft Office Access 2010 Inside Out
> > > > > Microsoft Office Access 2007 Inside Out
> > > > > Building Microsoft Access Applications
> > > > > Microsoft Office Access 2003 Inside Out
> > > > > 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 ka0t1c_ang3l
> > > > > Sent: Tuesday, May 31, 2011 4:17 PM
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > Subject: Re: [MS_AccessPros] Open form using combo box and command button
> > > > >
> > > > > John -
> > > > >
> > > > > It's the Find Contract Form I'm having problems with. Each time I select
> > a
> > > > > contract or employee name to find a contract it prompts me for either the
> > > > vendor
> > > > > name. I have uploaded the database I'm currently using that has a few of
> > my
> > > > > contracts already put in.
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Kat
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> > > wrote:
> > > > > >
> > > > > > Kat-
> > > > > >
> > > > > > I get no prompt at all when I use your Find Vendor form - after I
> > entered
> > > at
> > > > > > least one row in Vendor Information.
> > > > > >
> > > > > > John Viescas, author
> > > > > > Microsoft Office Access 2010 Inside Out
> > > > > > Microsoft Office Access 2007 Inside Out
> > > > > > Building Microsoft Access Applications
> > > > > > Microsoft Office Access 2003 Inside Out
> > > > > > 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
> > ka0t1c_ang3l
> > > > > > Sent: Tuesday, May 31, 2011 3:38 PM
> > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > Subject: Re: [MS_AccessPros] Open form using combo box and command
> > button
> > > > > >
> > > > > > Good Morning John,
> > > > > >
> > > > > > This is the SQL of the Record Source.....
> > > > > >
> > > > > > SELECT [VENDOR INFORMATION].[VENDOR NAME]
> > > > > > FROM [VENDOR INFORMATION]
> > > > > > ORDER BY [VENDOR INFORMATION].[VENDOR NAME];
> > > > > >
> > > > > > I have also uploaded a zipped file of my database under Kats Files if
> > you
> > > > want
> > > > > > to look at it.
> > > > > >
> > > > > > Thanks!
> > > > > >
> > > > > > Kat
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> > > > wrote:
> > > > > > >
> > > > > > > Kat-
> > > > > > >
> > > > > > > What is the SQL of the Record Source of the form you're trying to
> > open?
> > > > > > >
> > > > > > > John Viescas, author
> > > > > > > Microsoft Office Access 2010 Inside Out
> > > > > > > Microsoft Office Access 2007 Inside Out
> > > > > > > Building Microsoft Access Applications
> > > > > > > Microsoft Office Access 2003 Inside Out
> > > > > > > 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
> > > ka0t1c_ang3l
> > > > > > > Sent: Friday, May 27, 2011 10:37 PM
> > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > > Subject: [MS_AccessPros] Open form using combo box and command button
> > > > > > >
> > > > > > > Hello all!
> > > > > > >
> > > > > > > I have a search form with several combo boxes and command buttons.
> > When
> > > I
> > > > > > click
> > > > > > > on the combo box and select a name I want to then click on the command
> > > > > button
> > > > > > > which will open up my form based on the selection made in my combo
> > box.
> > > > > > > Currently, what is happening after I select a name in the combo box
> > and
> > > > hit
> > > > > > the
> > > > > > > button is another box pops up asking me to enter the vendor name
> > again.
> > > > How
> > > > > > do
> > > > > > > I get rid of that and have the command button take me directly to that
> > > > form
> > > > > to
> > > > > > > bring up the information selected for the vendor? Any help is
> > > appreciated
> > > > > it!
> > > > > > >
> > > > > > > Thanks!
> > > > > > >
> > > > > > > Kat
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ------------------------------------
> > > > > > >
> > > > > > > Yahoo! Groups Links
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Yahoo! Groups Links
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Yahoo! Groups Links
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>

__._,_.___
Recent Activity:
MARKETPLACE

Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!


Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

RE: [MS_AccessPros] get control name associated with label

 

Pam-

You got it! If you were to put that code in the Click event of the associated
Text Box, it would run when you click the label.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
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 Pamela Zimmerman
Sent: Tuesday, May 31, 2011 9:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] get control name associated with label

Thanks John-

When doing this type of form I usually drop the field in detail view and
then move the auto generated label to the header. When moving the label to
the header, it must disassociate itself from the control. The code below,
when placed in those labels, returns not the (previously associated it
seems) control name, but the name of the form.

When I drag a new control to the form, the auto generated label does not
have any events showing in the property tab (Crystal said this earlier, it
makes sense now), so I can't put any code behind the click event of the
associated label. If I move the label to the header of the form, the label
now has events, but since it no longer associated to the control,
parent.name returns the name of the form. Who's on first?

I tried putting the code below directly in the form module of the auto
generated label in the detail part of the form, but that doesn't work. Once
the form is in 'form view' there is no clicking on that label, no matter
what I put in the code J

I will try the tag property and see what I can do with that..

Thanks!

Pam

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Tuesday, May 31, 2011 1:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] get control name associated with label

Pam-

The Parent property won't show up in the Properties Window, but it's there
in
code:

strControlName = Me.lblOne.Parent.Name

In 2007, if the controls are in a Layout, then you won't get the warning
about
an unassociated label.

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

-----Original Message-----
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 Pamela
Zimmerman
Sent: Tuesday, May 31, 2011 8:45 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] get control name associated with label

Hi John-

I believe the labels are associated with the text boxes. There is no small
green corner on the label, or exclamation point saying 'this label is not
associated with a control'. Looking at them I do not however see a 'Parent'
property on the property sheet.

To test, I added a new field, by dragging and dropping from the 'existing
fields' box and I cannot find a 'Parent' property in the automatically
generated label either. I am using Access 2007. Am I missing it?

I will take a look at using the tag property, I can probably make that work.
I would still appreciate getting a handle on the label/parent property issue
if you can help resolve that. It would seem the most common sense way to
work with the control.

Thanks so much for your input John. It is truly appreciated!

Pam

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 John
Viescas
Sent: Tuesday, May 31, 2011 12:31 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] get control name associated with label

Pamela-

When you said "associated," both Crystal and I thought you meant a label
attached to the text box. Typically, if you drag a text box onto a form in
Design view, Access also creates an "associated" label. In fact, that Label
control will have a Parent property that points to the control with which it
is
associated.

It sounds like you have independent labels. In that case, you could put in
the
Tag property of the label the name of the control with which it is
"associated."
You could then use the Tag property in the Click event of the Label control
to
determine which field needs to be sorted.

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

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Pamela
Zimmerman
Sent: Tuesday, May 31, 2011 5:54 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] get control name associated with label

Thanks John and Crystal!

I will add a bit. I have a series of forms that display a large amount of
reference table data. Clients need to maintain tables using these forms,
add new, or edit existing records. I have a client that has a large amount
of reference table data. They have requested the ability to sort the data
on various fields by clicking the column headings (which are labels).

The forms are continuous forms with the label in the top section of the form
and the data below in a column, similar in appearance to an excel
spreadsheet. Each form has several columns. It seems intuitive for the
user to click the column heading to sort the data as needed, not as much so
to click the column of data.

Although I could code the click from label using the control name, I don't
especially want to, because I will have to have this in a hundred or so
places and it will be more efficient if I can paste the same thing rather
than edit all of the individual control names in the code.

Crystal, I'm not quite tracking on the notion that a label associated with a
control has no events. I have click event code attached to lblPodNumber
(which is associated with txtPodNumber) and it runs as it is coded (just not
as I want it to).I must be misunderstanding something here.it's getting
late.

All I really want, is on the click of the label, move the focus to that
label's associated control. This would then make the desired control the
active control, and then the code would work. Is this possible??

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Crystal
Sent: Friday, May 27, 2011 2:15 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] get control name associated with label

Hi Pam,

adding on to what John said ...

if a label is associated with a textbox or other control, it has no events.
The only way it can have events is to NOT be associated.

> I need to reference the name of the control that the label
> is associated
> with, not the active control.

you can reference a control this way:
Me.controlname
or
Me("controlname")

~~~

looking at your code:

Call thisOrder(ActiveControl.Name, Screen.ActiveForm)

instead of using the name property of the ActiveControl, which won't be
right, why not pass the name of the control you wish.

'~~~~~~~~~~~
Call thisOrder("txtPodNumber", Me)
'~~~~~~~~~~~

Maybe use ME instead of Screen.ActiveForm unless you are on a subform and
want to refer to a parent

I would caution against embedding logic into controls, but another thing you
can do is use the TAG property, which is the last property on the Other tab
of the property sheet. It is not used by Access, you can write and read to
it as you wish. This means, you could put the name of the control there and
do this:

'~~~~~~~~~~~
'not recommended
Call thisOrder(ActiveControl.tag, Me)
'~~~~~~~~~~~

It is better to put the logic in the the code behind the form where you can
compile and fix things quicker.

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Fri, 5/27/11, John Viescas wrote:

> Pam-
>
> Don't put the Click event procedure in the label - put it
> in the associated text
> box. If the user clicks the associated label, the
> click event for the text box
> fires!
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: Pamela Zimmerman

> Can anyone one tell me how I can reference a control
> associated with a
> label?
>
>
>
> Given the form has a label called lblPodNumber and a field
> called
> txtPodNumber
>
>
>
> I have this:
>
>
>
> Private Sub lblPodNumber_Click()
>
>
>
> Call thisOrder(ActiveControl.Name, Screen.ActiveForm)
>
>
>
> End Sub
>
>
>
> I need to reference the name of the control that the label
> is associated
> with, not the active control. How can I do that?
>
>
>
> If possible, I would prefer not to use the actual label
> name (lblPodNumber),
> as I would like to keep this as reusable as possible.
>
>
>
>
> Suggestions appreciated!
>
>
>
> Pam
>
>
>

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

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

Yahoo! Groups Links

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

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

Yahoo! Groups Links

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

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

Yahoo! Groups Links

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!

.

__,_._,___