I have a program that you can search all or a specific record. Once you find the record, you can double click on it and another form will open up with only that record's information.
What I need is to have a button that will copy this record's name, address, phone number, contact info, and etc --> and create a new record with a new Record Number using the current record. This will allow the user to avoid entering in the same information again. For confirmation purposes, I would like to have a SAVE button to verify and save to the DB.
Does anyone have any inputs on how I can do this? If you would like to see the program, please let me know.
Thanks in advance for all your help and suggestions!
Im a newbie at developing access databases. I have just finished creating my first application. The problem i have is that i would now like to create an exact copy of my table definitions without all the junk data i have been entering while i have been creating the application. I would like to use this copy so i can link the finished database to it. Could someone please offer me some advice as how to best go about doing this ?
I have a form with several subforms for entering information while surveying rooms in a building. I am trying to create a button to copy records from one of the subforms if the data is the same (for example if there are 3 types of flooring in multiple rooms) and append it into the same subform with a different space ID. I can not get it to recognize the Space ID on the current record. This is what I have in the command button code:
Private Sub AppendFloorCmd_Click() Dim FloorTypes As String, SpaceUpdate As String Dim CurrentSpace As TextBox Set CurrentSpace = Me.SpaceID FloorTypes = "INSERT INTO FlooringSurveyTable (FlooringHomoID)" & _ "SELECT FlooringSurveyTable.FlooringHomoID FROM FlooringSurveyTable " & _ "WHERE (((FlooringSurveyTable.SpaceID)=[Enter Space ID to copy]))"
[code]....
When I click the button, it appends the right records but makes me type in the current space ID - I've tried a bunch of ways of naming that control, but it will not work.
I have a folder which holds 1000s of pictures organised in subfolders, for example:
D:~AI Database Print Scans2009family and D:~AI Database Print Scans2009holiday
And so forth. In total at the moment 17 main subfolders, each of which hold another 2-3 subfolders.
I am putting together a database to bring pictures together with all sorts of details. I import the picture via hyperlink and complete the various fields. All that works fine but there are a lot of pictures! And it gets confusing to see which ones have already been entered into the database and which ones haven’t.
One solution for this is to copy the pictures that have been “completed” to another folder. I have found a way to do that:
Dim fs As Object Dim oldPath As String, newPath As String oldPath = Forms!frmPrintDetails.txtPath1 newPath = "D:~AI Database Print ScansCompleted_Entries" Set fs = CreateObject("Scripting.FileSystemObject") fs.CopyFile oldPath, newPath Set fs = Nothing
Works fine, but the problem is that I loose the subfolder structure, it copies all pictures to the same main folder. I’d like to maintain the subfolder structure and add code to create the correct subfolders and next copy the picture. With the different paths I’m lost. I don’t know how to extract the correct path in code. I’d also like to either rename or remove the picture once I have completed entry of the details. The problem I have again is that I don’t know how to code for a changing path.
The underlined part (acCmdRecordsGoToNew) is false part of this code, because it copies the Adress Info to a new record, instead of copying it in the same.
-Is there someone that can help me with this problem, to make the copy-button in the Form run properly?
-Are there other options to achieve te same?
I have put in a attachment, to give you guys a visual example of what I mean.
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
I am running A Form. I have created it that I if I Double Click on one of the fields, it automatically creates a copy (which is run from a Query). That all works fine. My problem is that my Table has 500 Records and I want the Form to jump straight to the New Record after it creates it. Here is my Code: Code:Private Sub USName_DblClick(Cancel As Integer) DoCmd.OpenQuery "Copy_Drug" Me.RequeryEnd Sub
I have the employee data record... I want copy of the same record to insert in table but with different employee id and Site through forms. StaffNo is the primary key.
I have a database for staff to request checks to be cut. I have one table with a group of regularly used payees & addresses. A second table stores data for each individual check request. I need to be able to copy a record from the addresses to the check request. I do not want to add all addresses to the address table, as it is only for commonly used payees. So from the check request table, I am able to lookup a payee, which opens the address form to display the address. I need to be able to copy the displayed address to the open check request form.
In the attached db I have a form I use in datasheet view to show data. I have an attached subform that the user updates. The user opens the subform by clicking on the + sign to open the subform, the updates the fields clicks the + sign again to close the form. Then repeats for the next record. What I would like to happen is when the user clicks the + sign again to go to a new form is to have the data from the fields below to auto popualte the new form instance. I could do this with a continuous form and it worked but the users would like to see the data in a datasheet design. Is this possible? Thanks...
I have this form that contains a good number of bound fields. The behaviour I would like to add to this form is, upon the press of a button, a new form would pop open (same form) as a copy of the current. This would make entering in multiple items with very few differing fields much easier.
I don't know a good way to do this. I mean I could list out each control, enter it in a new row in the database, and then open the new form pointing to that record, but that seems ridiculous. That would be like 500 lines of just gathering the data and inserting.
So I decided to cycle through all the controls, pick out the types I need, such as textboxes etc, and then get the value from that and put it in a new entry. So I would end up getting the name of the field in a variable, (named field), but I am unable to extract the value from the form from this string. Something like _ Me. & field & .Value _ really doesn't work. Anyway I can use a variable to get the value of a field?
Hi, I have a form ('A') for editing new records in table 'T' . I want to be able to copy data (just some fields) from another record to this new record.
This was my plan: On this form 'A', I made a button "copy another" that opens a form 'B' that should show all the records from tabel 'T'. User select a record and then all the necessary fields will be copied to the new record in form 'A'.
However, the first error starts when I open this form 'B'. I get the errornumber 3211. The err description is (I have to translate because I have a dutch versoin). "The database engine can't lock the table 'T'. Table 'T' is in use at the moment by another user or proces". How can I make this work? I understand that the table is in use, because form 'A' is using the same table.
Hi, I have a Edit Form, where users edit the customer information. I want to add a Button which creates another copy of the same record in the table. How Can I achieve that? any suggestions? Regards -KJ
I have followed the development of Access from the early beginning, and even before the early beginning with databases like Q&A, Foxbase etc. I have survived with Access 2002 for a long time. However, the unavoidable string of events has given us more and more complex systems (for the noble purpose of making life easier, I assume). In my particular case I now have an up-to-date system (Access 2010) that I do no handle. My impression is that also the experts have trouble. I am now close to discard Access 2010 as too complex for my simple needs.
Here follows an example of a database that was easy to construct in Access 2002 but which I have major problems to reconstruct in Access 2010: The database in question shall keep track of expenses. The database have fields like date, project, type of merchandise, description of merchandise, price, name of store, notes, hyperlinks.
On opening the database I want a search screen (a form) that is exactly identical to the records I am going to produce (except that all fields are empty). On the search screen I put a search topic (e.g. the name of a store), and then initiate the search by pressing a fast key. The search result generates a number of records, I move on to the last one, I copy it, and on the copied record I do the necessary adjustments. The whole operation is done in a matter of seconds. The procedure is functional, and it gives me what I want.
I have made some "work around" procedures that bring me to the final touch, namely to copy/paste the record.
Hi I need to copy some data from last record to next(New record), when a user clicks a button on a form. I don't want to copy all the data.
An example would be booking in items from an invoice: Company would be the same Invoice number would be the same Product code would be different quantity would be different
Hope this makes some sence, and i'm not being stupid:rolleyes:
Is it possible to copy the current record on a form to a different table? Example:
Form Name = Training Orders bound to a table with the same name. 2nd Table Name = History
I need to export certin fields from the Training Orders Form into the History Table. Below is the way I am trying to make it happen, but it does not work.
With Me.RecordsetClone .AddNew ![Forms]![History]![Last Name] = Me.[lastname] .Update
Suppose I have a customer database. Is there a way if I click on a button, it will create a new record and copy some of the info from the previous record?
Is it possible to send a copy of a record to another table already created? if so what is the sql statements to do so or any other ideas that you might have.
I have fields on a form for the Date, the Start time and the Finish time. These won't change for the next 120 records. So, upon opening a new record, I'd like the Date and times to appear there already. But here is the crux: After about 120 entries, the date and Time changes, for the next 120 entries. So, once the 'batch' is finished, or I close access, the values do not need to be remembered until I enter a new record.
I copied something like the following from a book and tried running it with various modifications, just for the Date to start with, but no luck. (It did strike me as too simple for something, clearly, as unbelievably TRICKY as my problem...) I did find quite a few posts on this here but none seemed to work for me, or made sense to me in the slightest. (I did mention that I'm a complete rookie, didn't I?)
Private Sub Acquired_date_AfterUpdate() Me!Acquired_date.DefaultValue = "'" & Me!Acquired_date.Value & "'" End Sub
ok so I have two forms open: One is a SP Bookings form with a subform SPDetails Query subform. The other form is the not connected/related SP Contacts Query form, to which users enter Full Name weight age ect. Need to copy the names of the new customers Full Name to the Lookup Contact Column in SPDetails Query subform. I got this far, with my trial runs are commented out. The only thing it does when I click on the button is move to new record on Sp Contacts Query Full Name and Copy the previous record. How do I get the button to copy the Full Name from form SPContacts Query.Full Name to the SPBooking Query.subform SPDetails Query Subform.LookupContact
Code: Private Sub Command52_Click() Me.Full_Name.SetFocus DoCmd.RunCommand acCmdSelectRecord
I found and pasted some code which copies records from the previous record on the form. Seems to work well, but I was wondering if there is an issue with the copying of the first field which is a combo box?
Currently I have created a data base and form. I am at a point where I need to copy data from one record specific field to a different field in the new record all while creating a new record.
Create a new record
Copy field in LastWeekInfo current record to New record ThisWeekinfo field
I have uploaded a small database. I keep track of payments for people who receive a language proficiency allowance. Usually the members receive this allowance for two years. Sometimes they receive it for one year.
Lang Level DateQuaFrom DateQuaTo DatePd From DatePd To Hindi Inter 15-Dec-12 14-Dec-14 15-Dec-12 14-Dec-13 Hindi Inter 15-Dec-12 14-Dec-14 15-Dec-13 14-Dec-14
There is a field called NoOfPays . If this field value is 2 in the first record then I want it to insert a second record as shown above. How do I do it. I tried to append but it is not working.
Now copying the record with the maxID is not correct.
Let's say, I'm updating a record, and I have a combo-box that says transfer and another combo-box that states "where to?" - or words to those effect.
Each record has a field for credit value and a field for debit value.
When I've finished entering the current record, I want to run code that fires the event, so, copies all the data from one record, to create a new record, BUT...
1) changes the "where to" from the old record to "From" in the new record. 2) changes either the credit or debit value, to the opposite in the new record?
I would like to do this from a sub-form. I can copy a whole record, no problem, but can't seem to change field values.
