Imported Form Changes

This is a multi-part message in MIME format.

------=_NextPart_000_0153_01CB03DC.5FB2C170
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Access 2007 sp2.

I hope I explain this ok... Here goes.

When I want to discard changes made to a form by importing a form form a =
backup
the imported form takes on all the characteristics of the form I want to =
replace.
As an example, lets say I remove a command button from Myform in my main =
db.
I then import Myform from a backup knowing that this form still has the
command button. When I open the imported formj (Myform1) it still has =
the command
button and is identical to the form I'm trying to replace.
Keep in mind this is only an example 'cause I wouldn't import a form =
just for one command button.
Actually I made many changes to this form when I decided I didn't like =
it and decided to import from the backup.
After importing the imported form was identical to the one I'm trying to =
replace.
When I open the db with the form I want to import the form is fine. It =
seems to magically change
to the one I want to replace after importing.
I tried importing the form from a backup I did in February and the same =
thing happened.
Doesn't matter, I could import a form from February 2007 and there would =
be the same results.
In fact I imported the form from 5 other backup with the same results.
I renamed to old form before importing and I deleted the form before =
importing with the same results.

Access seems to see both the old form and the imported as the same even =
though they are different.
Only if I create a new db and import all the objects from the db with =
the form I was trying to import
does the form import properly.
I've created several new dbs and have imported all the objects from a =
backup several
time in the past 2 weeks just to try to eliminate corruption.
As far as corruption is concerned I printed out 'Preventing Corruption' =
from Allen Browne's fine web site.
The only thing I might have here is if my computer is over heating =
without my knowledge.
I have no other problems with any other software on my computer. My os =
Vista Basic sp2 x32
seems to be running fine.
If it is corruption my db becomes corrupt ever few days or so.
Seems I can't breath on my db the wrong way.
Oh yes, I can admit I gave unplugged my power cord to the computer on =
several occasions in the past year.

Any help or suggestions will be appreciated,
James

------=_NextPart_000_0153_01CB03DC.5FB2C170
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18904">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2 face=3DArial>Access 2007 sp2.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2 face=3DArial>I hope I explain this ok... Here =
goes.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2 face=3DArial>When I want to discard changes made to =
a form by=20
importing a form form a backup<BR>the imported form takes on all the=20
characteristics of the form I want to replace.<BR>As an example, lets =
say I=20
remove a command button from Myform in my main db.<BR>I then import =
Myform from=20
a backup knowing that this form still has the<BR>command button. When I =
open the=20
imported formj (Myform1) it still has the command<BR>button and is =
identical to=20
the form I'm trying to replace.</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial>Keep in mind this is only an example =
'cause I=20
wouldn't import a form just for one command button.<BR>Actually I made =
many=20
changes to this form when I decided I didn't like it and decided to=20
import&nbsp;from the backup.</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial>After importing the imported form was =
identical to=20
the one I'm trying to replace.<BR>When I open the db with the form I =
want to=20
import the form is fine. It seems to magically change<BR>to the one I =
want to=20
replace after importing.<BR>I tried importing the form from a backup I =
did in=20
February and the same thing happened.</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial>Doesn't matter, I could import a form =
from=20
February&nbsp;2007 and there would be the same results.<BR>In fact I =
imported=20
the form from 5 other backup with the same results.<BR>I renamed to old =
form=20
before importing and I deleted the form before importing with the same=20
results.</FONT></DIV><FONT size=3D2 face=3DArial>
<DIV><BR>Access seems to see both the old form and the imported as the =
same even=20
though they are different.<BR>Only if I create a new db and import all =
the=20
objects from the db with the form I was trying to import<BR>does the =
form import=20
properly.<BR>I've created several new dbs and have imported all the =
objects from=20
a backup several<BR>time in the past 2 weeks just to try to eliminate=20
corruption.<BR>As far as corruption is concerned I printed out =
'Preventing=20
Corruption' from Allen Browne's fine web site.</DIV>
<DIV>The only thing I might have here is if my computer is over heating =
without=20
my knowledge.<BR>I have no other problems with any other software on my=20
computer. My os Vista Basic sp2 x32<BR>seems to be running fine.<BR>If =
it is=20
corruption my db becomes corrupt ever few days or so.</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial>Seems I can't breath on my db the wrong =

way.</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial>Oh yes, I can admit I gave unplugged my =
power cord=20
to the computer on several occasions in the past year.</FONT></DIV><FONT =
size=3D2=20
face=3DArial>
<DIV><BR>Any help or suggestions will be appreciated,</DIV>
<DIV>James<BR></DIV></FONT></BODY></HTML>

------=_NextPart_000_0153_01CB03DC.5FB2C170--

0
JamesJ
6/4/2010 3:52:14 PM
access.forms 6864 articles. 2 followers. Follow

2 Replies
1024 Views

Similar Articles

[PageSpeed] 26

Hi James

There does appear to be some corruption in your database, so here's how I 
would approach it.

Follow the 8 steps on this page to:
    http://allenbrowne.com/recover.html

Now delete the form you plan to replace, and compact again.

Then open the database that you plan to import from, and go through the 
first 7 steps in that one too.

Now try the import. Because you cleaned up both files, and deleted and form 
and compacted it to get completely rid of it before importing it, the ghost 
form should be gone.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JamesJ" <jjy@darwin_roadrunner.com> wrote in message 
news:uBbJn3$ALHA.6116@TK2MSFTNGP02.phx.gbl...
Access 2007 sp2.

I hope I explain this ok... Here goes.

When I want to discard changes made to a form by importing a form form a 
backup
the imported form takes on all the characteristics of the form I want to 
replace.
As an example, lets say I remove a command button from Myform in my main db.
I then import Myform from a backup knowing that this form still has the
command button. When I open the imported formj (Myform1) it still has the 
command
button and is identical to the form I'm trying to replace.
Keep in mind this is only an example 'cause I wouldn't import a form just 
for one command button.
Actually I made many changes to this form when I decided I didn't like it 
and decided to import from the backup.
After importing the imported form was identical to the one I'm trying to 
replace.
When I open the db with the form I want to import the form is fine. It seems 
to magically change
to the one I want to replace after importing.
I tried importing the form from a backup I did in February and the same 
thing happened.
Doesn't matter, I could import a form from February 2007 and there would be 
the same results.
In fact I imported the form from 5 other backup with the same results.
I renamed to old form before importing and I deleted the form before 
importing with the same results.

Access seems to see both the old form and the imported as the same even 
though they are different.
Only if I create a new db and import all the objects from the db with the 
form I was trying to import
does the form import properly.
I've created several new dbs and have imported all the objects from a backup 
several
time in the past 2 weeks just to try to eliminate corruption.
As far as corruption is concerned I printed out 'Preventing Corruption' from 
Allen Browne's fine web site.
The only thing I might have here is if my computer is over heating without 
my knowledge.
I have no other problems with any other software on my computer. My os Vista 
Basic sp2 x32
seems to be running fine.
If it is corruption my db becomes corrupt ever few days or so.
Seems I can't breath on my db the wrong way.
Oh yes, I can admit I gave unplugged my power cord to the computer on 
several occasions in the past year.

Any help or suggestions will be appreciated,
James 

0
Allen
6/5/2010 2:08:22 AM
I've made a hard copy of 8 steps and when it happens again (and it will 
happen again)
I'll follow the instructions.
Thing that bothers me is what's causing the frequent corruption.

James

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message 
news:uTqB6PFBLHA.1892@TK2MSFTNGP05.phx.gbl...
> Hi James
>
> There does appear to be some corruption in your database, so here's how I 
> would approach it.
>
> Follow the 8 steps on this page to:
>    http://allenbrowne.com/recover.html
>
> Now delete the form you plan to replace, and compact again.
>
> Then open the database that you plan to import from, and go through the 
> first 7 steps in that one too.
>
> Now try the import. Because you cleaned up both files, and deleted and 
> form and compacted it to get completely rid of it before importing it, the 
> ghost form should be gone.
>
> -- 
> Allen Browne - Microsoft MVP.  Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "JamesJ" <jjy@darwin_roadrunner.com> wrote in message 
> news:uBbJn3$ALHA.6116@TK2MSFTNGP02.phx.gbl...
> Access 2007 sp2.
>
> I hope I explain this ok... Here goes.
>
> When I want to discard changes made to a form by importing a form form a 
> backup
> the imported form takes on all the characteristics of the form I want to 
> replace.
> As an example, lets say I remove a command button from Myform in my main 
> db.
> I then import Myform from a backup knowing that this form still has the
> command button. When I open the imported formj (Myform1) it still has the 
> command
> button and is identical to the form I'm trying to replace.
> Keep in mind this is only an example 'cause I wouldn't import a form just 
> for one command button.
> Actually I made many changes to this form when I decided I didn't like it 
> and decided to import from the backup.
> After importing the imported form was identical to the one I'm trying to 
> replace.
> When I open the db with the form I want to import the form is fine. It 
> seems to magically change
> to the one I want to replace after importing.
> I tried importing the form from a backup I did in February and the same 
> thing happened.
> Doesn't matter, I could import a form from February 2007 and there would 
> be the same results.
> In fact I imported the form from 5 other backup with the same results.
> I renamed to old form before importing and I deleted the form before 
> importing with the same results.
>
> Access seems to see both the old form and the imported as the same even 
> though they are different.
> Only if I create a new db and import all the objects from the db with the 
> form I was trying to import
> does the form import properly.
> I've created several new dbs and have imported all the objects from a 
> backup several
> time in the past 2 weeks just to try to eliminate corruption.
> As far as corruption is concerned I printed out 'Preventing Corruption' 
> from Allen Browne's fine web site.
> The only thing I might have here is if my computer is over heating without 
> my knowledge.
> I have no other problems with any other software on my computer. My os 
> Vista Basic sp2 x32
> seems to be running fine.
> If it is corruption my db becomes corrupt ever few days or so.
> Seems I can't breath on my db the wrong way.
> Oh yes, I can admit I gave unplugged my power cord to the computer on 
> several occasions in the past year.
>
> Any help or suggestions will be appreciated,
> James 

0
JamesJ
6/5/2010 10:03:35 AM
Reply:

Similar Artilces:

Import and export
Trying to salvage my data and it was suggestd I import and export files, do I need to import and export closed accounts as well? Only if you want them in the new file. In order to export a closed account, you'll need to first specify that it is open in Money. "Mike" <anonymous@discussions.microsoft.com> wrote in message news:269701c3fc78$9f29fcf0$a301280a@phx.gbl... > Trying to salvage my data and it was suggestd I import and > export files, do I need to import and export closed > accounts as well? ...

Importing messages #6
I have a backup disk that I would like to impport from, but obviously I do not know how. When I double-click a message, it does not recognize which program to use to open it and takes me to an MS site. All of these have a ..dbx extension. Thank you. "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message news:3398C3D3-FDD8-41CB-8F73-C445B56F6CF7@microsoft.com... >I have a backup disk that I would like to impport from, but obviously I do > not know how. When I double-click a message, it does not recognize which > program to use to open it and takes me...

Changing User Information without SA
Hello All, We're currently using GP 9.0 where I work (I'm the DBA) and we want to migrate these databases to a SQL 2005 cluster (these databases currently sit on a SQL 2000 stand-alone). These databases will be moving to cluster nodes that have other databases that are critical to our environment and we would like to limit the use of SA to strictly IT internally. My question: In PDK is there any way to allow GP users (employees) to modify other user information within the System -> User screen. For example: Someone logs in with their own GP account and wants to change tha...

Importing data
When I import sales data through 3CDaemon, I get cells that I of data that I cannot use in formulas. It is like they are corrupted. But can copy the info from cell to cell, just cannot use in formula (ex. =if(dd04="N",1,0. Formula does not error out, but it makes no difference if N, U, or anything else is in dd04. It answers back 0. How can I fix this ? Just a couple of guesses (I have no idea what 3CDaemon is). First, Get a copy of Chip Pearson's CellView Addin so that you can really determine what's in DD04): http://www.cpearson.com/excel/CellView.htm Second, ...

How do i change the height and width of a single cell in Excel?
You change the height of the cell by changing the height of the entire row, and the width of the cell by changing the width of the entire column. The cell cannot be independently resized, because then all the other cells wouldn't fit. You can merge contiguous rectangular ranges together to create super-cells. Depending on your objective, merging cells may have undesired side-effects. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ lotus1107 wrote: ...

Problems comming with change of Windows OS versions
Hi all, I work on MFC ,Dialog based applications........ when I develop an application and test it ,frequently I am facing one problem...It is the applications are working fine in one Windows OS version( consider XP) but if I test it another Windows OS version like( 98,2k,XPSP2)..there are some problems(like not underlining the shortcut keys,images not getting displayed..etc ) which are comming in that particular OS version only.... I want to know the reason behind this.....why is it working fine in one OS & not in other...?? I have clearly checked that the commands are g...

Import TransferIN into TransferOUT... its possible?
Hi, I have RMS 1.3, its possible to import a transfer in of one store into transfer out on my store? Thanks in advance. Aldo, If you are running HQ, it does this for you, on the next connect to HQ. -- * Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader to see and download the file attachment. If you are not using a reader, follow the link below to setup Outlook Express. Click on "Open with newsreader" under the MS Retail Management System on the right. http://tinyurl.com/75bgz ********** "Aldo" <...

excel 97 xml import
I have Excel 97 and need to import a XML file. I don't know vba. Slinger XL97 was written way before XML therefore it will not handle it. Only XL2003 (Individual product or from Office Pro) will recognise and handle XML import/export -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Slinger" <Slinger@discussions.microsoft.com> wrote in message news:D1D9952E-F741-4B11-8040-B27B34F382BE@microsoft.com... >I have Excel 97 and need to import a XML file. I don't know vba. ...

Problem with displaying images in forms
I have a problem with Microsoft Access 2007: there is a possibility to insert a picture into OLE Object field in Forms. However, it does not work: whenever I insert an image into OLE field in forms, it does not insert an image, but an icon of it, a Package. I did not check the field to insert icon: I want to have an image. But I always get an icon. Do you know how to make Access to display actual images instead of icons? I use Office 2007 on Windows 7 Professional 32-bit. I tried also Access 2010 beta--the problem occurs there too. Use an UNbound object frame. -- Milton Purd...

How I import data without truncating zero in the beginning
I am importing data from text file to access database but it is truncating all the zeros if they come in the starting.... please help me to resolve this problem as there is a field name telephone number and I need zero in the starting to distinguish between local and international calls. Remplace them by "+" (normaly it's the same) "Mohsin Habib" <MohsinHabib@discussions.microsoft.com> a écrit dans le message de news:8B32A18C-E88B-4259-8CAE-332EB821883C@microsoft.com... >I am importing data from text file to access database but it is truncating > ...

Importing JEs through the Table Import
Is there a way to import JEs throught the table import. If so, how is this accomplished? Please help! Thank you! If you have access to table import you must also own integration manager. either way, yes, you can import transactions. please give me a call at 214-373-8550 and we can walk through the process. Leslie "Christina" wrote: > Is there a way to import JEs throught the table import. If so, how is this > accomplished? Please help! Thank you! You can use Table Import but Integration Manager is much, much easier to use. If you can use Table Import, you own Inte...

Funny Split Form Bug?
Hi all, I just found a funny thing in Ms Access 2007 I have a splitform, in the form Header I have a combobox to call a rowsource from a table(period),which have Period,Start date, End Date when I update/add the record at the form is OK! but when I update/add the record in datasheet problem will occurs for 2nd column and 3rd column, cboperiod.column(1)&(2)=null why ? is it a bug? or my code got problem? I tried this about few weeks only found different between form and datasheet key in. my code as per below; Private Sub Form_BeforeUpdate(Cancel As Integer) If...

How do i set automatic update of footer as filename path changes
I am setting up a MS Word (2003) template for my users in which the footer of the document will indicate the filename & path. i will like this footer to change automatically to reflect the filename and path once the document is finalised and saved. Put in a FILENAME field. Update the field as required. You could either manually go into the footer and Update, or you could use code to do it. Topps wrote: >I am setting up a MS Word (2003) template for my users in which the footer of >the document will indicate the filename & path. i will like this footer to >...

Importing Dynamic data
Hi I have some tables in various xl files, call the files a,b and c. I want to import all these into a single xl file called e. If changes are made to a,b or c I want it to automatically update e. I have used the import function in d but if I change a,b or c to see the change I have to select the data in d and press refresh. Furthermore when I refresh d i have to have files a,b and c open otherwise it says connection lossed and is unable to refresh the data. Can someone explain to me in simple terms what I have to do in order to get the data automatically updated without having to alway...

sending a form
Good day, I am trying to create an issue tracker where one can use a form to assign someone from a given list to a task and then notify them of the task by being able to send the person an email containing the form. So far, I have only been able to create a macro that sends the entire database (and the user has to manually enter the email address). Any ideas on how to automate all of this? You can only natively do this in Access 2007. For earlier versions try Easy Survey: http://www.mapilab.com/outlook/easy_survey/ -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org...

Bulk Change Customer Price Level
We recently instituted a customer loyalty program. I need to set the price level for the 900+ custoemrs with these new cards and account numbers to Price level A. Account numbers are sequential and I can query them in reports but I lack the SQL know how to make the change. Any ideas. Starting Account number is 101010 and ending is 1010955 Hi Chris Try.... update customer set pricelevel = 1 where accountnumber between 0101010 and 1010955; I beleive account numbers are 7 digits; To roll back to all customers having "standard "price level use update customer set pricelevel ...

Importing a CSV file
Hi, When I try to import a CSV file into Outlook, it says I have to first install the DATA1.MSI file from my windows XP installation disk. I looked at my installation disk and here doesn't seem to be such a file. How can I import? Thanks, Randy If you have the correct installation disk, then all you need do is run the Office setup - Add/Remove options and add the Outlook import filters. Karl -- ____________________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact M...

Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my classes.(Alphabetized names down left vertical column. Dates across top of horizontal row.) I added a different color to all cells in every other row to make for easier reading of each student's name and absences. Every other row stays with a white background. My question: I wondered if it was possible to lock row colors while allowing data to change on top of them. If a new student is added to my class in alphabetical order, the alternating color pattern is often lost. It is a pain to rechange row and cell colors. Any shortcut ...

Import DB from CRM 1.2 to 3.0
Hi to all, How can I import the DB or data from CRM 1.2 to new CRM 3.0? Now my CRM DB are on SQL2000 server. Thank and regards. Augusto You should really upgrade CRM1.2 to 3.0. The data structutres are different enough that doing a migration would be pretty painful. Any reason not to upgrade? "IGBA75" <a.crippa@ieti.biz> wrote in message news:%23c97ZdkXGHA.3660@TK2MSFTNGP04.phx.gbl... > Hi to all, > > How can I import the DB or data from CRM 1.2 to new CRM 3.0? > Now my CRM DB are on SQL2000 server. > > Thank and regards. > Augusto > ...

why are my important emails going into junk email
I posted on outlook general and didn't get a response. so I looked here and there was no clue as to what is happening. I am using outlook 2007 on the desktop. now any mail coming in from facebook is going to junk email. also my zdnet newsletter is going there also. I have added their domain to the safe list but they are still going to junk. this probably started the other day when I got outlook 2003 going on my laptop so I could see my emails when I am away from home. I did lower the category for junk mail one item but that didn't help either. don't know what...

how can i import worksheets from multiple workbooks
Hi, I have a bunch of workbooks that all used the same template and were filled out for each week of the year. They all have a "totals" sheet the collects all the important data within. What i want to do is create a macro that imports that totals page, or a section of it from a bunch of these different workbooks, say all the ones in january or maybe the entire years worth so i can do some more analysis. my VBA skills are terrible but i am learning slowly. Any help would be appreciated. Hi David You can start here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin h...

Custom Zoom Form Not Updating Data
I have some code tied to the double click event for a control that opens a custom zoom form and displays the text as well as the label of that control. Right now, if I add to the text in the zoom form, it doesn't actually update the data in the table. I know I've read somewhere how to accomplish this, but my searching isn't finding it again. The code I'm using is below. Any help would be appreciated. Thanks Private Sub evnt_prblm_descr_txt_DblClick(Cancel As Integer) strZoomPar = Me.name & ";" & Me.ActiveControl.name strTitle = Me!Label16.Cap...

importing email
Can you import an email into Outlook from Aol.com using high speed internet cable? No. AOL uses proprietary mail format and does not play nicely with others. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Having searched the archives, Ben <mysanity@att.net> typed: | Can you import an email into Outlook from Aol.com using | high speed internet cable? ...

forms! (simple question)
what's wrong with the expression: Forms![tblFixtureSchedulePrintOptions].[PresetOption].Value = ... tblFixtureSchedulePrintOptions is a valid table; yet I get the error "cannot find..." thanks in advance, mark On Sun, 11 Mar 2007 10:12:16 -0500, Mark J Kubicki wrote: > what's wrong with the expression: > > Forms![tblFixtureSchedulePrintOptions].[PresetOption].Value = ... > > tblFixtureSchedulePrintOptions is a valid table; yet I get the error "cannot > find..." > > thanks in advance, > mark If [tblFixtureSchedulePrin...

why cant i change font size when i use conditional formatting?
When I use conditional formatting in Excel, the font size is grayed out and the options for the border are limited to 5, none of which are the ones I need, is there a way to make more formatting options available? Hi When you are in the process of applying conditional formatting, you are looking at the regular "Format Cells" dialog box which is not a dialog box specifically for conditional formatting. Conditional formatting cannot change the row height or column width of a cell - hence the font names and font sizes are greyed out. Presumably heavy borders change the row height o...