Delete A Report And Then Copy Another
Jan 21, 2005
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.
View Replies
ADVERTISEMENT
Aug 12, 2005
I have a "core" data form with many subforms containing various pieces of information regarding the record, such as subforms for donor giving, alum degree, student, faculty awards, etc.
Users of this database may only be required to update certain portions.
Can I copy the "core" form and delete the subforms (or any field for that matter) that a person doesn't need to see or is not responsible for maintaining, leaving only what they need for data entry?
What effect with this have on updating the underlying tables? Synchronization of records?, etc.
Or is this too simple a soloution?
Thanks for any advice or thought.
View 2 Replies
View Related
Jul 9, 2014
I have a form with a sub form. when a record is choosen in a combo box the sub form is filled out with a record.
what I am trying to do is have a button that will copy that record to a history table then delete it off the the main table.
I cheated by using the wizard to get the code to delete the record but I am having troubles modifying the code to copy that record to the history table. Here is the code below. I have tried to insert code in several places but it just errors out.
'------------------------------------------------------------
' Master_tbl_sub_fm
'
'------------------------------------------------------------
Function Master_tbl_sub_fm()
On Error GoTo Master_tbl_sub_fm_Err
With CodeContextObject
On Error Resume Next
[Code] ....
View 8 Replies
View Related
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
Aug 4, 2005
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
View 2 Replies
View Related
Apr 11, 2013
In 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 Related
Jul 16, 2015
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?
View 4 Replies
View Related
Aug 15, 2014
Need 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 Related
Feb 19, 2014
I 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.
View 2 Replies
View Related
May 6, 2014
All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.
View 13 Replies
View Related
Apr 2, 2007
I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.
How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?
View 2 Replies
View Related
May 19, 2011
I have two simple tables. I want to delete the records from Table1 that are on Table2. I've created a select query that gives me what I want but when I change to a delete query, I get this message: "Unable to delete from specified tables"
I think my problem has something to do with security but I can't figure out what to change.
View 13 Replies
View Related
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
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
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 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
