Events, dear boy, events #2
Yes I'm certain. I'm right-clicking the worksheet tab to view th
sheet's code page, then pasting the in the event code..
Gromit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=92
View this thread: http://www.excelforum.com/showthread.php?threadid=27721
...OWA Forms stops working
Exchange 2003 SP2
I have forms enabled but about once a day the forms stop working and instend
the popup box aksing for user name and password comes up.
Restarting the IISADMIN service fixes it but I can't find any errors in the
Have anyone seen this before or have any ideas?
...Modal Form from a child form
Hi, I have a little problem, I have a MDI form (Main Menu), this form
open a child form (A), and I need to open a form B as modal form from
form A. I can to this with showDialog(), but it open form B outside
MDI form (Main Menu) and it is showed on the windows bar as another
So the question is, there are any way to open a modal form from a
child form inside a MDI form?
El Alquimista wrote:
> Hi, I have a little problem, I have a MDI form (Main Menu), this form
> open a child form (A), and I need to open a form B as modal form from
> form A. I c...automatically get an alert when someone adds an event to public Calendar?
Is there a way to automatically get an alert when someone adds an event to a
Having the person who added the event send me an invite is not an option,
because they will not do this. (I am required to check the calendar to see
if any events have been added.)
I can't see a way to quickly see what new events have been added so I have
to check the whole calendar. (Or is there a way to view events by the date
they were added, not the date of the event?)
There should be some solutions for this at =
Sue Mosher, Outlook...Simple data form
I'm creating a Shipping template in Excel, and I want a simple form to
pop up for the line items. I can see how to do it using Data/Form,
however is there another way to do it, by not making the user do that?
Maybe so the form opens up when they get on the first cell of that part
of the worksheet?
Also I noticed when I do use this form, when I close it, it doesn't
bring me back to the worksheet, but rather to the VB code. I don't want
this to happen to my users. Any ideas?
~~ Message posted from http:/...Slow Closing of Form
1. Front-End - MS Access 2003
2. Back-End - SQL Server 2005
3. OS - Windows XP
I cannot understand why it takes a 5-7 seconds to close our Invoice form.
The Invoice form has several data components in it that retrieves data.
The code in the "Done" button of the form perform the following:
b. Check other loaded forms "IsLoaded()"
The form has also a code in the "Close" event which only checks for loaded
forms again "IsLoaded()".
Check to make sure that you aren't saving any f...Calendar items "disappear" with Event id 8206, 8239, 8241
I am using outlook xp with windows2k, share a calendar with other staffs.
"one of them will syn the calendar with the PPC". Now some of my calendar
items disappear after a while. They are still there but the stat/end dates
I can still see them if I do an "advanced find" under my calendar items and
search for all items. They appear in the list with no start or end date. And
it occurs randomly.
Thanks for support.
"Kenny" <Kenny@discussions.microsoft.com> wrote:
>I am using outlook xp with windows2k, share a calendar with oth...Create a copy of a form and link the entire form to a new datasour
I have two surveys: the initial survey and a post survey.
The Post survey includes all the questions in the initial survey as well as
I want to save time in creating forms. How can I make a copy of the initial
survey form and call it "Post" and add my new questions but change the source
to my "Post" table without recreating the entire form?
Thank you in advance.
You change the recordsource of the second form. You can use a single form
and change the recordsource on the fly. Just add a button to the form to
change the recordsource...Form won't open anymore
I was working on a form in design view and was adding a subform. When I
finished the wizard I resized and repositioned it and clicked save. A message
box came up saying "There is not enough memory to perform this operation.
Close all other programs and try again" I did this but still the same
message. The only way out of it was closing the form without saving it. Now
when I try to open the form it doesn't open in either design view or normal
view. When I try to open it from my menu with a button I get the runtime
message 2001 "You cancelled the previous operati...Form freezes
the logic is like that,
I have 4 queries, each query performs a diffirent calculation from different
each query have been called using the example down.
sslt_trnsfin = Nz(DLookup("Total_trns_volume", "Q_trnsf_in"), 0)
slt_trnsfin = sslt_trnsfin
sslt_trnsfin2 = Nz(DLookup("Total_trns_volume2", "Q_trnsf_in2"), 0)
slt_trnsfin2 = sslt_trnsfin2
sslt_trnsfin3 = Nz(DLookup("Total_trns_volume3", "Q_trnsf_in3"), 0)
and so on
i tried to put some text box within the for...Hyperlink on forms
I have a silly problem which is baffling me.
I have two forms - one single form view, one continuous forms view.
The single form has a tab control.
I have a hyperlink text box control on the continuous form and an identical
one on the tab control of the single form.
The hyperlink on the tab control only works if the sub-menu item "Hyperlink
> Open Hyperlink" is used. If I click on the control, the system inserts a
"#" before and after the url and then does nothing else. If I put the text
box control in an area of the form outside of the tab control,...Multiple Order Forms
I am in the process of customizing CRM and was wondering if it's possible to
create multiple order forms. Example... Different order forms based on
different products as the order information will change.
Thanks in advance for any advice.
There is no way of doing this with the standard client.
The only option for you is to customize the order system with your own ASP
"Jason" <Jason@discussions.microsoft.com> wrote in message
> I am in the process of c...AfterUpdate/BeforeUpdate and SetFocus
I have some problems with the SetFocus command in a Userform with an
AfterUpdate or BeforeUpdate routine.
To make it clear to you, I made a very small Userform to demonstrate it. It
only contains 8 TextBoxes and this code:
Private Sub TextBox01_AfterUpdate()
Private Sub TextBox02_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
Private Sub TextBox03_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Private Sub TextBox04_Change()
I expected that in ...The custom form could not be opened.
In Business Contacts, I get the message: "The custom form
could not be opened." on a nearly daily basis ... it then
goes on to say: "Array index out of bounds." I can go
in, clear the cache on "custom forms" in the business
manager, and the problem goes away, but it comes back
again soon for no apparent reason ... anyone know how to
have you tried deleting the frmcache.dat file, along all the form "folders"
in that same directory?
"Angie" <email@example.com> wrote in message
Hi everybody, i am having this problem:
There was a programmer that made an access aplication with VB Modules,
forms, an so on (With Spanish Office 2000), and now the organization change
all the aplications to English versions (including Office 2K).
The problem is that when i run the access app (With English version of
Office 2k) and click on any button, i get this error :
Microsoft Office Access can't find the macro 'procedimiento de evento'
But when i run de app with Spanish version of Office 2k (in other computer)
there is NO problem with the app and works well.
Any i...Checking for opened form
How can I check if a form is already open?
This always woks for me...
In a module... (TIP: Do NOT name the module IsLoaded!)
Function IsLoaded(ByVal strFormName As String) As Boolean
' Returns True if the specified form is open in Form view or Datasheet
Const conObjStateClosed = 0
Const conDesignView = 0
If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <>
If Forms(strFormName).CurrentView <> conDesignView Then
IsLoaded = True
Then p...CScrollbar events in VS 2003
I've added a scroll bar to a dialog in a new dialog only mfc app. but
the only event I can find for it is NM_THEMECHANGED (which throws a
compiler error)? Can I add my own WM_SCROLL handlers?
...one label all forms
I want to put a label on all my forms that says YOU ARE IN ARCHIVE. Can I do
this without placing a label on each form? Thanks.
You could set the form's Caption to that. That would mean that it would
appear in the bar at the top of the form. However, you'd have to set it, so
I don't know whether that'll save you anything.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"seeker" <firstname.lastname@example.org> wrote in message
>I want...Linked form can't be edited
I have a large table with contact details and also additional details which
only relates to about a third of my clients. If I include all the fields in
my main input form(1) it becomes very cluttered so I have created another
form(2) for just the additional information and select it with a button from
form(1). Form(2) is filtered according to the client in form(1). However even
though I have enabled editing in the properties box, I am unable to edit the
form(2) fields. Without the filter it works fine, but I have to find the
client manually to add the additional information. What...AfterUpdate
In the AfterUpdate code I had the detail back colour change if a check box
(tbc) = True. However if I tick the box now it turns the back colour of every
form irrespective if that record is ticked tbc or not!
Any help on solving this would be great.
Private Sub tbc_afterupdate()
If Me.tbc = True Then
Me.Section(0).BackColor = 65535
Me.Section(0).BackColor = 16777215
If you are using a continuous form, that code won't work. The good news is
that you can use Conditional Formatting to make it work. In Design View,
select the combo box and fro...Reservation Form
I have an active website for my business. I built it in Frontpage 2002.
It no longer will send email through the settings I used ( Reservation
form) and I cannot get it to take any of the settings I give it. I do not
think that my knowledge is sufisticated enough. And, I don't think that I am
entering the information completely enough.
I am using a simple form with a single enter button.
Can you help?
May be possible.
Microsoft MVP Expression Web
"FrontPage 2002 on windows XP"
<FrontPage200...Worksheet_Calculate code in same module as Worksheet Change event goes astray
Hi, I'm trying to get some code to fire, based on a formula in cell E2
changing value to equal 1.
Private Sub Worksheet_Calculate()
If Cells(5, 2) = 1 Then MsgBox "Fires ok"
'Application.EnableEvents = False
I can get it to work properly on a blank spreadsheet. However I need to
use it on a worksheet that already has a Worksheet Change code. Since it
seems like each worksheet can only have one module (page? not sure of
the right name) for code, the above code is in the same module as the
Thus, when the entry is made that chang...Auto populate a form form an open form
I have a main form with customer names and addresses and would like to
add a control button on this form which opens up another form which is
used for recording telephone calls on. What I have been trying to do
is auto populate this call log form with information from the main
form ie name and address?
Please don't re-post the same question twice. You have to be patient and wait for a
reply. Responders are volunteers, and you may not get an answer right away.
Posting twice causes some people to respond to the first post, while others are ...copy properties Under forms
I'm wondering if someone can help me with something on copying properties.
I've checked the access help but can't find anything there.
This is what i want to do.
I'm copying text boxes, labels that has caption, name and other information
in the properties that i want to keep when i copy the information to another
tab on a form.
Is there a way i can copy the property information without doing alot of
manual work by going into each text or label box.
I hope this makes sense.
thanks for you help in advance.
When you copy a control, everything about the cop...form pozition on screen
I would like to find form position on screen.
It's similar to DoCmd.movesize, but I want discover "parameters' for form
(left corner, top corner, etc)
Are you saying that you want to find out what the current position IS?
If so, you can use something like this:
MyFormLeftVariable = Me.Left
MyFormTopVariable = Me.Top
MsgBox "My Form is at " & MyFormLeftVariable & VbCrLf & MyFormTopVariable
Or however you want to use it.
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com