Undo dirty form after opening popup form
I have a subform within a main form. On the subform is an option
group with three option buttons. When you click on any of the option
buttons a popup form opens to which the user inputs a date. I need
the user to be able to click a cancel button on the popup form that
would close that form without saving changes and undo changes on the
underlying subform (i.e. return the option button to it's original
selection) that initiated the popup. Can someone help me with the
right syntax to use in the code? Thanks much!
I tried this behind the click event of the "Cancel" button on t...Excel data entry: choice of control for selection
I need to distribute a workbook as a data entry device that applies a
few constriants. In column A I have a list of Names. In Column B a
City needs to be selected from a limited list for each Name. The text
below describes "nearly there" options I've explored; but I'd like
opinion from experience. The objective is to be easy to for the user
to work around, reliable for its purpose of constraining values, and
ease of build and maintenance.
1. Is there a good way to replicate a Forms control (e.g., the
listbox) down an Excel column, so that it both addresses the cell
benea...Exchange Server 2007 and Domain Controllers
Could someone please tell me if I have to install Exchange Server 2007 on a
AD Domain Controller, or can it be installed on a member server? I have a
Windows 2008 Server that is a member server in a Windows 2003 Active
Directory network that I'm looking to install Exchange 2007 on.
Also, could someone tell me if there are any articles out there that will
help me install my Exchange 2007 in the same domain as an existing Exchange
2003 Server (running on Windows 2000 Server)? I'm looking to install the
new Exchange 2007 as a new server (new name) and migrate th...Using Access form to assign values of variables in an Excel VBA program
I have created a VBA program for Ms Excel.But,to get desired results,
every time, I go into the code to change the values of variables.Is
there a way to get the values of variables stored in an Access table?
YOu need to do a search for ADO method (ActiveX Data Object). There
are plenty of example of code on the web. You need to add two
references in your VBA to use the method.
from VBA menu tools - References
1) Microsoft Access XX.X object library
2) Microsfot ActiveX Data Objects X.X library
Use the latest versio of the two libraries on your PC.
You will make a conn...How do I get other email form my other accounts to show up
I have an email with hotmail, I would like to show up on my outlook and I
have an email with my university, I would like to show up on my outlook. Is
this possible and how if it is?
How to Configure Outlook with Hotmail
How do I add a POP3 email account in MS Outlook 2003?
"MIKE25" <MIKE25@discussions.microsoft.com> wrote in message
>I have an email with hotmail, I would like to show up ...Form Error (Query Update)
I have about 12 people to work on the database and each has own userID
and password. Their UserID and Password input and the form link to
the query that has the filter on "UserID and Password" for their
The message said "Can't Update; Query Locked".
Is there I do something wrong? I thought the form is the shared for
everyone to input based by UserID and Password.
We aren't there. We can't see how your database is set up.
For instance, do you have a split database, with a single "back-end" file on
your network an...How to set appointment at 4:15pm instead of 4pm or 4:30pm
I can't figure out how to get Outlook to allow me to start an appointment at
4:15pm. Outlook only allows me to set the appointment at 4pm or 4:30pm. I'm
using Office 2003 for Students & Teachers and WinXP professional. Any
suggestions would be much appreciated.
Highlight the :30 with your mouse and type over :15.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
http://www...Disable/Enable all controls on a form based on value of another control
What is the best to way to exclude a specific control (or controls)
from the following condition? (e.g., I would like to exclude SubjectID
and MRN from being Enabled or Disabled):
Dim Ctl As Control
On Error Resume Next
If IsNull(Me.SubjectID) OR IsNull(Me.MRN) Then
For Each Ctl In Me.Controls
Ctl.Enabled = False
For Each Ctl In Me.Controls
Ctl.Enabled = True
I'm using this to ensure that the user enters the SubjectID and MRN
*before* entering more data for the subject. By disabling all the...Form Speed
Has anyone noticed speed improvements by writing less code in the
actual form module and keeping most of the code in a seperate module?
> Hi All,
> Has anyone noticed speed improvements by writing less code in the
> actual form module and keeping most of the code in a seperate module?
No, the reverse is probably true, but only by microseconds. Forms are slowed
by the abundance of data. Limit the data by using queries on properly
indexed tables, and you speed up forms immensly.
Arvin Meyer, MCP, MVP
...Controlling Spell Checker
Is there way to have control over the MS-Access spell checking (besides just
launching it)? We want to tell it to check all records, but skip certain
fields (or, alternatively, ONLY check certain fields). Is that possible?
Alternatively, if that's not, we noticed that the spell checker skips fields
that are disabled. So one could disable the fields to be skipped; run the
spell checker; and then re-enable those fields when done. But how would one
know when it's done.
> Is there way to have control over the MS-Acces...Setting up a new integration for Wennsoft subcontractors
I'm having difficulty in setting up a new integration for importing vendors
and subcontractors from one data base to the another. I need to be able to
stipulate Jobs and cost codes against these as well though I think I'll need
to create new integrations for that?
...How can we make a control in a form to a required field
My form is based on a query which consists of 3 tables:
There is a tendency save the record without filling in the supplier number
and when they want to update the record they can not see anymore the record.
Wht is the VBA in the controls/field of the form that supplier number and
project number are compulsory meaning they can not save the record if they
leave thses 2 fields missing
Thanks in advance
H. Frank Situmorang
Don't go about this in VBA. Put the restrictions in the table design by
setting the field properties to requi...Allen Browne's Calendar Control
I am attempting to use Allen Browne's calendar control located at:
But I am getting the following error when I click on the calendar
"Compile error: Can't find project or library"
The Yellow debug arrow points to the following lines of code:
Private Sub Form_Open(Cancel As Integer)
On Error GoTo Form_Open_Err
'Initialize to the existing date, or today if null.
If IsDate(gtxtCalTarget) Then
Me.txtDate = gtxtCalTarget.Value
Me.txtDate = Date
With "Date" after the equals ...When Load Form
I would like for my textbox to update when my form loads.
I tried the following code, but my textbox just stays blank.
Private Sub Form_Load()
Text0.Text = "hello"
On Jul 4, 10:51 pm, "Tim McGavin" <n...@gsw-inc.com> wrote:
> I would like for my textbox to update when my form loads.
> I tried the following code, but my textbox just stays blank.
> Private Sub Form_Load()
> Text0.Text = "hello"
> End Sub
> Any ideas?
Text0.Value = "hello"
On Wed, 4 Jul 2007 23:51:25 -0500, "...Aligning controls at runtime
I have a form designer. The user can drag drop controls on the form. I
need to work on a feature where a user can align the controls placed on
the form. All of this is at runtime. Can someone help me in this
Thanx in advance.
> Hi ,
> I have a form designer. The user can drag drop controls on the form. I
> need to work on a feature where a user can align the controls placed on
> the form. All of this is at runtime. Can someone help me in this
> Thanx in advance.
Every control is a CWnd. Its current...Contact Form
I'm using Outlook 2003.
How can i create a new form and use it?
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"B_" <firstname.lastname@example.org> wrote in message =
> I'm using Outlook 2003.
> How can i create a new form and use it?
Tools->Forms->Design...Display Date from Unbound Field in Form in a Query
Just had an issue that in 10 years of using Access never saw - just wondering
if I just never encountered it or what...
I have a form running a query, the user enters a date. The report needs to
show the date - so the query has a field like this:
report date: [Forms!]![frm_report]![txtReportDate]
I had a problem exporting to Excel - seems the direct placement in the query
led to characters that Excel could not understand. I actually had another
date field from the form that I did a date add on, it worked fine. I
eventaully put the form reference in a Format, the issue was gone.
The...Unable to set Date Range on UPR_Month_End
I am in Dexterity, and I am opening the form UPR_Month_End and setting the
date range unfortunatly the set start date and end date are being wiped out
before the form makes it to the user. My code worked before the last
service pack from Great Plains, and I have tried many things to get it to
work. Basically what i am doing is on a button click on one of my forms I
am trying to set the date range on the period end payroll reports screen to
the beginning and end of a quarter for convienence because the ability to
run quarter end reports was removed from Great Plains. Below is the code...How to set Cache Mode via Group Policy?
We are running Win2k3 and Exchange 2003 in a 2003 domain. I need to push
out "Cached Exchange Mode" to everyone. Anyone know how I can do this? I
was thinking Group Poilcy via the Office 2003 ADM but I don't see options
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
On Fri, 06 Apr 2007 18:21:20 GMT, "Clayton Sutton" <email@example.com>
>We are running Win2k3 and Exchange 2003...Line Item Comment Text On Forms
I am trying to get the line item comment text to appear on my Sales Transaction entry forms (i.e. quotes, orders, and invoices). At present, this field shows but only 4 lines of text and only so wide. I would like to get infinite lines of text with the field growing or shrinking as need be on the form.
Would appreciate any advice here.
> On Tuesday, July 26, 2011 10:50 AM Mark Plaideau wrote:
> Good morning.
> I am trying to get the line item comment text to appear on my Sales Transaction entry forms (i.e. quotes, orders, and invoi...Add new fields to a form
Access Newbie here.
I created a simple little Contacts database and emailed it to my data entry
person who is in another city.
She has already entered quite a few records.
Now I would like to add a couple of new fields to the form.
Whats the best way to do that?
Is it possible for me to email her the new form and she can import it into
The database should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). In that way, anytime you need to make an
application ch...looping through controls
If the user checks selects 'Yes' from a combo box, I'd like to enable
a group of check boxes (all have tag property "col"). If the user
selects 'No', I'd like to disable them but, if any are checked, tell
the user data will be deleted and then set the checkboxes = Null
(assuming the user says okay). My current code triggers the prompt for
*each* check box that's checked, rather then looping through them
automatically. Do I need to another "For each ..." clause after the
first Else statement?
Private Sub cboColor_AfterUpdate()
...set first day of the week
how to change the first day of the week (that my boss use a weekly reports)
set datefirst 6 statment, completed succesfully but with no changing of
default setting ( 7 ) ,any help please
...delegate Control #3
I would like to rollout delegate control over our domain could any poin tme
to a good website that explains what each custom control does?
...Run-time error 2137 Received On Form Open
I have a switchboard that enables users to add, edit, or view reports. My
edit button runs a marco that opens my form but then also runs code Find().
This has worked for a few years but now a user receives the run-time error
2137 when they click that button. Any ideas on the fix or should the user
upload another copy of their front end? It is running on Access 2003.
Is it one user or are there multiple users which get the error. Has a service
pack been installed?
Take a look here:
First start by co...