Rabu, 01 Januari 2014

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (82)
Recent Activity:
SPAM IS PROHIBITED
.

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

[MS_AccessPros] SQL backend and Access Front end

 

Hello all,

I have a question about front ends and backends.

I tried a couple of months ago this scenario.

I have sql express on my work desktop. I tried to open the sql file on my work laptop and it did not recognize the file in sql express. I was wondering if there was a way to make this file portable so that I can create a front end and keep it on a usb drive to the sql file on the usb drive? I have a personal task database that I would like to learn to use sql as the back end and access as the front end.

Thank You

Jim Wagner


Sent from Yahoo! Mail for Windows 8

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

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

RE: [MS_AccessPros] help with a trimming a string

 

Jim,

Can't you create a new thread by just sending an email to <MS_Access_Professionals@yahoogroups.com>?

I never post from the group web page however I don't recall ever starting a new thread.

Duane Hookom MVP
MS Access
________________________________
> From: luvmymelody@yahoo.com
>
> Is anyone else having issues with starting a new topic? I click the
> button until it is not fun anymore.
>
> Jim Wagner

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
Recent Activity:
.

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

RE: [MS_AccessPros] RE: Issue with closing form

 

Rod,

As John suggested, please include content from previous messages in the thread so we don't have to go back to the group on the web to search for the history of your question. 

Is this particular case it doesn't make a lot of difference since you John seems to have helped you find the answer.

Make it a New Year's Resolution to always include enough content from previous messages to support the current question ;-)

Duane Hookom MVP
MS Access

________________________________
> From: desertscroller@cox.net
>
> John, I went back through the code. There are no events in LOAD or
> OPEN in the DuplicateRecords form, also none in SysMaint form. No
> CLOSE or UNLOAD events in either one at least I thought. After review
> the DuplicateRecords form, I realize I had made it a form with a
> subform. The subform was the issue, I had a CLOSE event located in
> it. After removing removing the CLOSE event everything is working
> great. I greatly appreciate your help.
> HAVE A HAPPY NEW YEAR
> Rod

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
.

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

Re: [MS_AccessPros] help with a trimming a string

 

Is anyone else having issues with starting a new topic? I click the button until it is not fun anymore.

Jim Wagner


Sent from Yahoo! Mail for Windows 8

From: Thomas Ewaldtewald@yahoo.com>
Sent: ‎Sun, ‎Dec‎ ‎29‎, ‎2013 at ‎7‎:‎06‎ ‎AM
To: MS_Access_Professionals@yahoogroups.com MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] help with a trimming a string

I'll use a string variable of strPath, and an integer variable of intSlash. You can do without the latter by combining the last two formulas, but it's easier to understand when you use the integer.

You can start with:

If right(strPath,1) = "\" then strPath = left(strPath,len(strPath)-1)

If you know for sure that the last character is a backslash, then you can just use:

strPath = left(strPath,len(strPath)-1)

So now, from your example, you have: "C:\mainpath\subfolder\subfolder"

Now that you know the last character is not a backslash, you want to find the last backslash that remains:

intSlash = InStrRev(strPath, "\")

InString (InStr) finds the first instance of a substring ("\" in this case) within a string (the variable strPath in this case). We're using InStrRev, which reverses the process in a sense, finding the first instance starting from the end of the string, not the beginning.

The variable intSlash now contains the location of the final backslash (position 22 in your example). Just delete what comesafter it:

strPath = left(strPath, intSlash)

I hope this is all clear. This will work in Accessor Excel, BTW. Feel free to ask any questions.

Tom Ewald
Detroit Area

From: "glcass58@yahoo.com"
To: MS_Access_Professionals@yahoogroups.com
Sent: Saturday, December 28, 2013 4:46 PM
Subject: [MS_AccessPros] help with a trimming a string

Hi all,
This is probably a simple question but I just can't seem to figure it out! In my recordset I have a field that is a folder path. I need to take the folder path and trim off the last folder level. So I want to take this:
"C:\mainpath\subfolder\subfolder\"
and trim it to:
"C:\mainpath\subfolder\"
The number of subfolders and subfolder names will vary with each record.
Thanks in advance for your help!!!


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
Recent Activity:
.

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

[MS_AccessPros] RE: Issue with closing form

 

John, I went back through the code.  There are no events in LOAD or OPEN in the DuplicateRecords form, also none in SysMaint form.  No CLOSE or UNLOAD events in either one at least I thought. After review the DuplicateRecords form, I realize I had made it a form with a subform.  The subform was the issue, I had a CLOSE event located in it.  After removing removing the CLOSE event everything is working great.  I greatly appreciate your help.
HAVE A HAPPY NEW YEAR
Rod

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
Recent Activity:
.

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

Re: [MS_AccessPros] Issue with closing form

 

Rod-


I should have asked:

Do you have any code in the Open or Load events of frmDuplicateLicense.  Also, is there any code in the Close or Unload events of either form?

There should be no timing problem.  You asked for frmDuplicateLicense to be opened before this code finished (even though you have already started a close of the current form), so it should stay open unless something else is closing it or causing it to error out.

Please include the entire thread in your reply.  I had to go hunting on the website to refresh my memory about your original question and my response.

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 Dec 31, 2013, at 3:45 PM, desertscroller@cox.net wrote:

Good Morning John,  I tried the command with the same results.  It appears to be a timing issue.  When I set a break point and step through the commands one at a time everything works fine.  I have tried changing the order of the two form commands with the same results.  Stepping through the code works but real time both forms close.

There is no code in the LOAD or OPEN events of SySMaint.  SysMaint consist of multiple command buttons to initiate different forms to allow for configuring Combo Box list used throughout the total application.  The one associated with Duplicate Record View contains the following:

Dim rptFilter As Variant
On Error GoTo DuplicateRecordsErrorHandler
  rptFilter = ""
  'rptFilter = "(lngUserID = " & GetLoggedUser() & ")"
  DoCmd.Close acForm, "frmSysMaint", acSaveNo
  DoCmd.OpenForm "frmDuplicateLicense", acNormal, "", rptFilter
DuplicateRecords_Exit:
  Exit Sub
DuplicateRecordsErrorHandler:
   MsgBox Err.Description, vbCritical
   Call LogError(Err.Number, Err.Description, "frmSysMaint-Cmd_DuplicateRecords_Click()")
   Resume DuplicateRecords_Exit

Currently rptFilter is not be used.

 

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
Recent Activity:
.

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