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 4.96 seconds.
Search: Posts made by: Tom van Stiphout[_2_]
Forum: Running & Setting Up Queries June 7th, 2010, 06:00 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 611
FILTER

On Sun, 6 Jun 2010 20:07:20 -0700, accessvoter
wrote:

Your question is a bit brief. Great: I can speculate all I want. For
example I speculate you have Access...
Forum: Running & Setting Up Queries June 6th, 2010, 04:41 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 320
Optimization of Between Clause Queries

On Fri, 4 Jun 2010 17:42:32 -0500, "Kevin Myers"
wrote:

A crude way to find out is to time the query, drop the index, and time
it again. My guess is that Access...
Forum: General Discussion June 5th, 2010, 10:28 PM Posted to microsoft.public.access
Replies: 1
Views: 1,653
Link table field format puzzle

On Fri, 4 Jun 2010 13:08:00 -0700, Han
wrote:

No you can't. Numeric is a data type that is poorly supported in
Access. It knows about real and double much better. Do...
Forum: General Discussion June 4th, 2010, 03:56 PM Posted to microsoft.public.access
Replies: 4
Views: 258
LIKE search help needed

On Fri, 4 Jun 2010 07:32:48 -0700 (PDT), Song
wrote:

You're missing a space and you have a spurius "=". It should be:
strCriteria = "PODetail.ItemDescription Like *"
&...
Forum: Database Design June 4th, 2010, 06:56 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 1,486
Let's pick a replacement for this (Access) newsgroup

On Tue, 1 Jun 2010 07:00:05 -0700, Fred
wrote:

My guess is that people will find a new home or homes with or without
your help. Each will select one/several based on...
Forum: General Discussion June 4th, 2010, 06:19 AM Posted to microsoft.public.access
Replies: 1
Views: 274
control name literal

On Thu, 3 Jun 2010 17:36:37 -0700, PeterM
wrote:

To dynamically refer to a control on a form use:
Forms(strFormName).Controls(strControlName)
This also suggests...
Forum: Using Forms June 3rd, 2010, 05:04 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 383
Remove CAPS

On Wed, 02 Jun 2010 19:23:03 GMT, "ladybug via AccessMonster.com"
[email protected] wrote:

I already showed you that:
UCase$(Left$(Me.Description.Value ,1)) &
LCase$(Mid$(Me.Description.Value ,2)
If you...
Forum: Using Forms June 3rd, 2010, 05:01 AM Posted to microsoft.public.access.forms
Replies: 6
Views: 665
Unbound text box calculation

On Wed, 2 Jun 2010 16:16:01 -0700, dab1477
wrote:

* What is in the ControlSource of this box3?
...as noted in my original post the ControlSource was...
Forum: General Discussion June 2nd, 2010, 04:05 PM Posted to microsoft.public.access
Replies: 1
Views: 237
Printing Structures

On Wed, 2 Jun 2010 07:41:01 -0700, dmills
wrote:

Check out Database Documenter in the menu.

-Tom.
Microsoft Access MVP


Does Anyone Have A Solution For Printing...
Forum: Using Forms June 2nd, 2010, 03:10 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 665
Unbound text box calculation

On Wed, 2 Jun 2010 06:17:01 -0700, dab1477
wrote:

That is not the way an unbound textbox normally behaves. So I have
these questions:
* What is in the...
Forum: Using Forms June 2nd, 2010, 03:02 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 383
Remove CAPS

On Wed, 02 Jun 2010 12:44:37 GMT, "ladybug via AccessMonster.com"
[email protected] wrote:

One possibility would be in the control's AfterUpdate event:
Me.Description.Value =...
Forum: General Discussion June 2nd, 2010, 02:46 PM Posted to microsoft.public.access
Replies: 5
Views: 331
Allen Browns List files recursively

On Wed, 02 Jun 2010 06:45:30 -0700, Tom van Stiphout
wrote:

Sorry, I meant:
myList.AddItem(strFilename & ";" & strFilePath)

On Tue, 1 Jun 2010 09:31:01 -0700,...
Forum: General Discussion June 2nd, 2010, 02:45 PM Posted to microsoft.public.access
Replies: 5
Views: 331
Allen Browns List files recursively

On Tue, 1 Jun 2010 09:31:01 -0700, StuJol
wrote:

Sure. It's very simple. Since you are looping over a folder tree I am
assuming you're adding rows one at a time....
Forum: Using Forms June 2nd, 2010, 05:33 AM Posted to microsoft.public.access.forms
Replies: 5
Views: 337
Missing files

On Sun, 30 May 2010 19:06:01 -0700, WST761
wrote:

The reason I was asking for "exact filename" is because "DAO1" is not
a normal filename. Files typically have...
Forum: General Discussion June 1st, 2010, 03:41 PM Posted to microsoft.public.access
Replies: 1
Views: 374
Database for a Testing Center - Tracking dates

On Tue, 1 Jun 2010 07:20:01 -0700, T. Douglas T.
wrote:

You need at least 3 tables, because there is a many-to-many relation
between Students and Exams: each...
Forum: Using Forms June 1st, 2010, 03:02 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 318
Problem Delay and Slowly Running the Microsoft Access

On Tue, 1 Jun 2010 02:13:01 -0700, Fauzi
wrote:

Check out this page:
http://www.granite.ab.ca/access/performancefaq.htm

-Tom.
Microsoft Access MVP
Forum: General Discussion June 1st, 2010, 03:00 PM Posted to microsoft.public.access
Replies: 5
Views: 331
Allen Browns List files recursively

On Tue, 1 Jun 2010 04:56:04 -0700, StuJol
wrote:

That doesn't seem a good idea: several versions of a document by the
same name can occur in the tree. If I only...
Forum: Using Forms May 31st, 2010, 07:42 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 308
mde file in Access 2007

On Mon, 31 May 2010 09:50:47 +0100, Bob H wrote:

Your combobox should be unbound (the ControlSource should be empty).
Then check out this...
Forum: Using Forms May 31st, 2010, 12:24 AM Posted to microsoft.public.access.forms
Replies: 7
Views: 308
mde file in Access 2007

On Sun, 30 May 2010 20:58:01 +0100, Bob H wrote:

OK, back to the original problem. You wrote: "when I select a record
from the list, it is not shown on the form".
What do you...
Forum: General Discussion May 30th, 2010, 08:37 PM Posted to microsoft.public.access
Replies: 11
Views: 374
Resource For Help With Access

On Sun, 30 May 2010 14:32:15 -0500, "Larry Linson"
wrote:

Hi Larry,
Another point is that with more and more support options going to a
moderated format, there may be fewer...
Forum: Running & Setting Up Queries May 30th, 2010, 08:33 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 327
Combo Box Query Help

On Sat, 29 May 2010 23:00:34 GMT, "Scott_66701 via AccessMonster.com"
[email protected] wrote:

One way is to have an extra hidden column in the combobox. For example
the rowsource would be a query like...
Forum: Using Forms May 30th, 2010, 08:28 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 337
Missing files

On Sun, 30 May 2010 11:47:01 -0700, WST761
wrote:

Do you know the exact filenames?
Does your project compile (Code window Debug Compile)?

Office 2007 came...
Forum: General Discussion May 30th, 2010, 08:21 PM Posted to microsoft.public.access
Replies: 11
Views: 374
Resource For Help With Access

On Sun, 30 May 2010 15:03:59 -0400, "Steve"
wrote:

Keep in mind that Steve is notorious for violating newsgroup etiquette
and is always trolling for work. He doesn't grasp...
Forum: Database Design May 30th, 2010, 08:20 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 10
Views: 2,684
Resource For Help With Access

On Sun, 30 May 2010 15:03:59 -0400, "Steve"
wrote:

Keep in mind that Steve is notorious for violating newsgroup etiquette
and is always trolling for work. He doesn't grasp...
Forum: Using Forms May 30th, 2010, 06:22 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 308
mde file in Access 2007

On Sun, 30 May 2010 18:00:40 +0100, Bob H wrote:

Did you put the database in a Trusted Location (see help file)?

-Tom.
Microsoft Access MVP


I have just converted a mdb...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 02:42 AM.


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