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 22 of 22
Search took 0.13 seconds.
Search: Posts made by: jubu
Forum: Setting Up & Running Reports May 27th, 2010, 10:48 PM Posted to microsoft.public.access.reports
Replies: 0
Views: 437
Posted By jubu
Business card formatting problems

I posted an earlier question, but perhaps my subject was too confusing to
know what I am requesting, so I am trying to re-word it. I have an Access
2007 database that stores training records for a...
Forum: Setting Up & Running Reports May 18th, 2010, 01:01 PM Posted to microsoft.public.access.reports
Replies: 0
Views: 411
Posted By jubu
Business Cards listing training records

I am using an Avery business card template in Access 2007 to show the name
and list of training records for each individual. I created a query to
gather the appropriate information and designed...
Forum: General Discussion October 27th, 2009, 06:54 PM Posted to microsoft.public.access
Replies: 2
Views: 50
Posted By jubu
Access 2007 database name disappears from Title Bar

Thanks. I did try that same technique earlier and it didn't seem to work,
but I tried it today and the Application name seems to be retained on the
title bar. Thank you.
--
jubu


"jubu"...
Forum: General Discussion October 22nd, 2009, 07:38 PM Posted to microsoft.public.access
Replies: 2
Views: 50
Posted By jubu
Access 2007 database name disappears from Title Bar

Is there a way to keep the database file name in the Title Bar of the Access
2007 application window? When we first open the database it will appear, but
once a table or other object is opened,...
Forum: Running & Setting Up Queries February 6th, 2009, 05:06 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 77
Posted By jubu
Qry returning too many records - join question

Apologies for delaying my response. Your message got me thinking again and I
realized that I had to link my tables through another piece of information,
which referenced the record of their...
Forum: Running & Setting Up Queries January 5th, 2009, 09:24 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 77
Posted By jubu
Qry returning too many records - join question

I considered that, however, if an individual starts one job, and then gets
another one during the same fiscal year, I still want to be able to see both
of those records.
--
jubu


"Michel Walsh"...
Forum: Running & Setting Up Queries January 5th, 2009, 08:20 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 77
Posted By jubu
Qry returning too many records - join question

I have 3 tables in my database (With sample info. Actually there are more,
but these are the ones giving me grief.). tblClientcountyInfo keeps track of
county info and when it changes. tblEmploy...
Forum: General Discussion November 18th, 2008, 10:20 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 100
Posted By jubu
text converted to scientific notations

thanks! I suspected that, but thought it important to ask the experts!
Appreciate all your help.
--
jubu


"David Biddulph" wrote:

No. Once Excel has stored it as a number, you can't restore...
Forum: General Discussion November 18th, 2008, 10:04 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 100
Posted By jubu
text converted to scientific notations

I'm actually asking this question on behalf of a friend. She indicated that
their mainframe system uses Crystal Reports, which immediately sends the data
into excel format. She does not have...
Forum: General Discussion November 18th, 2008, 09:39 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 100
Posted By jubu
text converted to scientific notations

I read the threads about numbers coming through as scientific. Most of the
suggestions were to change the format of the cell. However, my situation is
such that when we download information from...
Forum: Worksheet Functions November 7th, 2008, 07:00 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 97
Posted By jubu
Change numeric value to it's text equivalent, ie dollar values

Thank you for your quick response. That is exactly what I was looking for.
--
jubu


"Mike H" wrote:

Hi,

Look here
Forum: Worksheet Functions November 7th, 2008, 07:00 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 97
Posted By jubu
Change numeric value to it's text equivalent, ie dollar values

Thank you for your quick response. That is exactly what I was looking for.
--
jubu


"Pete_UK" wrote:

Check out the links on this site:

http://www.xldynamic.com/source/xld.xlFAQ0004.html
Forum: Worksheet Functions November 7th, 2008, 06:26 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 97
Posted By jubu
Change numeric value to it's text equivalent, ie dollar values

I am looking for a function that would convert a dollar value to the
equivalent text phrase. Example: $1,923.45 would become One Thousand Nine
Hundred Twenty-Three and forty-five hundredths...
Forum: Running & Setting Up Queries April 16th, 2008, 06:20 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 81
Posted By jubu
Using criteria on a calculated field in a query

I have an Access 2003 database. The main table get its data from another
system (downloaded) of which some of the number fields come through as text.

Class (refers to number of students in...
Forum: Worksheet Functions June 30th, 2007, 12:46 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 64
Posted By jubu
Alert user that row has been modified by changing row color

--
jubu


"Bernie Deitrick" wrote:

jubu,

Copy the code below, right-click the sheet tab, select "View Code" and paste the code into the
window that appears. It will make the entire row...
Forum: Worksheet Functions June 27th, 2007, 04:24 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 64
Posted By jubu
Alert user that row has been modified by changing row color

I would like to set up a spreadsheet of data so that if anything is modified
in a cell, the entire row changes color. Is this possible in Excel and if
so, how can it be done. I have tried the...
Forum: Calendar August 9th, 2006, 04:51 PM Posted to microsoft.public.outlook.calendaring
Replies: 1
Views: 44
Posted By jubu
Track Mtng Attendees in Public Folder

Outlook 2000. A meeting was set up using a public folder calendar. However,
we have found that even when responses are returned, the public calendar is
not tracking the attendee status. The...
Forum: Running & Setting Up Queries August 9th, 2006, 02:05 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 71
Posted By jubu
Convert dates to "week beginning.." dates

It worked! Thank you so much for your help.
--
jubu


"Duane Hookom" wrote:

You want to subtract the number of days "d" calculated from the WeekDay()
function.
...
Forum: Running & Setting Up Queries August 7th, 2006, 08:02 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 71
Posted By jubu
Convert dates to "week beginning.." dates

I looked up the info about DateAdd, but I don't understand how it will find
the beginning of the week. Per your instructions (as I understand them) I am
constructing the formula as follows:
...
Forum: Running & Setting Up Queries August 4th, 2006, 08:26 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 71
Posted By jubu
Convert dates to "week beginning.." dates

I am using Access 2003 and have a query of daily entry information including
a Date field. I would like to be able to create another column that shows
the "Week Beginning..." for each of the...
Forum: Setting Up & Running Reports July 10th, 2006, 06:38 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 46
Posted By jubu
Report linked to subform in a subform

Thank you - that is exactly what I needed! Worked great!
--
jubu


"Allen Browne" wrote:

The tab control is not part of the reference, but you need to include the
".Form" bit to refer to the...
Forum: Setting Up & Running Reports July 7th, 2006, 09:09 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 46
Posted By jubu
Report linked to subform in a subform

I have an Access 2003 database with several tables: tblCustomers stores
customer information with primary key the CustomerID field. This is linked
to tblEnrollments in a one-many relationship,...
Showing results 1 to 22 of 22

 
Forum Jump

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