New to User Forms
When I first found this site I was a crazy woman and just about read
everthing. Thanks to all you folks who take the time to answer our
The one thing I cannot get to is a video/tutoraial on forms, the link was
provided by somebody as an assist to another question. I loved the videos
but was unable to complete the 3 or 4 part series and forgot to make it a
favorite. Can anybody point me in the right direction or provide links to
other training for starting forms?
Might have been Debra Dalgleish's site.
Gord...Want to change from Admin to User easily
I usually run my PC as Administrator which I now know is dangerous,
as it can let malware in and play with the system more easily. So
I want to create a limited User account instead, but all my settings
are under the Admin profile (eg. Quick Launch icons, file associations,
and so on).
Is there an easy way to migrate these to the User account, so that when
I log in as User, my desktop is the same, icons are the same, etc?
Thanks for any advice.
> Hi all,
> I usually run my PC as Administrator which I now know is dangerous,
> as it can...Tabebed Forms in Access!!!HELP!
I am trying to design a tabbed form in Access 2007. I have my five tabs
named etc....I have inserted fields onto the first tab and for the life of
me cannot figure out have to get the fields from the first tabs to not show
up on the other tabs!!!!!
I want each tab to contain its own fields. How do I do this???? PLEASE HELP
Try cutting the controls, and pasting them back on the the correct page.
Make sure that the page itself is selected before pasting the control.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Heather Elbert&qu...QUERYING ACCESS
I have an Excel workbook that is querying an Access database, which in turn
queries an Oracle database. Is there a way to have Access automatically
update from Oracle when I open the Excel workbook?
Certainly there would be with code, but can you not using the Oracle ODBC
driver to get the data directly from Excel. It would then simply be a
button press to update.
If you need help with this post back
Microsoft MVP - Excel
"Drew" <email@example.com> wrote in message
news:...Users Shared Folders
Can someone please put me out of my misery, and save me from spending another
day or so wasting my time trying to find the answer.
I just took delivery of new server with SBS 2003. Another company installed
it for us.
They set it up so that when you create a new user it automatically sets up a
user folder in "c:\Users Shared Folders"
I do not want that to happen there. I NEED it to happen in the D directory.
I have read about moving existing folders etc etc. But I dont need to do that
cause I have yet to set up the users, but will be shortly. All I want to...Check button
I am running a long process and would the user to be able to stop/cancel the
I can put a button on the sheet or one a userform but what code do I need to
insert in my process to detect if the button gets clicked?
On Apr 15, 9:45=A0am, "Fred" <repl...@newsgroup.please> wrote:
> I am running a long process and would the user to be able to stop/cancel =
> I can put a button on the sheet or one a userform but what code do I need=
> insert in my process to detect if the button gets click...Moving command buttons for April Fools
What I want to do for April Fools day is reprogram all the command buttons on
our attendance database switchboard such that when a teacher moves the mouse
over it, it moves. I have the following:
Private Sub Command0_MouseMove(Button As Integer, Shift As Integer, X As
Single, Y As Single)
Command0.Left = Command0.Left + ((1 + Int(500 * Rnd())))
Command0.Top = Command0.Top + ((1 + Int(500 * Rnd())))
This works beautifully, until the button reaches the bottom or right-hand
side of the form, then, of course, I get an error message as the Left or Top
value becomes invalid.
Is there...VBA in Access or Outlook
I have a table containing email addresses and other data that I need to email
out to each recipient in the table. Each email will contain in the body of
the message only the data relative to the particular recipient.
My question is which application Access or Outlook is the best one to code
the module in to do this?
I am using Access 2003 and Outlook 2003.
Use the SendObject command in Access VBA.
> I have a table containing email addresses and other data that I need to email
> out to each recipient in the table. Each email will contain in the body of
...Fetch user login information using JScript
I am new to MS CRM. I am trying add custom HTML pages to the CRM which
requires the user login information.
I would like to know how to go about this and solve my problem
Any help regarding this would be appreciated
I am not 100% sure of this but could you not just have the page use
"NN" <NN@discussions.microsoft.com> wrote in message
> I am new to MS CRM. I am trying add custom HTML pages to the CRM which
> requires the user...Determining size of "autosized" user control
Given a user control that contains some kind of dynamic content (content
I do not know the dimensions of at compilation time). This user control
is then dropped into a Window, without specifying size. I am trying to
determine the size of the content at runtime once it is defined. Take
the following sample code:
/// Interaction logic for Window1.xaml
public partial class Window1 : Window
MyUserControl ctrl = new MyUserControl();
...Users not showing up All Users
Exchange 2k3 on a SBS 2k3 box.
I went in through AD Users+Computers, and created mailboxes for users.
Two days later, the mailboxes still don't show up in Exchange System
Admin-Recipients-All Addresses-All Users. As a matter of fact, the
mailboxes aren't showing anywhere, and we're not able to send mail
internally(external isn't a factor yet, as the box hasn't gone live).
Strange part is, is that if I right click on All Users-Properties, then
click on the Preview button under the General tab, all of the
users+mailboxes show up.
Is this normal?
And on a second note...wha...user breakpoint
I use malloc in a thread,before the thread quit,I use free,cause pop up
"user breakpoint called from code at 0x77f7f570" error.
HEAP[DownTradetrek.exe]: Heap block at 0037B1C8 modified at 0037DA00 past
requested size of 2830
I don't know what happen.Thank for your help.
"msg_du" <firstname.lastname@example.org> wrote in message
> I use malloc in a thread,before the thread quit,I use free,cause pop up
> "user breakpoint called from code at 0x77f7f570" error.
> Debug output:
> HEAP[DownTrad...OWA Access stops / Outlook ok
Server is HP DL380 running Exchange 2003 SP2 and Win2k3.
Up to last Thurs was running fine (as could be expected), but from thurs 23
morning we have found that Exchange is stopping the OWA service and webmail
does not work. This is affecting almost all of our users as we are Mac-based
and use Entourage - which is a WebDav client.
It seems as though Outlook 2003 works still - checked via Parallels.
I cannot find anything in the logs that is specifically about OWA/WebDav.
Any suggestions for how to determine the cause please?
On Mon, 27 Nov 2006 09:52:02 -0800, craigontour
<craigonto...How to keep Access from rearranging logical expressions iin the criteria cells ?
I'm using MS Access 2003.
In my query, in lots of yes/no columns, I enter criteria.
In my case expressions like
(=Forms!frmCriteria!checkboxN) OR (Forms!frmCriteria!checkboxN=False)
After editing in design mode and saving the query, I close the design
The query works fine.
I open it again in design mode, and ...
all my logical expressions have been transformed into a logically equivalent
They spread over more cells.
Everything looks very different.
And I do not like to take this state as a basis for further changes.
Because I feel that my way of express...User shows up 17x under logons under Mailbox
We have an office where all the users are displaying from 12-17 times under
logons while everyone else displays only 3 or 4 times. What does this
indicate? Does this indicate connections, being dropped then reconnected? TIA
Are they running PDA synchronization software?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Greg" <Greg@discussions.microsoft.com> wrote in message
> We have an office where all the users are displaying from 12-17 times
> logons w...Need User Name and Password
I am reinstalling RMS 1.3 in a customer that their server crashed and need
to reinstall everything from scratch... I do not remember the default user
name and password for RMS 1.3.; I remember that is a number 1 or 2 (I think)
but do not remember the password!
Thanks for your Help in Advance
Rommel J Jimenez
try Password or password
if that doesn't work, look it up with the sql statement:
select * from cashier
"Rommel J. Jimenez" wrote:
> Hello Everyone,
> I am reinstalling RMS 1.3 in a customer that their server crashed and need
> to r...Access 2007 runtime Error
I have created a quotes database in which i would like my end users that are
all useing the 2007 runtime to be able to E-mail a report in .pdf format. The
macro behind the button works fine on the developers station. but in the
runtime environment I am getting an action failed: Error 2950. The send
object isnt working. I get a message before the actual error code Stateing
that the format in which i am attempting to output the current object is not
available. I have done some digging and run into a few posts about changing
the registry. But i didnt really want to have to do that to 40 pl...I have lost the minimise and maximise buttons on my worksheet
I have an excel file on screen. I can see the minimise and maximise buttons
on the top right of the screen, but on the sheet itself there is no buttons
showing. I also cannot move the sheet itself in any way by dragging on the
sides. There is also no bottom scroll bar.
Trying to post a question
> I have an excel file on screen. I can see the minimise and maximise buttons
> on the top right of the screen, but on the sheet itself there is no buttons
> showing. I also cannot move the sheet itself in any way by dragging on the
> sides. There ...First-chance exception . . . (NTDLL.DLL) . . . Access Violation.
What is the basic meaing of this? :
First-chance exception in Room 101.exe (NTDLL.DLL): 0xC0000005: Access
Steve Russell wrote:
> What is the basic meaing of this? :
> First-chance exception in Room 101.exe (NTDLL.DLL): 0xC0000005: Access
Only the developers of NTDLL.DLL know. Since you can't do anything
about it you must assume it is an uninteresting event that was handled
by code designed to handle it.
Scott McPhillips [VC++ MVP]
> Steve Russell wrote:
>> What is the basic meaing of this? :
>> F...Best method to allow two users to make edits to the same Excel File
I am trying to determine what is the best method to allow two users to
simultaneously make edits to the same Excel file. It is VERY rare that
we will ever be typing in the same Cell as the other person, but we
both need to work out of the same workbook at the same time.
We are working in two separate locations, by the way.
Is using Dropbox along with "Tools > Share Workbook" the way to go? Or
should I use Google Docs? Or possibly Sharepoint? Or Excel 2010 Web
The main question I am trying to answer is "what actually works" and
is generally hassle free.
Thanks fo...How to summarize Access query data?
I have a table and a resulting query with 1,400 records. I would like a
summary page for a given category. For example, there are 20 people and each
has a number of work orders they are responsible for. Each work orders has a
discrete identification number. I want two numbers per person: (1) the
number of orders they have (a count) and (2) the sum of all the "Remaining
Hours" each person has associated with their associated orders. (The
existing query takes the estimated hours and subtracts the actual hours with
the result being the "Remaining Hours.")
This is...Random Users Calendars not viewable
We recently moved our Exchange 2003 server to another machine. Since doing
so, we have random users whose calendar will only apear as \\\\\\ when we
try to invite them to a meeting. I have tried to replicate the Schedule+
Free Busy folder but this has not worked either. Any suggestions?
On Tue, 12 Sep 2006 04:32:01 -0700, Kevin
>We recently moved our Exchange 2003 server to another machine. Since doing
>so, we have random users whose calendar will only apear as \\\\\\ when we
>try to invite them to a meeting. I have tried to...Access 2007
I have a table with 36 rows containing the field, FiscalYear, values,
1,2 or 3, and EndDate, containing month end values for 3 calendar
years, for example, FiscalYear 1 EndDate for January is 1/31/2008,
FiscalYear 2 is 1/31/2009 and FiscalYear 3 is 1/31/2010. Repeat for
month end Feb - Dec for each FiscalYear. I'm trying to create a query
that would return the maximum month-end for each fiscalyear.
I've been futzing with returning unique values for fiscal year to
re...Manager grayed out on user setup
After adding a user, I want to change the manager (which is blank at the
moment) but the manager field is grayed out, as a result, I can't change this
field. Any suggestions?
On the users detail form, go to the Actions menu. There will be an option there
to change the manager.
MVP - Microsoft CRM
On Thu, 13 Jan 2005 07:37:07 -0800, idtpes <email@example.com>
After adding a user, I want to change the manager (which is blank at the
moment) but the manager field ...OWA Security
I wanted to ask you somethng about OWA. I have Exchange
Server 5.5 installed. And my users are constantly being
locked out. It seems somehow, someone got a users list, or
maybe it is someone who knows the mails of everyone, can
this be possible? And if it is so, how can I prevent users
to get locked out, and mantain security???