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