Is is possible to copy queries, reports, modules, etc. from one database to another, and if so, how? I have some queries and reports in an inventory database I'd like to copy and use in another database without having to set them up or re-code them again.
Thanks,
Rod
So I have this killer report that took me hours to set up. I run it daily and it is great.
I now need to filter it slightly for 1 specific user. So what I did was I copied the query and renamed it. I added the filter I needed. But I don't want to have to re-create the report. Even though I know what I need it will take quite a bit of time to recreate it.
Is there a better way? Can I copy the report (using the same query) but add the filter on the report side?
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
How can I through VBA check to see if a report exists, if so, delete it and then copy another report and save it under the original name.
for example:
if the report "weekly stats" exists, delete it.
then copy (not rename) the "Weekly States Template" report to "Weekly Stats"
The reason I want to do it this way is that the report gets fields added dynamically each time it is run. I have not been able to have the report close without saving (automatically) and unfortunately, even though the user has been told to NOT save the report when prompted, they do. This would solve that problem.
Any help would be appreciated.
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 RelatedHi,
I need help with an access 2000 multiple queries problem.
I have the following:
Table 1 = info below / table 2 = computer types / table 3 = offices 1 through 10
field 1 = name (20 employees)
field 2 = computer (5 different type of computers)
field 3 = office (10 different offices)
field 4 = issued
field 5 = not issued
field 6 = stolen
On a form I have the 2 combo boxes (computer and office) to select and check boxes to select issued or not issued or stolen.
I need a report printed based on the multiple criteria query only showing the results that I ask for.
For e.g. in office 5, computer IBM, issued.
Print Report: lists names of all in office 5, with IBM’s, issued only!
etc.
Please help.
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
I am new at Access. I have an excisting database but i would look to copy/duplicate it from on computer to another. Because i would like to start experimenting in the excisting database, but without changing things in the real one. How would you duplicate it, because if i just 'copy' it. I have to change some pathways, but i don't know how.
View 7 Replies View RelatedIn Report Design View, is there any way to copy the group, sort and total specifications that are in one report and paste them into another report?
View 4 Replies View RelatedI have MSAccess 2003 running on WindowsXP. I have multiple users sharing a single database. When more than one user opens the same database, a copy of the database is being created?? I don't know if this is a standard trait of Acccess or something else. Any explinations would be helpfull.
Thanks
Bob
I'd like to be able to show recruiters the database as an example of my work (to get an interview, etc.). Of course, I can't just show them a copy of the database with all of the private information on it, so I'd like to be able to show them a copy of the database with no records. Is there a way to export/copy it so I can do this in Access 2007?
View 4 Replies View RelatedNeed to track donations in two areas. Have one query that tracks them in location A and one that tracks them in location B. Same query, no other difference. Report made on location A is fine. Made a copy of it and based it on the 2nd query--and I get a pop-up "Enter Parameter Value" for Last Name. The Last Name field is not in the query or anywhere in the report that I can find.
View 3 Replies View RelatedI have a continuous form that has 5 columns of data per line and it also has a 6th column that I can enter data into. What I want to be able to do is if I enter data into the 6th column it will copy that record except the 5th column to a report.
I have tried searching this forum and other but not quite sure of the terminology so not getting good results.
Hey Guys,
Hope you can help as this one's got me stumped!
I'm using Access 2000 and run a mailmerge function via a button on a form. (It opens Word, which then uses a query in the database to refer to and then 'automerges' into a new Word document).
It used to work absolutely fine but now it opens Word and then opens another copy of the database (so I have 2 running) and all hell breaks loose.
Any ideas what I can do to stop this? Has anyone come across this before?
Any help/suggestions would be gratefully recieved as I feel like I'm in a 'needle in a haystack of needles' situation here.
Cheers,
Rusty
:D
I have a relatively small data base.
There are a number of what I call reference tables. These are fairly static and in the main will not change.
There are a further half a dozen tables all linked together.
The system basically takes an enquiry which may lead to a repair taking place. The repair will have a number of jobs and each job may have parts replaced.
What I want to do is have an identical database which to begin with will have exact copies of all the reference tables. The remaining half a dozen tables initially will be empty but grow with time.
The user wants to be able to copy the completed repairs he selects over to the 2nd database (which is initially empty). As weeks go by he wants to select further completed jobs that have not already been copied over to the 2nd database. The 2nd database will be updated so I can't just copy over all completed repairs each time.
I had envisage him doing this by using a front end to the 2 databases and firstly selecting which of the completed jobs which haven't been copied over. This is a fairly straight forward query that will update a field on the repair table.
Once he has done this I was thinking that I could run a query that would pull all the rows from the 6 tables from database 1 and update the corresponding tables/rows on the 2nd database.
I don't actually know how to approach that. The process needs to be simple for the user. ie 1. select repairs to copy over 2. run something to copy them over.
I pasted the tables, modules, macros, etc. from one database to another and the only thing left is the Saved Import. How can I get that into another database? It is quite a large import, otherwise i would just recreate it.
View 3 Replies View RelatedHow can I overwrite the existing Access database with another Access database without the need for the end user to get involved in the process.
I want the code to copy a new mdb file over the database I am using (!) and then automatically start the new mdb file...
I'm using the DoCmd.CopyObject method to copy a table from my front end db to my back end. My back end db is password protected and it keeps prompting me for the password. Can I somehow send the password in code so that the user is not prompted?
View 8 Replies View RelatedI need a way that I can simply have a User click a button on a form of the database and it will do automatically create a zip file of the entire database and start Outlook and attach the zip file and send it to me.....
View 4 Replies View RelatedIs there any way i can a button on a form which will make a copy of my entire database?
View 1 Replies View RelatedI have created an MS Access 2007 for a user. When the user uses the database, it automatically saves a copy of the database. Why is this happening? I did create for the database to compact/repair each time to user closes the database. ... However, when I open/close the database, there are not new copies of the database.
View 1 Replies View RelatedI'm a access novice who is looking to create a database to store training records for permanent and agency staff, and contractors staff. I need the database to be able to produce reports on how many courses were trained over each month, and the total duration of the course completed (in hours).
View 2 Replies View RelatedI have built an Access 2010 split database on my computer and it functions as built. My next step was to copy it to the server at work and test it. I discovered the tables had to be re-linked and so did that. As I have read in the Access World Forums in order to function as a multi-user database a copy of the front end must be placed on the individual workstation with the back end residing on the server, however the hyperlinks in the back end will not function when the copy on the workstation is run. I simply get an unable to open "filename" error pop-up. I can run the server copy and everything functions as built. I know that the hyperlinks require all the files to be in the same folder (relative vs. absolute), but if the back end contains all the hyperlinks why does the location of the front end seem to affect the operation of the back end?
View 3 Replies View RelatedSo I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.
I am using Access 2010.
Hi,
If two developers are working on two seperate databases, is it possible to merge the work done in both database together, that i mean to say is, can we export the form/report/query from one database and import it in the other ?
Thanks
Joy
I have Access 2010 and I have a query that I want to take a copy of, save as and call it call it something else in the same database.
For example "query1" I want to save as and call it "query2" .