(Msg. 9) Posted: Sun Oct 04, 2009 6:27 pm
Post subject: Re: Does Access Support Concurrent Users? - Boy is Steive desperate [Login to view extended thread Info.] Archived from groups: microsoft>public>access>gettingstarted (more info?)
"Steve" <notmyemail.DeleteThis@address.com> wrote in message
news:tuadnfzuAujbklTXnZ2dnUVZ_rqdnZ2d@earthlink.com...
>
> I provide help with Access, Excel and Word applications for a small fee. I
> could help you look at the forest and develop a strategy and
> implementation that significantly improves the efficiency of the current
> system. If you are interested, contact me.
>
> Steve
So this is number eight of your pimping for today?
If you were so good at Excel and Word, why are you not pimping your services
there? Could it be that you have delusions of adaquecy?
These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.
A few gems gleaned from the Word New User newsgroup over the past Christmas
period and a few gems from the Access newsgroups to show Stevie's
"expertise".
Dec 17, 2008 7:47 pm
Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve
Dec 22, 2008 8:22 pm
I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve
Dec 24, 2008, 1:12 PM
How do you protect the document for filling in forms?
Steve
One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)
Steve wrote:
> Yes, you are right but a database is the correct tool to use not a
> spreadsheet.
Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...
Sept 10, 2009
(In respose to a perfectly adequate GENERIC solution stevie wrote)
This function is specific to the example but not generic for any amount paid
out.
Steve
Sept 9, 2009
"Steve" <notmyemail.DeleteThis@address.com> wrote in message
> you can then return all the characters in front of it with the Left()
> fumction. Would look like:
> Left("YourString",Instr("YourString","VbCr" Or "VbLf") - 1)
>
> Steve
No, it would not look like
Left("YourString",Instr("YourString","VbCr" Or "VbLf") - 1)
First of all, the constants are vbCr and vbLf: no quotes around them. With
the quotes, you're looking for the literal strings.
Second, you can't Or together character constants like that. Even if you
could, Or'ing them together in the InStr function like that makes no sense
at all.
Sept 22,2009
Sorry Steve, even I can see that this is a useless answer. I made it pretty
clear that "CW259" is just ONE possible value for the control.
"Steve" wrote:
> Hello David,
>
> Open your report in design view and select txtOrderID. Open properties and
> go to the Data tab. Put the following expression in the Control Source
> property:
>
> =IIF([chkActive],"CW259","(CW259)")
>
> Steve
(Msg. 10) Posted: Mon Oct 05, 2009 4:05 am
Post subject: Re: Does Access Support Concurrent Users? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Steve" <notmyemail.RemoveThis@address.com> wrote in message
news:tuadnfzuAujbklTXnZ2dnUVZ_rqdnZ2d@earthlink.com...
> Hello,
>
>
Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...
For those who don't 'agree' with this mail , because $teve was 'helpfull'
with his post...
We warned him a thousand times... Sad, but he is not willing to stop
advertising...
He is just toying with these groups... advertising like hell... on and on...
for years...
oh yes... and sometimes he answers questions... indeed...
and sometimes good souls here give him credit for that...
==> We are totally 'finished' with $teve now...
==> Killfile 'StopThisAdvertising' and you won't see these mails....
(Msg. 11) Posted: Mon Oct 05, 2009 11:41 am
Post subject: Re: Does Access Support Concurrent Users? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If you only have a few machines, you can certainly use a workstation as a
server. The advantage of a server, in addition to what you've mentioned is
that it controls logins and security. It can also direct backups of itself
and other machines on the network.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com
"minofifa" <minofifa.TakeThisOut@discussions.microsoft.com> wrote in message
news:849819F5-DAB5-4B0B-ACD1-55451A576784@microsoft.com...
> Awesome, thanks everyone for the resources. I really appreciate it.
>
> I have one more question, and this may induce many of you to ream me out
> for
> being incredibly ignorant but...
>
> I have been reading a bit about windows server 2008 but it seems to me
> that
> a lot of the functions it provides can be more easily implemented using a
> sophisticated router. Our project is small so things like DNS, WINS, DHCP
> etc are overkill. I am leaning towards a solution where the office
> computers
> are connected with a single router, and one will act as a file sever,
> providing access to my MS Access backend. This server would probably only
> need to run Windows 7. the server would also hold all of the office's
> excel
> and word files (which would be accessed through the Access application via
> separate front ends deployed on each user's computer.
>
> Any advice would be much appreciated ( and I will be going through all of
> the great resources provided so far). Thanks again.
>
> "Arvin Meyer [MVP]" wrote:
>
>> And to answer this part of the question:
>>
>> minofifa wrote:
>> > Can i restrict some parts of the
>> > application to certain users? thanks a lot for any help. Windows and
>> > Office is foreign ground for me.
>>
>> Yes, either create separate front-end applications for each user, or you
>> need to use the MDB format so that you can secure your database and give
>> permissions to each user. The second choice is by far better, but there's
>> more to learm. Here's where you can learn some security information:
>>
>> Security FAQ
>> http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE >>
>> Lynn Trapp's summarization:
>> http://www.ltcomputerdesigns.com/The10Steps.htm >>
>> KB articles:
>> http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009 >> http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe >> http://support.microsoft.com/default.aspx?kbid=325261 >>
>> Joan Wild's articles:
>> http://www.jmwild.com/security02.htm >> http://www.jmwild.com/security97.htm >> http://www.jmwild.com/SecureNoLogin.htm >> http://www.jmwild.com/Unsecure.htm >> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com >> http://www.mvps.org/access >> http://www.accessmvp.com >>
>>
>>
(Msg. 12) Posted: Mon Oct 05, 2009 10:05 pm
Post subject: Re: Does Access Support Concurrent Users? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
John W. Vinson <jvinson DeleteThis @STOP_SPAM.WysardOfInfo.com> wrote in
news:uf3ic558q7k586209cve6sck330svnenin@4ax.com:
> An Access database does NOT need to be "on a
> Server"
Not a dedicated file server, but if you put it on a workstation,
it's on a server -- the server service is something you can't turn
off in Windows Workstation, as a matter of fact.
> and you do not need to worry about DNS, etc. - the networking
> capabilities of Windows can deal with all that for you.
Er, in a situation where you're using your network for Internet
access and you have a router that acts as gateway to the Internet,
you can get by with pure TCP/IP networking with NETBIOS over TCP/IP
turned off, because you are connecting only to hosts defined in DSN
via the router.
But if you have NETBIOS over TCP/IP turned off, there is no name
resolver for the local workstations, so you either need to implement
a DNS (some routers can do it), or you need to turn on NETBIOS over
TCP/IP, or you need to put entries in the workstations' HOSTS files
that map the server name to its IP address (which would mean the
"server" workstation can't have a dynamic IP address, i.e., one
assigned via DHCP).
It's very easy to set up a network that works just fine for Internet
access that then won't be able to share files peer-to-peer. And the
lack of DNS is the reason -- the easiest solution is to sacrifice
pure TCP/IP by turning on NETBIOS over TCP/IP, but some folks are
loathe to do that because it's theoretically a security
vulnerability (though only on an improperly firewalled network).
(Msg. 13) Posted: Tue Oct 06, 2009 9:51 am
Post subject: Re: Does Access Support Concurrent Users? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"David W. Fenton" <XXXusenet RemoveThis @dfenton.com.invalid> wrote in message
news:Xns9C9BDFBE8FE38f99a49ed1d0c49c5bbb2@74.209.136.93...
> Not a dedicated file server, but if you put it on a workstation,
> it's on a server -- the server service is something you can't turn
> off in Windows Workstation, as a matter of fact.
Well, you can, but shouldn't because it also stops the browser service:
Control Panel >>> Administrative Tools >>> Services >>> Server Service
(Msg. 14) Posted: Tue Oct 06, 2009 10:05 pm
Post subject: Re: Does Access Support Concurrent Users? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Arvin Meyer [MVP]" <arvinm.TakeThisOut@mvps.invalid> wrote in
news:uG##fwoRKHA.220@TK2MSFTNGP02.phx.gbl:
> "David W. Fenton" <XXXusenet.TakeThisOut@dfenton.com.invalid> wrote in message
> news:Xns9C9BDFBE8FE38f99a49ed1d0c49c5bbb2@74.209.136.93...
>
>> Not a dedicated file server, but if you put it on a workstation,
>> it's on a server -- the server service is something you can't
>> turn off in Windows Workstation, as a matter of fact.
>
> Well, you can, but shouldn't because it also stops the browser
> service:
>
> Control Panel >>> Administrative Tools >>> Services >>> Server
> Service
>
> Just right click and stop it, or disable it.
Back in NT4 days it broke a lot more than that -- I don't recall the
specifics.
Being a control freak, I wanted to shut down all services that I
considered unnecessary on my first NT-based workstation, and I
quickly figured out that the Server and the Remote Procedure Call
services were two that you couldn't get along without! The RPC
Locator is a different story...
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2
Page 2 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other