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 0.04 seconds.
Search: Posts made by: Larry Daugherty
Forum: Database Design May 15th, 2010, 01:21 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 11
Views: 678
Posted By Larry Daugherty
Update - Microsoft Responds to the Evolution of Community

It must be that the Progressives have gotten control at MS just as
they have in two of the three branches of the US government. All on
their own they decide what is best for the universe and our...
Forum: New Users April 30th, 2010, 04:31 AM Posted to microsoft.public.access.gettingstarted
Replies: 1
Views: 318
Posted By Larry Daugherty
Issues Template

It's unlikely that you'll get any help that requires anyone to
download and analyyse someone else's guickie application. You'd do
better to use the sample databases and tools that are provided...
Forum: New Users February 16th, 2010, 10:37 PM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 208
Posted By Larry Daugherty
How do I prevent others from editing my Access 2007 database?

First, your application's configuration should be a FrontEnd linked to
tables in the BackEnd.

When your application is ready for your users, compile the FrontEnd
into the "DE" form you are using: ...
Forum: Database Design December 18th, 2009, 11:20 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 7
Views: 179
Posted By Larry Daugherty
Change all Names: objects, fields, code, etc.

To get you over the current hurdle:

get a copy of FindAndReplace from Rick Fisher at www.rickworld.com
It's shareware and is specific to Access versions. It will allow you
to fint and replace the...
Forum: Database Design December 18th, 2009, 03:43 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 202
Posted By Larry Daugherty
Limitations on WHERE Clause in lookup query for a table column

Stop!

Lookup fields in tables are a miss-feature provided by Microsoft that
should never be used - ever! For a discussion see
www.mvps.org/access search for "lookup field"

Tables are simply...
Forum: New Users December 18th, 2009, 02:03 PM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 178
Posted By Larry Daugherty
Changing the names of fields in tables after creating other object

No, those other objects use the field names.

There are a couple of 3rd party tools that are handy for the purposes
of globally re-naming fields in all of your objects. One of them
should be in your...
Forum: General Discussion September 22nd, 2009, 11:00 PM Posted to microsoft.public.access
Replies: 3
Views: 64
Posted By Larry Daugherty
Copies being made and Records being deleted by Access

Moving the servers "off-site" may be the cause of the symptoms. Off
site probably means that you are getting at the database over the WAN.
Access only plays well when it's all on the same LAN. As...
Forum: New Users September 22nd, 2009, 10:17 PM Posted to microsoft.public.access.gettingstarted
Replies: 7
Views: 145
Posted By Larry Daugherty
how can i repeat selected fields on an access 2007 form

A standard module is one that is not a class module - such as the
module for a form. If you already have modules showing in the
Database|Modules window then you can add the line in an...
Forum: Database Design September 22nd, 2009, 02:50 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 10
Views: 163
Posted By Larry Daugherty
Need to have a field always have 13 characters & insert leadin

Don't know if you found a solution to your issue. The below little
routine returns a 13 character string with leading zeros and the
number set to the right.

HTH
--
-Larry-
--

"WolfDog"...
Forum: Database Design September 22nd, 2009, 12:44 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 103
Posted By Larry Daugherty
AutoLookup in List Box

The behavior you describe is offered for a ComboBox, not a ListBox.
That is if you are in design mode and the wizards are enabled.

HTH
--
-Larry-
--

"Donna" wrote...
Forum: New Users September 22nd, 2009, 12:39 AM Posted to microsoft.public.access.gettingstarted
Replies: 7
Views: 145
Posted By Larry Daugherty
how can i repeat selected fields on an access 2007 form

Place the following declaration in a standard module.

Public Const CQuote = """" 'that's two quotes - used in string and
Where clause formation


Then place a copy of the below line of code in...
Forum: General Discussion September 22nd, 2009, 12:09 AM Posted to microsoft.public.access
Replies: 12
Views: 128
Posted By Larry Daugherty
Hide Access Application window?

The below snippet of code is taken from one of the "execute" command
buttons that causes a form to be either Previewed or Printed
immediately depending on the state of two radio buttons in an...
Forum: New Users August 25th, 2009, 03:39 AM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 111
Posted By Larry Daugherty
Combo Box Error

Try the "go to a record ... " option.

HTH
--
-Larry-
--

"Kathy" wrote in message
...
I have created a...
Forum: General Discussion August 7th, 2009, 08:19 PM Posted to microsoft.public.access
Replies: 3
Views: 78
Posted By Larry Daugherty
Queries or SQL in Form Record Source

With all due respect to my friend Jeff, my tendency is to go exactly
the other way. My Database | Queries window is often completely empty
in a finished application.

In days of yore I kept queries...
Forum: Database Design August 4th, 2009, 04:28 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 15
Views: 227
Posted By Larry Daugherty
Overtime DB Help Needed

You didn't mention my suggestions so you obviously must understand why
and how to implement them.

You're still keeping secrets.

You want to use your Access application to control a process...
Forum: Database Design July 31st, 2009, 05:57 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 15
Views: 227
Posted By Larry Daugherty
Overtime DB Help Needed

To get an answer or suggestions appropriate to your situation you'll
need to supply a lot more details about your real-world situation and
the desired workflow.

You don't need all of the information...
Forum: General Discussion July 28th, 2009, 05:19 PM Posted to microsoft.public.access
Replies: 1
Views: 52
Posted By Larry Daugherty
Update query help...

"Wrong" might be too harsh but there may be more elegant ways to get
the job done:

Your Form should be based on a Query which includes the target table.
At the point where your question begins, your...
Forum: Setting Up & Running Reports July 26th, 2009, 11:58 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 95
Posted By Larry Daugherty
Subreports not Saved in Main Report

Doing it the way you have done you should have three sets of
separately named subreports: Report1, subreport1A, subreport1b;
Report2, subreport2A, subreport2B, etc. ...

However, your schema...
Forum: Setting Up & Running Reports July 26th, 2009, 11:41 PM Posted to microsoft.public.access.reports
Replies: 5
Views: 101
Posted By Larry Daugherty
Conditional Formatting Programming

L.A. Lawyer; is saying "Thank you" too high a price to pay for
valuable services rendered? The responses you've received in this
thread alone saved you from many hours to many days of...
Forum: Database Design July 22nd, 2009, 10:36 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 157
Posted By Larry Daugherty
Event Procedure to lookup value in table and perform action based on value

Compare [DLookup() the value in that table and field] with Now().

HTH
--
-Larry-
--

"steve" wrote in...
Forum: General Discussion July 21st, 2009, 07:08 PM Posted to microsoft.public.access
Replies: 1
Views: 104
Posted By Larry Daugherty
Searching for Contact in Office

Post your issue in a newsgroup concerned with the product in question.
This newsgroup is devoted to Access, the database product from
Microsoft.

HTH
--
-Larry-
--

"David Viger" ...
Forum: Database Design July 20th, 2009, 07:54 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 127
Posted By Larry Daugherty
Table with combobox type

No matter the later intended use, *Don't use Lookup Fields in Tables*.
Visit
www.mvps.org/access for a discussion.

You would be better advised to use a subform than a table datasheet to
display...
Forum: New Users July 18th, 2009, 06:41 AM Posted to microsoft.public.access.gettingstarted
Replies: 17
Views: 308
Posted By Larry Daugherty
Help creating database

Thanks Jeff,

I hope it was useful to OP.

Most useful to the neophyte is getting to know about the territory
that he or she doesn't yet know but that they will likely have to
travel in order to get...
Forum: New Users July 16th, 2009, 11:29 PM Posted to microsoft.public.access.gettingstarted
Replies: 7
Views: 147
Posted By Larry Daugherty
select random records problem

Ooops. Should have read ... next 5 records.

--
-Larry-
--

"Larry Daugherty" wrote in
message ...
I'm snowed ...
Forum: New Users July 16th, 2009, 10:46 PM Posted to microsoft.public.access.gettingstarted
Replies: 7
Views: 147
Posted By Larry Daugherty
select random records problem

I'm snowed ...

My knee jerk reaction is that you are sorting exactly the same each
time you start from scratch. You aren't randomizing anything.

But that's only a part of my problem. Where is the...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 08:56 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.