Multiple Form Copy reference Issue

Hello all,

I have 5 tables all identical, just the data differs. I created a somewhat
complex form for table 1. Because form 1 for table 1 is complex and thus
tedious to replicate, is there an easy way to copy form 1 four times to be
used to access tables 2-5, respectively?

I tried copy and pasting everything in form 1 to form 2 that is linked to
table 2 but I get reference errors: form 2 keeps looking for fields from form
1. 

Thanks!

-- 
Message posted via http://www.accessmonster.com

0
gymcshoe
2/11/2008 8:55:17 AM
access.forms 6864 articles. 2 followers. Follow

2 Replies
613 Views

Similar Articles

[PageSpeed] 51

Sorry answered my own question. I had charts on my form and they were causing
the reference errors. Thanks

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200802/1

0
gymcshoe
2/11/2008 9:29:27 AM
Your real problem is your database design.  You should not have 5 identical 
tables with different data.  They should all be one table with a field to 
identify to which group each record belongs to.  Doing it the way you are 
doing it will cause not only the problem you are now having, it will 
complicate everything else you want to do.
-- 
Dave Hargis, Microsoft Access MVP


"gymcshoe via AccessMonster.com" wrote:

> Sorry answered my own question. I had charts on my form and they were causing
> the reference errors. Thanks
> 
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200802/1
> 
> 
0
Utf
2/11/2008 2:07:05 PM
Reply:

Similar Artilces:

Two Momey 2007 Issues/Suggestion
I recently upgraded to MS Money 2007 Deluxe from Money 2004 and found two issues that MS has never seemed to resolve. The first is the frequency that bills are set at in the Bill Minder. The list of options in 2007 is still the same as in 2004. I would have figured that MS would finally allow you to set custom recurrent times. For example, I have a subscription that is billed every 3 weeks - not possible to do in Money. Second, is what I believe to be a bug that I found to be pretty prevalent, but apparently has not been fixed. The issue that that when I am entering a transaction and ...

Textbox in form that updates a table.
Is it possible for a textbox within a form to update a section within a table? If so how. Also I wanted to know is it possible to gray out a command button on a form after its clicked. Normally a textbox will update a single value in a single field in a table. To update several rows of a table, you can use an update query. The update query can use the value in the textbox on your form. To grey out a command button, you would set it's enabled property to false. Note: you must move focus to another control so that the command button doesn't have the focus at the time. Jeanette Cu...

Sample CRM Data Install Issue
Installed test version of CRM fine running as a web site on its own IP address. Try to run the sampledata wizard on CD1 but it fails at the first dialouge - enter the address of your crm server. Mine is running locally on 192.168.0.91 - accessible fine thnrough a browser - so I enter this and get back an error message saying crm server not found or not got sufficient priviledges to do this. Am logged on as Administrator account? Any advice on what needs to change to make the wizard work? Thank you Roger ...

Use the ctrl+t to move from tab to tab in a form
I have a department that would like to be able to use the keyboard instead of using the mouse to select a different tab in their form. My form consists of the following; In the Detail: I have a Tab Control (TabCtl211) that consists of 3 tabs and with in the tabs there are several fields that they add/update Case Entry/Update (0), Legal/Closure (1) and Restitution (2) I want to use the ctrl+t to move from tab to tab, because they use the tab key to move from field to field and then to new record. How do I make this happen for them? Penny "Penny Miller" <Penny.Miller@CO....

How do I copy a screen in Excel for use in Powerpoint?
I need to copy a few Excel screens for training purposes and want to paste them into a PowerPoint slide show. Can anyone help? Alt+PrintScreen and the paste into Powerpoiint. "Bess" wrote: > I need to copy a few Excel screens for training purposes and want to paste > them into a PowerPoint slide show. Can anyone help? It shows that i have transferred it to the clipboard but it will not show me the screen in PowerPoint. Any ideas on what I'm doing wrong? "David Hepner" wrote: > Alt+PrintScreen and the paste into Powerpoiint. > > "Bess" ...

should i hide a form or make it modal
Quick question looking for others opinions on the subject I develop apps for a company and up until now I have been using modal forms to keep the most resent form open on top I have recently learnt how to hide the access window and keep the forms visible using popup quite neat to be honest. My reasoning behind this is staff here use many apps but when I present them with an app that is built using ms access they think they cannot use it as for some reason in their heads it is harder to click a button using a ms access app than to click a button using a non ms access app. (PS if yo...

Reference previous record
I have a query that lists our parts and their cost. Some parts have 1 record and some parts have 2 records because their cost have changed. How can I have the query compare the previous cost for that part if one exists? Thanks, Jasper On Tue, 20 Apr 2010 15:37:06 -0400, "Jasper Recto" <jrecto99@yahoo.com> wrote: >I have a query that lists our parts and their cost. Some parts have 1 >record and some parts have 2 records because their cost have changed. > >How can I have the query compare the previous cost for that part if one >exists? ...

Looking for XML Template Reference Docs
I need to make some changes to the Receipt Templates and Statement formats. In RMS, these templates are designed in XML. Can somebody point me to a reference doc that will assist me in customizing these templates? I am most interested in seeing a list of possible variables that can be included in reports/receipts/statements. Thanks, Paul Arenson Anderson Plywood Sales Culver City, CA ...

HELP..Tax exempt issues
hey there kind of stuck..I have a client and she needs to use the indian status tax exemption. I have it set up that when everything is done that she can select the HST tax or the Tax Exempt (meaning pay only PST) i believe..anyways When we do this for some reason it goes to $0 in tax which isnt correct..I tried it like 5 times and all same thing..i rechecked everything and i know i am doing it correctly because i ave done it other clients..this one has become a mystery..plz anyone help me asap thanks ...

Labels in user forms
Hi group, In a Userform, can the label (where you enter text) show the result of a formula so that the message changes depending on the formula? Or is there a way to do this in another way if the label can't do that? Rob Rob , I assume that you mean a textbox not label, as that is where you enter text. One way could be to trap the Calculate event for the sheet that your formula is on and update the text box from there, something like Private Sub Worksheet_Calculate() UserForm1.TextBox1.Text = Range("A1") End Sub -- HTH Bob Phillips ... looking out across Poole H...

Easy way to reference a specific cell in a new worksheet
This project is for week over week sales. A new worksheet is added every week. The current week's sales are in Column E for every salesperson and the previous week's sales are in Column F. I would like the Column F to automatically reference Column E on the previous worksheet every time a new worksheet is added by copying the previous worksheet. It's not that hard to work around it now, I would just like to save time and automate the process. Is this possible? Let me know if what I am attempting to do does not make sense. TIA Hi without VBA this is not possible -- ...

Odd Webmail issue
When you use a favorites shortcut to our e-mail server spell check does not work. We get an error that says The spelling in this item cannot be checked. When you type the webmail address in the browser spellcheck works find. Does this have something to do with SSL? Thanks Jennifer Atchison ...

Multiple date validation in a single cell
I am trying to do a rather complicated validation (I think it i anyway!) I want to allow ONLY dates of a particular format to be entered int the one cell - i.e. YYYY OR mm/YYYY OR dd/mm/YYYY For example, the same cell can have either one of these format entered, but MUST match one of them to be accepted. 1970 is OK and is captured in the cell as 1970 (not 1/01/1970) 70 is assumed to mean 1970 on entry 05/1970 is OK, captured in the cell as 05/1970 (not 1/05/1970) 5/70 or May-70 is assumed to mean 05/0970 on entry 05/06/2004 is OK 5/6/04 or 5 June 04 is assumed to mean 05/06/2004 on entr...

copying charts into new sheets, data is pulled from old sheet
i make a sheet with a load of data and some graphs, then i want to copy the whole thing into a new sheet to process some similar but different data, all the cell references translate cleanly, and refer to the new sheet however, the graphs reflec tthe previous sheets ranges and data. how can i copy the graphs so they refer to cells on the new sheet? btw i know excel pretty well, and i could go through and drag new data on, but i would like about 30 graphs per sheet, so its tedious. thanks instead of copying just the data, use the Move or Copy Sheet option under Edit and copy the whol...

Documents in Multiple Monitors
Excel and Powerpoint (even in Office 2007) make it ludicrously hard (impossible?) to view two documents on multiple monitors. Even seeing them side by side is unintuitive (compared to Word). Will this be finally addressed in Office 2007? It wasn't as of the last beta I tried. -- -C. Moya www.cmoya.com I'm able to do it with my multiple monitor setup. What problems are you having? How are you trying to do it? Craig CMM wrote: > Excel and Powerpoint (even in Office 2007) make it ludicrously hard > (impossible?) to view two documents on multiple monitors. Even seeing ...

Easiest way to insert multiple copied rows?
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Currently, I copy a row, right click and choose insert copied cells. <br> This works great but only works for copying one row below. <br><br>What if I want to copy 2 or 3 rows below? <br><br>I can find blank rows, copy them, and insert them and then do this, but that is real tedious. <br><br>I wish there was a was to simply copy a row and hit some keystroke which would copy that row right below as many time as you click the keystroke. Does this exist? thanks! Try clic...

CRM Cluster Nodes cannot reference virtual name
We have an installation with CRM two clustered nodes using Windows 2003 NLB Nodes: CRM01, CRM02 Virtual Name: CRM Apart from standard CRM implementation, we use CRM assemblies, both for workflows but also for pre/post-callouts Users PC's can access the system using http://crm:5000 (the virtual name) and NLB correctly balances the load between the two nodes The problems start when trying to access CRM from the web server nodes. Using http://crm01:5000 works without requiring username/password (integrated authentication) Using http://crm02:5000 works as above Using http://crm:5000 works giv...

How to change the view at "View Duplicates" form?
Please help on how to change the view at "View Duplicates" form? we want to add more columns on this view. But I cannot find this view at SavedQueryBase table. Thanks -- MS CRM consultants at Melbourne Visit my CRM blog at http://melbournecrm.spaces.live.com/ ...

Transparency and Images
Hi Folks, Can any one help with a solution to enabling the use of images of circles with transpaernet backgrounds to be displayed correctly. I am using files in a BMP format that have a transparent background but when they display in the form the image has a 'white' square area where it is supposed to be transparent. Any assistance is appreciated. Regards, -- John Dumay You could use a gif and set the background to transparent. -- Wayne Manchester, England. "jdumay" wrote: > Hi Folks, > > Can any one help with a solution to enabling the use of images ...

how may I copy color of a other cell
Hello, I need a function that copy also the full format/color/size of a cell Example A1 = USD 12'500.00 (monetary size, 12 fat, blue bottom) A2 = mon 12.03.2004 (dates, 10 not fat, white bottom) If in A3 I type: =" A1 " I would like a blue bottom, 12 fat, etc. and If I type =" A2 " a white bottom, 10 not fat, etc.... Is it possible? Thank you for any help. Thierry, Maybe you can use the Format Painter. Select the cell that has the formatting you wish to copy, and click the Format Painter. It's a paintbrush on a button on the Standard toolbar. Now click the c...

How to copy Rules & Alerts from one PC to another
I occasionally copy my Outlook.pst file from my desktop to my laptop when I travel, and then back again when I get home. I also export and import the Rules & Alerts. The problem is that the Rules & Alerts for my emails don't copy over very well. The rules are there, but they say "on other machine", and most (but not all) of the rules that reference a specific email account (e.g. when received through specified account) are missing the account specification. Since I have quite a few rules, it is laborious to fix all these rules every time I transfer my fi...

Searching Multiple Sheets
Is there a way to search multiple Excel Sheets (same workbook), other than clicking on each sheet and using the Find feature? Thank you, in advance. With XL2000 and higher, you can select multiple sheets by holding down the Ctrl key and then do Edit > Find. Or select all sheets by clicking the first sheet, hold down the SHIFT key, and click the last sheet. HTH Jason Atlanta, GA >-----Original Message----- >Is there a way to search multiple Excel Sheets (same workbook), other than clicking on each sheet and using the Find feature? Thank you, in advance. >. > Thank you ...

Forms...
I have a couple of questions relating to Outlook Forms. 1. Let say I develop a form on my computer. I can then fill it out and send it to another individual to complete? Or do they need a copy of the form on their Outlook? 2. If I wish to use a form through an organisation, how can I create/distribute it so everyone has access to it? 3. Can anyone recommend any good websites to learn more about Outlook forms? Thank you for enlightening me, QB Author a Word Document, save it as an attachment in a E-Mail. Simple, yes? >WT< "QB" <QB@discussions....

Help! Form always in design mode
I'm pretty new to forms, I completed my first one yesterday which woks fine. However, I'm now doing a second which is causing no end of headaches! I have followed the instructions in help, but every time I open the form up it is always in design mode by default, which mean that I have to unprotect it and turn design mode off before I can use it properly. I have tried saving it in several different ways, as a word doc and as a template, but still it opens up in design mode, (still protected), but the check boxes do not work. What am I doing wrong? -- KerryOrr The fact that you m...

multiple indexes in one document
I have a document that lists information in a table. This information has to be split into two indexes in separate parts of the same document. Trick is that one index will need to contain all of the information and the other just certain pieces. I created the main index and it is fine, however I do not know how to double mark entries for use in the second index. There are two separate mechanisms for this, and you can use one or the other. (I would discourage trying to use both at the same time.) If all the items for the second index are together in one part of the table...