Rabu, 28 Agustus 2019

[MS_AccessPros] Re: Form issues

 

Bill - It sounds like the form has some corruption. Two things that should fix it:

1. import it into a new, blank database, delete the form in the original db, compact, import from that new db.

2. Save form as text, delete the existing form, load from text.

To do #2:
press Ctrl+G to open Immediate window.
Type: SaveAsText acForm, "yourformname", "full file path"
Delete existing form & compact
Immediate window again: LoadFromText SaveAsText acForm, "yourformname", "full file path"

-Bill Mosca


---In MS_Access_Professionals@yahoogroups.com, <Bill.Singer@at-group.net> wrote :

I have Office 365 running on a Windows 10 machine

I have a form that has been running for years.  The form pulls information from a query that just reads a table.

 

I have been asked to add a field to the form.  No big deal.

 

However, once I make a change to the form it will not open again.  I can open and close the form and it works fine.  I can go into design mode and back to form mode and as long as I don't make any changes, no problems.  However, as soon as I go to design mode and make one single change, such as moving a field a millimeter, and then close the form, I can't open it again.    Periodically it tells me that I can't open a form that is already open.  However, I can't see anything so I don't know why it is thinking the form is open.   I can still right click the form and hit design mode and the form pops up but as soon as I try to save and go to form mode from design mode, the form disappears.

 

Any Idea what is going on?  I have tried compact and repair.  I started making changes yesterday and it worked fine.  But now I have issues.

 

I am just thinking, there may be a person that is tapped into the back end database and they did not shut down their computer.. and I made some changes to the back end.

 

Any help would be appreciated.

 

Bill

 

Bill Singer

 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar