Hiding records on reports by checkbox on form
Hi, I'm in the proccess of buliding a new database. Its purpose is to store
various organisation contact details and then to produce reports based on
this that can be printed onto sticky labels. This much or basically finished.
However, we naturally don't want to print the whole database every time, so
I'm using a checkbox on the interface form that will filter the report so
that only checked records are prepared for printing. Can anyone tell what
code I need to use to do this, and where? I've tried various methods, but
nothing seems to work. I'm using accesss 2003 by the w...Make a pivot table from an existing pivot table
I'm trying to make a completely new pivot table out of an existing
pivot table where the existing table is actually the source data (not
the original data table). The problem I have is that this intermediate
pivot table has 3 columns of unique values (with over 1000 rows) before
we get to the data. I can't just copy it and make a pivot table, or
create a mirror sheet that isn't a pivot table because of the blank
cells underneath each change in value.
I have this:
Source Name Attempts Data
Mail Joe 1 654
...PDF Table to Excel Spreadsheet
This has been asked in numerous places all over the web but I have not
found a workable solution. We have a mainframe system that generates
PDF reports for billing. However, few people in our organization
these days speak mainframe. We need Excel to do calculations on the
data. I began working on a method for converting using UEdit Macros
and an Excel macro because the fields are fixed-width. My attempts
have been unsuccessful.
Here is what I want to accomplish:
-Copy a region of text from a PDF
-Paste into Excel
-Break the values out into the appropriate cells.
http://www.google.com/sea...How can I access a public calendar from a custom form
I am trying to create a custom form that would allow a
employee to request a vactation time frame. This form
would then be mailed to a supervisor who could approve or
disapprove the request. I am having difficulty getting
the response posted to a public calendar vs. the managers
private calendar. Help! -Jeff
...Best way to design tables for cascading on my form
My company inspects damaged cars for insurance purposes. Up to now,
(relating to this issue) I've had tblDamageArea populate a list box on my
form where the user can select the various parts of the car that were
damaged. I've had this list include parts for multiple kinds of cars and I'd
like to make this list cascade to include only those parts relevant to the
car type inspected.
I've created a tblVehType to separate Sedan, Coupe, 4DoorTruck, SUV, etc.
which populates a cbo on my form where the user will select the type which
will then be used as the crite...Missing something basic
Working with Access 2003. I have a table of users, their phone numbers, and
job classes called tblUsers. A query extracts that information into
qryUsers. I have a form that uses the query as the record source called
frmUsers. The form only contains a single combobox so someone can select the
user for which they wish to view data in other forms. It works fine for the
first user on the list in the combobox. Selecting any other user in the
combobox causes the first record in the table to change to that user's name.
The table and the query both contain:
...disable MDI window list menu
I created a MDI application. When I create a new child window, it
automatically adds window name to the 'Window' menu, i.e., it adds 'Doc1',
How do I make it NOT do that? Thanks.
You can change the default name of your documents (in the string table) or
you could remove the Window menu from the top menu, or, I think, you can
just hook into OnInitMenuPopup() for the mainframe and remove the entries
starting with AFX_IDM_FIRST_MDICHILD.
This article might help you get started. In this one they remove all those
items and replace them with a popup...Summing cells in pivot tables
I have a problem summing cells in a pivot table. When I double-click on a
cell that I want to add, the formula from that cell gets added. Eventually I
run out of characters. Is there a way to switch how the cell gets picked up.
I can manually enter the cell addresses that I am trying to sum but that
takes forever. Thanks,
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:
> I have a problem summing cells in a pivot table. When I double-cli...Forms and Reports from CrossTab queries
I have read a few postings in this area, but they all seem to be very
specific to particular situations. Can someone please guide me towards the
best solution to my dilema?
I have a form with two list boxes which contain many variables (answers to
specific questions from a survey). When two different questions are slected I
run a cross tab query resulting in a dymanic result of rows and columns based
on the selections.
I now want to display the result as a datasheet on my form and in a similar
fashion as a report.
Any help is, of course, greatly appreciated.
John D...Hiding a field from a sub form.
I know that this looks easy (and it probably is) but this is what I need to do.
I have this code that I can hide a field within the same form
' NI.Visible = Not NB
And this works just fine.
what I would like to do is Hide a Field from a Sub Form and I am hitting a
I tried this, so please tell me where I am brain dead.
frmDateEntry!product.visible = not NB
Thanks in advance,
Learn Today, Teach Tomorrow
Great Success is ones ability to ask for Help.
On Fri, 18 May 2007 14:50:00 -0700, TheNovice
>I know tha...Exporting distribution lists
Is thee any way to export distribution lists into
something like a spreadsheet?
Which version of Exchange are you using? In 5.5 it is easy to do. 200x is
not as easy, but doable.
"Elbryyan" <firstname.lastname@example.org> wrote in message
> Is thee any way to export distribution lists into
> something like a spreadsheet?
Do you keep all of your DGs in one OU? If so you can easily use LDIFDE or
"Elbryyan" <email@example.com> wrote in message
news:483201c4a09c$dd0a524...new to making forms on access
I have a table whihc has column name title and some survey question.
Now i want to create a form so that when i select Name ( I guess this will
be combo box) I dont know how to do that even where i can select name ? but
when i select name the person title auto populates and so does the relevant
answers to the questions
for example i choose John and the title should auto populate and question 1
should populate also and so on but if i pick adam then everything related to
Your help will be really appreciated
The table look like this
Name Title Qu...is it possible to have datasheet smart tags appear in a form?
is it possible to have datasheet smart tags appear in a form?
...Publish Form Changes without restarting IIS?
Is there another way to publish form changes without restarting IIS? We
run a 24x7 IT shop and taking down a production system for every change
is a pain.
Presumably as you are 24/7 you have multiple CRM servers, so you only need
to IISRESET one CRM server at a time, thus users will not notice any loss of
"BWIT" <firstname.lastname@example.org> wrote in message
> Is there another way to publish form changes without restarting IIS? We
> run a 24x7 IT shop and taking down a production system for every chang...Import Adobe Form into Access for Report
I am trying to import a PDF into Access to use as a report and populate the
fields with a query I have created. I can not find any help in getting this
Can someone help me?
...batch importing of mailing lists to Excel
I've got a mailing list of around 1000 names, stored in both Word and
Entourage like this: First Name Last Name <e-mail address>
Once I’ve eliminated the < >, do I then have to individually copy & paste
(or type) all the info in three Excel columns? Or is there a simpler solution
for batch importing of mailing lists to the Excel spreadsheet?
> I've got a mailing list of around 1000 names, stored in both Word and
> Entourage like this: First Name Last Name <e-mail address>
> Once I’ve eliminated the < >, do I then ...table manipulation
my db has a single table, Table1. Table1 is as follows:
rows are not unique; i.e. I can have more than 1 row with the same author.
What would be the SQL code to generate a table2 with the following
where every author now has only 1 row and titles and publishers for
author are appended to the right as as may fields as necessary?
> Hi all
> my db has a single table, Table1. Table1 is as follows:
> rows are not unique; i.e....Create field from append query based on linked table name
Here's the setup:
Two linked tables called 'PHD' and 'XANS' bring in daily data from two
A union table-query puts the common data in both into the same name
fields. This table-query is called 'SOLS_DATA_MERGE'. I then created a
new table called 'SOLS_MAIN' and I ran an append query called
'SOLS_DATA_APPEND' to append the data in the table-query,
'SOLS_DATA_MERGE' into the new table, 'SOLS_MAIN'. The main reason for
this was so that I could assign my data a primary key.
Even though I have achieved my goal of merging the da...Why won't contacts list out in address book
When I open my address book or select the To: or CC: options, my contacts are
not listed out. I performed the steps at the below link. The address book
appears to be linked to the contact folder since the address book shows the
correct contact file in the very top and will search from it, but why aren't
the contacts listed for easier selection like I've seen before? Thanks..
To give further info, I am running Outlook 2007 and the only message in
either the global address list or my sp...Making cell change colour
I want to make a cell change colour 'on click'.
Is there any way that this is possible?
Help would be appreciated,
Message posted from http://www.ExcelForum.com/
this would require VBA / using an event procedure like
Selection_change. Do you want to go this way?
> Hi all
> I want to make a cell change colour 'on click'.
> Is there any way that this is possible?
> Help would be appreciated,
> Many thank
> Message posted f...It's twins!!! Two sets of personal folders!!
I had to re-install outlook and reloaded my .pst file. My
inbox got all the mail back but my contacts didnt come
back. I imported the pst file and now i have double!! It
wont let me get rid of either. What do I do now??
...Distribution List Limits
Hi, I could find an answer to this for Outlook 2002 but not for Outlook
2003. Is the answer the same? We are using SBS 2003. The error is:
"The distribution list has reached the maximum size for your network e-mail
server. The new member could not be added."
List was at 132 members.
Not an Outlook question. These limits are set by the server, not Outlook. If
your sever hasn't changed, then I imagine the limit is still the same.
"Paddy Ryan" <email@example.com> wrote in message
...Custom Roll up and Drill down calculation for Excel Pivot table
Greetings to all -
I am currently struggling with a method to apply a custom rollup
function for an Excel pivot table. I am trying to calculate a sell
through % which is calculated as Sales $/(Sales $ + Ending Inv $). I
want to be able to calculate this % at the weekly, monthly, and yearly
level. I can successfully add a calculated field which works
perfectly when the user has WEEK on the pivot table. However, if the
user wishes to remove week and see the Sell Thru % at the Monthly
level, then Excel naturally sums the Sell Thru % for each week in the
month. This is not an accurat...List Box Change Event
I have a list box and have the following code in the worksheet module:
Private Sub MyListBox_Change()
My list box is called MyListBox but when I select it nothing happens. All I
want is to go to another sheet after the change occurs.
The only thing I can think is the name of my list box is incorrect but it
does show as MyListBox in the cell name drop down but it doesnt appear in the
defined names. Using 2003.
Can anyone see what I am doing wrong?
Thanks in advance
What sort of ListBox is it, from the Forms to...Make input in one column determine dropdown list in another.
Is there any way I can make the info thats input in one column (selected by
dropdown list) determine which (one of several) dropdown list is used in
Use a list formula of the type
where E1 is the first DD.
(remove nothere from the email address if mailing direct)
"gettin-older" <firstname.lastname@example.org> wrote in message
> Is there any way I can make the info thats input in one column (selected