Jumat, 30 September 2011

[belajar-access] Harap pencerahan dari para pakar

 

Assalamu'Alaikum Wr. Wb.

Harap masukan & informasi atas kendala pada file attachment terlampir.
atas masukan dan informasi yang diberikan, saya ucapkan terima kasih.

Wassalam.

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

.

__,_._,___

Re: [belajar-access] memqanggil tanggal di query

Dear Aditya Pratama

Tambahkan function Between... And...., lengkapnya sbb:
Between [Forms]![TRF Form Transaksi Harian]![Date (THP-TW)] And
[Forms]![TRF Form Transaksi Harian]![Date (THP-TW)]

Best Regards,
AccessWizards

Pada tanggal 30/09/11, Aditya Pratama <indravena@yahoo.co.id> menulis:
>
>
> Dear Pakar Access,
> Minta bantuan mengenai pemanggilan data di Query, yang
> selama ini saya bisa hanya memanggil menampilkan tanggal tertentu, misalkan
> saya memanggil query data saya untuk yang tangal (THP-TW)
>
> Rumus yang diketik adalah seperti centang
> warna Merah  :
>
>
> Setelah di masukkan rumus diatas maka jika
> Query dijalankan akan tampil pertanyaan tanggal yang diinginkan:
>
>
> Dan ini adalah hasil pencariannya :
>
>
>
> Dari data diatas adalah untuk mencari tanggal yang diinginkan
> sesuai dengan tanggal yang diinput di parmeter, dan yang saya tanyakan
> adalah
> kira kira apa rumus atau formula diatas jika yang saya ingin tampilkan
> adalah
> data dari 13 Oct'11 s/d 20 Oct'11 ? sehingga akan tampil semua data
> yang (THP-TW) adalah sesuai tanggal permintaan yaitu 13 Oct'11 s/d 20
> Oct'11
>
> Mohon sarannya
>
> Salam


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

SPAM IS PROHIBITEDYahoo! Groups Links

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

<*> Your email settings:
Individual Email | Traditional

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

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

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

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

[MS_AccessPros] Re: Following the color change thread

 

A.D.

Yea, I found it after I posted.
I have altered the form and its table and query to use the existing data in my application and it works fine...except... I have 4 other fields that are comboboxes row sourced from other tables. Updating and adding records has proven to be a "challenge".

Walter

--- In MS_Access_Professionals@yahoogroups.com, "A.D. Tejpal" <adtp@...> wrote:
>
> Walter,
>
> Double click event of ColorStrip controls (along with events for other controls) gets hooked programmatically, in form's load event.
>
> Best wishes,
> A.D. Tejpal
> ------------
>
> ----- Original Message -----
> From: nkpberk
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, September 30, 2011 00:42
> Subject: [MS_AccessPros] Re: Following the color change thread
>
>
> A.D>
> One question, double clicking on the "CSxx" produces the color picker dialog but there is no "doubleClick" event associated with the control, how are you calling the color dialog?
> Walter
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "A.D. Tejpal" <adtp@> wrote:
> >
> > Walter,
> >
> > My sample db named Form_ContSimulated_ColorsRowWise.zip, uploaded to 4Shared.com demonstrates the approach outlined in my earlier post. It is in Access 2000 file format (Ref: DAO 3.6). Link for downloading the file is given below:
> > http://www.4shared.com/file/ngHp16DH/Form_ContSimulated_ColorsRowWi.html
> >
> > Simulated continuous form using unbound controls, displays 12 records at a time. Full coverage of data is provided via suitable navigation buttons. Apart from being able to edit the records, the user can add new records or delete any desired one by clicking appropriate command buttons. All these actions are feasible directly on the simulated form. Current record remains identified by special highlight in first column.
> >
> > First two columns (locked) display the record number and TrainID. Next two columns, holding TrainCode and ColorValue, are editable. Last column serves as ColorStrip, each row displaying the color represented by ColorValue in the previous column.
> >
> > There is two way synchronization between ColorValue and ColorStrip. Any value entered in the former gets reflected as corresponding color in the latter. On the other hand, double click on ColorStrip invokes the color dialog box, where the user has unlimited choice and the color finally selected gets displayed in the color strip. Simultaneously, appropriate value gets assigned in ColorValue column.
> >
> > Note:
> > The modules for color dialog box have been taken from Access 2002 Desktop Developer's Handbook.
> >
> > You might like to try it out and confirm whether it is in line with your objectives and whether anything needs further attention.
> >
> > Best wishes,
> > A.D. Tejpal
> > ------------
> >
> > ----- Original Message -----
> > From: nkpberk
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Thursday, September 29, 2011 04:43
> > Subject: [MS_AccessPros] Re: Following the color change thread
> >
> > John;
> > That may be the best(chickens)way out. I'll have to generate a "Pick a canned color" form with a warning if they choose the same color more than once.
> > Off to the multi-colored brick road :-)
> > Walter Griffin
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > Walter-
> > >
> > > Maybe pick 64 nice unique colors. By using the color picker, you're being a bit
> > > too user-friendly! Note that the user *could* pick two colors only one color
> > > number apart in the color picker. The numbers would be unique in the table, but
> > > would appear virtually the same on the screen. Better to give the users a
> > > selection of enough different "canned" colors.
> > >
> > > 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)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> > > Sent: Wednesday, September 28, 2011 8:58 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] Following the color change thread
> > >
> > > John;
> > >
> > > Actually no, I'm using a color picker control and the user can generate
> > > something like 16000000 colors.
> > > When I originally set up the "trains" table and form I made a dozen or so "color
> > > swatch" files and realized some users may need a LOT more than that (certainly
> > > not 16 million! but 50 or 60 would not be out of the question)
> > > After that I thought to "automate" the color choices with the color picker and
> > > now I can't format the form the way I would like, That's what I get for
> > > thinking!
> > > I may have to revert to the original plan (with a lot more choices than before)
> > > if I can't figure out how to generate them on the "fly".
> > >
> > > Walter Griffin
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > > >
> > > > Walter-
> > > >
> > > > I assume you have a set number of colors that can be assigned. If that's the
> > > > case, build separate GIF or JPG files that are a "blob" of each color, create
> > > a
> > > > table with the color code, and a text field that points to the picture file on
> > > > your hard drive. Join your base table with the color code table on the color
> > > > code, then use an Image control bound to the text field to display the correct
> > > > color.
> > > >
> > > > 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)
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> > > > Sent: Wednesday, September 28, 2011 5:21 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: Re: [MS_AccessPros] Following the color change thread
> > > >
> > > > Tim;
> > > > You know, that might work, build a table with an ID and a image control (OLE
> > > > doesn't seem to want to work reliably on my system with 2010 on it so I'm
> > > stuck
> > > > with an attachment type :-P) Just have to figure out how to build the color
> > > > image file in code and associate it with the "train" record. Or add an
> > > > attachment directly to the "Train" record and forget the linked table? Might
> > > get
> > > > complicated to change the value tho. May be over my head, too, Ain't no pro at
> > > > this!
> > > >
> > > > Tim, your close, I'm in Pleasant Lake
> > > >
> > > > Walter Griffin
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "juiceplustim" <tritter@>
> > > > wrote:
> > > > >
> > > > > Learning some interesting depth about continuous forms, since I use those
> > > > frequently and am always looking for good layout ideas. This is always a
> > > pain,
> > > > but thanks to John below - I see more clearly why.
> > > > >
> > > > > Here's something that may (MAY) be worth a try. If you are storing the
> > > color
> > > > choice in the record, why not have a related table with 2 fields. One for the
> > > > color choice code number, and the other field storing an image of a simple
> > > line,
> > > > bar, or rectangle in the color you want with that code (whatever shape, size
> > > > works for your specific form). Then match that color image table to your
> > > record
> > > > source for the form and just display the linked image behind whatever part of
> > > > each record you want. Those types of images as a GIF are very small, and
> > > > shouldn't add much to the load time of the form for even a large set of
> > > records.
> > > >
> > > > >
> > > > > Anyone see why that couldn't work? I don't have anything right now that I
> > > > would need to try it out on, but would love to know if that's a good work
> > > > around.
> > > > >
> > > > > Tim Ritter
> > > > > Fort Wayne, IN
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
> > > wrote:
> > > > > >
> > > > > > Walter-
> > > > > >
> > > > > > It works in the report because the report formats each record one at a
> > > time.
> > > > It
> > > > > > would also work in Single Form view, but it doesn't work in Continuous
> > > form
> > > > view
> > > > > > because there is really only one copy of each control. You see multiple
> > > > rows
> > > > > > because Access "paints" all but the current row, and it honors Conditional
> > > > > > Formatting as it's doing the "painting." There is no event associated
> > > with
> > > > > > "painting" each row in a form like there is in a report (On Format).
> > > > > >
> > > > > > 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)
>
> [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] Fields not populating after combo box is clicked

 

Great Day, I have a subform that identifies vehicles that will be repaired at a local mechanic's shop. The customer information comes up in another subform; no problem there. this subform that permits the user to select the vehicle for service, frmJobVehicle Sub is unbound and displays information from qryVehicles - Make,Model, and Tag Number. VehicleID is the first field, but is not displayed, so there are four fields. Here is the SQL for this combo box:

SELECT qryVehicles.VehicleID, qryVehicles.Make, qryVehicles.Model, qryVehicles.[Tag-State]
FROM qryVehicles
ORDER BY qryVehicles.[Make], qryVehicles.[Model];

The combo box permits me to select a vehicle, but after the vehicle is selected, I can't populate the applicable fields. Here is the code that I have in the subform's On Current event:

Private Sub Form_Current()

cboVehicles = Me.txtMakeModelYear2

End Sub


and the after update event code for the combo box is below. I am using this code to try to populate the fields.

Private Sub cboVehicles_AfterUpdate()

Me.txtMakeModelYear2 = cboVehicles
mbResponse = MsgBox("Is this vehicle with tag number " & Me.TagNo & " the correct vehicle for this repair order?", vbYesNo, "Correct Vehicle?")
If mbResponse = vbYes Then
Me.cboVehicles = Me.txtMakeModelYear2
Me.VehicleMake = Me.cboVehicles
Me.txtTagNo2 = Me.TagNo
Me.txtVIN2 = Me.VIN

Else
mbResponse = MsgBox("Please select the correct vehicle.", vbOKOnly, "Correct Vehicle?")
End If
Exit Sub


End Sub

Thanks in advance for your assistance.

Thanks,

David

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

Re: [MS_AccessPros] Append Query Where Clause question

 

Troy -

Alone with John's advice, i'd like to add this: You should always specify the fields in both the target and the source. That way you are sure to get everykthing where it belongs should the table structures change in any way in the future.

INSERT INTO dbo_Key_Scans(LastName, FirstName, MyDate)

SELECT LastName, FirstName, MyDate
...

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, "John Viescas" <john@...> wrote:
>
> Troy-
>
> To add a WHERE clause, the table referenced must be in the FROM clause. Maybe
> you need to do a LEFT JOIN between TransMast and Key_Scans, then select only the
> rows where ScanDateTime1 Is Null - indicating the matching rows from TransMast
> don't exist yet in Key_Scans. I would take a stab at the SQL, but I don't know
> what should match in the two tables.
>
> 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)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Troy Sherven
> Sent: Friday, September 30, 2011 4:48 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Append Query Where Clause question
>
> Hi,
>
>
>
> I'm new to the group and new to Access. I'm having some issues with an
> append query. Here is the SQL:
>
>
>
> INSERT INTO dbo_Key_Scans
>
> SELECT dbo_TransMast.*
>
> FROM dbo_TransMast
>
> WHERE (((dbo_Key_Scans.ScanDateTime1) is Null));
>
>
>
> When I run this query, Access is prompting me with a parameter for
> dbo_Key_Scans.ScanDateTime1. My first thought was, "maybe I have
> something spelled wrong?" I checked it numerous times. The query runs
> fine without the WHERE clause. What am I doing wrong?
>
>
>
> Thanks,
>
>
>
> Troy Sherven
>
> MCD, Inc.
>
> Madison, WI
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

__._,_.___
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: Operation must use updatable Query MSG Banging my head against a wall Help!!!

 

Frank

SharePoint is still not a good place for a relational database. I haven't worked with it, but the folks I know who have have also faced these kinds of obstacles.

My suggestion is to first check your permissions to see if you can append/edit/delete.

If that doesn't help, you might want to post to a SharePoint group (not that I'm trying to drive you away).

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, "frank_guasp" <fguasp@...> wrote:
>
> I recently migrated an application to Access 2007.
> The Backend Tables are housed as lists in Sharepoint.
> I have full access to those lists
>
> I'm running a query that appends a record to this list and I get the following MSG: Operation must use updatable Query.
> I don't what to do. It happens sporatically. There are no other users
>
> I have a unique field (Sharepoint ID is unique)
> I've tried it via a query and via SQL Code and they both work spratically. What am I missing.
>
> This query used to work when I had the table housed on a SQL Server.
> I don't know what to do.
> HELP!! I'm loosing my mind
>

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

[MS_AccessPros] Operation must use updatable Query MSG Banging my head against a wall Help!!!

 

I recently migrated an application to Access 2007.
The Backend Tables are housed as lists in Sharepoint.
I have full access to those lists

I'm running a query that appends a record to this list and I get the following MSG: Operation must use updatable Query.
I don't what to do. It happens sporatically. There are no other users

I have a unique field (Sharepoint ID is unique)
I've tried it via a query and via SQL Code and they both work spratically. What am I missing.

This query used to work when I had the table housed on a SQL Server.
I don't know what to do.
HELP!! I'm loosing my mind

__._,_.___
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: I am trying to import and keep getting an error message.

 

Tiffany

I should have added: If the columns aren't in the same order as the table import into another table and then run an append query to get the records in the new table into the correct table. You'll just have to set up the append so each column goes to the right field.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Tiffany
>
> If I remember right, you have to have the excel columns in the same order as the table fields so Access knows where everything goes. Could that be the problem you are having?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "cc0623" <cc0623@> wrote:
> >
> > I am trying to import data from excel and I keep getting the error "F1 does not exist in destination table", but it is in the table listed as Unit. Can anyone tell me hoe to fix this problem?
> >
> > Thanks,
> > Tiffany
> >
>

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

RE: [MS_AccessPros] Append Query Where Clause question

 

Troy-

To add a WHERE clause, the table referenced must be in the FROM clause. Maybe
you need to do a LEFT JOIN between TransMast and Key_Scans, then select only the
rows where ScanDateTime1 Is Null - indicating the matching rows from TransMast
don't exist yet in Key_Scans. I would take a stab at the SQL, but I don't know
what should match in the two tables.

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)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Troy Sherven
Sent: Friday, September 30, 2011 4:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Append Query Where Clause question

Hi,

I'm new to the group and new to Access. I'm having some issues with an
append query. Here is the SQL:

INSERT INTO dbo_Key_Scans

SELECT dbo_TransMast.*

FROM dbo_TransMast

WHERE (((dbo_Key_Scans.ScanDateTime1) is Null));

When I run this query, Access is prompting me with a parameter for
dbo_Key_Scans.ScanDateTime1. My first thought was, "maybe I have
something spelled wrong?" I checked it numerous times. The query runs
fine without the WHERE clause. What am I doing wrong?

Thanks,

Troy Sherven

MCD, Inc.

Madison, WI

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

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

Yahoo! Groups Links

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___

RE: [MS_AccessPros] Re: Open Multiple Instances of a Form, each to a specific record

 

Amy-

What are your search criteria on your "search" form? Consider creating an
unbound form with a list box that has all the columns of interest. Make the
list box multi-select so the user can pick multiple rows. Then build a filter
from the rows selected and open them all up on a Continuous View form.

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)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of amy_hollows
Sent: Friday, September 30, 2011 1:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Open Multiple Instances of a Form, each to a
specific record

John,

I am opening multiple instances because I want to see different records next to
each other in order to edit them simultaneously. I can search for a record in
my search form, double click to open it in a separate form, then search for
another record in my search form and double-click to open it...and so on. Then
I can edit them simultaneously.

IS there an easier way to do this?

amy

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Amy-
>
> Why are you opening multiple instances? It would seem to me (unless the
> "search" form is also frmFY12Targets1Edit) that you simply should do a
> DoCmd.OpenForm and apply the filter directly. Applying the filter after the
> form opens gets the job done, but it's much less efficient because the form
> opens on ALL records before you set the filter.
>
> DoCmd.OpenForm "frmFY12TargetsEdit", WhereCondition:="AutoNumber = " &
> Me.AutoNumber
>
> 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)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of amy_hollows
> Sent: Friday, September 30, 2011 11:32 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Open Multiple Instances of a Form, each to a
> specific record
>
> I totally just did some crazy googling and figured out how to make this work
AND
> I changed the caption in each instance of the form to make it slightly more
> meaningful to the user.
>
> 1. code in my mdPublic module:
>
> Option Compare Database
>
> Public clnfrmFY12Targets1Edit As New Collection 'Instances of
> frmFY12Targets1Edit.
>
> Public Sub OpenAfrmFY12Targets1Edit(objForm As Form)
> 'Purpose: Open an independent instance of form frmFY12Targets1Edit to a
> specific record based on the AutoNumber field in the "search form".
>
> Dim frm As Form
>
> 'Open a new instance to a particular record, show it, and set a caption.
> Set frm = New Form_frmFY12Targets1Edit
> frm.Filter = "[AutoNumber]= " & objForm.[AutoNumber]
> frm.FilterOn = True
> frm.Visible = True
> frm.Caption = "Record Number" & objForm.[AutoNumber]
>
>
> 'Append it to our collection.
> clnfrmFY12Targets1Edit.Add Item:=frm, Key:=CStr(frm.Hwnd)
>
> Set frm = Nothing
> End Sub
>
> 2. code on the double-click event of the AutoNumber field (i know i know, bad
> field name) of my "search form":
>
> Private Sub AutoNumber_DblClick(Cancel As Integer)
> Call OpenAfrmFY12Targets1Edit(Me)
> End Sub
>
>
> My question to you: do you foresee me having any issues in the future based
on
> how I built this. The forms are based on only one table. I just want to make
> updating the table values very easy for the user to do.
>
> thanks!
>
> amy
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "amy_hollows" <amy_hollows@>
> wrote:
> >
> > John,
> >
> > Thanks so much for the quick reply. This is my first time joining a MS
Access
> group and so far so good! :) Here is the code I used to open independent
> instances of my form:
> >
> > Option Compare Database
> >
> > Public clnfrmFY12Targets1Edit As New Collection
> > 'Instances of frmFY12Targets1Edit.
> >
> > Function OpenAfrmFY12Targets1Edit()
> > 'Purpose: Open an independent instance of form frmFY12Targets1Edit.
> >
> > Dim frm As Form
> >
> > 'Open a new instance, show it, and set a caption.
> > Set frm = New Form_frmFY12Targets1Edit
> > frm.Visible = True
> > frm.Caption = frm.Hwnd & ", opened " & Now()
> >
> >
> > 'Append it to our collection.
> > clnfrmFY12Targets1Edit.Add Item:=frm, Key:=CStr(frm.Hwnd)
> >
> > Set frm = Nothing
> > End Function
> >
> > I would like to call this function on a double-click event of a record in a
> "search form" that I have created and pass it an argument (i think this is the
> correct terminology) to open to a specific record. The "search form" has an
> AutoNumber field that uniquely identifies each record. The "search form"
allows
> users to search by up to 3 criteria and returns a list of records in a
> continuous form. I want the user to be able to double-click on a record (or a
> button or whatever...I can just decide later where to set the dbl click event)
> to open a separate "edit form" to edit the record. The user will often need
to
> edit 2+ records at a time, thus the need for opening multiple instances of a
> form (to a specified record).
> >
> > Thanks in advance for your help. :)
> >
> > amy
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
wrote:
> > >
> > > Amy-
> > >
> > > Because you open multiple copies be setting an object reference to the
> form's
> > > class module, you can use that object to manipulate the form, including
> setting
> > > the Filter and FilterOn properties or doing a search on the Recordset to
> move to
> > > a specific record. Post the code you're using now with a more detailed
> > > description of how you want to apply a search, and I can probably give you
> the
> > > modifications you need.
> > >
> > > 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)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of amy_hollows
> > > Sent: Thursday, September 29, 2011 4:50 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Open Multiple Instances of a Form, each to a
> specific
> > > record
> > >
> > > I have used code from Allen Browne to successfully open multiple instances
> of a
> > > form in my database (pretty sweet). Now, I would like to be able to open
> the
> > > instances of this form to a specific record, which is specified in the
> search
> > > results of another form that I created that searches a table based on 3
> > > criteria. I can do these two things separately (open multiple instances,
> and
> > > open a form to a specific record). Any ideas on how to combine these two
> ideas
> > > into something work-able for me?
> > >
> > > (P.S. I am now at the "cut and paste and modify and debug" stage of VB
> > > programming so bear with me if my questions sound totally vague. I'm
super
> > > excited about programming and making this db work though, so any help is
> much
> > > appreciated!)
> > >
> > > thanks!
> > >
> > > ~Amy
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

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

Yahoo! Groups Links

__._,_.___
Recent Activity:
MARKETPLACE

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

.

__,_._,___