|
how microsoft office use in our organization?
haha , this is my assignment , pls help me to find out the contents
....muackkss!
minimum 300 words!thx ya ...
|
1 |
07.09.2006 06:43:01 |
|
|
Toggle OLE Object Visible based on query results
I have a report that uses an OLE object mapped to a word document that
I would like visible or not visible based on the results of a query, I
have the following code but it does not work. Basically I just want the
OLE object to be visible if the the quoteid matches the quoteid field
on the form quotes and the unit title contains *windows*server*
Function HideSBSDocument()
Dim strQueryName ...
|
2 |
07.09.2006 06:36:29 |
|
|
Grouping Controls
Hi,
I want to move a group of conntrols programmatically.
Is there a way to group controls in a frame, name the frame, and then
manipulate the frame's Top and Left properties depending on a condition?
I looked at Format Group command, but I'm not sure if grouping does what I
need.
Thanks.
Alan
...
|
1 |
07.09.2006 05:53:54 |
|
|
Word Merge SQL syntax
I'm using Albert Kallal's Word Merge sample and managed to change the
recordsource to a query instead of picking up the controls from the open form.
The merge will be run from a cmd button on the case form (frmCase1) and I
need to specify a WHERE statement so it prints only the records associated
with the current CaseID. The textbox to be referenced is txtCaseID, field is
CaseID. How ...
|
2 |
06.09.2006 22:39:02 |
|
|
If 3 check boxes are checked =1
How would I go about writing an IF statement for this...I have 3 check boxes
on a report, if all 3 boxes are checked per record I need it to equal 1. How
would I write the If statement in unbound text box for that? CB1,CB2 and CB3
are all checked then the value equals 1.
Thanks...
|
3 |
06.09.2006 20:46:02 |
|
|
Null Records in Reports
I have a table with the field "desired_price_range" which holds numbers from
a drop down menu - ex: 201-250; 251-300. However, some of the records input
have left this field blank. When writing a report and grouping by price
range I receive the records with no price range at the top which is fine. Is
there a way to give the Null value a name for the report like "undecided"?
So the re...
|
4 |
06.09.2006 20:31:47 |
|
|
user select record to be printed
Good afternoon,
I have a continuous form which lists all the record in a table (list of
customers). I have added a checkbox so that a user can select/deselect which
records need to be used to generate a fax.
1- I want to have a cmd button which will select all the check boxes. How
can this be done?
2- How would I then run through the selected records to generate the fax?
Thank ...
|
2 |
06.09.2006 18:01:02 |
|
|
Age calculations work for some, not all dates
I am trying to show current ages on a report. I've tried two different
formulas, and on each the ages show up as years such as 1915, 1920, etc. The
funny thing is that both formulas work fine in other reports in the same
database...just not this one. I've even tried to copy and paste each from a
report that works, still no luck. The formulas I've tried are:
=DateDiff("yyyy",[DOB],Now...
|
4 |
06.09.2006 17:23:01 |
|
|
Number of Pages
Good morning,
i have a report that uses a table to generate a series of Fax (1 per record
within the table). Each fax can vary in length (1-3 pages each) based on
certain criteria.
When I insert the '[PAGES]' it gives me the total number of pages for all
the faxes tabulated together. How can I get the total number of pages for
each individual fax?
I hope I explained this suffici...
|
2 |
06.09.2006 16:26:34 |
|
|
Grouping without a primary key
I have a table that contains events, a type or diary if you will. There is
not a primary key for this table, but I have indicated that the field,
EventDate, be indexed and allow duplicates.
How do I group by the event date in a report? Also, will this automatically
sort on the date or do I need to do something for that to happen?
Thanks,
Les...
|
2 |
06.09.2006 16:05:37 |
|
|
Printing with memo fields
I have a table that is basically a diary. The EventDesc (memo field) is the
field in question. The format I have laid out is to have fields like "Date
of Event", "Subject", "Category", etc., print on the same line. Then I have
the EventDesc print underneath it.
The problem comes about when I have expanded the memo field to a particular
given size, say one that will display 10 lines a...
|
3 |
06.09.2006 15:20:02 |
|
|
Printing Date Range on Reports
I have a report that is generated by the user entering a date range into a
form, presses an apply button which run a macro awhcih runs all the queries
etc. The reports generates fine however I want to add the date range the user
selected to the report. I have done this in two seperate text boxes, the
first labled " Start Date" the second "End Date.
I have set the control for the Start Date ...
|
4 |
06.09.2006 15:10:07 |
|
|
How to Select Area Chart Legend Color Selection?
I am using Access 2000, 2002 and 2003. Currently the database will work on
on 3 versions.
I have an application where I generated two area charts (placed on landscape
8.5x11). The two area charts should contain the same data (but not always),
I wanted a way to specify the color of each of the layers to be the same
between the two independent area charts. Is where a way to do this?? ...
|
1 |
06.09.2006 15:03:02 |
|
|
Sort Sum in Footer Section
How do I sort the Sum in my footer section in Descending Order?...
|
2 |
06.09.2006 14:54:52 |
|
|
Subreport Totals
My report looks like this:
(main report)
1st month Purchased 2nd month Purchased 3rd month Purchased
20 30 50
---------------------------------------------------------------------------------
(subreport)
5 sales 4 sales
8 sales
--------------------------------...
|
2 |
06.09.2006 14:28:01 |
|
|
"The wizard is unable to create your report"
When I try to "Create report by using wizard", above subject error appears in
the Report Wizard dialog box. If I try to "Create report in Design view", I
don't get any response.
I have the database in "Open Exclusive" and am able to create forms, queries
and tables....
|
2 |
06.09.2006 11:32:44 |
|
|
Help with masking number
I have a report that I need to have it show and print a number that starts
with
a "0". The number is 064278 I trred to use a mask with "999999" but it did
not
word. Any Ideas.
...
|
2 |
06.09.2006 10:48:50 |
|
|
Cannot reference a report field value in a subreport from subreport
Here are the details:
Report Name = rptStatement
SubReport Name = rptStatementDetail
SubReport Control Name = sbrStatementDetail
SubReport recordsource = "qryStatementDetail"
Field in this recordsource to inspect = intSalaryPercent
I want to hide various text boxes on the subreport depending on a value
of a field in the subreport's recordsource with code put in the
SubReport's GroupF...
|
1 |
06.09.2006 09:10:42 |
|
|
alter table in access code
How can I issue an "alter table" command in a code in Access 97 ? THanks.
...
|
3 |
06.09.2006 06:46:26 |
|
|
Report by month
I have some reports I need to run on monthly activities. Until now I've had
the parameters in the Date field in my query "Between [First Date] and
[Second Date]".
Is there a better way of selecting date parameters?
Specifically, is there a way to simply specify a previous month and also
current month to date?...
|
2 |
06.09.2006 04:28:49 |
|
|
Bar chart values in middle of bar
Hello,
I have a bar graph showing the values on top of the bar, but I want the
values to show up in the middle of the bar. How do I do that? Thank you in
advance.
...
|
1 |
06.09.2006 04:14:02 |
|
|
Report Hangs
Using Access 2002. Every user can preview the report except for one. I log
into the system using her name and password and it works fine. But for her,
the report gets to "Formatting Page Press Ctrl Break to stop" and hangs
there. The "Layout For Print" property is set to NO. She was able to view
the report up until a week ago. She tells me that is when the IT group
"moved her". I tho...
|
1 |
06.09.2006 04:11:10 |
|
|
How do I count individual records in the Detailed section of a Rep
Hi: I’m working on an Access report. I have a table that has records that
list:
Year, Term, Class, Department, Section and each grade given in each class
section. My report should summarize each class section. This summary should
have: Number of students in the class. Here I use Count(*) which gives me
the correct number of students in the class.
But I’m also trying to get th...
|
9 |
06.09.2006 03:55:02 |
|
|
Specification of multiple link criteria
I am having a problem. From a selection from, I display a list of records
that meet one link field. From the shown list I would like to select a record
but this record can only be selected by using two link-criteria [ID_CSS] and
[ID-Lid]. How do I specify this correctly in the stLinkCriteria field?
Thanks for helping me out. in the Dutch forum nobody answered me.
Ron...
|
9 |
06.09.2006 01:29:21 |
|
|
Current method for returning a SQL value
I'm working on a form in which the value of a text box will be the sole
value returned by a QUERY string on a table in the same access database. The
query uses information from another text box as search criteria.
I've found that I can't use a SELECT string as a ControlSource value for the
Text box, so I'm going with VBA code.
No problem writing the SELECT string. Just need someone to qui...
|
2 |
05.09.2006 23:01:42 |