Move A Record In A Form To Another Form

Nov 30, 2006

Hi,

I created a small database and on my form (frmGE), I added a button "Delete". This button have to move the record (just the actual record and not all records) to the form "FrmRetired". The form "FrmRetired" have the same fields, except for the "comment" field.
I tried to programm it so when i click on it, the record will be moved to the "FrmRetired" and by the same time, the record will be deleted from the form "frmGE"

I created a ADD query, but I missed something...then for the "Delete" button, I added this code
Private Sub Move_data_click()
DoCmd.OpenQuery "QueryMove", acViewNormal, acReadOnly
EndSub

Any help will be appreciated.

Thanks

strong888hold

View Replies


ADVERTISEMENT

Forms :: How Move To Next Record After Fill Mask In First Record In Access Form

Jun 27, 2013

How move to next record (without enter) after fill mask in first record in access form?

View 4 Replies View Related

Forms :: Save Form Record On Move To Next Field In Record?

Jan 15, 2014

After I enter data into one field in a record I would like the form to save the record when I move to another field in the same record. It seems that the record is only saved when I exit it entirely. Is there a way to save a record when moving between fields in that record? Can this be done without using an Event Procedure for each field?

View 8 Replies View Related

Form - Move To A Field With New Record

Mar 16, 2005

I have a form we use for data entry, and not all the fields willhave data in them. When we click the new record button the cursor stays in the field where it was for the last record. We would like the cursor to move to the first field on the form everytime a new record is started.
Can anyone help me out here??

Thanks
Becky

View 8 Replies View Related

Form To Find Record And Move To Another Table

Oct 11, 2004

I'm trying to make a form with a single text box that will search for the contents of the text box in a table. Once it finds a match, it moves the record into another table. Anyone know how to do this?

View 4 Replies View Related

Forms :: Refresh Parent Form And Move To Next Record On Subform

Dec 10, 2013

I have two subforms on a "Page"/Tabs. Subform #1 is a continuous form which accepts data about dimensions of a pattern piece. The other subform needs to update its information display each time the last control of the first subform loses focus, because it tells me how much material is required for all pieces of this pattern that are entered.

My first feeble attempt at this was to add the following code to the "Lost Focus" event of the final control on the first subform:
Form.Parent.Refresh

This succeeded in forcing the second subform to re-run its calculation.

However, after the recalculation took place, I wasn't able to move to the next record on the first subform. This subform is a continuous form, and I need to be able to add another row of data and then see the second subform change based on the additional information in the first subform.

Obviously I've done this wrong.

View 1 Replies View Related

Forms :: Move From Last Field In Form To New Record Field On First Page

Aug 27, 2014

What is the best way to move from the last field on the last page of a form to a new record field on the first page?

View 5 Replies View Related

Form Header - Can I Move It To Side Of Form?

Sep 6, 2006

Hi all, I basically have a long form which requires me to use the right side scroll bar to complete everything.

I currently have a top header area (which is great because it is viewable even as you scroll all the way down).

I'm wondering if Access is capable of having a "side header" (for lack of better words), i.e. on the right hand side have just a few buttons or fields that always stays there even though I scroll all the way down the form? This would work the same way as the header, just on the side instead.

Any help would be appreciated.

Thanks in advance!

View 1 Replies View Related

General :: Making A Form Button That Will Act As TAB- Move From Field To Field In The Form?

Jun 12, 2013

I made a form for use in touch screen app. I would like to make a form button that will act as TAB- move from field to field in the form.

View 4 Replies View Related

Move Form To Top Window

May 25, 2005

I have a pop up form that appears (with a beep) when a condition occurs. I would like that form to appear on top of all other window applications.

Access is an active application but the pop up form is hidden if other applications are in use.

Is there a way to have the pop up window appear on top?

Any help would be appreciated.

View 6 Replies View Related

Using A Form To Move Records From One Table To Another.

Jun 27, 2005

Hello. I have a question that seems simple but I can't get it to work. Any help would be appresiated.

I need a form that will pull the oldest record from one table, allow the user to add a few fields to the record, then paste the record to a different table. when it is done the original record has to be removed from the original table.

I have tried using a append Query, but it moves all of the records at once and doesn't allow data entry on each record. I'm not sure if this would be done by a Query, Form or Macro. I have laid out the nessacary data flow below incase there is an easier way to do this.

Persons A,B, and C enters data into table 1.
later person D pulls the oldest record from table 1, reads the data then adds fields to the record and records it to table 2. The information is then removed from table 1. Person D then goes onto the next record from table 1. When person D is done, there will be no data left in table 1.

Any Ideas? or can someone point me in the right direction for help?

View 3 Replies View Related

Move Controls Between Sections On A Form

Dec 19, 2004

Using Access XP

I have a continuous form that shows the main fields in my table. In the page footer of the form I have a tab control that has 4 additional fields for each record. I want to give the user the option of “Show Details”. When the user clicks on “show details” I want to move the tab control with the additional fields to the detail row so the user can see them.



I know how to move controls with VBA by setting the Top and Left properties and how to expand the detail size, but how do I move controls from one section on the form to another section on the form i.e. from the page footer to the detail section

View 1 Replies View Related

Forms :: Move A Form Without Borders?

Mar 20, 2014

move a form without borders but not for microsoft access it's for visual basic microsoft access 2013

View 3 Replies View Related

Modules & VBA :: Move Between Records On A Form

Aug 11, 2014

i have a form, where a user inputs a account number inputting the account number, then populates all the relevant table fields, into the form for the user to edit.however if there is more than one account, with that account number, how do i get it so they can cycle through on the form?

View 2 Replies View Related

Forms :: Move Form Out Of Access?

May 30, 2014

Is it possible to set a property to allow the user to click and drag an open form out of the Microsoft Access 2010 parent window? Specifically to a second monitor.

View 3 Replies View Related

Forms :: Move Subform To Behind Main Form

Apr 13, 2013

I have a form with a subform in it. The subform is actually going to actually have more information and is going to take up the majority of the form. The reason why it's the subform instead of the main form is because of the nature of the parent/child relationship.

Layout-wise I'd like to have the content of the main form in the top left, with the subform taking up the space from the top right down to the bottom. This ends up covering the content of the main form in the top left. I tried using the Send to Back function on the subform but it still blocks the main form.If there's no easy way then I guess I'll just have to have the entirety of the subform below the main form content.

View 2 Replies View Related

Modules & VBA :: Move Field On Tabbed Form

Sep 11, 2014

If I have a field in a tabbed form (the form has pages), can this field be moved from a tab to another programatically?

The form is called "ProjectMain". The field is called "Lenght" and the page (form tab) it is on is "specs1". Sometimes I need to have this field in the page (form tab) "specs2"

View 3 Replies View Related

Macro To Move Completed Order To Another Form

Aug 24, 2015

I have created an access database to track orders through out production. I have also created a form labeled "orders" with a subform where it has all the orders information, customer info and product info. Along with this there are 3 check boxes for each order they are labeled, "Routed", "Pressed" "Finished". I am looking for a macro for when I click the "finished" check box that order is moved to another form to reduce the amount of clutter on the orders form. Is there anyway to do this?

View 1 Replies View Related

Move Or Copy Email By Drag & Drop On Form

Sep 27, 2006

Hi all,

Is there a way that I can move or copy emails directly from Outlook to a form by using drag & drop?

I know how to do for the files in explorer, but can't figure out how to do from outlook.

Thanks,
Jatz

View 1 Replies View Related

Move Or Copy Email By Drag & Drop On Form

Sep 27, 2006

Hi all,

Is there a way that I can move or copy emails directly from Outlook to a form by using drag & drop?

I know how to do for the files in explorer, but can't figure out how to do from outlook.

Thanks,
Jatz

View 1 Replies View Related

Forms :: How To Move Records With Down Button In A Tabular Form

Jun 28, 2013

Is it possible to move down records with the down button in a tabular form to the same field in the next record.

View 11 Replies View Related

Forms :: Can't Move Individual Fields When Formatting Form

Oct 15, 2014

I've just created a form and I'm trying to move and size the fields but they seem to be grouped together and whatever I do to one happens to all of them. I select one field and just that field has the orange outline but when I move it they all move.

View 5 Replies View Related

Cannot Move Database Up To Front View Behind Form Switchboard

Apr 13, 2012

Hard to see the image but basically, I can't seem to bring the database behind the form to the front to view it when I click on it. I've never encountered this before.

View 5 Replies View Related

Queries :: Form Filtering And Creating Query - Move Top X To New Table

Jan 24, 2015

Tried to find things but being a mix of a couple of different actions havn't been able to actually find it

So basically I found a awesome form somewhere that builds the SQL query based on all the users selections.

When you hit the create button it will save the query and update the sub data sheet below with your query results.

From here the part I'm lost on is getting the TOP x number of records and moving them to a new table, I wanted it to work on the 2 drop down boxes that are on the form. select your values and hit the button.

I'd imagine it would be a sub query that I'd use for the top x like I have in the past but I just can't seem to get it to work

Quick steps

1. create your query
2. check your data in the sub datasheet
3. decide the number of records to move to the new table
4. select the name
5. hit the button

This would copy the ban, xcv & dfs fields from the importeddata table to the moverecordshere table & also update persname in the moverecordshere table with the name selected in the form.

Sample db attached ....

View 1 Replies View Related

Forms :: How To Move Up And Down Selected Item In Access Form Listbox

Feb 10, 2014

I've designed access form with one listbox and added 'up' and 'down' buttons to move up and down the selected item in the listbox. i.e from its selected position to one item up when 'up' button clicked and same as one item down when down button is clicked. Any VBA code will do this functionality?

View 7 Replies View Related

Move Add Existing Fields Outputs On Form In Design View

Aug 5, 2015

[URL] .....

In the Lesson tutorial shown above I am clicking on tools and adding existing fields. I get a lot of output label and text box pairs for each field that I add.

However, they are all on right below the other. That is no problem just move them. No way.

Whenever, I move it a label and test box for say Order Status, I get ... nothing. It stays where it is.

They (label and text box) do not move together. So how do I get them to move together.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved