Copy A Mdb To Usb

Oct 16, 2006

I have created a database with a number of backends. Users have the database on their home PC. I want a simple visual way of copying one of the backends to a usb drive and then having the ability to transfer the mdb from the usb to their work machine.

View Replies


ADVERTISEMENT

Copy Button In A Form To Copy Fields To Other Fields In The Same Record

Sep 23, 2005

Hi there,

Can someone help me on this issue?

I want to copy Postal Address Information to Visit Address Information wthin the same record, in my Contact Database that I am building at the moment.

I want to copy 4 fields to 4 other fields within the same Record.

This the current code I use for the Copy-button:

---

Private Sub cmdCopyFields_Click()

Dim v1 As Variant
Dim v2 As Variant
Dim v3 As Variant
Dim v4 As Variant


v1 = Me!Field_a.Value
v2 = Me!Field_b.Value
v3 = Me!Field_c.Value
v4 = Me!Field_d.Value


RunCommand acCmdRecordsGoToNew

Me!Field_e = v1
Me!Field_f = v2
Me!Field_g = v3
Me!Field_h = v4


End Sub


---

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.



Thanks in advance,

Quinten

View 3 Replies View Related

General :: Make A Copy Of BE File Rather Than To Make A Copy Via Code

Nov 26, 2012

Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.

View 4 Replies View Related

Copy Mdb

Jun 14, 2007

How can I copy an existing database complete with tables, queries, forms and reports but without the data to start a new database based on the original

View 1 Replies View Related

Copy DB

Jan 14, 2005

hoi,

I'm using 2 db one local (LocalDb) and one on a server (serverDb). If the localDB don't have a connection with the server it use a copy of serverDB that local is.
Now must it be possible by clicking a button (in localDB) to copy the database serverDB to its local location.

Is this possible? So yes how?

thanks

koen

View 6 Replies View Related

How To Copy A Form?

Apr 19, 2006

This is actually a rephrase of the scenario I posted in the other thread yesterday.

I have a form, titled "Danish", now i wan to make a copy of it, i.e, its textboxes, buttons and save the new form as "English". How can i perform ALL of the above in coding?

Thks..

FT :)

View 4 Replies View Related

Copy Function

Oct 28, 2005

Hey what does anyone know anything about a copy function? I think it is vb code but I am not sure. what i am trying to do is to. create a id number using the last 2 digits of the year from the date, and adding a "-" and adding the last record number plus 1... SO I think I have the date things but I am not sure how to do the last record id number plus 1?? I was told it could be done with a copy, I am not sure. what ideas do you have about it??

thanks

View 1 Replies View Related

Copy And Paste

Apr 5, 2006

Hi all,
I get information sent to me on email. This information then needs to be transfered onto a database. the information is always the same.
name *****
Date of birth **/*****
consultant ******
ward BLA ******

Is it possible to copy and paste all the information in one go from the email and paste everything into its correct places on a form with one action? This would save alot of time & effort on the users part.

Many Thanks

Samzie

View 14 Replies View Related

Copy Report

Dec 8, 2006

hi

i have a database x (x.mdb) and y (y.mdb)
i would like to copy some report from x to y

any idea?

thank

View 1 Replies View Related

Copy From One Record To The Next

Jul 10, 2007

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...




Me("Type").DefaultValue = """" & Me("Type").Value & """"
Me("Severity").DefaultValue = """" & Me("Severity").Value & """"
Me("EventStatus").DefaultValue = """" & Me("EventStatus").Value & """"
Me("AdminDate").DefaultValue = """" & Me("AdminDate").Value & """"

View 1 Replies View Related

Copy Function?

May 19, 2005

Is there a copy function in a query.

I need to copy a field from the direct previous record in a table and have it loop till the end.

Any thoughts?

Thanks everyone.
Your time is appreciated.

View 2 Replies View Related

Copy Queries

Dec 17, 2006

I have 4 different sites with their own data source and have created 33 Queries for the first site. Is there a way I can copy the queries to the other sites instead of recreating them manually? All sites have their own data that is in the same format. All the information is in the same format and similar (different amounts, dates, but all in amount and date fields), they are named differently corresponding to their sites.

EX:
Site 1Site 2

Data 1Data 1
Data 2Data 2

33 Queries(needs the same queries as site 1)

View 1 Replies View Related

Update Or Copy?

Mar 15, 2007

I have two tables. First table "Orders" is parent, secondary "Works" is child.
In Works on button event in field work_status i have the number, for example "6", which i must have in parent table "Orders" in field status_id. Criteria of this tables is order_id. What i must use? Update or copy? or Insert?

View 2 Replies View Related

Copy Cell Above And Add 1

May 2, 2005

I have a subform in Datasheet view. One field contains numbers. When entering data into the datasheet I wish to copy the number from the cell above and add 1. Can anybody help me with the code to do this?

View 5 Replies View Related

Copy A Form?

Jun 27, 2005

If I have a form based on 1 table and want to create an almost identical form based on the same table, how do I do it?
I need to delete only 5 fields from 1st form and then add 5 different fields.
All fields for both forms would be in the same table upon which they are based.

Russ

View 2 Replies View Related

Copy Record

Aug 5, 2005

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?

View 3 Replies View Related

Copy Record

Dec 9, 2005

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.

greetings
Nelleh

View 3 Replies View Related

Cannot Copy Forms

May 28, 2006

I cannot copy Forms from one db to another db. I can copy everything else, report, queries, tables, etc.
When I "export" the Form, it appears to copy. However, it does not appear in the directory where it should be. If I recopy, it says "its already there and ask to overide the present Form. Still no soap. How can you copy Forms from one db to another? This sucks big time!
Please help if you can.

View 1 Replies View Related

Copy Field

Jul 31, 2006

I have a data entry form with many records. Instead, of retyping the same data. I would like click a button and the data on the top row will copy downward.

View 3 Replies View Related

Database Copy

Jul 23, 2004

I need a clean copy of my database that includes everything except the data. I want to keep the keys and relationships etc. How do I do this? I am using Access 2003 Projects and SQL Server.

View 3 Replies View Related

Copy And Paste?

Aug 4, 2005

To speed up my input I copy a record and paste it.

Only trouble is that I have one field in the table that is dependant on the parent table. [The customers email address which I populate with a query/combo box. There could be many, depending who the order was for.]

Q: What function could I use after the paste funtion to ammend that field automatially setting it to 'null'

Q: I looked into WM_PASTE but I'm really struggling!

Many thanks
Jon

View 1 Replies View Related

Cannot Copy Forms

May 28, 2006

I cannot copy Forms from one db to another db. I can copy everything else, report, queries, tables, etc.
When I "export" the Form, it appears to copy. However, it does not appear in the directory where it should be. If I recopy, it says "its already there and ask to overide the present Form. Still no soap. How can you copy Forms from one db to another? This sucks big time!
Please help if you can.

View 2 Replies View Related

Copy Data To Sub-form

Jun 20, 2005

How do I go about copying data from a main form to the sub form?

I have a Soldto form with a Shipto subform.

When the two are the same I'd like to have a button to copy the data from the Soldto form to the subform.

I've tried some examples posted on this forum but, don't seem to cover a sub form.

Also, I have very limited coding experience, so please be gentle.

Thanks for any/all help you can give.

View 3 Replies View Related

Licensing And Copy Protection

Dec 26, 2005

Hello All,

I have created a management system for small home builders and contractors.

Typically these customers will have less than 25 users. So far I have installed it in a single customer’s site, but I want to expand.


I basically have two questions.
1. What is the best way to deliver this product without the end user needing Access?
2. How can I ensure they don’t make illegal copies and give to their friends or add user without purchasing more licenses?

Thank you all,
Joe

View 5 Replies View Related

How To Copy Records To Different Table

Jun 22, 2006

Hi all

This gonna be a long one.... I've search the whole forum for answer to this problem, but couldn't find the one suitable enough.

I have a quote table with the following field:


QuoteName
QuoteDescription
QuotePrice

and booking Table:


BookingName
BookingDescription
BookingPrice

The real table is much more complex, but this will do for now.

When a client call up for a quote, their request will be added into the "QuoteTable". One name can occur many times depend on how many they ask for quote. Once they decided to proceed with the booking, all the records need to be transfered into "BookingTable".

Currently, I use either one of the following codes found in this forum:


Dim dbs As DAO.Database
Dim rstQuote, rstBooking As DAO.Recordset

Set dbs = CurrentDb
Set rstQuote = dbs.OpenRecordset("SELECT * FROM QuoteTable " & _
"WHERE QuoteName = ' " & Name & " ' ")
Set rstClient = dbs.OpenRecordset("BookingTable")

Do Until rstQuote.EOF
rstBooking.AddNew
For Each Field In rstQuote.Fields
rstBooking.Fields(Field.Name).Value = _
Nz(rstQuote.Fields(Field.Name).Value, "")
Next Field
rstQuote.MoveNext
rstBooking.Update
Loop


or


Dim lngOuterCounter, lngInnerCounter As Long
Dim dbs As DAO.Database
Dim rstQuote, rstBooking As DAO.Recordset

Set dbs = CurrentDb
Set rstQuote = dbs.OpenRecordset("SELECT * FROM QuoteTable " & _
"WHERE QuoteName = ' " & Name & " ' ")
Set rstClient = dbs.OpenRecordset("BookingTable")

If Not rstQuote.EOF And Not rstQuote.BOF Then
rstBooking.AddNew
For lngInnerCounter = 0 To rstQuote.Fields.Count - 1
rstBooking.Fields(lngInnerCounter) = _
Nz(rstQuote.Fields(lngInnerCounter), "")
Next lngInnerCounter
rstBooking.Update
End If


But none seem to work. Can anyone help?


Cheers
arnodys

View 8 Replies View Related

Database Copy Oddity

Sep 15, 2006

Alright...Our database was benchmarked by several other units. They're completely separate, i.e. independant data collection, no shared networks, different bosses.

At any rate, I made some changes to the db and created a "utility update (http://www.access-programmers.co.uk/forums/showthread.php?t=114008)" db for these other units to use to automatically get these updates. Before sending all of this out, I received copies of these other databases to make sure that everything works properly.

Well, everything works fine except for one db. I thought originally that they must've changed something in the db, so I made a copy of ours and imported their data and got the same error as in theirs. So...obviously, I thought there must be some problem in their data. I ran through it and double-checked the verification VBA in the form used to enter the data and there's no noticeable difference in the data and the VBA/form are identical.

This might tie into my previous post (http://www.access-programmers.co.uk/forums/showthread.php?t=114516) because there's something goofy in Access that I can't quite pin-point. As far as I know, there's no difference between any of the databases except for the data itself. Can the data be corrupted if it looks normal in the table? Would corrupt data cause an error in a query/report? (I've never run into corruption in a db before.)

Sometimes I don't like Access so much.:p

View 4 Replies View Related







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