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 1.64 seconds.
Search: Posts made by: RonaldoOneNil
Forum: Worksheet Functions May 28th, 2010, 08:57 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 0
Views: 176
Posted By RonaldoOneNil
Roundup and rounddown function - how to combine

Assuming the numbers are never more than 2 decimal places

=INT(A1+.49)

"Piotr (Peter)" wrote:

Dear All,

I have a spreadsheet with numbers containing decimals. I would like to
combine...
Forum: Worksheet Functions May 27th, 2010, 09:29 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 0
Views: 243
Posted By RonaldoOneNil
Using a COUNTIF statement with an AND operator

Assuming number of people is in column A and group work is in column B, use
the following adjusting the range as required

=SUMPRODUCT((A1:A1000=1)*(B1:B1000=0))

"JTurner" wrote:

I'm using Excel...
Forum: Using Forms May 25th, 2010, 01:17 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 429
Posted By RonaldoOneNil
Update box with combo box

Include the product name in the combo box. You can display it or not by
seting its column width to 0. In the control source of your other box, you
can then put
=[ComboBoxName].Column(1)

Adjust the...
Forum: General Discussion May 24th, 2010, 10:59 AM Posted to microsoft.public.access
Replies: 6
Views: 240
Posted By RonaldoOneNil
Can some tell me where my formula is going wrong please

Take out the quotes and the apostrophe in this middle of this section
.... [Revenue Stream Division] = 'Postage' And ([customer no] = ...

"Alan" wrote:



can some please tell what wrong with...
Forum: Worksheet Functions May 21st, 2010, 02:28 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 130
Posted By RonaldoOneNil
Average columns that contain text

You haven't said whether you want the text to be ignored or used in the
average as if the cell was 0 ?

if the following is in A1 to A6 then =AVERAGE(A1:A6) gives 7. Is this what
you want...
Forum: General Discussion May 21st, 2010, 02:16 PM Posted to microsoft.public.access
Replies: 1
Views: 198
Posted By RonaldoOneNil
select two option to one criteria

..... [cbMonth] & "' And ([Revenue Stream Division] = 'Production' Or [Revenue
Stream Division] = 'Other')")


"Alan" wrote:


thanks for you help yesterday with a dsum
just one quick...
Forum: General Discussion May 20th, 2010, 04:45 PM Posted to microsoft.public.access
Replies: 4
Views: 123
Posted By RonaldoOneNil
Like numbers in a field

Create a new query based on your parts issue listiong table. Drag the Part
number field into the query grid twice. Click on the Totals button, (the
greek sigma icon on the toolbar). Leave the first...
Forum: General Discussion May 20th, 2010, 04:32 PM Posted to microsoft.public.access
Replies: 10
Views: 274
Posted By RonaldoOneNil
dsum problem

You extra double quotes where you don't need them

..... [cbMonth] & "' And [Revenue Stream Division] = 'Production'")

"Alan" wrote:

Hi

=DSum("[AmountActual]","[Sales Analysis]","[Posting...
Forum: General Discussion May 18th, 2010, 02:36 PM Posted to microsoft.public.access
Replies: 8
Views: 99
Posted By RonaldoOneNil
Wildcard in query

Like
Left([Forms]![FormName]![cboSelectCar],InStr([Forms]![FormName]![cboSelectCar] & " "," ")-1) & "*"

"blake7" wrote:

Hi Guys, that works great although can the code also incorporate a single...
Forum: General Discussion May 18th, 2010, 12:31 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 114
Posted By RonaldoOneNil
Opening on a specific worksheet

Don't know whats happening with my posts !

Open the VBA code page for ThisWorkbook and enter the following into the
Workbook Open function

Me.Sheets("YourSheetNameToOpen").Select

"Tim" wrote:

...
Forum: General Discussion May 18th, 2010, 12:27 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 114
Posted By RonaldoOneNil
Opening on a specific worksheet

"Tim" wrote:

Hi

I have a workbook with dozens of individually named sheets. Can I get Excel
2007 to open the workbook on the same sheet regardless of which sheet I was
working on when I...
Forum: General Discussion May 18th, 2010, 12:26 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 114
Posted By RonaldoOneNil
Forum: Using Forms May 18th, 2010, 12:18 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 360
Posted By RonaldoOneNil
Combo box values for existing and new records

One way would be to create a text box on your form which is bound to the
devices field. This field is used to show the currently selected device.
Change your combo box to an unbound combo box so...
Forum: General Discussion May 14th, 2010, 09:28 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 132
Posted By RonaldoOneNil
conditional formatting

Try setting the condition to
Cell Value is
Not Between
=TODAY()
=TODAY()-(365*3)

"Teeny" wrote:

I have a column of dates and I want to highlight in red all dates that are
equal to and more...
Forum: Using Forms May 13th, 2010, 10:21 AM Posted to microsoft.public.access.forms
Replies: 6
Views: 543
Posted By RonaldoOneNil
How to enable New/Delete record button when a form opened?

Have you set the form properties Allow additions and Allow deletions to No by
accident ?

"fox" wrote:

Hello,
I have a problem to fix my program. It's a form which display records. I
have...
Forum: Using Forms May 13th, 2010, 10:19 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 450
Posted By RonaldoOneNil
cant type more than 11 numbers

A long variable can hold a maximum number of 2147483647
I suggest you make your bank account number field text. It does not need to
be a number just because it contains all digits. You are not going...
Forum: Using Forms May 12th, 2010, 09:00 AM Posted to microsoft.public.access.forms
Replies: 5
Views: 283
Posted By RonaldoOneNil
Dlookup Question

Also it needs to be all on one line unless you use the underscore
continuation character.

"buzzmcduffie" wrote:

I'm still getting a syntax error when I copy and paste your code. I must not
...
Forum: General Discussion May 12th, 2010, 08:57 AM Posted to microsoft.public.access
Replies: 14
Views: 105
Posted By RonaldoOneNil
Stop incomplete details by the user?

You have to fully qualify the command button as well
Forms![Data Entry]![Command148].Enabled = True
.....
Forms![Data Entry]![Command148].Enabled = False

"jo" wrote:

Hi John sorry to be a pain...
Forum: Worksheet Functions May 11th, 2010, 03:51 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 111
Posted By RonaldoOneNil
Countif help needed

Use this and adjust the range accordingly

=SUMPRODUCT((A1:A1000="CAR")*(N1:N1000499))

"Jessica Krall" wrote:

I am trying to use a countif statement for column A to count the number of
times...
Forum: Using Forms May 11th, 2010, 03:10 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 283
Posted By RonaldoOneNil
Dlookup Question

Sorry missed the closing double quotes off the end

...... And Active = 'yes'")

"buzzmcduffie" wrote:

I'm still getting a syntax error when I copy and paste your code. I must not
...
Forum: General Discussion May 11th, 2010, 03:03 PM Posted to microsoft.public.access
Replies: 14
Views: 105
Posted By RonaldoOneNil
Stop incomplete details by the user?

Create a function similar to below and then call it from the after update
event of each of your 3 fields and possibly the On Current event of the form.

Function CheckFields()
If Nz(,"") ""...
Forum: General Discussion May 11th, 2010, 01:13 PM Posted to microsoft.public.access
Replies: 14
Views: 105
Posted By RonaldoOneNil
Stop incomplete details by the user?

Ideally the button should be disabled until all the relevant fields have data
in them but to answer your question
In the click event of your button put something like this

If Nz(Me.[Your Field...
Forum: Using Forms May 11th, 2010, 12:31 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 125
Posted By RonaldoOneNil
Delete record button not working (allowedits = true)?

There is a separate form property called Allow Deletions

"Sandroid" wrote:

I set AllowEdits to False in forms and created a "edit record" button
to se AllowEdits to True as follows:

"
I...
Forum: Using Forms May 11th, 2010, 12:29 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 283
Posted By RonaldoOneNil
Dlookup Question

The following assumes that all your fields in the Lookup are Text values and
so are surrounded by single quotes.

Me![Goal] = DLookup("[Goal]", "tblMailCodeTasks", "MailCode = '" &...
Forum: New Users May 5th, 2010, 04:26 PM Posted to microsoft.public.excel.newusers
Replies: 3
Views: 304
Posted By RonaldoOneNil
Copy and Pasting Formulas are incrementing

Your original formula needs to have an absolute reference to stop it changing
as you paste into another column

i.e. $A$1 instead of just A1

"anickless" wrote:

Hi i am trying to paste formulas...
Showing results 1 to 25 of 100

 
Forum Jump

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