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 52
Search took 0.88 seconds.
Search: Posts made by: tighe
Forum: General Discussion June 3rd, 2010, 09:19 PM Posted to microsoft.public.access
Replies: 1
Views: 311
Posted By tighe
2003: Referencing Object On Subreport

me.[subViolations].Report![lblReportHeader].caption="Compliant"

"(PeteCresswell)" wrote:

I've Googled this and *think* I'm doing the right thing, but
no-go.

Report A has subreport object...
Forum: General Discussion June 3rd, 2010, 09:07 PM Posted to microsoft.public.access
Replies: 9
Views: 617
Posted By tighe
Only change font fomat in select words within a memo field

Garvic,

make sure the text box, on the form has Text Format set to Rich Text(data
tab of properties), as well as the table's memo field is rich text.

other than that there shouldn't be much to do...
Forum: New Users June 3rd, 2010, 08:58 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 2,067
Posted By tighe
macro help

mick.

i have to admit i dont use the where condition(it might be where the quotes
are) but you could handle this On Load of the "customers input form" with vba:

Sub Form_Load()
If IsLoaded("[order...
Forum: General Discussion June 3rd, 2010, 02:43 PM Posted to microsoft.public.access
Replies: 1
Views: 545
Posted By tighe
Custom Menu Bar in Access 2007

i belive this site http://www.accessribbon.de/en/index.php? will help with
what you are looking to do.

"Abdul Shakeel" wrote:

How do I create custom menu bar (not Shortcut menu) in access...
Forum: Using Forms June 2nd, 2010, 05:54 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 646
Posted By tighe
Combo Box Adding Button to edit list items

i believe it best to requery the combo box on the close event of the form
the user adds the contact to.

Sub Form_Close()
Forms![Form_name]![Combo1].Requery
End Sub

"JB10" wrote:

I have a form...
Forum: New Users June 2nd, 2010, 05:42 PM Posted to microsoft.public.access.gettingstarted
Replies: 1
Views: 1,795
Posted By tighe
Ribbon

first make sure you have an onLoad="OnRibbonLoad" to start for your ribbon
item.

customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
onLoad="OnRibbonLoad"

the vba:
Public...
Forum: Database Design June 1st, 2010, 03:19 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 1,765
Posted By tighe
2 Designers

thanks for the responses.

"Piet Linden" wrote:

On May 27, 4:00 pm, tighe wrote:
All,

how would you handle having two persons who work on
...
Forum: Running & Setting Up Queries May 27th, 2010, 10:17 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 485
Posted By tighe
Retrieve all record if check box = 0 (Not checked)

Silvio if i am understanding you:
1. the form should have all records.
2. on a form you have an unbound check box where if you check it, only -1
records appear, otherwise all records are...
Forum: Database Design May 27th, 2010, 10:00 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 1,765
Posted By tighe
2 Designers

All,

how would you handle having two persons who work on
creating/designing/editing a DB?

TIA

FYI I'm not in this situation but just in case.
Forum: Database Design May 10th, 2010, 03:11 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 311
Posted By tighe
"need good structure..." followup

Karl,

Financial Period, is technically one calendar month, but the tracking may
occur before, during, or after that period. we also may be working on
multiple periods for a certain client as...
Forum: Database Design May 5th, 2010, 02:28 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 311
Posted By tighe
"need good structure..." followup

hope i explain this well. i have a similar setup, as below, but for the
"MachineCounter" table i have a finacial period. this period is essentially
a month, but items can come be in/out in the...
Forum: Database Design May 4th, 2010, 11:02 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 270
Posted By tighe
#Name?

Karl,
thanks for the response, the #name? was appearing becasue of the
non-existence of [B].

i ended up adding a parameter to the crosstab queury, more than likely [B]
will exist for the whole...
Forum: Database Design May 4th, 2010, 08:36 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 270
Posted By tighe
#Name?

i have a form based on a crosstab query that sums on threee possible types
A, B or C. on the form the field for B shows #Name?, if B does not exist.
this is ok but i need it to show 0, any...
Forum: Database Design May 3rd, 2010, 10:36 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 333
Posted By tighe
need good database structure for tracking counter state

Peter,

hope i explain this well. i have a similar setup but for the
"MachineCounter" table i have a finacial period. this period is essentially
a month, but items can come be in/out in the...
Forum: Running & Setting Up Queries March 10th, 2010, 07:21 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 174
Posted By tighe
12 Month Running Total

Karl,

the datatype of Financial_Month is date but the queries i have the dates are
in format "yyyymm", i dont really need to select
Firm_Employee_Count_time.Financial_Month.

useing the alias...
Forum: Running & Setting Up Queries March 8th, 2010, 11:16 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 174
Posted By tighe
12 Month Running Total

All,

thanks for the advice to get me this far. previously i had asked about a 12
month rolling total, below is the SQl but for Decembers the total is wrong,
can anyone suggest a...
Forum: New Users February 18th, 2010, 05:28 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 150
Posted By tighe
Open mode

gina,

As a side note, although i am sure there are work arounds, but having the FE
on Vista is problematic. I ended up putting the FE on a shared drive, which
also gives me access to the folder...
Forum: Database Design February 3rd, 2010, 04:18 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 131
Posted By tighe
Query Confirmations still opening

all,

i figure my solution is to turn off warnings, but i wondered if any knew why
query confirmations are still happening when the user says the "confirm" in
Editing Advanced Options are...
Forum: Running & Setting Up Queries February 3rd, 2010, 04:15 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 116
Posted By tighe
sum for past tweleve months

overall i guess my best solution is running sum buit i cant get the right
results, for each period no less adding in a 12 month constraint.

Jeff:right but i guess my problem is i dont know how to...
Forum: Running & Setting Up Queries February 2nd, 2010, 10:42 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 116
Posted By tighe
sum for past tweleve months

jeff maybe i am misunderstanding, but i dont need the sum from the last
twleve months. i need a sum from 12 months prior to an OccurDate, if
OccurDate=200809 sum is all hirings and firings from...
Forum: Running & Setting Up Queries February 2nd, 2010, 08:25 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 116
Posted By tighe
sum for past tweleve months

i feel a little retarded i can’t pull the available information together to
get the result i need. i have looked at
http://support.microsoft.com/kb/208714 and a number of other posts, but i...
Forum: Mailmerge January 28th, 2010, 06:25 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 2
Views: 132
Posted By tighe
excel merege Confirmation Dialog

Peter,
perfect went with the "SQLStatement," this is great since users never know
what is going on.

"Peter Jamieson" wrote:

1. I guess you have already taken account of the registry change
...
Forum: Running & Setting Up Queries January 27th, 2010, 11:01 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 85
Posted By tighe
Count Number Of Employees for Month and Year historically

dorian,

thank you, but unless i am missing something for each month, i would have to
evaluate and requery to get my answer. i was hoping for answers like:
month/year:06/2007=5,...
Forum: Running & Setting Up Queries January 27th, 2010, 08:06 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 85
Posted By tighe
Count Number Of Employees for Month and Year historically

how i would i get the number of employees for each month and year that we
have data for?

my fields are :
Representative_Name
Approval_Date
Termination_Date

my data goes back to 06/2007. i can...
Forum: Mailmerge January 27th, 2010, 03:29 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 2
Views: 132
Posted By tighe
excel merege Confirmation Dialog

All,

Whenever I run an automated merge with excel as the data source a dialog box
appears and the user has to confirm the data source. How can I avoid this?

Set objWord =...
Showing results 1 to 25 of 52

 
Forum Jump

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