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 5.14 seconds.
Search: Posts made by: John W. Vinson
Forum: Using Forms June 7th, 2010, 09:52 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 3,304
Posted By John W. Vinson
Is there limit to number of files in a datebase in searching forms

On Mon, 7 Jun 2010 13:27:10 -0700, ky carver ky
wrote:

Once I hit 1001 files in a database, search does not work. Why?

What's the structure of your database?...
Forum: Using Forms June 7th, 2010, 08:39 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 2,077
Posted By John W. Vinson
Is a vertical datasheet view possible

On Mon, 7 Jun 2010 09:02:53 -0700, John F
wrote:

The standard layout for the datasheet view form is horizontal. Is there a way
to display the datasheet view...
Forum: Running & Setting Up Queries June 7th, 2010, 06:45 AM Posted to microsoft.public.access.queries
Replies: 5
Views: 2,036
Posted By John W. Vinson
complex query to pull unique values

On Mon, 7 Jun 2010 23:13:18 -0400, "JR" wrote:

in the query view or sql view?

You can use either, but in the query grid (which is NOT the query, just a tool
to help build SQL)...
Forum: Running & Setting Up Queries June 7th, 2010, 03:29 AM Posted to microsoft.public.access.queries
Replies: 5
Views: 2,036
Posted By John W. Vinson
complex query to pull unique values

On Mon, 7 Jun 2010 21:41:24 -0400, "JR" wrote:

Same query, except the for the date instead of First, I put Last and it
works.

sheer coincidence and good luck. Use the...
Forum: Running & Setting Up Queries June 7th, 2010, 03:28 AM Posted to microsoft.public.access.queries
Replies: 5
Views: 2,036
Posted By John W. Vinson
complex query to pull unique values

On Mon, 7 Jun 2010 21:23:45 -0400, "JR" wrote:

I have an inspection table to keep track of rooms in various buildings.
These rooms are shared with different supervisors. One...
Forum: Running & Setting Up Queries June 6th, 2010, 03:42 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 358
Posted By John W. Vinson
Sum and DateDiff

On Sat, 5 Jun 2010 19:33:30 -0700, Kelly
wrote:

Hi,
I doing a calculation in a query of the difference in times. I'm wondering
if I can control the decimal...
Forum: General Discussion June 6th, 2010, 01:44 AM Posted to microsoft.public.access
Replies: 27
Views: 4,063
Posted By John W. Vinson
Let's pick a replacement for this (Access) newsgroup

On 5 Jun 2010 22:35:03 GMT, "David W. Fenton"
wrote:

"bobbie" wrote in
:

Please delete me...
Forum: General Discussion June 5th, 2010, 08:29 PM Posted to microsoft.public.access
Replies: 1
Views: 1,810
Posted By John W. Vinson
MS Access 2007 Query _ Report

On Sat, 5 Jun 2010 11:36:22 -0700, stonewall1974
wrote:

I have a table that consists of a field named Minutes, multiple entries for a
specific individual...
Forum: Database Design June 5th, 2010, 05:53 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 1,848
Posted By John W. Vinson
Confused over new db

On Fri, 4 Jun 2010 10:40:17 -0700, Rach
wrote:

I am in the process of creating a db for a project, I have been given several
forms (paper forms that folks will be...
Forum: New Users June 5th, 2010, 04:41 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 1,835
Posted By John W. Vinson
Does SQL Run Behind Queries?

On Sat, 5 Jun 2010 03:39:06 -0700, trip_to_tokyo
wrote:

Access 2007

When I run a query does Access, "go away" and run the SQL for what I see in
the GUI?

If the...
Forum: General Discussion June 5th, 2010, 06:41 AM Posted to microsoft.public.access
Replies: 4
Views: 1,831
Posted By John W. Vinson
Close Form Event

On Fri, 4 Jun 2010 22:00:58 -0700, PeterM
wrote:

I don't think I've explained the problem clearly. I have the save button
setup the way you define in your...
Forum: General Discussion June 5th, 2010, 02:58 AM Posted to microsoft.public.access
Replies: 2
Views: 495
Posted By John W. Vinson
Unable check mail inbox

On Sat, 5 Jun 2010 08:52:37 +0800, "Rich" wrote:

Recently, many students in our campus(Shanghai Jiao Tong University) have
been complained about the problem.

In detail,...
Forum: General Discussion June 4th, 2010, 06:14 PM Posted to microsoft.public.access
Replies: 1
Views: 286
Posted By John W. Vinson
Unable to read message content

On Fri, 04 Jun 2010 10:45:02 -0400, Rhianna Kreger
wrote:

I have a pop3 account. I am able to download all my messages but random ones
do not appear in the message...
Forum: General Discussion June 4th, 2010, 06:16 AM Posted to microsoft.public.access
Replies: 2
Views: 405
Posted By John W. Vinson
Access2007 Combo Box

On Thu, 3 Jun 2010 21:20:44 -0700, ALF wrote:

Never saw this before and can't fix. I have an unbound combo box with 6
names. In the form I can choose one name. ...
Forum: General Discussion June 4th, 2010, 06:14 AM Posted to microsoft.public.access
Replies: 1
Views: 403
Posted By John W. Vinson
#Name? error in Formula

On Thu, 3 Jun 2010 20:49:02 -0700, forest8
wrote:

Hi

The Name Autocorrect Options have Track Name Autocorrect Info and Peform
name AutoCorrect are checked...
Forum: Running & Setting Up Queries June 4th, 2010, 01:38 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 299
Posted By John W. Vinson
Switch Last Name First Name to First Name Last Name

On Thu, 3 Jun 2010 16:35:15 -0700, Iram
wrote:

Hello,

Access 2003. I have a single field called "Name" in a table called "Members".

Ouch. Name is a reserved...
Forum: Running & Setting Up Queries June 4th, 2010, 01:29 AM Posted to microsoft.public.access.queries
Replies: 4
Views: 2,176
Posted By John W. Vinson
Pulling specific data from table field

On Thu, 03 Jun 2010 19:55:28 GMT, "jet04 via AccessMonster.com" [email protected]
wrote:

I am having a problem figuring the right way to pull specific data from
within the text of the table's field and...
Forum: Using Forms June 4th, 2010, 01:22 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 1,813
Posted By John W. Vinson
status validation help

On Thu, 3 Jun 2010 16:22:09 -0700, Gabe
wrote:

Hello, I need some help coding this one...

I have 3 fields in a form Amount, Date, and Status. If the user inputs...
Forum: General Discussion June 4th, 2010, 01:19 AM Posted to microsoft.public.access
Replies: 14
Views: 664
Posted By John W. Vinson
Two autonumber fields in one table possible?

On Thu, 3 Jun 2010 16:22:09 -0700, Sharon_wv
wrote:

Ken & Jeff -
I totally understand your logic for wanting me to stop. However, let me
give you more...
Forum: General Discussion June 3rd, 2010, 09:48 PM Posted to microsoft.public.access
Replies: 2
Views: 336
Posted By John W. Vinson
Calculating time

On Thu, 3 Jun 2010 12:23:06 -0700, Dave
wrote:

I have a single table database that has a drop down box of 60 days, 90 days,
and 180 days.

I want to calculate...
Forum: Database Design June 3rd, 2010, 05:59 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 1,925
Posted By John W. Vinson
My database loads but disabled?

On Thu, 3 Jun 2010 06:18:01 -0700, Al9315
wrote:

Hello
I have a database on Access 2003 - works !
Opended it in 2007 - does not work?
Converted it to 2007 -...
Forum: New Users June 3rd, 2010, 05:53 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 1,687
Posted By John W. Vinson
Query help

On Tue, 1 Jun 2010 20:48:01 -0700, Richard
wrote:

I have a form with (2) textboxes StartDate & EndDate also a command button.
When the command button is...
Forum: New Users June 3rd, 2010, 05:30 AM Posted to microsoft.public.access.gettingstarted
Replies: 17
Views: 3,398
Posted By John W. Vinson
Let's pick a replacement for this (Access) newsgroup

On Thu, 03 Jun 2010 04:44:22 -0500, Rick Brandt
wrote:

People coming from the Microsoft "get online help" buttons in the programs
will not know about these...
Forum: New Users June 3rd, 2010, 12:20 AM Posted to microsoft.public.access.gettingstarted
Replies: 17
Views: 3,398
Posted By John W. Vinson
Let's pick a replacement for this (Access) newsgroup

On Tue, 01 Jun 2010 20:03:55 +0200, Steve Hayes wrote:

Will the replacement one connect to Microsoft?

THIS one won't, that's for certain.

The Microsoft forums will be run...
Forum: Running & Setting Up Queries June 2nd, 2010, 05:13 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 397
Posted By John W. Vinson
Please help with access expression

On Sat, 29 May 2010 08:07:12 -0700 (PDT), joe_G wrote:

Hello,

I was hoping someone could assist with the following expression in
access that combines the Left function and...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 05:50 PM.


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