Checking for open forms in access 97


How can I check if a particular form is already open in access 97?



4/11/2007 7:06:07 PM
access 16762 articles. 3 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 26

John wrote:
> Hi
> How can I check if a particular form is already open in access 97?
> Thanks
> Regards

Copy this into a standard module and then use it to test for open forms...

Function IsLoaded(ByVal strFormName As String) As Boolean
 ' Returns True if the specified form is open in Form view or Datasheet 
On Error GoTo ErrHandler

    Const conObjStateClosed = 0
    Const conDesignView = 0

    If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 
conObjStateClosed Then
        If Forms(strFormName).CurrentView <> conDesignView Then
            IsLoaded = True
        End If
    End If

Exit Function

    MsgBox Err.Description
End Function

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com 

4/11/2007 7:35:33 PM
"John" <> wrote in message 
> Hi
> How can I check if a particular form is already open in access 97?
> Thanks
> Regards

4/12/2007 9:45:14 PM

Similar Artilces:

I am unable to use spell check in outlook express....get the message...."an error occurred while the spelling was checked".... any help would be appreciated..thnx...sam If you are on exchange try and remove your profile folder from both the server and the client machine. Had the same problem last week. >-----Original Message----- >I am unable to use spell check in outlook express....get >the message...."an error occurred while the spelling was >checked".... > >any help would be appreciated..thnx...sam >. > Owen <> wro...

Access denied opening XML attachment
A user on my network cannot open an xml attachment in Outlook 2003. It works fine in previous versions. It says "access denied. Error processing resource." If the file is saved to a drive, then it opens without a problem. Is there some security configuration that would cause this behavior? I have tested on multiple machines and multiple users to rule out profile or other causes. I have also checked security on the tmp folder the file is trying to open from. Any insight would be helpful. -Paul ...

How to make Access 2007 Navigation pane invisible?
I have tried the Access Options. | Current Database | Navigation, uncheck Display Navigation Pane, and the vertical "Navigation Pane" still displays in a compiled .ade. Something else yet? Dean Slindee "Dean Slindee" <> wrote in message news:%23o1Zj8odKHA.2188@TK2MSFTNGP04.phx.gbl... >I have tried the Access Options. | Current Database | Navigation, uncheck >Display Navigation Pane, and the vertical "Navigation Pane" still displays >in a compiled .ade. > > Something else yet? > > Dean Slinde...

Switching between multiple open windows
I ran across an option to change how to switch between multiple open windows on my desktop. It was an option to choose between hovering over a window or clicking on it. Thinking that only having to hover over a window to switch to it would save time, I selecting the option to hover... big mistake as it just became a big pain in the a_ _ for me. Now I would like to change back to one-clicking to change between viewed windows but can't remember or find where the option is located. Any help will be appreciated. -- rushl On 2/03/10, rushl posted: > I ran across an opti...

active form name
Hello!! What function returns active form name? Thanks!! Cesar There is no function to return the current field, window or form name. You can track the specific windows you are interested in using PRE triggers to set a global variable with the name or id or the current window. David Musgrave [MSFT] Senior Development Consultant Escalation Engineer MBS Support - Asia Pacific Microsoft Business Solutions Any views contained within are my personal views and not necessarily Microsoft Business Solutions polic...

Pulling data for a report from a form
Hi, I have a product report list that want to show the on hand qty. so i have this formula in a report field: =onHand([pkProductID],Forms!FrmMyDate!InvDateQty) but when i preview the report it shows #name? instead. Thank you -- Message posted via To refer to a textbox on another (open) form, use: =Forms!FrmMyDate!InvDateQty -- Arvin Meyer, MCP, MVP "josros60 via" <u56159@uw...

How to Exclude Account from Budget when Option Check Box is Inactive?
I want to exclude the income in my retirement accounts from being included in the budget planning and being shown as income in monthly reports. In the account details, the option is "checked" to include in budget planner but the lined is grayed out and in-active and thus I can't uncheck it. How to uncheck? ...

Cannot open Money Deluxe 2007
New laptop, successfully using Money, then now I cannot open it. Windows keeps shutting it down. Tried running as admin. Tried uninstalling, then reinstalling. Help! -- Karen In, Karen wrote: >New laptop, successfully using Money, then now I cannot open it. Windows >keeps shutting it down. Tried running as admin. Tried uninstalling, then >reinstalling. Help! What OS? Is there an error message? Were you successfully using Money on that new laptop? Did the problem occur recently? You might want to consider a system restore point from before the pr...

Reboots when opening Word documents in Outlook 2000
Whenever I try to open a Word document in Outlook 2000, my computer reboots. This just started happening. I have reloaded Office 2000, done virus scans and checked my pc with Spybot. Nothing has been identified. Any ideas? ...

Downloads checking account information into my Money 2006 Savings
I purchased and installed Money 2006 today. I have a problem. Everytime I import from my internet checking. It puts it into my Money savings account. Any way I can redirect the imported information into my checking file?-- Grasshopper In, New Money 2006 user wrote: >I purchased and installed Money 2006 today. I have a problem. Everytime I >import from my internet checking. It puts it into my Money savings account. >Any way I can redirect the imported information into my checking file? Is the problem you have the one described in

Unable to open the outlook window.
I just downloaded Microsoft Office Outlook 2003 to my computer. When I try to open Outlook, the window opens for about 2 seconds and then closes automatically. I received an error message: "cannot start microsoft office outlook. unable to open the outlok window. the server is not available. contact your system administrator if this problem persist." I'm have home based computer and don't have an administrator. Can anyone help? Did you create a profile with settings (email account, POP3 and SMPT server names, etc.) for Outlook to use? -- Kathleen Orland Outlook Ti...

open subfolders automatically on mail entry -- not happening.
Hello all. Have a problem that happens in one Outlook 2002, but not another -- so I know there's a likely setting someplace, but can't find it. I've even stumped my company's IT people on this one: I download mail through several rules (and accounts); and ship them to various subfolders off of parent folders. What I desire is to have the email automatically open the appropriate folder -- revealing the affected subfolder -- when new mail comes into it. In one of my Outlooks (both 2002), this does open automatically revealing the new highlighted message. But the other do...

Printing checks #6
When I print to blank stock in the pay to the order of line the Account name is printed rather than the Payee name. This is the test version of Money which I would like to buy and use as it seem to have features which I like but the print glitch is a problem. Is there something I am not doing correctly or is this a "Feature?" Thanks, Dave. ...

cannot open Outlook
When I try to open Outlook 97 I get the following error: Mapisp32 This program has performed an illegal operation and will be shut down. Registers: EAX=00000000 CS=015f EIP=bff7b997 EFLGS=00000246 EBX=00000000 SS=0167 ESP=0063f8d0 EBP=0063fab8 ECX=c14eb7f0 DS=0167 ESI=0063fd58 FS=5217 EDX=bffc9490 ES=0167 EDI=0063fd58 GS=0000 Bytes at CS:EIP: ff 76 04 e8 26 89 ff ff 5e c2 04 00 56 8b 74 24 Stack dump: 0063fb10 7c6b2593 0063fd58 85762034 0063fb10 7c6b2484 0063fb10 85762034 85762278 85762278 7c6a7881 0063fb10 0063fb10 0063fb24 00000000 00000000 ...

GST Tax Forms for New Zealand
Hi there, I have recently prchased Money 2005 Standard, ans the box has big claims about it being able to track GST on purchases etc. That all seems to be working well, except I cannot get the GST information out of it at all. How do I setup my tax forms to give me the totals that I need for my GST return? Thanks in advance Jerome Brown Dear Jerome, I also would like to display the GST in a final report. Did you have any luck elsewhere? Marcus "Jerome Brown" wrote: > Hi there, > > I have recently prchased Money 2005 Standard, ans the box has big claims > about...

One Record Per Page Printing-Access 2007
Report for daily appointments for senior transportation drivers. Report is grouped by Driver. Keep together is selected. Detail band: Keep together-Yes; Force New Page-Before Section; Can Grow-Yes; Can Shrink-Yes Goal: Report generated so each driver has his/her own appointments. Orientation: Landscape, paper size 8.5 x 14, column width: 13.5729"; column height: 0.3069" When previewing in Print Preview one record per page is appearing rather than all appointments for a driver for a given date. I have the bands as narrow as I can make them. I am missing somethi...

Outlook not opening #2
I recently installed Outlook. When I try to open it, I get the error message "Outlook requires Outlook Express 4.01 or greater". I do have OE 5.0 installed. Why am I getting this error? ...

error when opening .accdb file
I don't think this is a new issue but I can't seem to find the resolution... I get an error when opening my Access 2007 formatted database stating that the file could not be found, though at the same time the file opens successfully. -- Error is intermittent. On occasions where the error does not occur, the file opens normally (I have never had an occasion where the file did not open at all) -- I have only seen the error happen when I have a 'Display Form' set in the Application Options for the 'Current Database' -- The database contains macros, VBA m...

Outlook Opens looking for Exchange Server
A computer club member wishes to used Outlook so that she can sync with her Palm. Environment: Windows XP Pro SP2, IE 7, Windows Genuine Advantage installed. Symptom One: When Outlook is opened, the program is looking for Exchange Server. She is using a laptop with no exchange server available. Symptom Two: When performing Office Update, three items did not install all with error code 0x8024402C: 1. Update for Outlook Junk Mail (KB943591) 2. Office 2003 update SP3 3. Security Update for CAPICOM (KB931906) I suspicion that Office 2003 is a 60 day trial that has never been activated. Are ...

Slow Open/Save over Network Connection
My client has an Apple XServe located in a "co-location" server farm which is providing very fast and reliable network speeds (10 mbps DL, 11 mbps UL). His office location is using AT&T DSL with DL speeds around 3.5 mbps. The directory that sits on the XServe is shared over the internet so my client can access it from multiple locations. Most of the documents are MS Word files. They are using Intel based iMacs with the latest versions of MS Office 2008. The problem my client is facing is the horrible speeds of opening, saving, and closing Office 2008 files. It could take up...

Using Word 2003 in Vista: Opening dictionary shuts down Word
This is a problem in Vista; it did not occur when I used Word 2003 in XP. Whenever I try to open the dictionary in Word 2003, either by clicking its icon, or hitting Alt+click over a word, Word shuts down. Vista Business, Service Pack 2 Thinkpad T400, Intel Core 2 Duo CPU, 3GB RAM ...

MFC Registry Access in Automation Servers (EXE)
I have written a MFC server application (MFC automation server). Some configuration settings are saved with WriteProfileInt /WriteProfileString to the registry. I used SetRegistryKey("Mycompany") for the registry path. The application works fine under different users. Now this application is started as embedded server via my ASP code from the IIS. The machine is a Windows 2003 Web Edition Server. For this case the DCOM and IIS settings uses a predefined user for the ASP code and the COM server. If I start the app per hand now under this user everything is going well. But if the app ...

Excel 97 Worksheet Protection and cell colour
Hi there, One of our users has setup a worksheet will a small range of cells that are locked (they have formulas in them), he then protects the sheet. He then wants to change the colour of some of the other cells, these cells are not locked, but he cannot change the colour of the cells. Is there an obvious solution? Cheers, Andy Hi AFAIK you can't do this in Excel 97 without first removing the protection -- Regards Frank Kabel Frankfurt, Germany andy wrote: > Hi there, > > One of our users has setup a worksheet will a small range of cells > that are locked (they h...

center text when conditional format applied
Textbox control on Access 2007 form lost its centered alignment when conditional formatting is applied. This did not happen in previous versions of Access. I tried using format painter to apply conditional formats from a control created in an earlier version, but this failed. The control created in the earlier version then lost it's centering after saving in Access 2007. -- Roy Handy Interesting. I tried to replicate this behaviour but failed, it all worked as it should. Try revisiting your form after applying the conditional formatting and resetting the text box to center text. ...

Restricting SubForm to One Record Entry Per Parent: Access 2007
Hello All, I have a one-to-one relationship between two table. I have successfully added the subform, but I get the option to add additional child records in the Datasheet View. This means that when a user tabs to the next row and enters data they get an error--and they should. Question: How do I restrict the subform to show only one row in Datasheet View? I hope I was clear. Feel free to ask for clarification. Thank you in advance for your assistance. Alcide, You have two options here. If the records are already added to the source of the subform you could set the &qu...