Can I Copy A Form And Delete Suforms Others Don't Need?

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 Replies


ADVERTISEMENT

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 5 Replies View Related

Access 2010 - Delete Form Command Button With A Password To Confirm Delete

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

Modules & VBA :: Copy Record To History Table And Then Delete It From Main Table

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

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

Forms :: Button To Copy Values From 5 Fields In Current Form To New Form

Sep 30, 2013

I would like to create a command button on my form that copies values from 5 fields in the current record into a new record leaving all the other fields blank except for the new record ID.

The fields that contain the data that I want copied into a new form are:

1. Member_Name
2. Member_ID
3. Account
4. UBH/PBH
5. Assigned_WRCA

View 8 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 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

Forms :: Copy A Web Form To Normal Form?

Mar 4, 2014

I have built a database using Access 2010 using the 'web' format for the forms, reports and tables.

This has been fine so far as I have been using macros for my clickonevents.

However I now need some functionality not available in the web forms macro expression builder. Namely Openquery, (it is not on the available list). I therefore want to copy my forms formatting and properties to a normal non-web form allowing me to enter vba code.

Is there no way of doing this though - will I have to redesign the form again from scratch?

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

Copy Table On A Form

Oct 23, 2004

In the database I am developing, users have to be able to copy a table, no data, structure only. The source table is always the same one. Users have to be able to specify the name of the new table.
I would like to have them do this on a form, easy of use is important. Any ideas on this? Thanks. Trucktime

View 2 Replies View Related

Copy Data From Form To Another

May 20, 2006

hi guys....

am new here and i need smal help :)

i have 3 tables inventory and sales and order and i made 3 forms for each table

in inventory form the user will only read the data

in sales and order the user will enter and delete the data

so my problem is i want to know how when the user enter the data in order form all the data will be copy in inventory table so what ever added in order table it will be copy or updated to inventory table

how can i do that?? :confused:

View 7 Replies View Related

Copy Data To Another Form

Dec 11, 2006

Hello friends!

I have read some of the posted threads. But I still couldn’t understand on how to solve my problem.


The scenario

I have 2 forms which linked to 2 different tables with the same attributes.

Example:
Form 1 links to table 1.Collumns (index,name,address)
Form 2 links to table 2. Columns (index,name,address)

The problem

How do I replicate the same data from Form 1 to Form 2 with Single button / command?


The Objective

What I’m trying to do is to create an auto fill function so that user do not have to type in the data into form 2 / table 2 by referring to form 1 / table 1.

Hope you guys could help me with this.

:o

View 4 Replies View Related

Print Out A Copy Of A Form

Mar 14, 2008

I know how to print out a copy of a form that has no sub-forms as part of it. For those of you trying to do this, open the objects menu and click on Forms. Right click on the form you wish to print and save as a report. Open the reports menu and print the form. Suggest you eliminate colors or your ink supply will run out quickly.

Anyway, I am looking at trying to print the form with the sub-form showing as part of it. It is only for presentation purposes to show the End Users what the form will look like and ensure that all requirements are met. I could do a print screen but that only works if the form is smaller than the screen.

Any suggestions??

Thanks,
Alan

View 2 Replies View Related

Copy Some Info From One Form To Another

Apr 16, 2008

I have 2 different sets of tables,forms and queries, one for quotes and the other for orders.

All is basically simalar but the reason why i did not combine the two in one set of tables and queries is because after a certain time i want to delete some quotes and would also have too many fields in one table to manage.

Both have a main form (own table)with customer detail and then the subform (own table) contains various fields with data relating to products.

My problem now is because one in 5 quotes get accepted i want to just copy one field from main quote form to main order form and then 6 fields from quote sub form to order sub form, the rest of the info will have to be put in manaully in the orders form and sub form.

I thought of running a macro to open order form but not sure how to populate the relative fields.

Any suggestions, prob simple way of solving this but i am self taught and therefore dont know it all.

View 3 Replies View Related

Loop / Copy From One Form/table To Another.

Dec 13, 2005

Please could someone enlighten me on the following scenario I have.

I would like to get from a button click the information from Sheet_subID (cat_parameter) copied into the Main sheet Description field. I think this maybe would be done with a loop? Taking one from in tunr from Sheet_subID and then putting it into the description filed until al cat_parameters have been copied.

This information is not beng duplicated as such because the text that lands in the description field will be modified slightly by the user. The information contained within the Sheet_subID are for presets for in the case below Compensator Setting 3. Compensator 1 would have different presets.

Any thoughts people?

Cheers

Ade

http://www.norwichlife.co.uk/loop.gif

View 7 Replies View Related

How Do I Copy The Design & Fields Of A Form?

Sep 11, 2005

I have a table and a form that I designed. Now I need to copy all the fields and the design of the form I just created and give it another name so my partner can use the same design and fields, but put in his own information. Is it possible to copy just the design and the fields. If so, how do I do that? Thanks.

View 7 Replies View Related

Copy Form Format To All Forms ?

Jan 2, 2006

Hi i have just created my own form format and i want all my other forms to have the same format is there anyway of doing this ?

thanks

View 2 Replies View Related

Copy Text Fields On Form

Jan 28, 2006

Hi

I new to VBA and having a few problems with a database I'm working on.

I have a form that contains customer details. The are two sections one for the Registered Office Address and one for the Trading Office Address. I want to be able to allow the user to auto fill the Trading Office Address fields if the Trading Office is the same as the Registered Office.

I'm not sure how the event code should look. I was just going to add a button that will copy the text from the Registered Office Address fields and add them to the Trading Office Address fields. I've tried a couple of other groups but the replies just contain use this code....

TOName = ROName
TOAddress = ROAddress
etc... for all your fields.

I need a little bit more info on how the event code should look.

Any suggestions on the best code to use would be greatly appreciated.


Kind Regards

David

View 3 Replies View Related

Copy Form Data To Another Table

Feb 3, 2006

Hi All,

I have a form which is bound to a table. I want some of the Data to go to another table which is not the control source. I am trying this code, but no luck. What am I doing wrong?

Table![tblImageBLOBs]![record_number] = Me.aud_number

Thanks

Bones

View 6 Replies View Related

Assign Autonumber & Form Copy

Feb 8, 2006

I don't know if this is possible or not. I know you can assign your own autonumber by working w/ an append query. But my question is, if I have a number that is 1.0 - can I change the 10th spot after the decimal? I tried it myself w/ the append query but it changes the 1 to a 2.0. Is there a way to do that?

My next question is - I know there is a copyobject. I want to be able to click on a button, & it copies a form. BUT, you have to enter either a destination for the form or a new name for the form. But the problem is, I want to keep the current destination and the form name will change each time there is a new form created. Is there a way to have something pop up for me to rename the form?

Thanks in advanced.

View 3 Replies View Related

Carbon Copy Form Printing

Mar 27, 2006

I have searched all over google for help on this one, so now I enlist help from the good folds at the MS Access Help Center...

I have been given the task of updating a particular form our company has been using for over 10 years. The form was originally created to print on color coded carbon copy form with 5 sheets of paper. The form gets printed via a dot matrix printer (which pounds thru all 5 sheets). At this time, the form is done in MS Access 97 - and simply prints all fields via the print command.

Certain sections of the form do not print on all copies because the carbon copy paper masks the fields. I.E. the bottom sheet does not show the 'bill to' information but all other copies do.

So, I was asked to make the existing form print to our standard Laser Jet printers - but to hide certain items per page. I have determined how to print the form 5 times by simply adding some basic VB code to a command button. What I can't figure out is how to hide certain fields as the old carbon copy form once did. I.E. Print the same page of a form 5 times, but each page has different information on it per page.

Any help would be appreciated - thanx

View 1 Replies View Related

Copy/Paste Command On A Form

Jul 25, 2006

Copy/Paste

I have a textbox on a form that automatically shows the current date. Below that, I have 3 other textboxes for dates (each representing a step in a process). Often, the same date is imputed into each of these boxes. I would like to have an “Autofill” command button that would take the date in the first box and place it in the other three. This is so basic it’s hard. My usual searches turn up nothing. Any suggestions welcome.

View 5 Replies View Related

Copy Data From Form To Table

Nov 27, 2006

tbl_TEMP
frm_TEMP
tbl_FINAL

My user will open the database & use frm_TEMP. They will see a record using the form. The data will be in tbl_TEMP at first. My user will check all data, make any changes, then I want them to click a button on the form that will move the corrected record from tbl_TEMP to tbl_FINAL. It will then refresh the form and bring up the next record.

How do I do this? Thanks.

Travis

View 12 Replies View Related

Copy String Of Values From Form

Dec 22, 2006

I have a form which displays contact details for customers. I want to add a button to the form which concatenates name and address fields, adding spaces and line breaks, and then copies the full name and address so that it can be pasted into other applications (e.g. into a letter).

To do this requires that I implement some code to perform the following actions, but I can't figure out how to do it. Can anyone help?

1. Check Title field. If it is not null, take it's value and add a space after it.
2. Check First Name field. If it is not null, take it's value add it to the output of step 1 and add a space after it.
3. Check Surname field. If it is not null, take it's value and add it to the output of step 2 and add a space and a line break after it.
4. Check the Company Name field. If it is not null, add it's value after the line break and add another line break.
5. Repeat this for every field until the end of the address is reached, then copy the result.

Thanks in advance if anyone can help.

Gary

View 2 Replies View Related

Forms :: Copy And Paste To Form

Jul 26, 2013

I can not seem to paste text into a text box on an access 2010 form. I am however able to paste the text in a word document.

View 1 Replies View Related







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