I Have A Question About Copying Record Please

Sep 26, 2005

I have two tables, one is called Table A and the other is called Table B:

Table A contains these data:
I
II
III

Table B contains no data

in the form of Microsoft Access, I want to be able with a push of a button and DEPENDING on the selected item, I want that selected item to be copied into table B. For example, in table A I am selecting item II, when I push the button copy, I want that item to be copied into table B.

So the result will be:

Table A Table B
I II
II
III

How does one solve this problem please?

View Replies


ADVERTISEMENT

Copying Record

May 23, 2006

I have a db (sadly Access '97) for annual software renewals. Against each year there is a set of licences (can be up to sixty records), can anyone please tell me how from a form I can copy the licences from the previous year to the current year with the click of a button

View 1 Replies View Related

Automatic Sort After Copying A Record

Oct 3, 2005

I have a huge problem,
I have a form where there are companys with different contact-persons.
I sometimes need to add contact-persons for that company without typing adress and those kind of things, so i created a copy record button, But now i want the following:
If i copy a record (using the button) i want it to sort on [company] automaticly

Is this Possible, And if so Can some1 tell me hoe to do this

Kind Regards

SilverBlood

There's Nothing To Fear But Fear Itself

View 3 Replies View Related

Copying One Field From The Previous Record

Mar 1, 2007

Is there a way to make a button on a form that when it is pushed it copies one field from the previous record and then the rest is blank?

View 1 Replies View Related

Copying The Current Record On A Form To Another Table

Dec 17, 2007

is there an easy way to copy the current record on a form when clicking a command button such that a snapshot of that record is copied to a table for archiving purposes?

the table has about 120 columns so it is cumbersome to write an Insert Into sql statement within VBA code.

what i am attempting should be quite straightforward...i just want to take the current record in its entirety that is from a single table and append it to another table of the same structure.

any help would be appreciated!

View 12 Replies View Related

Forms :: Copying Memo Field Comments To Other Queried Record

Jan 15, 2015

I have one memo per change (user input)...I need to have the comment the user inputs to copy into other records that were queried. I tried insert. My coding does one of the records or all of the records ..I need it to copy just to the queried records ...and I have a query but no filter set.

View 4 Replies View Related

Forms :: Copying Data To A New Record - Skip Null Records

Aug 13, 2013

I've created some code that enables a user to copy an existing record to a new record, which looks like this:

Private Sub btnCopytoNewRecord_Click()
Dim Salutation As String
Dim First_Name As String
Dim Surname As String

'Copy fields to variables
Salutation = Me.Salutation

[Code] ....

This code is working fine, until it hits an empty field, and then I get an error message: Run time error '94':

Invalid use of NullIs there some code I can use to tell it to skip any null fields?

View 2 Replies View Related

Modules & VBA :: Copying Records From Linked Table / Each Record Slower And Slower

Jul 30, 2015

I have an access db with a linked table (to Sharepoint) which contains about 15000 records. I have to copy those records to the local access db. To do this I have a bit of VBAcode. It works, but for each next record that is copied it takes a bit longer. When starting the program the records are copied quite fast, but soon you see it slowing down until after a couple of thousand records it just goes too slow to be usefull, meaning it would take a lot of days to copy all records.

What I now do is let it copy 500 records and exit ms-access completely and then start it again and let it copy the next 500 records. This works but is tedious as I have to do it about 35 times. Why this gradual slowdown occurs?

The VBA code is pretty straightforward.(I use VBA because I do a bit of data wrangling while reading in the values of the records)

Code:

Dim importdb1 As DAO.Database
Dim rsimportdb1 As DAO.Recordset
Dim i As Double
Set importdb1 = CurrentDb
Set rsimportdb1 = importdb1.OpenRecordset("2015")
Set rsMain = CurrentDb.OpenRecordset("tbl_import")

[code]....

View 3 Replies View Related

Copying A Field??

Apr 14, 2006

I didnt know whether to post this here on in the table forum, so sorry if its in the wrong place!!

http://x402.putfile.com/4/10309543998.jpg

http://x402.putfile.com/4/10309512643.jpg

Ok, so in the frist screenshot the green box is based off of the table labelled 3. The red box is comprised of the InvoiceID from table 1, ProductID from table 2 and name/price is drawn from table 3.

The green box is used to view products, the red is an invoice. How do I add the currently viewed product (in this case, a case) to the invoice? I need to copy the product ID from table 3 to table 2. How do I go about this?

Many thanks! :D

View 2 Replies View Related

Trouble Copying DB From CD

Mar 13, 2006

I have an Access DB I have to put on numberous laptops. The DB is being transported via a CD. When i try to copy the DB from teh CD to a new folder on the laptop I get messages that the DB may have a virus and it cant be copied, or I need to install a microsoft service bulliten...xxxx ( I am not sure what the number is). The DB does contain VBA code and I am certain it is virus free. Is there some setting in access which enables this file to be copied on laptops which do contain virus or firewall protection or must I disable virus protection on these machines before instlaling the program or is it another issue altogether. Thanks.

View 3 Replies View Related

Copying Database

Mar 14, 2007

I'm new at all this so i'm sorry if it's a silly question, but i've split my db into a front and back end on a server but need to copy them and put a copy onto a laptop for my boss to take somewhere. How do i copy them so that they dont look for the other one in the server folder but on the hard drvie.

View 5 Replies View Related

Copying Data

Sep 30, 2005

im creating a fault logging databse, i have a form that shows all the "machines" details, (including its previous faults in a subform)
i have another form for inputting new faults.
what i want to be able to do is when you click on the "log new fault" the form will open up with some of the same details as the machine i was just looking at. e.g. it will auto copy over the "machine number" and "machine serial"
thanks

View 4 Replies View Related

Copying Value From One Textbox To Another

Jul 27, 2006

Hi all, I'm hoping there is a simple solution to this one.

To keep it simple, I have a continuous form showing a list of records. I have added an unbound textbox to this list.

I would like to copy the value of one of the fields for each record and paste it into the corresponding unbound textbox. I have tried this code:

txtJobPrice = txtCustomerPrice

but that simply copies the value of the record that has the focus and pastes it in ALL the unbound textboxes.

Can anybody help me with the code/solution to this problem please?
Thank you for your help if you can.
Carl

View 3 Replies View Related

Copying A Form

Nov 29, 2006

I am a beginner and I am having difficulty doing the following.

I have created a form from a query, (by agent)


The form took a little while to design, and I know how to copy the form, but how do you change the agent that is being referenced without having to go create the whole form layout again.


thanks for any help

Josh

View 4 Replies View Related

Copying Decimal Value Using VBA

Nov 19, 2014

I have a form containing two text boxes (1Average, Average1) that the first one is containing formula typed in form and the result of that is in decimal data type. I want to copy the result in [1Average] to the [Average1] text box for this i used the following VBA code:

Code:
Private Sub Text151_AfterUpdate()
[Average1] = Me.[1Average]
End Sub

But this code copy the value with full rounding the decimal part and doesn't copy the real decimal number for this i need to edit this code to copy the decimal value without any change and rounding.

View 8 Replies View Related

Copying Queries Across Databases

May 18, 2005

I have nearly 100 queries in an Access database which links to a SQL Server database. The queries are working just fine.

I have created a new Access database, linking to a different SQL Server database which has the same table layouts as the first. Is there a way to automatically copy the queries from the first Access database to the second?

View 2 Replies View Related

HELP! Copying Database Problem

Jun 27, 2005

Hello,
Excuse my inexperience, this is not my field. I am a network administrator and have never dealt with this problem before. I have been assigned the task of transferring a database (used by a security company to manage a gated community) to another system. I had to do this because the home owners association is changing security companies and they old security company is taking their computers with them. Now, I copied over all the files i could find and now that I am trying to set it up, I get the infamous error 3033, "you do not have the necessary permissions". I noticed that there is also a secured.mdw file. All i need to know is how to set up this database on a standalone system so that the new security company can access what they need. Thanks in advance for your help
-Nima Shariatmadari
Euclid Management

View 6 Replies View Related

Problem Copying Database From CD

Mar 19, 2006

I have experienced a problem copying a database from a CDR to the C Drive of a networked machine at work. What happens is that the Database attributes are changed to "Read Only" after being copied. I can change this easily enough but i dont want other users to have the same hassle.

This problem does not occur when i copy the same CDR to my desktop or laptop at home.

Anyone know why this might be?

View 6 Replies View Related

Copying Multiple Records

Nov 6, 2006

Hi all!

I need a little help with a new function in our CRM db (Ac2000).

I've made a system for handling sale-prospects. When a sale is done, I want to transfer the costumer info to the costumer table. All this is well, no problems with this.

BUT, each prospect (And costumer) has contacts. There can be several contacts to each prospect, connected with a prospect number.

The challange is to transfer the contacts as well. And assigning the new costumernumber..

Dont bother going techincal right away, but a point in the right direction would be great!

View 7 Replies View Related

Prevent Copying Of Database

May 28, 2007

Hi,
Does anyone have any ideas on how I might prevent a database from being copied. I have an application that I have set up with a number a tools to prevent exporting to an empty Access container, and from accessing the database design via the ShiftBypass feature, but the database can still be copied in its entirety. In some situations I would like to be able to add a feature to prevent this. Any suggestions?
FrankC

View 7 Replies View Related

Copying Elements Between Databases.

Nov 1, 2007

I wonder wether it is possible to copy elements from one database to another.
I have two copies of the same database. One for development and one for user access. If i for instance would like to copy a form from the development database to the other, how can this be done?

View 1 Replies View Related

Copying Of Data Between Table's.

Nov 25, 2004

I am creating a database where I want to have a table that has references to another table.

I have an ID field in both that are linked. I want to be able to on creation of a new record in this new table have it grab the ID field from the other table.

View 1 Replies View Related

Copying Records To A New Table

Feb 16, 2005

I am trying to help a new employee with an MS Access 2000 problem. The db was created years ago, and the main table (permits) needed some major changes. She created a new db with a table that has all the same fields as the old db, but many new ones as well. We want to now import the data from the old db's "Permit" table to the new db's "Permit" table. All the field names are correct, but we keep getting errors trying to import and export. There are approximately 940 records.

Is there an easy way to do this? Thank you!

Mike

View 1 Replies View Related

Copying Data To A New Table

Mar 1, 2005

hi

I am trying to copy the data from one table into another table. I then wanted to update the table where it is copied from. This data i then wanted copied into that table in another row.

Any ideas?

View 1 Replies View Related

Copying Table Contents

May 18, 2005

Hi,
I am trying to copy the contents of a table with 11 fields into a new table which is the same except for an additional two fields at the end.
Any advice would be appreciated..
Thanks..

View 2 Replies View Related

Copying Data Between Fields!

Jan 19, 2006

I have already asked this question before, but only one person responded, and it was not what I was looking for.

I would like to create a code that takes(copies) each record's data from a field and paste it into another existing field within the same table. I have about 2000 records... Your help will be highly appreciated.

It will have to be a VBA code or macro because I have to alter the strings that are copied before they are pasted into the other field.

View 2 Replies View Related







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