Senin, 30 April 2012

Re: [belajar-access] membuat tampilan surat dengan report access

 

Silahkan masuk ke mode design reportnya, lalu klik field "divisi"nya. Pada properties "Can Grow" set menjadi = Yes, dan pada properties "Can Shrink" set menjadi = Yes.
 
Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com/
----- Original Message -----
From: prisca
Sent: Tuesday, May 01, 2012 12:49 PM
Subject: [belajar-access] membuat tampilan surat dengan report access

dear all..
mohon petunjuk, saya mau membuat laporan dengan format surat. mohon petunjuk untuk mensiasati hal berikut:

Kepada Yth.
divisi umum bagian pemetaan
wilayah IV dept. blablabla

jl. abcde fghijkl mnop qr
stuv wxyz

di tempat

nah bagaimana mengatur tampilan divisi dan alamat agar bila nama divisi atau alamat kepanjangan, tampilannya tidak terpotong. atau saat nama divisi atau alamat kependekan, tampilannya tidak menyebabkan spasi.

contoh:
kepanjangan

Kepada Yth.
divisi umum bagian pemetaan
wilayah IV dept. bidang
                               <----- masih ada lanjutannya
jl. abcde fghijkl mnop qr
stuv wxyz

di tempat

seharusnya

Kepada Yth.
divisi umum bagian pemetaan
wilayah IV dept. bidang

kewirausahaan                                                  <----- lanjutannya tidak tampak krn lebar text box tidak mencukupi
jl. abcde fghijkl mnop qr
stuv wxyz

di tempat


kependekan

Kepada Yth.
divisi umum bagian pemetaan
                                                                                       <----- alamatnya lebih pendek jadi hasil tampilannya kya gini
jl. abcde fghijkl mnop qr
stuv wxyz

di tempat

apa ada cara supaya saat kepanjangan otomatis text box yang dibawahnya menyesuaikan (naik mepet ke atas) dan sebaliknya bila kepanjangan, text box d bawahnya otomatis turun..

trims

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

__,_._,___

[belajar-access] membuat tampilan surat dengan report access

 

dear all..
mohon petunjuk, saya mau membuat laporan dengan format surat. mohon petunjuk untuk mensiasati hal berikut:

Kepada Yth.
divisi umum bagian pemetaan
wilayah IV dept. blablabla

jl. abcde fghijkl mnop qr
stuv wxyz

di tempat

nah bagaimana mengatur tampilan divisi dan alamat agar bila nama divisi atau alamat kepanjangan, tampilannya tidak terpotong. atau saat nama divisi atau alamat kependekan, tampilannya tidak menyebabkan spasi.

contoh:
kepanjangan

Kepada Yth.
divisi umum bagian pemetaan
wilayah IV dept. bidang
                               <----- masih ada lanjutannya
jl. abcde fghijkl mnop qr
stuv wxyz

di tempat

seharusnya

Kepada Yth.
divisi umum bagian pemetaan
wilayah IV dept. bidang

kewirausahaan                                                  <----- lanjutannya tidak tampak krn lebar text box tidak mencukupi
jl. abcde fghijkl mnop qr
stuv wxyz

di tempat


kependekan

Kepada Yth.
divisi umum bagian pemetaan
                                                                                       <----- alamatnya lebih pendek jadi hasil tampilannya kya gini
jl. abcde fghijkl mnop qr
stuv wxyz

di tempat

apa ada cara supaya saat kepanjangan otomatis text box yang dibawahnya menyesuaikan (naik mepet ke atas) dan sebaliknya bila kepanjangan, text box d bawahnya otomatis turun..

trims

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

__,_._,___

Bls: [belajar-access] Trigger Insert Data Ke Tabel Setiap Akhir Bulan

 

terima kasih banyak pak Sofyan Efendi

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,

Dari: Sofyan Efendi <sofyanefendi@gmail.com>
Kepada: belajar-access@yahoogroups.com
Dikirim: Jumat, 27 April 2012 16:20
Judul: Re: [belajar-access] Trigger Insert Data Ke Tabel Setiap Akhir Bulan

 

Masya Allah, terlewat karena kasus ADP :))
Untuk mencari tgl akhir setiap bulan, rumusnya: DateSerial(Year(DateField), Month(DateField) + 1, 0)
Untuk insert data dari table A ke table B, bisa menggunakan query append.
Untuk mengetahui apakah hari ini sudah akhir bulan atau tidak, bisa menggunakan fungsi IF.
Sehingga, untuk trigger:
 
If date()=DateSerial(Year(Date()), Month(Date()) + 1, 0) then
    'lakukan proses append query disini
    ...
end if
Nah, sekarang tinggal disesuaikan dengan table dan kondisi di file Accessnya Mas Galih.
 
Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com/
----- Original Message -----
Sent: Thursday, April 26, 2012 10:44 PM
Subject: [belajar-access] Trigger Insert Data Ke Tabel Setiap Akhir Bulan

Mohon informasi untuk trigger yang berfungsi untuk meng insert data dari tabel A ke tabel B setian akhir bulan.
Terima kasih atas pencerahannya


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

__,_._,___

Re: [MS_AccessPros] Re: Network Drive with password

 


Hi In,

Thank you..

Will try the code.

Regards,

Fathan Haras

-----Original Message-----
From: "acravenrohm" <yahoo@craven.de>
Sender: MS_Access_Professionals@yahoogroups.com
Date: Mon, 30 Apr 2012 20:19:22
To: <MS_Access_Professionals@yahoogroups.com>
Reply-To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Network Drive with password

That's a wide open question Fathan,

one part of an answer could be to use the code in:

http://www.vbforums.com/showthread.php?p=1411899

which will allow you to logon to a server through vb(a) code. Then, depending on whether you want to map a drive or just access through a UNC Path, you may need some more calls to map a drive letter.

(I actually don't use this anymore so the security gnomes at Microsoft may have changed things so that a real user has to enter a password nowadays.)

--- In MS_Access_Professionals@yahoogroups.com, "Fathan" <fathan02@...> wrote:
>
>
> Dear all,
>
> Can we open network drive with password thru vb code instead of go to window explorer and type the password ?
>
> Thank you in advance for your guidance.
>
> Regards,
> Fathan
> Fathan Haras
>



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

__._,_.___
Recent Activity:
.

__,_._,___

Re: [MS_AccessPros] Re: Network Drive with password

 


//sorry, resent due incomplete msg//

Hi Bill,

Thank you..

I have vba code in my excel (in my computer) to
make connection with access file in network drive in LAN of my office.

It used to work until our IT guys set up a password to the map drive.

Now, I need to open the network drive using window explorer (one time only) before running the vbcode with my excel file.

Regards



Fathan Haras

-----Original Message-----
From: "Bill Mosca" <wrmosca@comcast.net>
Sender: MS_Access_Professionals@yahoogroups.com
Date: Mon, 30 Apr 2012 16:17:51
To: <MS_Access_Professionals@yahoogroups.com>
Reply-To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Network Drive with password

Fathan

I'm not sure if there is a way or not. But I can look into it as time permits.

Can you tell us a little more about what you need to accomplish?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca



--- In MS_Access_Professionals@yahoogroups.com, "Fathan" <fathan02@...> wrote:
>
>
> Dear all,
>
> Can we open network drive with password thru vb code instead of go to window explorer and type the password ?
>
> Thank you in advance for your guidance.
>
> Regards,
> Fathan
> Fathan Haras
>




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

__._,_.___
Recent Activity:
.

__,_._,___

Re: [MS_AccessPros] Re: Network Drive with password

 


Hi Bill,

Thank you..

I have vba code in my excel (in my computer) to
make connection with access file in network drive in LAN of my office.

It used to work until our IT guys set up a password to the map drive.




Fathan Haras

-----Original Message-----
From: "Bill Mosca" <wrmosca@comcast.net>
Sender: MS_Access_Professionals@yahoogroups.com
Date: Mon, 30 Apr 2012 16:17:51
To: <MS_Access_Professionals@yahoogroups.com>
Reply-To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Network Drive with password

Fathan

I'm not sure if there is a way or not. But I can look into it as time permits.

Can you tell us a little more about what you need to accomplish?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca



--- In MS_Access_Professionals@yahoogroups.com, "Fathan" <fathan02@...> wrote:
>
>
> Dear all,
>
> Can we open network drive with password thru vb code instead of go to window explorer and type the password ?
>
> Thank you in advance for your guidance.
>
> Regards,
> Fathan
> Fathan Haras
>




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

__._,_.___
Recent Activity:
.

__,_._,___

RE: [MS_AccessPros] table design

 

Elizabeth-

Those fields look fine as part of the Client 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)

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

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
Sent: Monday, April 30, 2012 10:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] table design

 
How would you design for all the other fields besides dates? Fields that have to
do with the client, like:

Active (y/n)
Years of service (number)
assets ($)
preparer (text)

They have lots of data like this with all different data types. They use these
fields sometimes as report filters, sometimes as report columns along with the
dates as columns, and sometimes they just want a field like preparer on a report
just to reference in the header (so you'd have client name and preparer in the
header and the dates as the columns)
Thanks.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Elizabeth-
>
> Better to properly normalize the design. Putting a string of date fields in
the
> Client table would violate first normal form (repeating groups).
>
> 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)
>
> -----------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Monday, April 30, 2012 9:14 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] table design
>
>  
> Yes, my question is on the attributes. Is it better to have a narrow table of
> client_id and client name with one to one relationships by client_id to many
> subject-matter attribute tables? Or is it better to have one wide attribute
> table? thanks
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Elizabeth-
> >
> > So the related table is Client? That should give you a 1-M relationship to
> this
> > table as long as you include ClientID. Each client will have multiple events
> > consisting of an EventID and the date the event occurred.
> >
> > 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)
> >
> > ---------------------------------
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> > Sent: Monday, April 30, 2012 8:45 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] table design
> >
> >  
> > The dates are when forms are sent to clients and received back from clients.
I
> > was going to have them in one table
> > ID
> > Event_ID (key to the event description, i.e. Form "A" Sent Date)
> > Date
> >
> > The attributes are about the client. Do you need more info? Thanks for your
> > help.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> > >
> > > Elizabeth-
> > >
> > > Need more info. What are these "dates" related to? Why aren't they in
their
> > > related table(s)? One-one joins are a pain the patootie.
> > >
> > > 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)
> > >
> > > -----------------------------
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> > > Sent: Monday, April 30, 2012 5:36 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] table design
> > >
> > >  
> > > Hi there-
> > >
> > > I have many, many attributes and a factless fact table (dates of events).
My
> > > first thought is that I'd like to put the attributes in separate tables by
> > > subject matter and have one to one joins. But then I thought I better ask
> you
> > > all if you thought Access would run faster if the attributes were in one
> wide
> > > table.
> > >
> > > Thanks,
> > > Elizabeth
> > >
> >
>

__._,_.___
.

__,_._,___

RE: [MS_AccessPros] BeforeUpdate in subform cancels update when Close button on main form is clicked

 

Connie-

If you want to kill the close, you need some more code:

Option Compare Database
Option Explicit
Dim intCancel As Integer

Private Sub Form_Close(Cancel As Integer)
' If Before Update has canceled,
If intCancel Then
' Cancel the close
Cancel = True
End If
End Sub

Private Sub Form_AfterUpdate()
' Make sure intCancel if off
intCancel = False
End Sub

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim db As DAO.Database, rstP As DAO.Recordset

'Prevent double entries for Me.Ordr = 1
If Me.Ordr = 1 Then
' Point to this database
Set db = CurrentDb
'Open ListingContacts to find priorities for this listing that are the same as
Me.Priority
Set rstP = db.OpenRecordset("SELECT * FROM SalesBuyers " & _
"WHERE SaleID = " & Me.SaleID & " And Ordr = " & Me.Ordr)
If rstP.RecordCount > 0 Then
Msgbox "Another contact has this order." _
& vbNewLine & "Change the other contact's order and then enter this contact"
' Cancel the update
Cancel = True
' Set cancel in progress in case form is trying to close
intCancel = True
End If
End If
'Clean Up
rstP.Close
Set rstP = Nothing
Set db = Nothing
End Sub

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)

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

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Monday, April 30, 2012 10:01 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] BeforeUpdate in subform cancels update when Close
button on main form is clicked

 
Good afternoon or evening :-),

If the user is in the middle of entering data on a subform and decides to close
the form using the Close button on the main form, the BeforeUpdate event of the
subform gives the message that the something needs to be changed and cancels the
update, but the DoCmd.Close continues so the form is closed with no opportunity
to change the data.

Don't think you need it but here's the code behind the BeforeUpdate event.

'Prevent double entries for Me.Ordr = 1
If Me.Ordr = 1 Then
' Point to this database
Set db = CurrentDb
'Open ListingContacts to find priorities for this listing that are the same as
Me.Priority
Set rstP = db.OpenRecordset("SELECT * FROM SalesBuyers " & _
"WHERE SaleID = " & Me.SaleID & " And Ordr = " & Me.Ordr)
If rstP.RecordCount > 0 Then
Msgbox "Another contact has this order." _
& vbNewLine & "Change the other contact's order and then enter this contact"
Me.Undo
End If
End If
'Clean Up
rstP.Close
Set rstP = Nothing
Set db = Nothing

Thanks!
Connie

__._,_.___
.

__,_._,___

Re: [MS_AccessPros] Slow combo box find as you type

 

Connie

No judging allowed here. You're safe to voice any and all thoughts about databases.

I would not have a combined Street-City. It's too simple to concatenate the fields in whatever forms/reports you need. I do that all the time with First and Last names. In fact, I usually have a standard view (query) of fields I use all the time. It combines items like First and Last, Doctor, nurse, social worker, site, etc.

Then I use that as a table in a bazillion places.

But still, you are over-thinking your address data. 123 Main Street in Mytown, Mystate, Myzip is going to have only one location. Breaking it all out into separate tables defies logic and hurts performance. A search on 500 records should take a fraction of a second.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> John and Bill,
>
> I'm wondering if I should commit the ultimate No no...Would it work to create a field in the HomeInfo table (or a separate table) that was the combined street or streetCity and index that? And anytime the data is updated force an update of that field? As you would guess that info is used in MANY places.
>
> Hoping you are not going to excommunicate me :-)
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Connie-
> >
> > Because you're using an expression to generate the display field in the combo
> > box, an index won't help at all. You could make the query slightly more
> > efficient by putting an index on Nbr, Direction, Street, Direction2, and City
> > and then do an ORDER BY on those fields rather than the expression.
> >
> > 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)
> >
> > --------------------------------
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > Sent: Monday, April 30, 2012 9:36 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] Slow combo box find as you type
> >
> >  
> > John,
> >
> > There are currently 502 rows in the HomeInfo table. If I create an index based
> > upon 5 fields, will the query use it automatically?
> >
> > Oh--here's the query SQL for qAddressCity:
> > SELECT HomeInfo.HomeInfoID, IIf(IsNull([HomeInfo].[Nbr]),"",[HomeInfo].[Nbr] & "
> > ") & ([HomeInfo].[Direction1]+" ") & ([Street_List].[Street]+" ") &
> > ([HomeInfo].[Direction2]+" ") & [City_List].[City] AS AddressCity,
> > HomeInfo.TownshipID, HomeInfo.CityID, HomeInfo.ParcelNbr
> > FROM Street_List RIGHT JOIN (HomeInfo LEFT JOIN City_List ON HomeInfo.CityID =
> > City_List.CityID) ON Street_List.StreetID = HomeInfo.StreetID
> > ORDER BY IIf(IsNull([HomeInfo].[Nbr]),"",[HomeInfo].[Nbr] & " ") &
> > ([HomeInfo].[Direction1]+" ") & ([Street_List].[Street]+" ") &
> > ([HomeInfo].[Direction2]+" ") & [City_List].[City];
> >
> > Connie
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> > >
> > > Connie-
> > >
> > > How many rows in the underlying table? Do you have an index defined on
> > > AddressCity? That would 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)
> > >
> > > ---------------------------
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > > Sent: Monday, April 30, 2012 8:18 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Slow combo box find as you type
> > >
> > >  
> > > Hi all!
> > >
> > > I have a form Listings where the first thing to be entered is the address via
> > a
> > > combobox whose row source is a query that draws data from the HomeInfo table.
> > My
> > > problem is that entry is increasingly slower. I type in 2 or 3 characters and
> > > then have to wait before I can type any other characters. An example would be
> > > typing in 55738 210th St Alberta and after 55738 it stops. Access says it is
> > > calculating, then says it's doing a query. Have to wait several seconds before
> > I
> > > can continue entering. I have tried entering the above several times and
> > > sometimes there's no problem and other times there is.
> > >
> > > ControlSource: HomeInfoID
> > >
> > > RowSource: SELECT qAddressCity.HomeInfoID, qAddressCity.AddressCity,
> > > qAddressCity.ParcelNbr FROM qAddressCity ORDER BY qAddressCity.AddressCity;
> > >
> > > On Not In List Event:
> > >
> > > 'If this property has not been entered yet, open the form for entering. (Not
> > > using properties feature for this because I can not click on the close button
> > on
> > > the form.)
> > > Dim msg, style, title
> > > msg = "This property is not in the database. Would you like to add it?"
> > > style = vbYesNo
> > > title = "Add Property"
> > > Response = Msgbox(msg, style, title)
> > > If Response = vbYes Then
> > > DoCmd.OpenForm "HomeInfo", , , , acFormAdd
> > > End If
> > >
> > > I also have a BeforeUpdate and AfterUpdate event, but those are not being
> > > triggered since I'm just typing and not tabbing or pressing Enter.
> > >
> > > HomeInfo table fields:
> > > HomeInfoID
> > > Nbr
> > > Direction1
> > > StreetID
> > > Direction2
> > > CityID
> > > TownshipID
> > > CountyID
> > > Notes
> > >
> > > Thanks!
> > > Connie
> > >
> >
>

__._,_.___
.

__,_._,___

Re: [MS_AccessPros] table design

 

How would you design for all the other fields besides dates? Fields that have to do with the client, like:

Active (y/n)
Years of service (number)
assets ($)
preparer (text)

They have lots of data like this with all different data types. They use these fields sometimes as report filters, sometimes as report columns along with the dates as columns, and sometimes they just want a field like preparer on a report just to reference in the header (so you'd have client name and preparer in the header and the dates as the columns)
Thanks.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Elizabeth-
>
> Better to properly normalize the design. Putting a string of date fields in the
> Client table would violate first normal form (repeating groups).
>
> 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)
>
> -----------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Monday, April 30, 2012 9:14 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] table design
>
>  
> Yes, my question is on the attributes. Is it better to have a narrow table of
> client_id and client name with one to one relationships by client_id to many
> subject-matter attribute tables? Or is it better to have one wide attribute
> table? thanks
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Elizabeth-
> >
> > So the related table is Client? That should give you a 1-M relationship to
> this
> > table as long as you include ClientID. Each client will have multiple events
> > consisting of an EventID and the date the event occurred.
> >
> > 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)
> >
> > ---------------------------------
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> > Sent: Monday, April 30, 2012 8:45 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] table design
> >
> >  
> > The dates are when forms are sent to clients and received back from clients. I
> > was going to have them in one table
> > ID
> > Event_ID (key to the event description, i.e. Form "A" Sent Date)
> > Date
> >
> > The attributes are about the client. Do you need more info? Thanks for your
> > help.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> > >
> > > Elizabeth-
> > >
> > > Need more info. What are these "dates" related to? Why aren't they in their
> > > related table(s)? One-one joins are a pain the patootie.
> > >
> > > 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)
> > >
> > > -----------------------------
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> > > Sent: Monday, April 30, 2012 5:36 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] table design
> > >
> > >  
> > > Hi there-
> > >
> > > I have many, many attributes and a factless fact table (dates of events). My
> > > first thought is that I'd like to put the attributes in separate tables by
> > > subject matter and have one to one joins. But then I thought I better ask
> you
> > > all if you thought Access would run faster if the attributes were in one
> wide
> > > table.
> > >
> > > Thanks,
> > > Elizabeth
> > >
> >
>

__._,_.___
.

__,_._,___

[MS_AccessPros] Re: Network Drive with password

 

That's a wide open question Fathan,

one part of an answer could be to use the code in:

http://www.vbforums.com/showthread.php?p=1411899

which will allow you to logon to a server through vb(a) code. Then, depending on whether you want to map a drive or just access through a UNC Path, you may need some more calls to map a drive letter.

(I actually don't use this anymore so the security gnomes at Microsoft may have changed things so that a real user has to enter a password nowadays.)

--- In MS_Access_Professionals@yahoogroups.com, "Fathan" <fathan02@...> wrote:
>
>
> Dear all,
>
> Can we open network drive with password thru vb code instead of go to window explorer and type the password ?
>
> Thank you in advance for your guidance.
>
> Regards,
> Fathan
> Fathan Haras
>

__._,_.___
.

__,_._,___