hide a text box in a continuous form
I have a form that i created that display each form as a row in a continous
form. What I need is to have one text field on one row not visible when a
check box is checked. Does anyone know how to do this? Thanks!
Using Conditional Formatting, evalaute the state of the field bound to the
CheckBox to set the Background color of the TextBox to match that of the
Background color of the form. You might have to set the Disabled prop via CF
There is sample code showing one wat to accomplish this here:
A2K or Higher Only!
New Feb 08,2002...In role Form\insertAction\sendEmail\description(please help)
add date field to this section ,but when I recieve this Email I cant see
...Form as Web Page
It has been many years since I used Access, but I would swear that I used to
be able to save/export the form as an HTML or at least make it look like a
webpage. I want to be able to open the form and add/modify records without
having access to (or even see) the tool bars, etc...
Yes you could save as a Data Access Page. Does not have all the
functionality of regular forms. Maybe this would help:
MS Access 2010 will be released in June and has the ability to build web
databases. Quite nice from what I have seen. The ...Form creates unwanted rows in table
I've created an asset database which keeps track of computers, laptops
etc. There is one company which has many departments and every
department has many rooms. (surprise, surprise)
There are four tables: tables Department and Asset and two "middle"
tables DepartmentRoom and AssetRoom.
The table structures are as follows:
depID (foreign key to department)
assetID (foreign key to asset)
roomID (foreign key to depa...How do you get the maximum value to display in text box form
In a form, if I have 4 text boxes and 3 of them will contain a number. How do
you get the maximum value to display in the 4th. I have tried many different
things, I can make it work for a single field in a table, but that finds the
value through all records. I just want it to display the max value from the
numbers on the form, which could be different for various records.
You could use something like this as the Control Source of the 4th text box
(the underscore is for ease of reading here, and must be removed from the
=IIf([Field1]>[Field2] And [Field1]>[Field3],...Can't get Date Range to work from Form to Report
I've followed Allen Browne's directions very closely for creating a form for
a date range to limit results to that date range on a report and can not get
it to work for some reason. I've read many threads on this board which all
say the same thing and it seems to work for everyone else. :(
Here's what I have:
A form with two unbound text boxes called [txtDateBegin] and [txtDateEnd].
The form is called "frmDateRange" and the report is called "Sales Activity
Report". The two unbound text boxes are set to "Short Date" format which the
user ...Can a form update a database?
I need to create a conference call agenda/meeting minutes template. On it
I'd like to use check boxes to note who of the invitees showed up. I'd like
to be able to get a listing of all the people (who may or may not be invited
to all meetings) and the dates they attended. Can a form in Excel populate a
database or could the form populate another Excel file? I'm real stupid
about how to do things like this - does anybody have advice or maybe even a
I'd put the checkboxes in column A (say A1:A20) and link each checkbox to the
cell underneath the check...Format TextBox to Currency in a Form
I am having trouble formatting textbox in a form.
Here is a little background on what i did in a form. I have a combobox that
has all the company names. I am populating textbox results by selecting
company name from the combobox. For Example, If i select CompanyA from the
combobox then the textbox1 will populate its revenue. But, its populating in
a general number format without any decimals.
I tried everything from changing the property in the textbox and the source
But i have no luck getting the Currency in the format.
Can someone please help me with my isssue.
...Subreport in Form
Virtually, what I would like to do is put a subreport in a form. Reading
around, I have discovered this to be impossible ;).
Basically, what I have is a report building form that I would like to have a
preview of the report off to the side. Is there a practical way of
accomplishing this? I am using Access 2007.
Thanks for any input!
...Data entry forms
Is it possible to create a data entry form in outlook (2003 or 2007) where
the user could fill-in fields... and then send it back to the originator?
If so, how? What is it called in outlook so I can look it up further?
You can use Custom Forms for this or use InfoPath if you have that installed
for your users as well.
A good resource to get you started with custom forms and VBA see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
h...Outlook Desktop Client Error
I have installed desktop client on my system.It has been installed
successfully.While opening the outlook it is showing some errors like error
while loading Crm functionality. CRM server is unavailable, try again later.
This is my system configuration
Windows 2003 server standard edition
MS office 2003 with SP2
Previously it was working fine.
The errors are
1.There is a problem communicating with the Microsoft CRM server.The server
might be unavailable. Try again later.If the problem persists,contact system
2. An error occured loading CRM functionality,try restarting ...Making custom form default for contacts
I am a beginner with Outlook. I am a new hire in a department that uses
Outlook contact information in a Word Mail Merge process. I am teaching
myself how this all works, and have been doing ok, but I am struggling with
forms, particularly the form used for contacts. I don't have any problems
modifying the form (for example to add FirstName and LastName fields), but I
am very confused about how to get Outlook to use my modified form instead of
the default custom contacts form.
It seems to me that this should be a simple property setting, but I've had
no luck tinkering w...How do I create drop down form fields in Excel?
Is it possible to create dropdown lists in Excel? If so, how do I do it?
You can use Data Validation to create the dropdown lists. There are
instructions in Excel's Help, and here:
> Is it possible to create dropdown lists in Excel? If so, how do I do it?
Excel FAQ, Tips & Book List
...Finding Desktop region in MFC
I am working on a commercial application, and recently discovered a bug
I have been asked to fix (they threw it back in my lap).
Run the application on a 2-monitor system, such as a laptop in a dock
with an external monitor. Drag the main window to the second
(non-taskbar) window and quit. Now move the laptop to a different dock
with the second menu on the other side (or without a second monitor at
all) and launch the app.
Oops. The app continues to want to go on the side it was last put, even
though there is now no monitor there. (Yes, my dock in the office and at
home have the second ...How to sometimes open form to new record?
I have a parent form which is then linked to a child form. I want to
have two buttons on the parent form, one to open the child form and
display all the records with the corresponding foreign key, and one
button to open the child form to a new record with the corresponding
foreign key already inserted. I have figured out how to open the child
form to a new record, but I cannot figure out how to insert the parent
ID into the child foreign key. Help! Thanks.
You don't have to enter the ParentID in the Child subfrom records...
Establish a one many relationship between the Pa..."Replace" keyboard shortcut
MS Word 2004
Re: Find/Replace, it is a quick, efficient keyboard process after
highlighting a string to be copied to hold the Command key while
pressing C, F then V. When I then want to enter the "replace" string,
my hands have to leave the keyboard, go to the mouse and click the
Replace tab before I can continue. I cannot find any reference that
offers a keyboard short to drop down the Replace window. Is there one?
I'm not sure if there is a direct keyboard shortcut for the Replace
command, but once you've brought up the Find dialogue, you can simpl...Promted for opening of attachment form Outlook
I have tasks linked to notes in One Note, whenever I click the attachment to
open the notebook, I get a "Opening Mail Attachment" you should only open
attachments from trustworthy.......... and the " always ask before opening"
box is checked and grayed out so I cant change it.
Although not the biggest problem in the world, it is an annoyance. Any
thoughts on how to eliminate this?
-------- Original-Nachricht --------
> I have tasks linked to notes in One Note, whenever I click the attachment to
> open the notebook, I get a "Opening Mail...Accessing desktop shortcuts when programs are running
Operating System: Mac OS X 10.5 (Leopard)
Is there any way to toggle between program windows and the desktop so that you can access the shortcut icons there without resizing or minimizing your program windows? It would be great to be able to do this, especially when I have four or five word documents open . . .
You can use the ApplicationName> Hide ApplicationName or Hide Others command
to hide the window(s) to access the Desktop - assuming you don't have any
other application windows open.
However, you might want to explore other more effective...Is there any way to use outlook forms in public folders through OW
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"You''ll never walk alone" <Youllneverwalkalone@discussions.microsoft.com>
wrote in message news:DCF3575C-B329-4375-8977-C4ECDE9045A4@microsoft.com...
...Form Combo Box
In Cell A1 I have a link to a Index function that uses Indirect(A1) to look
up a named range.
I also am making a form, and I just want the form to choose between some
names that are located in cells "Z1:Z10" of the worksheet and put the
selected name in Cell A1.
How do you link the combo box to cells Z1:Z10, and put your choice in cell A1?
Thanks a lot for your help
> In Cell A1 I have a link to a Index function that uses Indirect(A1)
> to...Newbie Remote Assistant and Desktop Questions
Developing C++ on VS 2008 Pro, XP Pro, Win32.
I have a client that recently upgraded from Vista to Windows 7
Ultimate, 32 bit, on his laptop.
I recommended he get Ultimate so I could run Remote Desktop over
the Internet. This is before I actually tried using Remote Desktop.
After getting Remote Desktop up, I see that I really want, to help
my client, is Remote Assistant.
Both Remote Desktop and Remote Assistant are now running fine with
two XP PCs on my LAN, using my Internet address, to connect.
I've cobbled together port numbers requiring...Changing & recalculating default values on a form
There are a number of occassions in my application where I use a calculated
control (1) as the default value for an unbound control (2). Most of the
time the user will accept this value and move forward; however, if one of the
underlying values upon which the calculated control (1) is based changes, I
would like the value of the unbound control (2) to be updated. I do not want
to bind the control (2), because there will also be a few times when the user
will need to change its (2) value independent of the value calculated in
Can I do this? Thanks so much.
i have the following working within a macro:.
'copy the data to the database
ws.Cells(iRow, 1).Value = Me.txtPart.Value
ws.Cells(iRow, 2).Value = Me.txtLoc.Value
ws.Cells(iRow, 3).Value = Me.txtDate.Value
ws.Cells(iRow, 4).Value = Me.txtQty.Value
Is there any way a can change this to do the following:- when i open the
form it moves to the next column, for example if i allocate cell AF 21 then
the next time i open the form it would go to cell AG21
Sorry the full macro is this
Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Part...code to change a form's allows?
I am wondering what the code syntax is to tweak a form's allows? Allows
deletions? Allows Adds? etc I know how to do it in the right-clicked form
properties manually, but I need it to be based on conditions.
Reason I need this is because I have one form that all users open.
Depending on their window's username, I have a security table that tells me
what role I want them to have in the database. Depending on their role, some
users have more rights than others on this form. I want to adjust the form
to allow additions for some users, but not others.
Me.AllowAdditions = Fals...Using a custom form kills forward/reply arrows in the inbox?
I installed a custom email form in Outlook 2000 and the "Forward"
and "Reply" arrows on mails in the inbox disappeared.
The arrows reappear on new mails when I swap the default back to
IPM.Note but as I really have to use this custom form the absence of
the Forward/Reply indicators is a pain.
Has anybody come across this issue before?
Is there a method to turn these "flags" back on or do I have to dig
into the code in the custom form?
The custom form is just a modied IPM.Note that provides access to a COM
Known issue, dating back t...