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
ME!!!!!!!!!!
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
http://I.Am/DougSteele
(no e-mails, please!)
"Heather Elbert&qu...
Function help #2I am wanting to know how to get excel to look at a coloumn of information
and compare with another coloumn and then tell me what and where the
differences are. Let me explain what I have. I have a spreadsheet that has
two seperate "pieces" of information. Each piece has two coloumns. What I
need to do is have a function that will look at coloumn a and then compare
it with coloumn b. The twist in this is that the information does not line
up as far as the rows go. I am running Excel 2000 on an XP box. Any help
is great. thanks!!!!
Derrell
Try using conditi...
New to User FormsWhen 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
qurestions.
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?
Thanks!
Might have been Debra Dalgleish's site.
http://www.contextures.on.ca/xlUserForm01.html
Gord...
Want to change from Admin to User easilyHi all,
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.
a wrote:
> Hi all,
>
> I usually run my PC as Administrator which I now know is dangerous,
> as it can...
Help with RegisterhotkeyHi,
I am trying to create a shortcutmanager for ppt.
I used RegisteHotkey and somehow managed to trap hotkeys, but now I
have 2 problems i am not able to solve.
1. The hotkey is a system wide hotkey, meaning regardless of whether
ppt is the active application or not the hotkey is trapped in
powerpoint.
2. I am not aware of how to trap single keys (ie without combination
of CTRL,Shift etc.), for eg. how do I trap just the key F3 (function
key), without any combination keys.
I am sort of desperate to solve and finish the addin.
Will appreciate any help with this.
Thanks and regards
Dha...
Users Shared FoldersHi guys
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...
Help with creating databaseI'm a recent college graduate at a new job. I am trying to help my company
move a report that is currently done in Excel into Access.
To help you better understand my goal I will try to describe my business and
the nature of this report as briefly as possible.
We are a clothing designer. All of our product is produced in factories
overseas and delievered to our clients in the U.S.
Our W.I.P. report is currently in Excel. It's purpose is to give us an
up-to-date picture of what part of the production line our products are
currently in. Information on this report inclu...
Fetch user login information using JScriptHi..
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
NN,
I am not 100% sure of this but could you not just have the page use
integrated authentication?
Jeff Loucks
888-474-2237
MVP
"NN" <NN@discussions.microsoft.com> wrote in message
news:0E6BA8D5-2F2D-492B-8CB8-84284D04FF59@microsoft.com...
> Hi..
>
> I am new to MS CRM. I am trying add custom HTML pages to the CRM which
> requires the user...
Providing help for a templateHi,
I have a template which is not that easy to use, so I need to show some help
to users - what is the best way of doing this. It should be something that
is not modal, as it should stay visible as the user works.....
Regards
Bo Rasmussen
Bo,
You can use Data - Validation. Leave the "Allow" box set to "Any value."
Put instructions in the Input Box, and they'll pop up like comments when the
cell is selected. Or use cell comments (right-click, Insert comment).
They'll pop up when the mouse hovers over the cell. Modeless UserForms
(Excel 2000 and beyond) can...
Help me do thisHi Everyone,
I need some help. I want to use Windows Live mail without signing in or
having a hotmail or live account. I use gmail and it works fine. I have
exported all my contacts from my live.com email and imported all of my
contacts so that is not the problem. I want to import my calendar from my
live account. I can't find anyway to do this. If I stop signing in of course
my calendar is gone. How can I export my live.com email calendar into
windows live desktop client so I don't have to sign in anymore? Thx
"T-Man" <a@anon.com> wrote in message...
Determining size of "autosized" user controlGiven 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:
/// <summary>
/// Interaction logic for Window1.xaml
/// </summary>
public partial class Window1 : Window
{
public Window1()
{
InitializeComponent();
MyUserControl ctrl = new MyUserControl();
...
Users not showing up All UsersExchange 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...
Help with Page Life Expectancyhi I am using 32bit SQL Server 2005 and SP3 applied and hosted with
VMWare
Hi i have a situation where Page Life Expectancy counter shows a
consistent average of 70 seconds when running the perfmon. I read
that this should be > 300 seconds on average
Buffer Cache Hit Ratio = 99%
Memory grants pending = 0
lazy writes/sec = 0
i am trying to find out what queries are causing this but i'm not sure
how to go about doing it. does anyone have a suggestion of what to
run and look for?
Derek
Identify the queries consuming (or that will consume) the most memory
select req...
user breakpointI 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[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" <dch1237@msn.com> wrote in message
news:uzRWBIO7DHA.1804@TK2MSFTNGP12.phx.gbl...
> 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...
need help with look-up and time ragehi, I have a table that looks something like this:
Unit Time
ENT 10:36:00
ENT 01:15:00
EMU 12:36:00
etc etc.
I need to be able to calculate number of entries per unit per time range, eg
the numbers of times ENT occurs between 8am and 4pm.
Any suggestions?
Thanks, Ruth
Try this:
=3DSUMPRODUCT((A1:A10=3D"ENT")*(B1:B10>=3D--"8:00:00")*(B1:B10<=3D--"16:00:=
00"))
Or, you could put ENT in C1, the start time in D1 and the end time in
E1 and use:
SUMPRODUCT((A1:A10=3DC1)*(B1:B10>=3DD1)*(B1:B10<=3DE1))
Hope this hel...
System Low in Resources HelpHi....
My father is having a problem with his computer and I am not sure ho
to fix this. Everytime he tries to open excel the computer will freez
and after hitting ctrl+alt+delete I get a message saying the compute
is low in resources.
This happens everytime I try to open a new or existing workbook. Coul
anybody give me some tips or advice. Thanks.
Bighers
--
Message posted from http://www.ExcelForum.com
Hi,
Not an expert, but a couple things come to mind:
1) does his PC have enough memory/disk space for other
applications, like Word, to operate OK? If not, then
you need to 'beef it...
User shows up 17x under logons under MailboxWe 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?
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Greg" <Greg@discussions.microsoft.com> wrote in message
news:F194F160-CC25-4068-A213-1D13FE73DD8E@microsoft.com...
> We have an office where all the users are displaying from 12-17 times
> under
> logons w...
Using only dates needed in Excel 2007 chartI'm trying to Chart data from a table and when I create a chart it adds in
the days between mine. I only want working days. This is in Excel 2007.
Change the x-axis to catgegory, not Time Scale. (Chart options, axis)
This will display only the data you've given XL.
--
Best Regards,
Luke M
"HFST04" <HFST04@discussions.microsoft.com> wrote in message
news:161B5351-A851-4776-A1F0-0E838A1722EE@microsoft.com...
> I'm trying to Chart data from a table and when I create a chart it adds in
> the days between mine. I only want working days. This is in...
IMAP service started but the protocol needs to be started under SysMGRI have a W2K3 and Exchange 2003 server with no error messages in the event
viewer. Even though IMAP is listed as started under
Services, I had to go to Exchange System Manager to go to the server, select
protocols and then start. There are no error messages in the Event viewer -
can anyone tell me how to start this service automatically? It is currently
set for automatic in Services but that isn't doing it (even though it says
started)
If you stop the service with the virtual server online it should be online
when the service is again started. You might have to refresh but it shoul...
Help for ICT Gcse c/wHi
Basically I am making a model for my ICT coursework (AQA), it's about dog
training courses for a vets surgery.
For part of it, we have to work out the minimum number of dogs needed for a
course to run (has to be less than �50).
I have made a table, which links to other worksheets..
No. of dogs: Cost per course: Cost per dog: Can course run?
1 �348.35 �348.35 No
2 �350.60 �175.30 No
3 �352.85 �117.62 No
4 �355.10 �88.78 No
5 �357.35 �71.47 No
6 �359.60 �59.93 No
7 �361.85 �51.69 No
8 �364.10 �45.51 Yes
9 �366.35 �40.71 Yes
...
Need User Name and PasswordHello Everyone,
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...
Definitely a Newbie--Need an exampleI'm told VBS comes with MS OSes, and that if I had an example script of
a vbs program, I could see how it works by double clicking on the file.
Does someone have a simple program that I could try that on? Maybe
something that simply prints some text or prints the results of a simple
calculation. I'm using Win 7.
--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet
Solid waste produced to gen...
excel need to be installed on server?hello all,
does excel have to be installed on my web server if i want
to use a regular html form to receive user data to
populate then execute some calculations in an excel
spreadsheet?
thanks in advance,
greg
Yes if you want the calculation done at the server side. However Excel and
other Office apps. are not designed to run in this way (as server side
processes). It can and has been done but it takes some knowledge.
I've written an article on this, not sure if I posted it to my site. Use
the contact me form on the site if you are going to pursue this method and
I'll post i...
Best method to allow two users to make edits to the same Excel FileI 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
Aps?
The main question I am trying to answer is "what actually works" and
is generally hassle free.
Thanks fo...
HelpHello,
I have Money 2006 Deluxe.
I keep getting this message:
Account setup is temporarily unavailable. Please try again later.
I have tried all week.
Thanks
Frank
...