Waitable Timer versus Sleep ?
Is there any advantage of using a WaitableTimer versus a Sleep
statement if you have only one thread ?
i.e. the following code
HANDLE hTimer = NULL;
liDueTime.QuadPart=-100000000; // 10 sec
hTimer = CreateWaitableTimer(NULL, TRUE, "WaitableTimer");
SetWaitableTimer(hTimer, &liDueTime, 0, NULL, NULL, 0);
if (WaitForSingleObject(hTimer, INFINITE) == WAIT_OBJECT_0)
cout << "10 Seconds elapsed\n";
cout << "10 Seconds elapsed\n";
On 28 Mar 2005 22:47:20 -0800, ...Fixing coloumn title in datasheet forms
I have a form which has a subform. Is there anyway to fix the length of the
column heading in the datasheet view? I can expand it when viewing but when
I close the form and open it again it has shrunk back to its smaller size.
Are you referring to the column width? If so check out columnwidth
properties in help.
"Tony Williams" <email@example.com> wrote in message
>I have a form which has a subform. Is there anyway to fix the length of the
>column heading in the datasheet view? I can expand it when...problem with overlapping text in contact forms
I have Outlook 2007 on a cumputer running Windows XP Professional SP3. Whe I
attempt to add a new category for contacts, the text input appears completely
overlapped and garbled. When I hit OK to create the new category, it comes
out correctly, but I can not see if it is inputted correctly until after I
hit OK. This problem seems to be spreading to other standard Outlook forms,
especially those that appear in a pop-up window. Any ideas as to what might
be causing this and how to resolve this? Thanks in advance.
I am just new to Access. I have created a form with contacts, names,
address, telephone numbers etc for a company which has several Boards and
Committees. I would now like to add the various boards or committees they
belong to, i.e, the company name is The Brown Company, I have 100
shareholders in my contacts list. There are several boards, ie. the Brown
Investment Board, the Brown Real Estate Board, the Brown Legal Sevices Board
(in all there are about 40 different committees and boards). Within those
Boards I would like to identify which roles or positions the various
shareholde...People who post Ubuntu countdowns here are complete RETARDS
Some mentally deranged posters are using the forum to post daily countdowns
to the next INFERIOR release of that CRAPPY Ubuntu that NOBODY needs or
wants. It is best to ignore those posts.
Electro Lytes wrote:
> Some mentally deranged posters are using the forum to post daily
> to the next INFERIOR release of that CRAPPY Ubuntu that NOBODY needs or
> wants. It is best to ignore those posts.
Electro Lytes wrote:
> Some mentally deranged posters are using the forum to post daily countdowns
> to the next INFERIOR release of that CRAPP...Form Controls
I have a form that I use as a switchboard to print off forms.
How do I select a company name, then after I select the name have it print a
report or form? Can't figure out how it all works together.
Select Company from a combo box
After select, what do you use to get the report to open for that Company?
Here's an example
Dim strWhere As String
strWhere = "IssueID = " & Me.[NameOfCombo]ID
DoCmd.OpenReport "NameOfReport", acPreview, , strWhere
Jeanette Cun...forms #2
I have invoices that get typed out every time Use them. Is there someway
to create the form in excel so I can use the computer? This would be so
muck easier than typing out three copies!
if you'ld like to email me (julied at hcts dot net dot au) direct i have a
sample invoicing workbook that might suit your needs.
"Bob Kerr" <firstname.lastname@example.org> wrote in message
>I have invoices that get typed out every time Use them. Is there someway to
>create the form in excel so I can use the compute...Populate sub form
I have asubform that is linked to the main form via one field, multiples
entries are allowed in the sub form, but the linked field is the same for all
I can add new records manually in the sub form okay.
What I want to do , sactivate a query/programming etc that is done by
clicking a button that automatically adds several records to the subform from
a table that contains potential data items based on a field in the main form.
ie if the item in the main form is set to tru, then the sub form is to have
several specific records added to it.
how do i do populate the subform ...Reset Contact form for Org
Exchange 2007 SP1 and Outlook 2003. It appears that the contact in our Org
are using two different forms. A Custom and the Default Outlook contact form.
What are my options to reset all contacts in Exchange (shared and mailbox)
back to the default form. I know I can change the MessageClass for each user
in their mailbox. Is there a more efficient way?
Thanks, = SJMP
...Changing a forms name
years ago when starting my Access Program I allowed my main form the use the
default name "Table1". I didn't know then how many other things I would be
refering back to that form. Now I find new users getting confused.
Question: I know MS will allow me to change the name and MS will try to
change all references, but I know for experience that does always work. Can
I assign an alias?
Guess what my main "table" is called?
Message posted via http://www.accessmonster.com
You can create a query with the appropriate name, and Access will use the
query rather th...Timer Interval Event and sound
My requirement was to read the the names of the employee with sound - each
after 2 seconds interval
On the Employee Form ( EMpFormA) I add a Label and wrote the following code
(which was earlier
helped by Mr. Dougless Steel answer posted for my question. I modified
little to suit my
requirement, I mean I modified to function so that I can use several
places). It runs perfect.
After clicking the label the curson moves from one record to another and it
reads the name of the
employee after 2 seconds gap. Its ok. BUT the problem is something else
which I have mentioned
after the ...Unable to save a form or report in Access 2003.
Recently, I have been unable to save new forms and reports or make changes in
Access 2003. I was able to in the past. I can save changes to the tables
and queries. I have permission checked. Does anyone have any ideas?
It sounds as if you are working with an mde file instead of an mdb file.
Does this happen with only one database or any Access database you are using?
Does this happen if you create a new database?
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
> Recently, I have been unable to save ...Open form to specific record from button on continuous form
I have a continous form with limited data and I would like to have a button
which then opens up a selected record in another form. I've placed the button
via the wizard and, while it opens the form, it doesn't open to the selected
It it possible to have a button on a continous form which would then open
to a bookmarked record on another form? The wizard put this code, is it
possible to modify this?
Private Sub btnOpenForm_Click()
On Error GoTo btnOpenForm_Click_Err
DoCmd.OpenForm "frmName", acNormal, "", """...Change Print Form
Anyone know how to change the format of the Case that prints out? Example,
I'd liek to add my Compnay Logo to and a signature line so we can print the
case prior to going to the client site and provide a copy of the Case for
thier records as well as get sign off of the work being completed.
As far as I know you have to use reports to customize prints.
But if anyone knows how to change the standard printouts (for me for orders
> Anyone know how to change the format of the Case that prints out? Example,
> I'd liek to...Form
I am trying to create a project progress form. The is completed twice a
I have created a table that has the periods as follows:
Report Num Period Start Period End
1 01 Jan 10 15 Jan 10
2 16 Jan 10 31 Jan 10
The second table has the work items in the project:
Item # Work Desc. % Total % this Period % Cumulative
1 ...Form with multiple "tabs"
I am trying to create a survey in access but would like to separate the form
into sections: General, School, Family, Relationships, Needs.
Instead of creating 1 single form, what I would like to have are "tabs" for
How would I go about and create this?
This is very simple. Just pick the 'Tab' control on the toolbar and click on
your form to make an instance of the tab control there. It starts with two
tabs, but you can right-click on the control and select 'Add page' as many
times as you need pages. Other controls are picked fr...How to publish form in an organization?
How do I publish a form (the 'While You Were Out' form) in my organization's
Exchange Server when I cannot see the Organizational Forms Library when
clicking the 'Manage Forms' button?
Thanks in advance,
do you have an organizational forms library configured? what version
"Mervin Williams" <email@example.com> wrote in message
> How do I publish a form (the 'While You Were Out' form) in my
> Exchange Server when I cannot see the Org...I have a countdown set up in Excel, how can I move it to desktop?
I want to be able to see the countdown on a small part of my screen, without
having to have Excel taking up half of the space! Is there a way to capture
part of the Excel sheet and move it to the desktop?
no, but you can go view/toolbars and turn them all off, then
tools/options/view and turn off scroll bars and headers, etc, and you can
size the window down to about an inch by an inch
If you put Excel in full screen mode (View - Full screen), it will remove
the toolbars. If it doesn't, remove them manually once with View -
Toolbars, and full screen mode will remember that). Now ...forms in Excel
I would like to create a form in Excel that can be used as a source for an
Access table. I don't necessarily want to create the form in the VBA
editor. There are two form features in an Excel sheet: The Control toolbox
and the Forms toolbox. How should i decide which one to use?
My question is very simple (I hope): in MS Works, you can toggle between List
View and Form View, and print an individual record in the latter. Can this be
done in Excel?
> I would like to create a form in Excel that can be used as a source for an ...Countdown Clock
I have created a clock that counts down to a specific date with Days, Hours, Minutes and Seconds. I have also set up a macro button that updates the clock when the button is pressed. Does anyone know how I can update teh formulas that run the clock automatically so the the clock counts down on its own without prompting?
I have an example workbook that I will send you if you send me your
e-mail address privately.
MS Excel MVP
"Robert p" <firstname.lastname@example.org> wrote in message
>...Countdown Timer #2
I am trying to create a countdown timer which basically allows me t
have a date & time in one cell and another displaying how long there i
left to go. Any ideas? TI
Message posted from http://www.ExcelForum.com
"Dirk Diggler >" <<Dirk.Diggler.email@example.com> wrote in
> I am trying to create a countdown timer which basically allows me to
> have a date & time in one cell and another displaying how long there is
> left to go. Any ideas? TIA
For a date and time in A1
wi...Form Title Bar
my question is:
I don't want any text appear in the (form title bar)?
my solution is
I put dot (.)in the caption
or border style = None
is there any other solution?
Just type a space - no dot needed. It will retain the blank space.
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
> thank you
> my question is:
> I don't want any text appear in the (form title bar)?
> my s...Wookbook Update from User Form
I have a User Form with several Control Buttons on it. This user Form has
about (50-60) Text Boxes & Combo Boxes on it. I would like to be able to fill
in the User Form and click on the Control Button and it updates the Workbook
Control Button name is "Update_Enginering_Spec_8"
User Form Name is "UserForm1
Text Box name is "Location_4"
Combo Box name is "Address_41"
Workbook name is "Master_Engineering_Spec"
Workbook Sheet name is "Cover Sheet"
If someone would help me do the first one or two boxes, I ca...Fields in Main Form to Populate Records in Child Form
I am working with a local non-profit that works with Seniors and am trying to
revamp their database. I have created several tabs for each type of event
the volunteers or receipients may particiapte in (Education, Travel,
Donations, Committees, Teacher, etc.). I want to be able to create the input
in the main form where they can input there, click ADD and have it populate
the child form that is in a datasheet view. I want to make the child form
read-only so the volunteers that input the data can't accidentally overwrite
any existing data.
My thought was to create a "...Countdown
Is there anyway to do a time countdown in Excel? Like take todays date and
time and take the date and time of 3 weeks from now and do a countdown.
=<your value here>-TODAY()
format cell "general" for result
"Aaron Russell" <firstname.lastname@example.org> wrote in message
> Is there anyway to do a time countdown in Excel? Like take todays date
> time and take the date and time of 3 weeks from now and do a countdown.