sort when click buttons on form header
I have a continuse form and underlined query as record source.
I want user to be able to click buttons on the form header to sort. I have
Last Name, First Name, Department, Phone etc. How to code these buttons?
If the source is a straightforward select query you can always use
right-click of the mouse (but have you disabled the menu?)
"Song Su" wrote:
> I have a continuse form and underlined query as record source.
> I want user to be able to click buttons on the form header to sort. I have
> Last Name, First Name, Department, Phone etc. How to c...Quicken Password protected
I just got Money 2004 Deluxe, I am trying to import my
data from Quicken and the program says there is a password
for my quicken account that is required, but I never had a
password. No way to get past this. Any ideas?
If your data file is Q04, Money04 can only deal with Q03 or older.
Otherwise, who knows?
"Stephen Weiss" <email@example.com> wrote in message
> I just got Money 2004 Deluxe, I am trying to import my
> data from Quicken and the program says there is a password
> for my quicken account that is req...Where are Form Fields Stored
When I add a field to a form Using CRM form editier, where does it add the
data thta represent the field being added to the form?
Do you mean the information used to render the field on the form or the
actual data? The data will be stored in a table like
contactextensionbase...ie any fields you add to the contact entity are
stored in contactextensionbase rather than contactbase.
this is different than crm 1.2 which stored custom fields in contactbase
Microsoft CRM MVP
"Hotwheels" <Hotwheels...Form On Open event, except not exactly
I have a form with a command button that opens a second form and
populates it with data from the initial form. That part is fine.
What I want to do is use that data in an On Open event (or something)
that will execute *after* the data is loaded by the first procedure.
Specifically, the second form should display an image based on a path
and filename concatenated from the first form's data :
Forms!PhotoData!imgFrame1.Picture = strImagePath
It all works fine using a command button on the second form; but that
requires loading a default image and a manual click to display the
intended imag...Design the Contact Form
I want to add a few fields to the standard Contacts form. When I
select Design this Form it flickers and I end up looking at a basic
version of some kind. I am using Office 2010 so I'm not sure why this
happens. Pointers most welcome. Also I too end up with the sticky
note icon and not a contacts icon for new contacts using this form.
P.S. I can now add that I think it might be the differences between
Forms 2.0 controls and Outlook controls. I have added all the Outlook
controls to my Control Toolbox but still no joy...
...Password Protect Outlook #2
I work in an offcie environment and sometimes have to
leave my PC unattended for just a few minutes.
Unfortunately some confidential emails have been read by
my staff and I need a way of safeguarding them other than
turning off the PC, is there any way I can password
protect access into my Outlook 2000, so all I do is close
Outlook. (Sorry still operating under W95)
You can set a password on a Personal Folders File. If the folder list isn't
visible in Outlook, click View | Folder List. Right-click the root folder
(usually "Personal Folders" or "Outlook T...protecting outlined data
I want to be able to use the expand/collapse function in outlines when the worksheet is protected.
Copy this macro in a normal module
It will run automatic when you open the workbook
You can also use the workbook open event
.Protect Password:="rbelecki", userinterfaceonly:=True
.EnableOutlining = True
Look in the VBA help for more information about protect(userinterfaceonly)
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"rbelecki" <rbelecki@l...How to protect 2. axis in an Excel Chart to stay if data changes
A Pivot table is created on Tab1 in an Excel workbook. On Tab2 there is a
Line Chart created with data from Tab 1 using 2 axis.
If data in Tab1 change the 2nd axis on Tab 2 disappears, jumps ober and
overrules axis 1.
How can I protect chart area with 2 axis being able to change referring data
in the pivot table.
...Password protection on split database
I have a database which is split into front end and back end. The front end
is password protected but the backend isn't Is it possible to protect both
with the same password? I've tried protecting the backend with a password
but when I open the front end it can't "see" the backend.
Put a password on the backend, then, after opening the front-end, use the
Linked Table Manager to update the links (just like you would if you had
moved the backend). You should be prompted for the 'missing' password during
You should only...Protection
OK my problem is I am using an offie computer that everyone has access to and we cannot - and do not want to - change this. Is there a way that I can put a password for my profile on Microsoft outlook so that no one can read the new AND the old messages found in my inbox?
You can put a password on your PST file, presuming you use a PST file...
Emad Kamel wrote:
> Hi everyone,
> OK my problem is I am using an offie computer that everyone has
> access to and we cannot - and do not want to - change this. Is there
> a way that I can put a password for my profile on Micr...Phone Activity Form
My question is regarding viewing phone call activities from the activities
entity created from a quick campaign for Leads. I am only able to view the
regarding (which is the campaign name) and recipient (which is the full name
of the Lead) field, on leads we often only know the company name and not a
first or last name. So viewing the resulting phone activities created from
the quick campaign have to be opened up then click again to open up the Lead
form to view the company name if there is no first or last name, very time
consuming. When I do an advanced find and chose edit columns/...Autopopulate Multiple Fields in Table Using a Form
I have a form based on a table where I want to store data. The data to store
comes from combo boxes based on various lookup tables. The wrinkle is that
there is one lookup table that contains 2 fields of data (questionnum and
question) I want stored in the table once the questionnum is selected. The
question field is formatted as 'memo'. When I create the combo box the
question field is not an option for selection. I add it manually to the
properties after completing the criteria for the combo box. I have been
struggling with the code used to autopopulate more than one field but...Form as Default
I have created a form in order to have a constant cc
recipient every time I open up a new email......how do I
make that the default?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
After searching google.groups.com and finding no answer, Heather asked:
| I have created a form in order to have a constant cc
| recipient every time I open up a new email......how do I
| make that the default?
...Can I create a form to run off of info saved on Excel 97?
I have alot of info stored onto an excel workbook and add to it daily. Info
keyed into this spreadsheet daily has to be handwritten onto a coversheet for
others to view. I have to fill out 30+ seperate sheets of paper with
selected info from each row added into excel each day.. Is it possible to
print this info out on a form? Or do I have to use Microsoft access for that?
Yes, it should be possible. You would have to create an electronic
version of the cover sheet within XL. Then, in the appropriate
locations you would have cells with formulas that look up the relevant
data from ...Access Forms using Word as Base
I would like to create a form to input information into an Access database.
I would like to have the Access form resemble the Word fillable form as much
as possible. Please let me know if there is a way to use the design of the
Word form as an Access input form or if I have to design the Access input
form from scratch. We are running Access 2002 on an xp machine.
Thanks and have a great weekend!!
You can use a bitmap image of a Word form as a guide to placement of the
controls on a Access form, but the only way that you can use a Word form
with Access ...CANNOT PROTECT
Trying to password and read only protect a Microsoft Word
docuement that is embedded in Excel. When I open
the "protected" document, the read-only prompt does not
appear...and I can still make changes and close the
Try this: create the document directly in word, protect it and save it to disk. Then copy the text you want and past it special as an OLE object in excel
...How to protect cells?
I would like to protect a range of cells (A2:D24) with a password for a
group of users that would make changes to cells in this range. Then on
the same sheet, also protect a range of cells (E2:E24) from everyone but
me. Is this possible?
Please don't multipost.
See the thread in .programming.
"Mark F." <firstname.lastname@example.org> wrote in message
> I would like to protect a range of cells (A2:D24) with a password for a
> group of users that would make changes to cells in this range. Then on
> the same she...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...Problem With Form/Subform
Access 2003 desktop application .......
When I try to open a form/subform I get the message:
"Could not use <name of backend file>; file already in use."
What could be causing this message to appear?
If I click OK, the form opens with just a blank space for the subform. If I
remove the control source from the subform control, the main form opens
correctly. I can open the subform by itself with no problem.
I have rebuilt the form/subform and get the same message.
Thanks for any ideas!
"Steve" <email@example.com> schreef in be...How to Activate "Show all" in a Protected Shared Workbook
I created a protected and shared workbook in Excel 2003 ,the default
Filter Option is "Auto Filter"
how can I use the "Show All" in Filtering.?
even I unchecked the "Filter Settings" in "Tools-> Share Workbook ->
Advanced -> Include Personal View " but it did not work.
If the workbook were not shared, then you could create your own macro that
unprotects the worksheet, does the showall and reprotects the worksheet.
But with the workbook shared, you can't change the protection of a shee...Password protected sheet access
I have a spreadsheet protected with a unknown password.
How do I access this sheet?
Ps: the "read only" option is not available.
Is this the password for opening the file, or the one for unlocking locked cells in the
already open sheet ?
Best wishes Harald
Followup to newsgroup only please.
"Rivane Cardim" <firstname.lastname@example.org> wrote in message
> I have a spreadsheet protected with a unknown password.
> How do I access this sheet?
> Ps: the "read only...Having 3 .set files with different ISV's and custom form modifications
Currently we have 2 seperate SQL instances for 2 different
environments. We want to be able to create one environment that has 3
companies, with one .set file with customizations, and alot of
ISV's; one company with customizations and 2 ISV's; and create one
new company with a plain vanilla GP only 2 ISV's no customizations;
We currently have the 2 instances with the first 2 set up that way and
now looking to consolidate into one environment with the company
dropdowns together. Will this be a pain to manage or is it even
...Form problem 03-11-08
I have an input form to capture records to linked SQL tables. the one form
opens up with a blank screen on a new record, which is right. The other form
opens up with a record loaded... I've looked at every single property for the
form, but cannot see a difference between the two forms. Also, the tables
that the forms are linked to are identical in setup.
Can you help?!
On Tue, 11 Mar 2008 08:05:01 -0700, PsyberFox
>I have an input form to capture records to linked SQL tables. the one form
>opens...Form closing unexpectedly without error
Morning all. I'm seeing something really strange on a form I'm
reviewing, wondering if anyone can offer any suggestions. Access XP/
I'm opening the form to add a new record with:
DoCmd.OpenForm "frmInventoryItem", _
Only one field on this form is required. If I enter the required
field, everything happens as I would expect. If I do not fill it in,
* If I close the form by clicking on the "x" in the upper right
corner, I'm prompted twice: once that "The field '...Protecting a Worksheet
Does anybody know how to protect a workbook so that a user
CANNOT unhide a sheet, CANNOT add rows to the viewable
sheet, CANNOT alter locked cells, but CAN add text to a
comments column which will expand and Wrap text as the
comments increase in size?
I understand how to protect/unprotect locked cells, but I
cannot find the right combination for the above
functionality. Is it even possible?
Any help is greatly appreciated.
When a _Workbook_ is protected (Tools, Protection, Protect Workbook,
Structure) sheets cannot be unhidden.
When a _Worksheet_ is protected locked cells ca...