Help Moving Records From A Form

May 7, 2005

I have an Employee Database with a form that displays the employee record. When an employee leaves they want to be able to click on a button on the form and have the record moved to a different table. My thought was to do a append query to move the record from my active employee table to the termed employee table, but that would still leave a copy in my active table. I'm not real up on coding that much so Im not sure if there's a way to have code move a record from 1 table to another table or copy the data from 1 table to another table and delete it from the first table. Any help would be greatly appreciated.

View Replies


ADVERTISEMENT

When Moving From Records On A Form

Sep 10, 2004

I was wondering if anyone knew how to check when the user has clicked to move on to the the next record on a form?

Ed

View 1 Replies View Related

Moving Records

Mar 6, 2005

I would like a button on my form that will move a record from one table to another. Can anyone tell me how to do this

View 2 Replies View Related

Moving Old Records.

Oct 25, 2005

hiya!

i have a database that holds details of calls that have been answered on the phone concerning problems with computers.
details that are recorded are caller name, and date of call etc...

however, i want to know if there is a way that i can move all calls recorded BEFORE the present date to another table ( say a "past calls")..?

is there a button that i can put on my database that will run a function and move all calls recorded before the present date to another seperate table..?

thanks everyone!
johnny
:)

View 1 Replies View Related

Moving Records

Jun 27, 2005

Could someone assist me in getting code that allows me to move a record from one table to another when the user clicks a button.

Thanks

View 13 Replies View Related

Moving All Records In Field Down 3 Records

May 30, 2013

I currently have a database that I had to copy over each field from another databse to create the one i have now. When i copy the records from one field over it appears they all move up three spaces for some reason is there a equation i can enter to make them all move down three records in the table?

View 2 Replies View Related

Moving Invaid Records

Nov 28, 2006

Hi again

I have a table that’s full of records, I want to split it into 2 separate tables (identical structure but they have input masks), The input mask is set to LLL0000 all I want to do is send valid records to one table and invalid ones to the other.

I think the best way would be an update query but it doesn’t check the input mask only the validation (and trying to break the string apart using an expression is impractical and lengthy)

Can anyone think of any way of splitting this table – I’m getting rather desperate now and have been trying for over a week with no success

Any help is greatly appreciated

Thanks
Matt

View 3 Replies View Related

Moving Records In The Same Table?

May 22, 2006

Hello there,

Is it possible somehow to move a record in the same table, to different row (in the form)? Or in other words, is it possible manualy adjust the position of records (rows) in a report?

I have a continuous form, where rows are filled with data (e.g. 10 rows ).Then i have report , which looks the same as form (rows, and their order). But sometimes user wants to move certain position (row) up or down, to be it on top or bottom or two places above, or below etc, of row list....is there any easy way to do it? Like some button press, where you could swap position with next record (next row) .....

Or just delete (everything) and fill again from beginning the way he wants...

Thanks!

View 4 Replies View Related

Moving Record Information To New Records

Dec 29, 2005

Hi, found this forum looking for an answer to this question. Hope someone can help.

I'm trying to build a database that tracks electronic components. Mostly the database tracks location movements, but also repair issues and other possible changes. I'm thinking the best way is a database that has a record for each move, and any other changes are included in each record.

My question is, is there a way I can easily have the current information be propogated over to a new record, where it could then be modified? Example: I'm looking at a record of an item that was just returned to me. I would like to click a button on the form which would create a new record, then move all currently displayed information into that record.

Thanks for any help.

View 3 Replies View Related

Moving Records To Another Table Then Delete

Mar 15, 2007

OK guys, ive done some searching and saw some stuff on this, but everytime I try something I get a INVALID SQL error message. So Im hoping you guys can help out cause Im lost right now.

I have a 2 tables, Training and Schedule. Training contains all the employees training records. Schedule is meant to be a temp table where the supervisors can enter the training and then once completed, can check the COMPLETED checkbox and hit the LOAD TO TRAINING RECORD command button and it moves ONLY the files for that trainee (a combo box) with a completed checkmark to the training table.

Ive tried this code sooooooooo many ways and its giving me a headache. My original way didnt work at all (had a lot of Do..Loop and With Statements, and then someone posted something about Archiving which is the code Ive gone off of now). Any help you guys can off would be awesome!

Heres what I got:

Private Sub cmdLoad_Click()

On Error GoTo Err_Load_Record_Click

UploadHistory

Exit_Load_Record_Click:
Exit Sub

Err_Load_Record_Click:
MsgBox Err.Description
Resume Exit_Load_Record_Click

End Sub

Sub UploadHistory()

Dim DB As Database
Dim WS As Workspace 'Current workspace (for transaction).
Dim strSql As String 'Sql Code.
Dim strMsg As String 'MsgBox message.
Dim bInTrans As Boolean 'Flag that transaction is active.

Set DB = CurrentDb()
Set WS = DBEngine(0)
WS.BeginTrans
bInTrans = True
Set DB = WS(0)

On Error GoTo Err_UploadHistory

'Execute the add.
strSql = "INSERT INTO [Training] " _
& "(TaskNumber, Date, Hours, TrainerLast, TraineeLast, Qualified) " _
& "SELECT " & "Schedule.Task, Schedule.Date, Schedule.Hours, Schedule.Trainer, " _
& "Schedule.Trainee, Schedule.Qualified FROM [Schedule] " _
& "WHERE (((Schedule.Trainee) = " & Me.TraineeCombo & " AND (Schedule.Completed)= 1));"

DoCmd.SetWarnings False
DoCmd.RunSQL strSql
DoCmd.SetWarnings True

'Execute the delete.
strSql = "DELETE FROM [Schedule] WHERE Trainee = " & Me.TraineeCombo & " AND Completed = 1;"

DoCmd.SetWarnings False
DoCmd.RunSQL strSql
DoCmd.SetWarnings True

'Get user confirmation to commit the change.
strMsg = "Upload " & DB.RecordsAffected & " record(s) from " & Me.TraineeCombo & "?"
If MsgBox(strMsg, vbOKCancel + vbQuestion, "Confirm") = vbOK Then
WS.CommitTrans
bInTrans = False
End If

Exit_UploadHistory:
'Clean up
On Error Resume Next
Set DB = Nothing
If bInTrans Then 'Rollback if the transaction is active.
WS.Rollback
End If
Set WS = Nothing
Exit Sub

Err_UploadHistory:
MsgBox Err.Description, vbExclamation, "Upload failed: Error " & Err.Number
Resume Exit_UploadHistory

End Sub

View 4 Replies View Related

Moving Through Records And Updating Sub Forms

Jan 23, 2006

hi all,

I have this database I'm working on and have a couple of issues I can't work out.

The first is this, I want to have my sub forms go to the last record when moving through the main form, currently I can only get this to work when I open the form?

If I move through the records in my main form (forward and backwards), the two sub forms go to the first record only, so how can I get them to go to the last recor?

I've attached the DB to show you what I mean.
Thanks in advance
Tez

View 3 Replies View Related

Tables :: Moving Records From One Table To Another

Jan 16, 2014

I have to move records from one table to another.

When we lose a client I need to take them out of my current table and put them in my dropped table.

I don't want to lose my summary info and I want the dropped client to keep it's ID Number which is an identifier.

Seems I can't just copy it from one table to another and then go back and delete it from the Current.

Seems I can't cut from Current and paste into Dropped.

In a perfect world it would be great if my boss could just check a box in Current Table and the record moved to Dropped all by itself!

View 7 Replies View Related

Moving Records Fluidly Between Tables

Sep 5, 2014

I am designing a database to keep track of a state's surplus fire property to be doled out to volunteer departments as I see fit.

I have a table for surplus property that includes what department currently has the surplus property, what type of equipment it is and additional equipment information. I also have a table for "pending transfer property" to track what pieces of property I have decided to potentially assign to a fire department from the state's surplus inventory.

My problem comes when I need to transfer a piece of equipment from one department to another. I would like the surplus property table to automatically remove the property from the surplus property table to the pending transfer table so that it will not be listed on a pending transfer and in the states surplus at the same time. On the flip side, if a transfer falls through I'd like that record to repopulate in the surplus inventory again.

View 2 Replies View Related

Form Validation Before Moving To Another Tab

Dec 27, 2007

All -

I am experiencing an issue with the following code. The code works fine, I'm just not sure where to place it on a subform in a Tab Control to ensure that all validation is done before the user can move to another tab.

Any ideas what event I need place this on? I tried the BeforeUpdate and it popped up first error box, but then proceeded onto the next tab that I clicked.

Thanks!


'Enforce required fields on a form
Dim ctl As Control
For Each ctl In Me

If ctl.Tag = "Required" Then
If IsNull(ctl) Or ctl = "" Then

MsgBox "You must complete all required fields to continue", vbCritical, "Required Field"
ctl.SetFocus
Exit Sub
End If
End If
Next
'All fields are validated, now set ctl to essentially being unbound

Set ctl = Nothing

View 2 Replies View Related

Moving Data From One Form To Another

Dec 12, 2005

Hi,

I have read a couple of threads about what I am trying to do on other forums and I wanted your views please.

Basically I have to Forms, on form one I have a basic quote generator which will output a specific value in a textbox in form one. If that quote is accepted I would like that value to be feed through to a field in form2 which is linked to a table. I have a button "Accept quote", on form one which opens a new record in the table feeind form 2.

Is this possible??

Regards

View 2 Replies View Related

Moving To Field In Sub Form

Jul 28, 2006

I have these sub forms which is in datasheet and single form view in the main form.

I can't move from the field in the main form to the one in the subform with the tab or enter key. It just keeps running to the next record.:confused:

View 2 Replies View Related

Moving A Form To A New Record On Open

Apr 21, 2006

Ok i'm opening a form with the intention of grabbing the last reference number and adding one then moving to a new record.

However the form opens on the first record. Here is my code.

Private Sub Form_Open(Cancel As Integer)
Dim lastbookref As String
Dim expans As String
Dim Newbookref As Integer
Form_frmbooking.RecordSource = "SELECT tblbooking.Bookingno, tblbooking.Clientno, tblbooking.Sampledate, tblbooking.Sampleref, tblbooking.[Sample place], tblbooking.Recieveddate, tblbooking.Recievedby FROM tblbooking WHERE (((tblbooking.Bookingno) Like """ & Left(Form_frmClient.Clientname, 3) & "*""));"

If Form_frmbooking.Recordset.BOF = True Then
Form_frmbooking.Bookingno = Left(Form_frmClient.Clientname, 3) & "/00/0001"
Else
Form_frmbooking.Recordset.MoveLast
lastbookref = Form_frmbooking.Bookingno
DoCmd.GoToRecord , , acNewRec

Newbookref = Val(Right(lastbookref, 4)) + 1
Select Case Newbookref
Case Is < 10
expans = "000" & Newbookref
Case Is < 100
expans = "00" & Newbookref
Case Is < 1000
expans = "0" & Newbookref
End Select
Form_frmbooking.Bookingno = Left(Form_frmClient.Clientname, 3) & "/00/" & expans
End If
End Sub

Anyone have any idea why this is not moving the new record.

Even more bizarrely the new booking reference is inserted into the new record....its just that the form opens up on the first record.

View 1 Replies View Related

Moving Form To Top Right Of Access Window

Feb 15, 2006

I have a form which I want to move OnLoad to the top-right of the Access window. Something like this:

Private Sub Form_Load()
Me.Move Right:=150, Top:=150
End Sub

But there isn't a Right:=, only Left:=. So maybe I could find out the width of the Access window? Is this possible?


Thanks for any advice.

View 6 Replies View Related

Moving Instructions In Unbound Text Box On The Form

Oct 9, 2005

I need to display some of the insruction lines in unbound / bound text box that will gradually moves up.

Example :

"This multiuser client server db is licenced to "ABC & Co.". This sofrware is to reduce cost of production and it increases speed of your production process more...."

These instruction lines may be arojnd 10-15 lines. I need to display it as non-stop moving up text massages on the main form once the data base is opened.

Is this possible? How?

With kind regards,
Ashfaque

View 5 Replies View Related

Forms :: Moving Form By Code On The Display

Jul 22, 2014

I'd like to do the following: when the user does something on Form A, Form B has to be open and the Forms should be located on the sides (Form A to the left side, Form B to the right side) of the display so the user can see them at a time.

However both Form A and Form B has an automatic centering function set when used alone.

Is there a way I could push this from code? I can't fine anything like that among the form's property.

View 2 Replies View Related

Forms :: Moving View Of A Form SetFocus?

Sep 19, 2014

I have a data entry form.

There are some selection controls that require the user to enter data before the next one becomes enabled.

My form then has two different groups of controls that the user see's depending on the selections earlier, either one group or the other is made visible.

My question is how to move the view so that the appropriate group is where I want it.

If I use setfocus to a control the form moves but not how I want it to (The control that i setfocus on is half way up the screen rather than close to the top.).

I know there must be a better way, I tried move size but it didn't seem to do what i wanted.

View 4 Replies View Related

Prevent Cursor From Moving On Image / Form Change

Feb 8, 2007

I've created a form. Within that form I have an image control. I am using this code to pull the corresponding plant image from a folder filled with JPGs.

It works just fine except one thing. When I change from record to record my cursor jumps to the center of the pulled JPG. I don't want my cursor to move at all when loading these images. Is this possible? Thanks.


Private Sub Form_Current()

Dim FileExistsbol As Boolean
Dim stFileName As String

stFileName = CurrentProject.Path & "- Landscaping Material Images" & _
[LandscapeCommonName] & ".jpg"
stFileName = Trim(stFileName)
FileExistsbol = Dir(stFileName) <> vbNullString

If FileExistsbol Then
[LandscapeMaterialImage].Visible = True
Me![LandscapeMaterialImage].Picture = stFileName
[LabelNoPictureAvailable].Visible = False
Else
[LandscapeMaterialImage].Visible = False
[LabelNoPictureAvailable].Visible = True
End If

End Sub

View 2 Replies View Related

Forms :: Find Current Record When Moving From One Form To Another

Aug 7, 2013

Lets say,

Form A has fields: ID, LN and FN

ID LN FN
1 A F
2 B G
3 C H
4 D I
5 E J

Form B has fields: ID, LN and TR

ID LN TR
1 A Y
2 B N
3 C Y
4 D Y
5 E N

I would like to be able to switch between these two forms and the form automatically set focus to the record that I was on the form prior. Meaning if I am on record 3 on Form A and navigate to Form B, I would like to automatically set focus to record 3. Is this possible?

A possible issue after this gets sorted out is what happens if with the same scenario above record 3 does not exits? is it possible in that instance to simply requery the form?

View 11 Replies View Related

Forms :: Cursor Moving On Multi Subforms In A Form?

Mar 6, 2015

Issue with Cursor moving on multi Subforms in a form.

I have 2 sub-forms in a main form as per screenshot. So Cursor moving from main form to 1st subform working well. After can't move the cursor from 1st subform to 2nd subform with tabbing or entering. Still there in 1st Subform in the last entered filed after tabbing or entering. I've checked on tab orders also they shown correct but it is can't move to 2nd subform.

View 2 Replies View Related

Forms :: Creating Required Field In A Form Before Moving To Next Record

Feb 5, 2014

I have created a Form based from a Table. On one of the fields, I need to be required inside the Form before moving to the next record of that form. I can not make the required field in the table, because I have to append information day to day.

Also, the required field is a combo box option that is limit to the list.

What kind of Code I can do inside the form of the specific field to make it required before clicking onto the next record. It does not matter if the processor closes out of the form before updating, only if moving to the next record.

View 5 Replies View Related

Forms :: Stop User From Moving To Next Text Box In Access Form

Jun 20, 2014

I have a form in which user will enter few values but I need users to enter the comment in relevant text box too only if they have any non zero value.

I have attached an example for reference....where red encircled portion is for values and blue is for relevant comments. If value is non zero then user should be enforced to enter the comment too......system should not allow user to move forward or backward until there is some comment.

View 1 Replies View Related







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