Hi Tiffany,
If you want two separate forms then make a copy of
the first form giving it a different FormName and
change the the new form's data source as required.
They can both be open at the same time. You can also
add VBA code to allow one form to manipulate the
other form. We can help you with the neccesary VBA
code if you tell us what you need.
In the forms' OpenEvent you can specify the position
and size of the form on the screen with something like,
Private Sub Form_Open(Cancel As Integer)
' Syntax: MoveSize(Right, Down, Width, Height)
DoCmd.MoveSize 100, 7500 ' Set the top left position only
End Sub
Note: The units for the arguments are twips
(twip: Unit of measurement that is equal to
1/20 of a point, or 1/1,440 of an inch.
There are 567 twips in a centimeter.)
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Tiffany-
>
> In the After Update event of the form that shows all assets, requery the "sold"
> form if it is open, and the record checked will "magically" appear there.
>
> 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 cc0623
> Sent: Friday, October 07, 2011 6:21 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] I need help understanding something....
>
> I wish it was that simple.... The reason why I need two forms is because my boss
> wants to visually see in a datasheet view the "active assets" in one form and
> the "sold" in the other. What it basically comes down to is she is to used to
> flipping back and forth between the spreadsheets she has been using for the last
> 6 years.
>
> So... based on the table "Assets" I have created a datasheet form called Assets,
> then copied that form and renamed the new form "Sold Assets". There is a
> checkbox titled "sold" in all three. I want her to be able to check the box in
> the "Assets" form and it will move the record into the "Sold" form. The original
> record will always stay in the Assets table.
>
> How would I be able to do this?
>
> Thanks,
>
> Tiffany
>
>
>
>
> ________________________________
> From: Duane Hookom <duanehookom@...>
> To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
> Sent: Friday, October 7, 2011 10:09 AM
> Subject: RE: [MS_AccessPros] I need help understanding something....
>
>
> Since the forms are "identical" you can use a single datasheet form and open it
> with a filter for active or a filter for sold. Most of us use code to open
> forms using the DoCmd.OpenForm method. The line of code that uses DoCmd.OpenForm
> allows us to specify a WHERE CONDITION. Let's assume 1) your form name is
> "frmMyForm"2) you have a [Status] field with values of either "Active" or
> "Retired" Your code to open with active records might look like: DoCmd.OpenForm
> "frmMyForm", acFormDS, , "[Status]='Active'"to open to the Retired records:
> DoCmd.OpenForm "frmMyForm", acFormDS, , "[Status]='Retired'" Typically we might
> grab the "Active" or "Retired" value from a combo box or other control on the
> form that has the code to open frmMyForm. Duane HookomMS Access MVP To:
> MS_Access_Professionals@yahoogroups.com
> From: cc0623@...
> Date: Fri, 7 Oct 2011 15:27:13 +0000
> Subject: [MS_AccessPros] I need help understanding something....
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> If all my records were in one table could I make two identical datasheet
> forms from that table and in one datasheet a person could see all the active
> assets and in the other sheet all the sold assets?
>
>
>
> I am having a real problem explaining to my boss we should just keep all the
> records in one table and then she could use either form to see "active assets"
> and "retired assets". The control from one datasheeet form to the other would
> be a checkbox titled sold.
>
>
>
> Thanks,
>
> Tiffany
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar