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 83
Search took 0.40 seconds.
Search: Posts made by: Gabe
Forum: Using Forms June 4th, 2010, 05:23 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 2,708
Posted By Gabe
status validation help

That worked great, I had to tweak it a little...thank you John!

Private Sub Form_BeforeUpdate(Cancel As Integer)
If (Me![Amount]) 0 And IsNull(Me![PaidDate]) And Me![Status] = "Complete"
Then
...
Forum: Using Forms June 4th, 2010, 05:00 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 2,708
Posted By Gabe
status validation help

Yes, if they don't put an amount then the "Complete" status is still
acceptable, sometimes costs are not inccured but if they do put an amount in
then they must enter a date or "PaidDate" down...
Forum: Using Forms June 4th, 2010, 12:22 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 2,708
Posted By Gabe
status validation help

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

I have 3 fields in a form Amount, Date, and Status. If the user inputs an
Amount then they must enter a "Date" in order for the database to accept a...
Forum: Worksheet Functions May 19th, 2010, 05:21 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 126
Posted By Gabe
networkdays alternative

I have several people that are not familiar with the Analysis Toolpak, is
there a work around for the networkdays function? I just have two dates in
B33 (start date) & B34 (end date), so currently...
Forum: General Discussion May 12th, 2010, 06:42 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 157
Posted By Gabe
Variable Range in Formula

Wait nevermind I think I got it, how about:

=SUMPRODUCT((INDIRECT(B2)=$B$5)*(INDIRECT(B2)=$B$6))

"Gabe" wrote:

I'm stuck on this one, hopefullly someone can help. I have the following
...
Forum: General Discussion May 12th, 2010, 05:45 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 157
Posted By Gabe
Variable Range in Formula

I'm stuck on this one, hopefullly someone can help. I have the following
formula:

=SUMPRODUCT((B2=$B$5)*(B2=$B$6))

Well "B2" in this formula is supposed to a variable range, but it wont...
Forum: General Discussion May 12th, 2010, 12:32 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 128
Posted By Gabe
Two date validations

How do I create two validation rules for one cell containing a date?

1. The date (Cell A1) must be between a certain range (12/01/2009 and
12/31/2012).

2. The date must not be greater than Cell...
Forum: General Discussion April 5th, 2010, 06:22 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 110
Posted By Gabe
Count specific days in between dates

Thank You!

"Mike H" wrote:

Hi,

Start date in A1, End date in a2 and the days to count in B1:B3

=SUMPRODUCT((B1:B3=A1)*(B1:B3=A2))
Forum: General Discussion April 5th, 2010, 06:01 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 110
Posted By Gabe
Count specific days in between dates

Hello,

I am trying to count a specific number of days in between 2 dates. For
example, if I specify a certain date range of:
Start Date: 01/01/2010
End Date: 12/31/2010

and my fixed days a...
Forum: Setting Up & Running Reports January 15th, 2010, 07:11 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 91
Posted By Gabe
# of subreports in 1 main report?

Is there a limit to the amount of subreports you can put in 1 main report?
I'm using Access 2003. I have like 92 subreports I need in 1 report...or
maybe I'm doing it wrong.

Each subreport is...
Forum: Running & Setting Up Queries January 15th, 2010, 12:56 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 139
Posted By Gabe
two null fields?

Hello,

I have two fields in a query, if they both are blank I don't want to see it.
But if one or the other is blank I want to see it.

Thanks.
Forum: Contacts December 8th, 2009, 05:33 AM Posted to microsoft.public.outlook.contacts
Replies: 2
Views: 107
Posted By Gabe
Distribution list does not appear in Contacts. Comes up in To:

Distribution list does not appear in Contacts. Comes up in the "To:" of the
message when I put in a few strokes. Why is this?

--
Thank you,
Forum: Database Design October 29th, 2009, 07:21 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 88
Posted By Gabe
Linking Two Tables

Thanks John, you are correct, I joined the two tables and the process wasn't
as bad as I thought it would be.

~Gabe

"John W. Vinson" wrote:

On Wed, 28 Oct 2009 16:35:01 -0700, Gabe...
Forum: Database Design October 29th, 2009, 12:35 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 88
Posted By Gabe
Linking Two Tables

I have two tables in Access 2003, Master (Parent) and Hours (Child).
Currently they share a One-To-One relationship. I need a record to be created
in the Hours table every time there is a record...
Forum: General Discussion October 5th, 2009, 04:41 PM Posted to microsoft.public.access
Replies: 10
Views: 132
Posted By Gabe
Linking to a mainframe database

I just wanted to say thanks to everyone who responded.

The ID numbers are assigned in Access via auto number in my table when I
import the data from the Excel spreadsheet. Disregard the customers...
Forum: General Discussion October 3rd, 2009, 12:41 AM Posted to microsoft.public.access
Replies: 10
Views: 132
Posted By Gabe
Linking to a mainframe database

Perhaps I should clarify a bit:

Here's my dilemma, let's say that the Master table has about 100 records,
all with different employee names. I have another table called "Hours" that
tracks how...
Forum: General Discussion September 29th, 2009, 12:08 AM Posted to microsoft.public.access
Replies: 10
Views: 132
Posted By Gabe
Linking to a mainframe database

Thanks for the info, is there a way to tell what kind of mainframe database
it is? It opens from TCP3270...?

On the import, I am just importing a new data extract named master1.xls,
cloning the...
Forum: General Discussion September 28th, 2009, 11:24 PM Posted to microsoft.public.access
Replies: 10
Views: 132
Posted By Gabe
Linking to a mainframe database

Hello,

I was just wondering if it is possible to link a table in my Access database
directly to a mainframe database? The mainframe database is written in Cobol.
Currently, I am having to import a...
Forum: General Discussion September 2nd, 2009, 06:07 AM Posted to microsoft.public.word.docmanagement
Replies: 3
Views: 78
Posted By Gabe
Forum: General Discussion August 11th, 2009, 12:47 PM Posted to microsoft.public.outlook.general
Replies: 2
Views: 122
Posted By Gabe
Outlook Today

How do I prevent Outlook Today from showing completed tasks?
Forum: General Discussion July 6th, 2009, 08:09 PM Posted to microsoft.public.access
Replies: 2
Views: 137
Posted By Gabe
Preventing entries based on a field

Hello,

I want to prevent duplicate record entries based on a field.

For example, I have a table with an "lastname" field and a "round"
field. If a user enters the record "Doe" for lastname and...
Forum: Using Forms July 2nd, 2009, 11:33 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 69
Posted By Gabe
Dependent subform?

Nevermind I got it. Thanks for all your help though.

~Gabe

"Arvin Meyer MVP" wrote:

You shouldn't need to enable/disable a subform if you are making it
Visible/Hidden. Is SEIU_Only_Query the...
Forum: Using Forms July 2nd, 2009, 10:18 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 69
Posted By Gabe
Dependent subform?

I'm trying to have a subform appear on my main form if a certain value is
selected from a combobox, but I'm having some trouble. I put the following
code in the AfterUpdate field of my combobox but...
Forum: General Discussion June 8th, 2009, 10:53 PM Posted to microsoft.public.access
Replies: 2
Views: 100
Posted By Gabe
validation dependencies

Hello,

I want to prevent duplicate record entries based on a field.

For example, I have a table with an "employeename" field and a "round"
field. If a user enters the record "John Doe" for...
Forum: General Discussion June 8th, 2009, 09:45 PM Posted to microsoft.public.access
Replies: 3
Views: 73
Posted By Gabe
Validation for partial addresses

Hello,

I was wondering if anyone might know the code to use for validating partial
addresses? The addresses in my table should look like this: Salem, OR 97301.
However, some users are putting bad...
Showing results 1 to 25 of 83

 
Forum Jump

All times are GMT +1. The time now is 04:12 PM.


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