A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 6.42 seconds.
Search: Posts made by: Arvin Meyer [MVP][_2_]
Forum: General Discussion June 4th, 2010, 02:58 AM Posted to microsoft.public.access
Replies: 3
Views: 471
blinking form...

Often video resources are low when that happens. Turn on your task manager
and have a look at the performance tab while you are doing this task. If
there's no spiking, turn on your performance...
Forum: General Discussion June 4th, 2010, 02:51 AM Posted to microsoft.public.access
Replies: 5
Views: 651
Access as a Front-End

In the 18 years that I have been working with Access, I have helped clients
fix 8 data corruptions. The first was a machine left on and unplugged, the
second an interrupted phone line during a...
Forum: New Users June 2nd, 2010, 04:26 AM Posted to microsoft.public.access.gettingstarted
Replies: 7
Views: 2,680
Access Labels Maker Doesn't Work

If you look in the table, you have stored them unformatted. You can change
that with an update query (for safety, use a new column) using the format
function that John provided you.
--
Arvin...
Forum: General Discussion June 2nd, 2010, 04:05 AM Posted to microsoft.public.access
Replies: 3
Views: 472
Calculate working days between records

"kidkosmo" wrote in message
...

Thanks, Arvin. That does give me an alternative to using...
Forum: General Discussion June 1st, 2010, 05:35 PM Posted to microsoft.public.access
Replies: 14
Views: 841
Two autonumber fields in one table possible?

"Sharon_wv" wrote in message
...
I am designing a database to capture information that will be classified...
Forum: Using Forms June 1st, 2010, 04:25 AM Posted to microsoft.public.access.forms
Replies: 9
Views: 671
password-protected form

Here it is:

http://accessmvp.com/Arvin/Security.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions",...
Forum: General Discussion June 1st, 2010, 03:59 AM Posted to microsoft.public.access
Replies: 2
Views: 446
Click on List box and move to that record in the form

"Kelly" wrote in message
...
I have a single form which will be used for users to clock in and out. On...
Forum: General Discussion June 1st, 2010, 02:29 AM Posted to microsoft.public.access
Replies: 1
Views: 407
Window 7 live mail

"bert" wrote in message
...
How can I block/reject a particular e-mail address from arriving to me..
I have...
Forum: General Discussion June 1st, 2010, 02:27 AM Posted to microsoft.public.access
Replies: 1
Views: 560
How do I stop printing job in Microsoft word?

"Alpha" wrote in message
...

It's hard to stop a job once it's in the printer's memory. The best chance
is...
Forum: General Discussion May 31st, 2010, 10:46 PM Posted to microsoft.public.access
Replies: 2
Views: 519
How can I type within a cell like it is a word document?

Possibly with a Rich Text Box control. FMS has one:

http://www.fmsinc.com/MicrosoftAccess/RichTextMemo.html

and here's a free one:

http://www.lebans.com/richtext.htm
--
Arvin Meyer, MCP,...
Forum: Using Forms May 31st, 2010, 10:16 PM Posted to microsoft.public.access.forms
Replies: 9
Views: 671
password-protected form

I'm building a quick sample application which will be called Security.mdb,
located at:

http://www.accessmvp.com/arvin

If these newsgroups are closed just keep checking, it will be there within a...
Forum: Using Forms May 31st, 2010, 08:17 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 448
Employee Barcode scan IN and OUT using Access 2007

What happens if the employee isn't quick enough, or worse, is distracted
halfway through?

You can use a Timer in the popup form to close it after n milliseconds, but
are you sure that you want to?...
Forum: Using Forms May 31st, 2010, 08:14 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 497
Password protection

See my response to your other post.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by...
Forum: Using Forms May 31st, 2010, 08:13 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 497
Password protection

Access 2007 supports the MDB format which is the only format that can use
User-Level Security.

Move all the data on the server and front-end code to the MDB format (Access
2003 and earlier)....
Forum: General Discussion May 31st, 2010, 08:08 PM Posted to microsoft.public.access
Replies: 3
Views: 472
Calculate working days between records

Try this, I know it works since I've been using it for 13 years:

http://www.mvps.org/access/datetime/date0006.htm
--
Arvin Meyer, MCP,...
Forum: General Discussion May 31st, 2010, 08:06 PM Posted to microsoft.public.access
Replies: 1
Views: 497
How Do I open convert a dbk file

Your question may be better answered in a newsgroup appropriate to your
problem. This newsgroup is dedicated to the Microsoft Access database
product. The Microsoft website may have misdirected...
Forum: General Discussion May 31st, 2010, 08:05 PM Posted to microsoft.public.access
Replies: 3
Views: 471
blinking form...

Those menu commands are from Access 95 and while still supported, are no
longer used. The current useage is:

DoCmd.RunCommand acCmd??

Since I don't know what you are trying to accomplish, look at...
Forum: General Discussion May 31st, 2010, 08:02 PM Posted to microsoft.public.access
Replies: 4
Views: 420
HELP

Try a UseNet server. There are several free ones in Germany, jjust search
for free news servers,
--
Arvin Meyer, MCP,...
Forum: Using Forms May 30th, 2010, 04:33 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 497
Password protection

Yes, the MDB format can be secured with ULS (User-Level Security) the ACCDB
format cannot be.

Here's all the information you will need to secure your database:

Security...
Forum: Using Forms May 30th, 2010, 04:30 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 497
Password protection

I would use the server to protect the data. Move the back-end on the server
to a folder which is accessible only to those you want.
--
Arvin Meyer, MCP,...
Forum: Using Forms May 29th, 2010, 11:00 PM Posted to microsoft.public.access.forms
Replies: 9
Views: 671
password-protected form

Unless you are using the MDB format, you cannot secure individual objects
using Access security. Even with Access security you cannot require a
password for a single form. What you can do however...
Forum: Using Forms May 29th, 2010, 10:52 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 448
Employee Barcode scan IN and OUT using Access 2007

Within Access, you can have as many forms as is practical open, subject of
course to your available memory. In order to see what is happening on
another computer on the network, you will need to...
Forum: Using Forms May 29th, 2010, 04:09 AM Posted to microsoft.public.access.forms
Replies: 9
Views: 671
password-protected form

"blanch2009" wrote in message
...
How do you clear or reset the password?

I think you need to tell us...
Forum: General Discussion May 29th, 2010, 04:06 AM Posted to microsoft.public.access
Replies: 10
Views: 846
My last post in this forum

I've been wondering whether it's worth it myselfm but I can't just give up
because Microsoft decides to move in another direction. I'm partial to
newsgroups mostly because they are much easier, and...
Forum: General Discussion May 29th, 2010, 03:50 AM Posted to microsoft.public.access
Replies: 7
Views: 537
Access 2003 Form

Actually it checks the length of the value. So change that line of code to:

If Me.[Check_Number] = 0 Then
--
Arvin Meyer, MCP,...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 01:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.