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.32 seconds.
Search: Posts made by: Kc-Mass
Forum: Running & Setting Up Queries June 3rd, 2010, 03:53 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 462
Posted By Kc-Mass
Multiple Queries to Multiple Reports

Hi

Two options:

If you want to produce a report for a single year look in help file for
"Parameter Query". A parameter query will prompt for the year you are
interested in. (you'll only need one...
Forum: General Discussion May 25th, 2010, 12:16 AM Posted to microsoft.public.access
Replies: 4
Views: 2,072
Posted By Kc-Mass
Deleting records from a table

You could copy your table (structure only) to a new table; set a compound
index on street address, city, state and zip with no duplicates allowed.
Then simply append your records to the new table. ...
Forum: Running & Setting Up Queries May 23rd, 2010, 11:48 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 335
Posted By Kc-Mass
Search Tables

Look here - this will do it:
http://www.rogersaccesslibrary.com/forum/topic12&OB=ASC.html

Look for: DH (DuaneHookom) QBF.


Regards

Kevin
Forum: Running & Setting Up Queries May 13th, 2010, 01:21 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 165
Posted By Kc-Mass
Problem with query

Thanks John

I'll try That

Kevin


"John Spencer" wrote in message
...
Easiest way is to add two hidden controls to your form and...
Forum: Running & Setting Up Queries May 12th, 2010, 09:07 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 165
Posted By Kc-Mass
Problem with query

I have not seen anything like this before but:

1. I am querying a table with completed invoices to get those from a
selected fiscal period. The period (quarter) is selected from a combobox....
Forum: General Discussion May 7th, 2010, 04:32 PM Posted to microsoft.public.access
Replies: 2
Views: 191
Posted By Kc-Mass
Set Control source at runtime

Assuming that OrgName is in the same table try:
Me.txtNAME.ControlSource = "OrgName"

Regards

Kevin


"SAC" wrote in message
...
Forum: General Discussion April 28th, 2010, 03:54 AM Posted to microsoft.public.access
Replies: 4
Views: 96
Posted By Kc-Mass
Dump Table info into excel

Hi Dave,

Try the code below

Regards

Kevin

Sub TableAndFieldList()
Dim lngTable As Long
Forum: General Discussion April 27th, 2010, 04:40 PM Posted to microsoft.public.access
Replies: 3
Views: 74
Posted By Kc-Mass
Finding unprintable characters in data

You look for CHR(13) and CHR(10) with instr() function to
find and left, right and mid functions to remove.

Regards

Kevin


"Nich" wrote in message...
Forum: Running & Setting Up Queries April 26th, 2010, 11:39 AM Posted to microsoft.public.access.queries
Replies: 3
Views: 235
Posted By Kc-Mass
Combining Duplicates in Select qry

In the query design panel menu select "View", "Totals"
Then in the fields set PartNumber to "Group on" and set Qty to "Sum"

Regards

Kevin


"Jack Leach" dymondjack at hot mail dot com wrote in...
Forum: Using Forms April 23rd, 2010, 03:37 AM Posted to microsoft.public.access.forms
Replies: 3
Views: 153
Posted By Kc-Mass
Tab sequencing not working

Add to the code that does the calculating and makes another control visible
a line like this:

Forms!YourForm!txtYour3rdControl.SetFocus
RegardsKevin
"JWCrosby" ...
Forum: Running & Setting Up Queries April 21st, 2010, 12:55 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 70
Posted By Kc-Mass
I want year in one table to be less or equal year in another table

Try something like this substituting your table and field names.

SELECT tblTreatments.DateTreated, Year([DatePresent]) AS YearSpeciesPresent,
tblSpecies.Species
FROM tblTreatments INNER JOIN...
Forum: General Discussion April 17th, 2010, 04:39 PM Posted to microsoft.public.access
Replies: 3
Views: 159
Posted By Kc-Mass
Updatable Calander

If they are all coming up as write protected it is likely that you are
trying to open the dbs from the Zip file. You need to extract them from the
zip file and then open them with...
Forum: Using Forms April 12th, 2010, 12:19 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 71
Posted By Kc-Mass
Form Field/Function problem

Place a procedure like this air code in each of the three text boxes that
you total.

Private Sub txtOne_AfterUpdate()
Dim lngYellow As Long
Dim lngWhite As Long
lngYellow = RGB(255,...
Forum: Running & Setting Up Queries April 10th, 2010, 03:55 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 97
Posted By Kc-Mass
DSum doesn't work on other PCs

Hi,

You'll want to load the text of the query and describe the tables involved
to the group.

You should also check the update status of your various Access
installations.

Look for the version...
Forum: General Discussion April 6th, 2010, 01:04 AM Posted to microsoft.public.access
Replies: 1
Views: 80
Posted By Kc-Mass
Importing Spreadsheets dropping five rows

Hi,

I have a most perplexing problem. When I Import a spreadsheet I am getting
all but 5 rows.

If I add a column of psuedo row number for debugging, all the records come
in.

Plain old...
Forum: Running & Setting Up Queries April 1st, 2010, 02:44 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 93
Posted By Kc-Mass
Subtracting Value from Field if Yes/No = Yes

Silly question but I have often wondered about this - What is an OP?

Thanks

Kevin
"Stefan Hoffmann" wrote in message
...
ho...
Forum: General Discussion March 31st, 2010, 04:45 AM Posted to microsoft.public.access
Replies: 11
Views: 98
Posted By Kc-Mass
Calculating an Average

Hi Nona,

So what you want is the average of each payment lag for each contract, for
each month.

So change what I said before to add a grouping for the Month. Something
like:

From the toolbar...
Forum: Using Forms March 30th, 2010, 04:40 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 82
Posted By Kc-Mass
Problem with form opening From List Box

Problem solved but thanks.

"kc-mass" connearney_AT_comcast_DOT_net wrote in message
...
Hi,

I have a form with a list box that lets me assign...
Forum: Running & Setting Up Queries March 30th, 2010, 04:29 AM Posted to microsoft.public.access.queries
Replies: 3
Views: 98
Posted By Kc-Mass
Find Duplicate Records in two tables

This will show you who did not get a gift card but Paid Tax. Fix the table
names to suit.

SELECT tblNoGiftCard.Name, tblTaxPaid.Name
FROM tblTaxPaid INNER JOIN tblNoGiftCard ON tblTaxPaid.Name =...
Forum: Using Forms March 29th, 2010, 04:45 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 82
Posted By Kc-Mass
Problem with form opening From List Box

I solved the "Method of Object Problem - bad reference to Form et al.

The problem now (I Think) is that the Record source is not being updated
with the SQL
and is thus returning the wrong customer....
Forum: Using Forms March 29th, 2010, 04:08 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 82
Posted By Kc-Mass
Problem with form opening From List Box

Hi,

I have a form with a list box that lets me assign companies to employees.
Some employees get a full assignment (100% of value derived) and some get a
partial(55%, etc). When the user double...
Forum: General Discussion March 28th, 2010, 03:28 AM Posted to microsoft.public.access
Replies: 4
Views: 80
Posted By Kc-Mass
Compact and Repair Database?

This question should really go to David Fenton who has very strong opinions
on access compact and repair.

Essentially don't do it.

Regards

Kevin
Forum: General Discussion March 28th, 2010, 03:19 AM Posted to microsoft.public.access
Replies: 11
Views: 98
Posted By Kc-Mass
Calculating an Average

Not quite clear but lets suppose you want to get the average days between
billing date and payment date for each contract. You already have the
daysBetween for each contract transaction by...
Forum: Using Forms March 26th, 2010, 11:38 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 67
Posted By Kc-Mass
Functions not working

Open a module (Cntrl G) in your db. In the tools menu select "References"
You will likely find that one of the checked references has the word
"Missing"
placed in front of it. Make note of the...
Forum: Using Forms March 25th, 2010, 05:59 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 67
Posted By Kc-Mass
Functions not working

Open a module (Cntrl G) in your db. In the tools menu select "References"
You will likely find that one of the checked references has the word
"Missing"
placed in front of it. Make note of the...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 09:53 AM.


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