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...Optimiztion question
I was looking at MSDN on optimizing queries
(http://msdn.microsoft.com/en-us/library/ms998577.aspx) and am unclear as to
why a foreign key relationship affects the query in this case. At the
beginning of the article it gives an example and starts out by saying:
The sample screen shot in Figure 14.2 shows an execution plan that accesses
only one table, although two tables are included in a join in the query.
Because there is a declared foreign key relationship between the authors
table and the titleauthor table, and the au_id column in the titleauthor
table is not allowed to b...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...Outlook 2003 viewing problem
We are using Outlook 2003 from the Small Business Edition
2003 software, we have wireless router for our LAN and
the modem connected to the router. We have 7 PCs in the
The problem is only on one computer, the user is
receiving emails from people outside OK, but emails sent
internally is another matter. Internal emails although
they seem to be being received because the sound alert
for new messages happens, but then the message doesn't
display in any of the mail boxes. Also sending email from
that PC to another internal PC on the LAN is not working.
I have checked the ru...MS Publisher "Select Table" won't list views with user-defined functions?!
MS Publisher "Select Table" won't list views (queries) containing
What's wrong? And how to work around this?
Using the latest version of Microsoft Publisher and MS Access (2003 sp2
with all latest updates), I am trying to create physical asset labels,
with a unique serial number on each label.
And in Microsoft Publisher, when I go to "select data source" and
select my MS Access database "20060117pst2301pmb primary.mdb" (which
generates such serial numbers), I get a popup entitled "Select Table"
which lists all its tab...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...Great Plains Invoice History view?
Has anyone built a view in MSCRM that will show Great Plains Invoice
history? I would be willing to purchase one.
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 fix this so I can view my attachments?
I can't view my attachment.
I found the following topic in help but it doesn't give me
way to fix this so I can view my attachments?
I anivirus protection I don't need this feature from
I see a paperclip next to a message, but when I open it,
the attachment is gone.
You may have received a message that contains a level 1 e-
mail security attachment file type. To prevent the
inadvertent spread of viruses, Microsoft Outlook checks
the file type of each attachment in a received message
against the file types on the e-mail security attachment
file type...viewing a user's email account
I have been charged with reviewing a user's email activity / mailbox for a
possible impropriety. Is there a way to do this from exchange, or better yet
what is the best way to accomplish this steathfuly?
On Mon, 23 Oct 2006 18:20:02 -0700, Rossel1
>I have been charged with reviewing a user's email activity / mailbox for a
>possible impropriety. Is there a way to do this from exchange, or better yet
>what is the best way to accomplish this steathfuly?
I really hope that the users' employment contract provides for this
Operating System: Mac OS X 10.5 (Leopard)
I did the most recent upgrade for office and it wouldnt run it said to delete the PIDlist for microsoft office so i did and then it said to get the product key which i did and now when i put in the product key and push continue it wont continue it just stays on the same page it will go back but wont go forward what should i do?
...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 ...cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more
text is displayed....casn increase the size of the cell, but still only so
much will display....rest of the cell show blank.
+the limit is 1024 characters. You can extend this with manually inserting
linebrekas using aLT+ENTER
> I have cell format to wrap text and it works fine to a p[oint then no
> more text is displayed....casn increase the size of the cell, but
> still only so much will display....rest of the cell show blank.
I have an Excel Workbook that I created for a PC Order Form. I set it up to
only make certain rows visible based on the Machine Model that they choose.
I digital signed the Worksheets and exported the Digital Signature
Certificate and installed it on the User’s PCs. The code works great. The
user opens the Workbook and it runs the Macros with no problem. The problem
I have is when the user goes to save the Workbook. They get an error that
“Excel can not sign VBA macros when saving to this file format. Do you want
to remove the digital signature and continue saving this workbook?”...IE8 'View Source' opens minimised
Suddenly, after no previous problems, when I open 'Page / View Source' in IE8
it flashes on screen then minimises immediately to the Taskbar.
It can be viewed when maximised ok.
It can be resized and I have then tried closing whilst holding down Ctrl.
It only happens to 'View Source' not any other window.
I am perplexed?
It is probably hidden from view behind the IE Window. Just move the IE
Window down your screen to see the View Source window behind it.
I have noticed the same issue since the last IE security update (last night
my time)... It is a...Cannot view itme in Public Folder between 2 different exchange 2003
I have 2 Exchange 2003 on WIN2k server.
Exchange 2003 (A) has 300 mailboxes and store the public folder.
Exchange 2003 (B) has 100 mailboxes.
User at Exchange 2003 (B) found that they can view the public folder but no
items in it.
User at Exchange 2003 (A) do not have this problem.
Is the public folder must replicate to other server?
Is any suggestion to view the item if no replication on public folder ??
These 2 servers in the same routing group.
Exchange 2003 (A) is the Master
Exchange 2003 (B) is the Member
"omer maydan" <firstname.lastname@example.org> wr...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!
...Simple IMAP question
How do I enable shared calendar with free/busy information through IMAP ?
When I add the "calendar" folder in IMAP it displays as a mail folder, not a
Is this calendar a mailbox or public folder?
Why are you using IMAP instead of MAPI? MAPI is much more feature complete
as it applies to this sort of thing.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Pierrot Robert" <email@example.com> wrote in message
> How do I...Exchange 2003 Question??
I would like to know if there is an upgrade path from Exchange 2003 Standard
Edition with SA to Exchange 2003 Enterprise Edition with SA? Thank you.
This might help
"KA Kueh" <firstname.lastname@example.org> wrote in message
> Dear all,
> I would like to know if there is an upgrade path from Exchange 2003
> Edition with SA to Exchange 2003 Enterprise Edition wit...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...Macro Question #10
I am working with a text file that I imported into Excel.
It is a transactional report of sales by customer. The
data will have the customer number and name spread out
over three cells. What I want to do is to create a macro
that will contatenate all three cell and then perform a
paste special and paste them into another cell in another
column. Since the number of transactions by customer can
vary the customer name and number can appear anywhere on
I created a macro to do this using the first customer
which appears in cell B5 through D5. The next customer