Sabtu, 31 Desember 2011

RE: [MS_AccessPros] Re: Cascading Combo Box

Bill,
Do yourself a favor and rename your combo box to something that makes sense. Then you have about 45 minutes to make your New Years resolution to find and consistently apply a good naming convention!

Duane hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: Bill.Singer@at-group.net
Date: Sun, 1 Jan 2012 04:06:12 +0000
Subject: [MS_AccessPros] Re: Cascading Combo Box






Duane,

Yes, Snow finally..

The second combo box is based on a query. The query is sorted with this criteria.

[Forms]![f_Jobs]![Combo74]

Where [Combo74] is the first combo box. Combo74 picks a name that is associated with a ID number. The second Combo box sorts the records for those records with that ID number.

Will the On Current event of the form update the 2nd combo box each time I move to a new record? I will give it a try.

Thank you,

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:

>

> Bill,

> Can you share how you are filtering the second combo box? Is there something in its criteria or are you changing the SQL of the Row Source or some other method.

>

> Whatever you are doing, you probably need to do it in the On Current event of the form.

>

> Duane Hookom

> MS Access MVP (hey it's finally snowing in MN)

>

> --- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@> wrote:

> >

> > Here is the good news. Thanks to this site I have succesfully set up two combo boxes with the options in the second combo box based on the selection in the first combo box.

> >

> > I have the "got focus" property on the second combo box set to refresh the record. Both the first combo box and the second combo box are entering the correct ID number into the correct table. The second combo box work off of a query that sorts based on the selection in the first combo box.

> >

> > There are about 300 records in the table.

> >

> > The problem is that we I open the form and go to the next record or the previous record the second combo box does not show the selection that was made. It just shows as blank. When I click on the box the correct item shows up. It is as if it was there all the time but waiting me to touch it with the mouse. This is frustrating. I would like the second combo box to show the selected item as I go through the next record.

> >

> > I would think the combo box would refresh when I go to the next record but it will not show the selection until I click on it.

> >

> > What did I do wrong?

> >

> > Bill

> > Minnesota

> > Happy New Year!!

> >

>






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

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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[MS_AccessPros] Re: Cascading Combo Box

 

Duane,

Refresh Record in the On Current of the form and in the On Focus of the 2nd drop down box ... and it works perfectly.

thanks and have a Happy New Year. As you can tell I am really partying hard here in front of my computer. I will not make it to midnight.

Bill
MN

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> Bill,
> Can you share how you are filtering the second combo box? Is there something in its criteria or are you changing the SQL of the Row Source or some other method.
>
> Whatever you are doing, you probably need to do it in the On Current event of the form.
>
> Duane Hookom
> MS Access MVP (hey it's finally snowing in MN)
>
> --- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@> wrote:
> >
> > Here is the good news. Thanks to this site I have succesfully set up two combo boxes with the options in the second combo box based on the selection in the first combo box.
> >
> > I have the "got focus" property on the second combo box set to refresh the record. Both the first combo box and the second combo box are entering the correct ID number into the correct table. The second combo box work off of a query that sorts based on the selection in the first combo box.
> >
> > There are about 300 records in the table.
> >
> > The problem is that we I open the form and go to the next record or the previous record the second combo box does not show the selection that was made. It just shows as blank. When I click on the box the correct item shows up. It is as if it was there all the time but waiting me to touch it with the mouse. This is frustrating. I would like the second combo box to show the selected item as I go through the next record.
> >
> > I would think the combo box would refresh when I go to the next record but it will not show the selection until I click on it.
> >
> > What did I do wrong?
> >
> > Bill
> > Minnesota
> > Happy New Year!!
> >
>

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

[MS_AccessPros] Re: Cascading Combo Box

 

Duane,
Yes, Snow finally..

The second combo box is based on a query. The query is sorted with this criteria.

[Forms]![f_Jobs]![Combo74]

Where [Combo74] is the first combo box. Combo74 picks a name that is associated with a ID number. The second Combo box sorts the records for those records with that ID number.

Will the On Current event of the form update the 2nd combo box each time I move to a new record? I will give it a try.

Thank you,
Bill

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> Bill,
> Can you share how you are filtering the second combo box? Is there something in its criteria or are you changing the SQL of the Row Source or some other method.
>
> Whatever you are doing, you probably need to do it in the On Current event of the form.
>
> Duane Hookom
> MS Access MVP (hey it's finally snowing in MN)
>
> --- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@> wrote:
> >
> > Here is the good news. Thanks to this site I have succesfully set up two combo boxes with the options in the second combo box based on the selection in the first combo box.
> >
> > I have the "got focus" property on the second combo box set to refresh the record. Both the first combo box and the second combo box are entering the correct ID number into the correct table. The second combo box work off of a query that sorts based on the selection in the first combo box.
> >
> > There are about 300 records in the table.
> >
> > The problem is that we I open the form and go to the next record or the previous record the second combo box does not show the selection that was made. It just shows as blank. When I click on the box the correct item shows up. It is as if it was there all the time but waiting me to touch it with the mouse. This is frustrating. I would like the second combo box to show the selected item as I go through the next record.
> >
> > I would think the combo box would refresh when I go to the next record but it will not show the selection until I click on it.
> >
> > What did I do wrong?
> >
> > Bill
> > Minnesota
> > Happy New Year!!
> >
>

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

[MS_AccessPros] Re: Cascading Combo Box

 

Bill,
Can you share how you are filtering the second combo box? Is there something in its criteria or are you changing the SQL of the Row Source or some other method.

Whatever you are doing, you probably need to do it in the On Current event of the form.

Duane Hookom
MS Access MVP (hey it's finally snowing in MN)

--- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@...> wrote:
>
> Here is the good news. Thanks to this site I have succesfully set up two combo boxes with the options in the second combo box based on the selection in the first combo box.
>
> I have the "got focus" property on the second combo box set to refresh the record. Both the first combo box and the second combo box are entering the correct ID number into the correct table. The second combo box work off of a query that sorts based on the selection in the first combo box.
>
> There are about 300 records in the table.
>
> The problem is that we I open the form and go to the next record or the previous record the second combo box does not show the selection that was made. It just shows as blank. When I click on the box the correct item shows up. It is as if it was there all the time but waiting me to touch it with the mouse. This is frustrating. I would like the second combo box to show the selected item as I go through the next record.
>
> I would think the combo box would refresh when I go to the next record but it will not show the selection until I click on it.
>
> What did I do wrong?
>
> Bill
> Minnesota
> Happy New Year!!
>

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

[MS_AccessPros] Cascading Combo Box

 

Here is the good news. Thanks to this site I have succesfully set up two combo boxes with the options in the second combo box based on the selection in the first combo box.

I have the "got focus" property on the second combo box set to refresh the record. Both the first combo box and the second combo box are entering the correct ID number into the correct table. The second combo box work off of a query that sorts based on the selection in the first combo box.

There are about 300 records in the table.

The problem is that we I open the form and go to the next record or the previous record the second combo box does not show the selection that was made. It just shows as blank. When I click on the box the correct item shows up. It is as if it was there all the time but waiting me to touch it with the mouse. This is frustrating. I would like the second combo box to show the selected item as I go through the next record.

I would think the combo box would refresh when I go to the next record but it will not show the selection until I click on it.

What did I do wrong?

Bill
Minnesota
Happy New Year!!

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

[MS_AccessPros] Re: Hide Database window

 

Bill,
I input the code you suggested below on the "got focus" of the startup form. I received an error message. "Ambiguous name detected"
Was there something obvious I missed.

Bill
Minnesota

Bill

Thanks, I will try this in the database right after I make a copy of it. I
have locked myself out of a database before.almost, I was sweating.
Bill .the newbee

MN

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Tuesday, December 20, 2011 3:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Hide Database window

Bill

Keep in mind you still are a bit of a newbee. Doing all this hiding might
> > > > > bite you in the butt if you don't know what you are doing. You need a back
> > > > > door in case you lock yourself out. The default back door is to hold down
> > > > > the shift key while you open the database. But you can even disable that
> > > > > option.
> > > > >
> > > > > Do this ONLY in your production copy, not in your development copy.
> > > > >
> > > > > Set up your startup form under Options>Current Database.
> > > > >
> > > > > In that form's code, put this:
> > > > >
> > > > > Private Sub ShowHideRibbon(bolShowRibbon As Boolean)
> > > > > 'Purpose : Shows or hides Ribbon depending on Boolean argument.
> > > > > ' Can be run in versions older than 2007 with no ill effects.
> > > > > 'DateTime : 4/11/2011 08:03
> > > > > 'Author : Bill Mosca
> > > > > 'Requires :
> > > > > On Error Resume Next
> > > > >
> > > > > 'Hide or restore ribbon in versions 2007+.
> > > > > If bolShowRibbon = True Then
> > > > > DoCmd.ShowToolbar "Ribbon", acToolbarYes
> > > > > Else: DoCmd.ShowToolbar "Ribbon", acToolbarNo
> > > > > End If
> > > > >
> > > > > End Sub
> > > > >
> > > > > Private Sub ChangeProperty(db As Database, _
> > > > > strPropertyName As String, _
> > > > > varPropertyType As Variant, varPropertyValue As Variant)
> > > > >
> > > > > On Error GoTo err_PROC
> > > > > db.Properties(strPropertyName) = varPropertyValue
> > > > >
> > > > > exit_PROC:
> > > > > Exit Sub
> > > > >
> > > > > err_PROC:
> > > > > 'If property not found, create it.
> > > > > If Err = 3270 Then
> > > > > Dim prpNew As DAO.Property
> > > > > Set prpNew = db.CreateProperty(strPropertyName, varPropertyType, _
> > > > > varPropertyValue, True)
> > > > > db.Properties.Append prpNew
> > > > > Else
> > > > > MsgBox Err.Description, vbCritical
> > > > > End If
> > > > >
> > > > > End Sub
> > > > >
> > > > > Private Sub Form_Load()
> > > > > ChangeProperty db, "StartupShowDBWindow", dbBoolean, False
> > > > > Call ShowHideRibbon(False)
> > > > > End Sub
> > > > >
> > > > > Close the database and re-open it. That will run the code. Close it again
> > > > > and the next time it opens going forward the ribbon and the database window
> > > > > will be hidden.
> > > > >
> > > > > 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
> > > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Singer"
> > > > > <Bill.Singer@> wrote:
> > > > > >
> > > > > > I have been looking for a way to hide the database window. Once a form
> > > > > > opens in popup mode I would like to hide the database window. I do not
> > > > > > want the user to have access to or even see the ribbon.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > >
> > > > > >
> > > > > > Bill Singer
> > > > > >
> > > > > > MN
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > >
> >
>

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

[MS_AccessPros] duplicates not seen but found by "find duplicates" query

 

I'm trying to get this version wrapped before Tuesday so am working from home.

One of my queries is coming up with a duplicate entry that I think I could get rid of by using "distinct" but I want to make sure it's not a symptom of an issue that will haunt me in the future.

I finally figured out that if I got rid of qMarketValueSales from the FROM portion, the duplicate went away. When I check qMarketValueSales, sure enough two duplicate records show up for that record.

What is weird, is that the find duplicates query finds the extra record for qMarketValueSales, but when I go open qMarketValueSales and sort on HomeInfoID I do not find a duplicate entry.????

The sql for qMarketValueSales is below.

Thanks much!
Connie

SELECT MarketValue.MarketValueID, MarketValue.HomeInfoID, MarketValue.MarketValue, MarketValue.MVYear
FROM (Listings LEFT JOIN MarketValue ON Listings.HomeInfoID = MarketValue.HomeInfoID) RIGHT JOIN Sales ON Listings.ListID = Sales.ListID
WHERE (((MarketValue.MarketValueID) In (SELECT TOP 1 MarketValueID
FROM MarketValue AS Dupe
WHERE Dupe.HomeInfoID = MarketValue.HomeInfoID
ORDER BY Dupe.MVYear DESC, Dupe.MarketValueID DESC)) AND ((MarketValue.MVYear)=Year([Sales].[SoldDate])));

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

[belajar-access] Parameter pada Pass through queries

 

Saya ingin bertanya bagaimana caranya memberikan parameter pada Pass Thru queries ? misal [Forms]![Form1]![TextBox1]
Kalau di Query biasa kan tinggal tulis di baris criteria di design view...trima kasih...

Regards
Hendra

__._,_.___
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.

.

__,_._,___

[AccessDevelopers] Yippee!

 


This is very effective http://iiyooo.com/inf.php?NewYear I liked it.

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
MARKETPLACE

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

.

__,_._,___

[AccessDevelopers] Odd behaviour when click a hyperlink

 

I am testing an Acess 97 application for distribution with Access runtime. I have installed the program on 2 machines with the runtime files, one Vista, the other XP SP3. There are no issues with the Vista installation. On the XP installation when any of several hyperlinks to the internet or local files is clicked, the browser (IE8) or FireFox 9) does not open .

Here are some results of my investigations into why this is happening:

If the browser is already opened the requested page is properly loaded in a new tab.
If IE7 is substituted as the default browser then it works OK.
I get the same results when the ShellExecute command is used or when CreateObject is used.

On the XP PC there resides another distributed Access program of ours which uses exactly the same runtime files. The hyperlinks in this application all work without problem.

If (and this is very odd) any of the hyperlinks are rapidly clicked a few times, then the browser opens ???

I have run out of ideas of what the problem can be - and I would appreciate any fresh thoughts on this.

Happy New Year to all
HM

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
MARKETPLACE

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

.

__,_._,___

Re: [MS_AccessPros] Re: Need help with query for form

 

thank you, Kathleen :) ... and you are welcome :)

Happy New Year
warm regards,
Crystal

* have an awesome day :)

________________________________
From: KTT47


Thanks, Crytal and happy birthday yesterday.  I am still working on getting this to work exactly the way I need it to, but you have given me the framework I needed. 

Thanks again.
Kathleen
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Kathleen,
>
> Welcome!
>
> make a textbox with this ControlSource:
>
> =DLookup("[CashLeft]","[Tablename]","[SalesDate]=#" & Date()-1 & "#")
>
> WHERE
> CashLeft is the field with cash left at the end of the day
>
> Tablename is the name of the table
>
> SalesDate is the field with your date of sale
>
>

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

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

Jumat, 30 Desember 2011

[MS_AccessPros] Re: Need help with query for form

 


Thanks, Crytal and happy birthday yesterday. I am still working on getting this to work exactly the way I need it to, but you have given me the framework I needed.

Thanks again.
Kathleen
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Kathleen,
>
> Welcome!
>
> make a textbox with this ControlSource:
>
> =DLookup("[CashLeft]","[Tablename]","[SalesDate]=#" & Date()-1 & "#")
>
> WHERE
> CashLeft is the field with cash left at the end of the day
>
> Tablename is the name of the table
>
> SalesDate is the field with your date of sale
>
>

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

Bls: [belajar-access] File Access

 

Saya sudah menambah, merubah Form, tabel, report.

Tapi setelah nama foldernya saya ubah jadi normal (Tgl & jam berubah).
nama foldernya MAT, kemudian saya ubah dengan nama MITRA.

Malah yang paling aneh di Folder MAT, file DataMAT.accdb Tgl. Modify 20-12-2011 15:12, saya hapus, kemudian saya copy lagi dengan nama file yang sama di folder lain dengan tgl modify 21-12-2011 13:00. Hasilnya di Folder MAT, Tgl. Modify  20-12-2011 15:12 bukan 21-12-2011 13:00.

Apakah itu mungkin virus?
Terima kasih atas responnya.

Salam sejahtera,
Coyev


Dari: CGSATU <cgsatu@yahoo.com>
Kepada: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Dikirim: Jumat, 30 Desember 2011 10:12
Judul: Re: [belajar-access] File Access

 

Apakah memang tiap kali buka ada merubah bentuk data? Atau mungkin bentuk form?
 
Kalau sekedar buka, kemudian masukkan data baru atau sekedar ubah data ya tidak akan berubah. Itu kan jam dan tanggal kita melakukan perubahan pada object MS Access
 
Cgsatu (Elang)

From: Mr Coyev Toni Setiawan <coyev@yahoo.com>
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Sent: Thursday, December 29, 2011 11:14 PM
Subject: [belajar-access] File Access

 
Salam untuk Para Master Access

Mohon Pencerahan,
Saya bikin 2 file Access (Ms. Access 2007), 1 untuk Data dan 1 untuk program. Tapi kenapa yah setiap saya buka file tersebut baik file data maupun programnya tanggal & jam modifikasinya tidak berubah (Tanggal dan jam masih pada saat dibuat). Biasanya kan setiap kita buka file Access, saat ditutup tanggal & jamnya akan berubah. Saya coba di Compact & Repair Data tetap tidak berubah. Kemudian saya coba buat file data baru tabelnya saya import dari Db sebelumnya, tetap saja sama (Tanggal & Jam saat file dibuat). Kenapa yah bisa begitu? Saya baru mengalami kejadian seperti ini. Sampai saat ini emang tidak ada masalah, saya baru input data masternya, tapi saya takut kedepannya ada masalah. Terima kasih.

Salam,

Coyev




__._,_.___
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.

.

__,_._,___