ACCESS FEED

Jumat, 30 Mei 2014

[belajar-access] 1 record barang pnya label banyak

Dear para master access

Mohon bantuannya agar 1 record barang bisa dibuatkian label sebanyak jumlah barang.

Terlampir file contohnya.

Terima kasih

__._,_.___

Posted by: dedy heru susanto <d3dy_h3rus@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

SPAM IS PROHIBITED

Visit Your Group

New Members 3

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Re: List of Attachements

These are the fields I have in my table:

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.

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (26)

Visit Your Group

New Members 3
New Links 1

• Privacy • Unsubscribe • Terms of Use

__,_._,___

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

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: Robin Chapple <robinski@westnet.com.au>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group

New Members 3
New Links 1

• Privacy • Unsubscribe • Terms of Use

__,_._,___

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

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: Robin Chapple <robinski@westnet.com.au>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

New Members 3
New Links 1

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] Separating names like Mary/John

Robin,

Is this for permanent or on the fly calculation? Does every record have two names with a "/" between them? Are there any spaces to worry about?

What have you tried? There are lots of string functions that can help.

Instr() can be used to find the position of the "/"
Left() returns a specific number of characters beginning a string
Mid() returns a specific number of characters beginning at a location

Duane Hookom MVP
MS Access

> From: Robin Chapple

>
> I run Access 2013 on a Win7 system
>
> I have inherited a database with first names recorded as Mary/John in
> one field.
>
> How do I separate them into two fields?
>
> Many thanks,
>
> Robin Chapple

__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

New Members 3
New Links 1

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Re: List of Attachements

Not sure how you set up the table, but it would be in a subreport. Since each vendor can have many attachments. If you added it to the query then you would end up with a "duplicate" vendor record for each attachment. Are you using the hyperlink field? If so you will probably have to do some string manipulation in a query to return just the file name from the long url path. Can you describe what fields you have in your table, and if possible post an example of what is in the hyperlink field. Maybe the easiest answer would be when you add the hyperlink you change the display text to just the file name manually. The hyperlink has 4 parts displaytext#address#subaddress#screentip. If your displaytext is just the filename then you should be able to pull that out. I will have to test.

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

Thanks for your help!! I now have a subform with the attachments, and the users are able to open the documents!!

I want to list the attachments on my compliance report, how would I do that? Is it as simple as adding the attachmentname to the compliance query? Each vendor has a compliance report, so the report would have to list the attachments associated with that vendor.

Thanks!