Access 97 Runtime question
We are using Access 97 runtime for some of our staff.
I noticed today that in reports if they right mouse click, they don't get a
shortcut menu. I want them to be able to Export the report they are viewing.
Would Access 2003 runtime have the shortcut menu?
"Kelvin Beaton" <kelvin dot beaton at mccsa dot c o m> wrote in message
> We are using Access 97 runtime for some of our staff.
> I noticed today that in reports if they right mouse click, they don't get
> a shortcut menu. I want them to be...Autofill In Linked Forms
I have created a couple of forms by selecting all the fileds in the form
wizard from two tables:
1. Suppliers (Fields: Supplier, Address, Contact, etc.)
2. Products (Fields: Supplier <Lookedup from Supplier Table>, Product, Rate,
Upon clicking the toggle button on Suppliers form I have the Products form
opened. However, as I enter the data in it, I want the Supplier filed in the
same be automatically be filled with the Supplier name as in the opened
Supplier form so as to be filtered and displayed the next time I open the
same instead of manually inserting the sa...Can see form in design view but not in open or layout view
I have set up the tables, relationships and forms. When I first created the
form I was able to view when clicking open. I made a couple of changes and
now when I click on open a box pops up to enter perimeter value. Also, I can
no longer see the form in opne or layout but if I click for design view, I
can see my form and all the tabs.
There is either something missing or somthing is named incorrectly. Had a
similar problem recently where a new version was installed in the front end,
but the table in the back end had not been updated properly (a new field) and
the new version of the...Rules not working #7
I have a mail profile that I use with one email address that gets a LOT
of spam. I have a fair size number of rules (probably 10-15) for
categorizing and filtering it, all of them starting wth "Apply this
rule after the message arrives".
Problem is that most of them only work about half the time. I'll get
some messages that were moved to the correct folders, and some similar
messages still in the inbox. If I click "Rules Wizard" and the "Run
Now" button, selecting all the rules, it moves the ones still in the
inbox to the correct folder.
How come it didn...Name Range with using Data Form
I first created a variable with A1:D1, four columns with named variable
Data. How to expand this Data range to A1:D2 after using the DataForm to add
one row data in the worksheet?? The same, the Data range should be A1:D3
when adding one more data row...
use the following formula in the name definition dialog
>I first created a variable with A1:D1, four columns with
>Data. How to expand this Data range to A1:D2 after using
the DataForm to add
>one row data in the worksheet?? The...Hyperlinks do not work in email in outlook
Shortly after installing the new service pack for Windows
XP I began getting this message whenever I tried to click
on a hyperlink in an email: "This operation has been
canceled due to restrictions in effect on this computer.
Please contact your system administrator."
I assume it is because some switch has been set. Could
someone tell me how to regain the ability to use the
embedded links in email in outlook? Thanks
Bob <firstname.lastname@example.org> wrote:
> Shortly after installing the new service pack for Windows
> XP I began getting this message whene...hyperlinks within the same document are not working
I am trying to create an email publication in MS publisher 2007. It has
several stories that will be sent out in email and the first section is
supposed to contain a summary with hyperlinks to each story within the same
email for more details.
I am adding a bookmark at the begining of each story, and then trying to
create a hyperlink in the summary section to the bookmark.
However, when I send the publication as email, or do an email preview, the
hyperlinks do not work.
...Outlook 2003 working with Groupwise client
We are moving our people from Groupwise to Exchange and I
am having a horrible time getting the two to work
together. We need to keep both clients on the machine for
a short time while the switch is done. I installed Outlook
2003 on my workstation running Windows XP and Outlook and
Groupwise are happily coexisting. When I tried this on a
Windows 2000 machine everything went to crap. I've tried
all of the tricks I can think of. I've removed Groupwise
and windows messaging and reintalled everything from
scratch and no dice. I just keep getting Outlook MAPI
errors and messages s...Exchange 2003 Envelope Journaling not working
I have a single Exchange 2003 SP1 server. I'm trying to get envelope
journaling to work.
I have enabled message journaling and then used "exejcfg.exe -e" to
enable envelope journaling. The journal mailbox is receiving the
standard message journal messages, but not the envelope journal
I have verified with LDP to confirm the heuristic value is 512 for the
Exchange Org object.
Anyone else seen this before or have any advice?
> I have a single Exchange 2003 SP1 server. I...Subtracting value from main form
I have a borrow module which will alow user to return item separately. So, I
have get the structure of returning it separately.
In my main form is the borrowing item, with the loaned quantity and the owed
quantity (will be calculated).
In the subform, there is the returning transaction. User will need to key in
the quantity returned and it will be automatically deducted from the quantity
But how am I supposed to get the quantity deducted while it 1 is in main form
and the other is in subform?
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-fo...DB Mail is is not working. Need help please.
I have try stop and start the db mail by executing the SPs below but no luck.
Does anyone has seem the error below and how to fix it.
Thanks in advance for your advise/help.
EXECute sysmail_help_queue_sp @queue_type = 'Mail';
queue_type length state
----------------------- ------------...Outlook/Access 2003
I've been doing a lot of research and purchased (but haven't completely
read) Sue Mosher's book. However, before I spend much more time I'd like to
find out if my idea is even feasible. The basic idea is to create an
appointment system for multiple therapists that can be used by a
receptionist and other staff. Using Outlook and Exchange is very nice but
the appointment data needs to end up in an Access table immediately.
We can purchase SBS 2003 with Exchange 2003 or we can buy a third party tool
for calendar sharing whichever would be the easiest to use. I currently...Keeping forms in order they are entered?
I am working with a database that was designed for us and have pretty much
just used without having to change much in but have now run into a problem
and hope someone can help. We track and number complaints we recieve by
number using last digits of year recieved then next number, i.e. a complaint
recived 12/31/09 might be 9234 and first one received this year would be
10001 and the next would be 10002. The problem is now when I open my forms
and go to the last one it is the 9234 instead of the 10002 which I need. How
do I keep that last form I entered last the next time I open the data...How do I get automatic completion to work for an in-cell dropdown
If I have a list of Alpha, Beta, Gamma and an in-cell dropdown, I'd like
typing 'G' to auto-select Gamma.
I'm pretty sure it was doing that at some point, but now, it does not.
This isn't supported under data|validation.
You could use A,B,G in the dropdown and then use a helper cell with a formula in
Say you put your abbreviations in A1:A3 of sheet2 and the real names in B1:B3,
then you could use:
Joseph Weisblatt wrote:
> If I have a list of Alpha, Beta, Gamma and an in-cell dropd...failure of Open XML 1.1.4 to work
Operating System: Mac OS X 10.6 (Snow Leopard)
Previous versions of this worked fine. This version comes up with comment "not enough memory". As I have 2mg Ram this seems strange. Any help appreciated.
I'm afraid you haven't provided sufficient information for anyone to go on,
especially since that message quite often has nothing to do with memory.
For any questions of a technical or performance nature it's important that
you specify your current update level of OS X as well as for Office.
Exactly when does this messag...increment through controls on form
I have a form that I've name the controls on it in such a way that I could
determine through open args if it should be locked or not. Example any text
box that begins with txtd would be unlocked with open args of 1. I was
hoping there was a way I could just move through the controls in a loop and
set that property with one function.....I'm not for sure how to accomplish
this though. Does anyone have some sample code on how to "loop" through all
the controls on a form and set the locked property? I can write the
criteria portion if I could get a sample of how to ..._CRTDBG_MAP_ALLOC doesn't seem to work
I'm having problems tracking down a meory leak and
thought the best way would be to follow the instructions
in MDSN: "Detecting and Isolating Memory Leaks Using
Microsoft Visual C++" However, I can only get the basic
memory dump, without source file and line number. It's as
if _CRTDBG_MAP_ALLOC is being ignored.
I tried building a test application (basic MFC SDI
application) to try it out.
At the top of Leaktest.h, I have
In CLeakTestApp::InitInstance(), I have
_CrtSetDbgFlag( _CRTD...OWA timeout does not work for every client
I set the timeout setting on OWA, i don't have any issues but i'm
getting lots of complaints that users are getting logged of after 15
min. why does this happen with some clients but not all?
...Attach Trigger to Save Function of Form
I am in the processes of trying to attach a trigger to the Save function of
an already existing GP form using Dex. In one of the documents, it states
that the CM_Checkbook_Maitenance has a SaveRecord function. I am trying to
acces the function that is similar to this on the PM_Vendor_Maitenance form.
I tried using SaveRecord and when I tried to compile it it says that it is an
unknown reference. Is there some documentation with a list of the functions
for each form?
PM_Vendor_Maintenance is an older form and probably doesn't have a
Try running t...look way to map form at CRM frontend to tables at CRM database
How can I find out what tables which new record has been added on when I
enter data through a form in CRM front end? I try to find way to map form in
the CRM frontend to the tables at the CRM database at backend? It is CRM 3.0
Thank in advances for help!
...Journal stopped working #2
I have noticed that after upgrading from Outlook XP (2002) to Office Outlook
2003 my journal has completely stopped logging entries.
I have turned it off and re-initialized it and still not entries. I mailing
want it to log Word and Excel files. Any help would be appreciated
I am running Exchange 2003 in cached outlook mode on a SBS 2003 server.
...visited links no longer change color
The links still work when clicked but, no longer show purple when visited.
This happens in both Outlook and Outlook Express. Yesterday I tried making
fonts a little larger as I have eyesight problem. Not sure if this is when
the link color problem started.
What I did exactly is:
*Tools > Options > Mail Format > click "Fonts" button > click "International
* At first I went through the list making each one "Larger" font size.
* I realized that it's probably only "Western European" I need to change, so
all others were set ...upload form problem / server question
www.icingpictures.co.uk / win xp / frontpage 2003
Want to create a form with upload file form field - i read on this forum
that the server type i use is important - it should be a windows type server
with frontpage extensions - i currently use a linux server with front page
extensions - do i need to change to a windows server?
Thanks for taking a looka t my question.
Yes, you must have a Windows Server, just like you stated you read.
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
"threademporium" <threademporiu...I cannot paste from one workbook to another. Copy works, paste do.
When I attempt to copy from one workbook and paste into another, copy appears
to work but paste does not. The paste menu item is grayed out in the
workbook to which I attempt to paste.
Are there setting that can be changed to aloow the paste??
Check to see if either workbook and/or worksheet is protected.
If so, unprotect. Then Copy/Paste should work.
BTW, how are you copy?paste(ing) Tab or content?
> When I attempt to copy from one workbook and paste into another, copy appears
> to work but paste does not. The paste menu item is grayed out...Spreadsheet macro stopped working!
I recently made an Excel spreadsheet for keeping track of my golf score.
The spreadsheet is quite simple. It consists of 4 sheets:
Scorecard, statistics, database and equations (for calculating some
I insert informations about the golf course I'm playing and how my score
was etc. I then hit a button "Save scorecard" that runs a macro. The
macro inserts specifik values from the scorecard into the database sheet
(which works like a charm). The macro also updates the "Statistics"
sheet with information about stroke number and points for ...