Sabtu, 31 Mei 2014

Re: [MS_AccessPros] performance access very slow in 64 bit

 

Valentino-


The two 64 bit machines should be faster.

You would need to post a copy of your code to see if we can spot any problems that would be slowing it down.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On May 31, 2014, at 4:46 PM, Valentino Avvisati valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello John-
Thank you for the answer
I'm not really an  expert but an "heavy" user of Access that is learning  by doing,  from this group and your books …
I used my laptop (windows 7 32 bit when I built the application ) and windows XP where I run some scheduled process that produce some report
In both where ok,

 

After I moved  the  application to   two machine 64 bit:
One is virtual machine with Intel xeon CPU  E5620 2.40GHZ
Ram 2 GB (effectively not too much)
The other was   a Real machine with windows 7 64 bit intel core I7 3,30 GHz
8 Gb ram,   much more powerful of the machine where I do not have issue that is an
Windows Xp Dell AMD Athlon 64 x dual Core processor 4200+
2,20 GHz 3
3 GB ram

 

Mainly the procedure make d Do loop cycle on a table to take one key code after I use this code to create query using db.CreateQueryDef
The procedure create open and close many time a query
It look like this is very  slow in 64 bit environment it is very slow
It is also true that I did not declare all variable, I'm not an expert and probably I also made some mistake that decrease the performance and use a lot of resources, but up to this moment I did not have any problem and I do not have problem in 32 bit.

 

 

 



2014-05-31 9:02 GMT+02:00 John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>:
 

Valentino-


When you run a 32-bit application on 64-bit Windows, there's extra overhead having to "thunk" all the 32-bit address to actual 64-bit and back, but it shouldn't be that noticeable.  What are the other characteristics of the two machines?  How much memory on each?  How fast is the processor?  Access is particularly sensitive - especially when running complex queries - to the amount of memory available.  In earlier environments (Win 98), you could often double the speed of Access simply by adding more memory.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On May 31, 2014, at 8:28 AM, 'valentino avvisati' valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning,

 

I have built an application in microsoft access 2007 that is doing some elaboration (repetitive query and successive elaboration on data extracted)

The database is divided I two file, (the second file just stock some tables  ad Is located in same directory of main file mainly because , during the elaboration,  the file increase very fast ii dimension)

The procedure run In around 30 minutes in windows xp 32 bit environment and also under windows 7 32 bit. This is ok for me.

the same file moved to windows 8.1  office 2013 (or also windows 7) but 64 bit machine , take so long time that I always stop before end (4-5 time more)

I'm not sure if the problem is really the 32 bit environment or due to the fact that I do not follow all the rules to be efficient, but it look like is appearing only when I move to 64 bit machine

Somebody knows why this occur and possible solution?

 

Thank you to all (really very useful group)

 

Valentino Avvisati

 
 
 
 
 
 





__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)

.

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

Re: [MS_AccessPros] performance access very slow in 64 bit

 

Hello John-

Thank you for the answer

I'm not really an  expert but an "heavy" user of Access that is learning  by doing,  from this group and your books …

I used my laptop (windows 7 32 bit when I built the application ) and windows XP where I run some scheduled process that produce some report

In both where ok,

 

After I moved  the  application to   two machine 64 bit:

One is virtual machine with Intel xeon CPU  E5620 2.40GHZ

Ram 2 GB (effectively not too much)

The other was   a Real machine with windows 7 64 bit intel core I7 3,30 GHz

8 Gb ram,   much more powerful of the machine where I do not have issue that is an

Windows Xp Dell AMD Athlon 64 x dual Core processor 4200+

2,20 GHz 3

3 GB ram

 

Mainly the procedure make d Do loop cycle on a table to take one key code after I use this code to create query using db.CreateQueryDef

The procedure create open and close many time a query

It look like this is very  slow in 64 bit environment it is very slow

It is also true that I did not declare all variable, I'm not an expert and probably I also made some mistake that decrease the performance and use a lot of resources, but up to this moment I did not have any problem and I do not have problem in 32 bit.

 

 

 



2014-05-31 9:02 GMT+02:00 John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>:
 

Valentino-


When you run a 32-bit application on 64-bit Windows, there's extra overhead having to "thunk" all the 32-bit address to actual 64-bit and back, but it shouldn't be that noticeable.  What are the other characteristics of the two machines?  How much memory on each?  How fast is the processor?  Access is particularly sensitive - especially when running complex queries - to the amount of memory available.  In earlier environments (Win 98), you could often double the speed of Access simply by adding more memory.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On May 31, 2014, at 8:28 AM, 'valentino avvisati' valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning,

 

I have built an application in microsoft access 2007 that is doing some elaboration (repetitive query and successive elaboration on data extracted)

The database is divided I two file, (the second file just stock some tables  ad Is located in same directory of main file mainly because , during the elaboration,  the file increase very fast ii dimension)

The procedure run In around 30 minutes in windows xp 32 bit environment and also under windows 7 32 bit. This is ok for me.

the same file moved to windows 8.1  office 2013 (or also windows 7) but 64 bit machine , take so long time that I always stop before end (4-5 time more)

I'm not sure if the problem is really the 32 bit environment or due to the fact that I do not follow all the rules to be efficient, but it look like is appearing only when I move to 64 bit machine

Somebody knows why this occur and possible solution?

 

Thank you to all (really very useful group)

 

Valentino Avvisati

 

 

 

 

 

 



__._,_.___
Posted by: Valentino Avvisati <valentino.avvisati@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)

.

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

Re: [MS_AccessPros] performance access very slow in 64 bit

 

Valentino-


When you run a 32-bit application on 64-bit Windows, there's extra overhead having to "thunk" all the 32-bit address to actual 64-bit and back, but it shouldn't be that noticeable.  What are the other characteristics of the two machines?  How much memory on each?  How fast is the processor?  Access is particularly sensitive - especially when running complex queries - to the amount of memory available.  In earlier environments (Win 98), you could often double the speed of Access simply by adding more memory.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On May 31, 2014, at 8:28 AM, 'valentino avvisati' valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning,

 

I have built an application in microsoft access 2007 that is doing some elaboration (repetitive query and successive elaboration on data extracted)

The database is divided I two file, (the second file just stock some tables  ad Is located in same directory of main file mainly because , during the elaboration,  the file increase very fast ii dimension)

The procedure run In around 30 minutes in windows xp 32 bit environment and also under windows 7 32 bit. This is ok for me.

the same file moved to windows 8.1  office 2013 (or also windows 7) but 64 bit machine , take so long time that I always stop before end (4-5 time more)

I'm not sure if the problem is really the 32 bit environment or due to the fact that I do not follow all the rules to be efficient, but it look like is appearing only when I move to 64 bit machine

Somebody knows why this occur and possible solution?

 

Thank you to all (really very useful group)

 

Valentino Avvisati

 

 

 

 

 

 


__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)

.

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

Jumat, 30 Mei 2014

[MS_AccessPros] performance access very slow in 64 bit

 

Good morning,

 

I have built an application in microsoft access 2007 that is doing some elaboration (repetitive query and successive elaboration on data extracted)

The database is divided I two file, (the second file just stock some tables  ad Is located in same directory of main file mainly because , during the elaboration,  the file increase very fast ii dimension)

The procedure run In around 30 minutes in windows xp 32 bit environment and also under windows 7 32 bit. This is ok for me.

the same file moved to windows 8.1  office 2013 (or also windows 7) but 64 bit machine , take so long time that I always stop before end (4-5 time more)

I’m not sure if the problem is really the 32 bit environment or due to the fact that I do not follow all the rules to be efficient, but it look like is appearing only when I move to 64 bit machine

Somebody knows why this occur and possible solution?

 

Thank you to all (really very useful group)

 

Valentino Avvisati

 

 

 

 

 

 

__._,_.___
Posted by: "valentino avvisati" <valentino.avvisati@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

.

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

Re: [belajar-access] 1 record barang pnya label banyak

 

dedy heru susanto ...,

Bisakah lampiran dikonversi ke Ms Access 2003? Begitu pula kasus Sampeyan sebelumnya (hitung if).

Agar memudahkan saya melakukan simulasi.

Hariyanto (Surabaya)

--------------------------------------------
On Sat, 31/5/14, dedy heru susanto d3dy_h3rus@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: [belajar-access] 1 record barang pnya label banyak
To: belajar-access@yahoogroups.com
Date: Saturday, 31 May, 2014, 5:15 AM


 









Dear para master accessMohon bantuannya agar 1 record
barang bisa dibuatkian label sebanyak jumlah
barang.Terlampir file
contohnya.Terima
kasih










#yiv8229239658 #yiv8229239658 --
#yiv8229239658ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv8229239658 #yiv8229239658ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv8229239658 #yiv8229239658ygrp-mkp #yiv8229239658hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv8229239658 #yiv8229239658ygrp-mkp #yiv8229239658ads {
margin-bottom:10px;}

#yiv8229239658 #yiv8229239658ygrp-mkp .yiv8229239658ad {
padding:0 0;}

#yiv8229239658 #yiv8229239658ygrp-mkp .yiv8229239658ad p {
margin:0;}

#yiv8229239658 #yiv8229239658ygrp-mkp .yiv8229239658ad a {
color:#0000ff;text-decoration:none;}
#yiv8229239658 #yiv8229239658ygrp-sponsor
#yiv8229239658ygrp-lc {
font-family:Arial;}

#yiv8229239658 #yiv8229239658ygrp-sponsor
#yiv8229239658ygrp-lc #yiv8229239658hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv8229239658 #yiv8229239658ygrp-sponsor
#yiv8229239658ygrp-lc .yiv8229239658ad {
margin-bottom:10px;padding:0 0;}

#yiv8229239658 #yiv8229239658actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv8229239658 #yiv8229239658activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv8229239658 #yiv8229239658activity span {
font-weight:700;}

#yiv8229239658 #yiv8229239658activity span:first-child {
text-transform:uppercase;}

#yiv8229239658 #yiv8229239658activity span a {
color:#5085b6;text-decoration:none;}

#yiv8229239658 #yiv8229239658activity span span {
color:#ff7900;}

#yiv8229239658 #yiv8229239658activity span
.yiv8229239658underline {
text-decoration:underline;}

#yiv8229239658 .yiv8229239658attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv8229239658 .yiv8229239658attach div a {
text-decoration:none;}

#yiv8229239658 .yiv8229239658attach img {
border:none;padding-right:5px;}

#yiv8229239658 .yiv8229239658attach label {
display:block;margin-bottom:5px;}

#yiv8229239658 .yiv8229239658attach label a {
text-decoration:none;}

#yiv8229239658 blockquote {
margin:0 0 0 4px;}

#yiv8229239658 .yiv8229239658bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv8229239658 .yiv8229239658bold a {
text-decoration:none;}

#yiv8229239658 dd.yiv8229239658last p a {
font-family:Verdana;font-weight:700;}

#yiv8229239658 dd.yiv8229239658last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv8229239658 dd.yiv8229239658last p
span.yiv8229239658yshortcuts {
margin-right:0;}

#yiv8229239658 div.yiv8229239658attach-table div div a {
text-decoration:none;}

#yiv8229239658 div.yiv8229239658attach-table {
width:400px;}

#yiv8229239658 div.yiv8229239658file-title a, #yiv8229239658
div.yiv8229239658file-title a:active, #yiv8229239658
div.yiv8229239658file-title a:hover, #yiv8229239658
div.yiv8229239658file-title a:visited {
text-decoration:none;}

#yiv8229239658 div.yiv8229239658photo-title a,
#yiv8229239658 div.yiv8229239658photo-title a:active,
#yiv8229239658 div.yiv8229239658photo-title a:hover,
#yiv8229239658 div.yiv8229239658photo-title a:visited {
text-decoration:none;}

#yiv8229239658 div#yiv8229239658ygrp-mlmsg
#yiv8229239658ygrp-msg p a span.yiv8229239658yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv8229239658 .yiv8229239658green {
color:#628c2a;}

#yiv8229239658 .yiv8229239658MsoNormal {
margin:0 0 0 0;}

#yiv8229239658 o {
font-size:0;}

#yiv8229239658 #yiv8229239658photos div {
float:left;width:72px;}

#yiv8229239658 #yiv8229239658photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv8229239658 #yiv8229239658photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv8229239658 #yiv8229239658reco-category {
font-size:77%;}

#yiv8229239658 #yiv8229239658reco-desc {
font-size:77%;}

#yiv8229239658 .yiv8229239658replbq {
margin:4px;}

#yiv8229239658 #yiv8229239658ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv8229239658 #yiv8229239658ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv8229239658 #yiv8229239658ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv8229239658 #yiv8229239658ygrp-mlmsg select,
#yiv8229239658 input, #yiv8229239658 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv8229239658 #yiv8229239658ygrp-mlmsg pre, #yiv8229239658
code {
font:115% monospace;}

#yiv8229239658 #yiv8229239658ygrp-mlmsg * {
line-height:1.22em;}

#yiv8229239658 #yiv8229239658ygrp-mlmsg #yiv8229239658logo {
padding-bottom:10px;}


#yiv8229239658 #yiv8229239658ygrp-msg p a {
font-family:Verdana;}

#yiv8229239658 #yiv8229239658ygrp-msg
p#yiv8229239658attach-count span {
color:#1E66AE;font-weight:700;}

#yiv8229239658 #yiv8229239658ygrp-reco
#yiv8229239658reco-head {
color:#ff7900;font-weight:700;}

#yiv8229239658 #yiv8229239658ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv8229239658 #yiv8229239658ygrp-sponsor #yiv8229239658ov
li a {
font-size:130%;text-decoration:none;}

#yiv8229239658 #yiv8229239658ygrp-sponsor #yiv8229239658ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv8229239658 #yiv8229239658ygrp-sponsor #yiv8229239658ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv8229239658 #yiv8229239658ygrp-text {
font-family:Georgia;}

#yiv8229239658 #yiv8229239658ygrp-text p {
margin:0 0 1em 0;}

#yiv8229239658 #yiv8229239658ygrp-text tt {
font-size:120%;}

#yiv8229239658 #yiv8229239658ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv8229239658

__._,_.___
Posted by: hari yanto <har_i20002000@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
SPAM IS PROHIBITED

.

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

Re: [belajar-access] saldo awal

 

Asumsi awal, saldo awal adalah 0. Barang masuk pertama, adalah saldo awal. Bila kita memilih tanggal tertentu, saldo awalnya berdasarkan hitungan tanggal-tanggal sebelumnya.

Tidak ditetapkan pada 1 field, karena merupakan hasil dari entryan.

Hariyanto (Surabaya)

--------------------------------------------
On Fri, 30/5/14, irawan irawan@adisatria.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: Re: [belajar-access] saldo awal
To: belajar-access@yahoogroups.com
Date: Friday, 30 May, 2014, 3:32 PM

Terima kasih pak Hariyanto,



Kalau field saldo awal bagaimana? dibikin trx masuk brg atau
bagaimana?



thx

irawan



On 5/30/14, hari yanto har_i20002000@yahoo.com
[belajar-access]

<belajar-access@yahoogroups.com> wrote:

> irawan irawan...,

>

>

> Coba lihat di link ini:

>

>

>
https://groups.yahoo.com/neo/groups/belajar-access/conversations/messages/38394

>

>

>

>

> Hariyanto (Surabaya)

>

>

> -----------------------------------------

> On Fri, 30/5/14, irawan irawan@adisatria.com
[belajar-access]

> <belajar-access@yahoogroups.com> wrote:

>

>

> Subject: [belajar-access] saldo awal

> To: belajar-access@yahoogroups.com

> Date: Friday, 30 May, 2014, 9:20 AM

>

> Selamat pagi semuanya,

>

>

>

> Bagaimana perlakuan saldo awal pada persediaan
barang,

>

> Field saldo awal (jumlah maupun Rp ) diletakkan di
table

> master barang

>

> atau di table tersendiri. Sehingga kita bisa memindah
saldo

> awal

>


> setiap akhir periode.

>

>

>

> terima kasih

>

> irawan

>

>

>

>



__._,_.___
Posted by: hari yanto <har_i20002000@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
SPAM IS PROHIBITED

.

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

RE: [MS_AccessPros] How do I write a public procedure that 2 different forms can call.

 

Good morning Mr. Mandeno

I first would like to say thank you. It's been quite long since… I finally have got a chance to get back to play with the Public Function that you were helping me with.

 

Now I've got the function working pretty good and it can be called from different forms. However, I am not sure if my code is efficient enough or the statements (such as MoveFirst, MoveLast, check for EOF, Requery, Goto …) is redundant or unnecessary.  I've also tried to create a Sub (resides in the main form) which deletes records in the sub form. However that created a Run-time error '3265' Item not found in this collection.  What part of my code caused that error? Below is my code.

Thank again Mr. Mandeno

Phucon


'Delete record in the main form, this sub's working OK

Private Sub cmdDelOrder_Click()

Call FindFormRecord(Me, "pkeyOrderID", Me.txtOrderID) 'passing Number data type

End Sub

 

'Delete record in the sub form, this created 'error 3265 item not found in this collection'

Private Sub cmdDelProduct_Click()

Call FindFormRecord(Me, "fkeyProductID", Me!subSubTotal.Form!cboProductID)

End Sub

 

Public Function FindFormRecord(

    SearchForm As Access.Form, _

    SearchField As String, _

    SearchValue As Variant, _

    Optional NoMatchMessage As String = "Record not found" _

    ) As Boolean

   

On Error GoTo ErrorHandler

 

With SearchForm.RecordsetClone

    Select Case .Fields(SearchField).Type

        Case dbText

             SearchValue = Chr$(34) & SearchValue & Chr$(34)

        Case dbLong

             SearchValue = SearchValue

    End Select

   

    .MoveFirst

    .MoveLast

   

  If Not .EOF Then

         .FindFirst "[" & SearchField & "] = " & SearchValue

            If Not .NoMatch Then    'if found then delete the record.

                If MsgBox("Deleting " & SearchValue & ".  Proceed to delete?", vbInformation + vbYesNo, "Delete record.") = vbYes Then

                    .Delete

                    .Requery

                End If

            Else

                MsgBox NoMatchMessage

                GoTo ExitcboFindSetup

            End If

    Else

        GoTo ExitcboFindSetup

    End If

End With

   

ExitcboFindSetup:

    Exit Function

   

ErrorHandler:

        MsgBox Err.Number & vbCrLf & Err.Description

        Resume ExitcboFindSetup

End Function

 

__._,_.___
Posted by: saigonf7q5@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)

.

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

Re: [MS_AccessPros] Re: Separating names like Mary/John OOOPS

 

you can build a single function and use it in an update query. Untested

Public Function getName(varName as variant, WhichName as integer) as variant
   dim strNames() as string 
   on error resume Next
   if not isnull(varName)
      if WhichName = 1 or WhichName = 2 then
          WhichName = WhichName - 1
          getName = split(cstr(varName),"/")(WhichName)
      end if
   end if
end function


On Fri, May 30, 2014 at 5:37 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
 


The original field is "Mary/John Smith".

I have extracted the last name already.

Sorry!

Robin

At 31/05/2014 07:33 AM, you wrote:

 

Thanks Bill,

I need Mary/John to be in separate fields please.

Regards,

Robin

At 31/05/2014 06:52 AM, you wrote:
 

Robin
Two fields or two records?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

 


__._,_.___
Posted by: Peter Poppe <plpoppe@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)

.

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

Re: [MS_AccessPros] Re: List of Attachements

 

Well I think you are done.  However, not certain all those fields are needed. Some were examples from some of the other approaches.  I would think you only need (ID or AttachmentID). I assume that is an autonumber.  I think the Vendor number is the foreign key to the related parent table so you need either one of those. So lets assume that you are using Vendor_FK.  Then your form would have an attachment subform linked by the Vendor ID in the parent table to the Vendor_FK in the subform.  Should be the exact same thing you use in your subreport to show your list.  There was some code to take your existing attachments and move them out of the database and populate the table with the related information.


On Fri, May 30, 2014 at 5:43 PM, ka0t1c_ang3l <no_reply@yahoogroups.com> wrote:
 

These are the fields I have in my table:

 

ID

AttachmentID

AttachmentName

AttachmentTimeStamp

Parent_FK

Vendor_FK

 

The hyperlink field is the AttachmentName Field.  In the subform I am manually entering the name of the document, and then I right click to edit the hyperlink and add in the location of the document.


__._,_.___
Posted by: Peter Poppe <plpoppe@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (27)

.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)