Can't get the proper display of a field in my report.
I have 2 tables, both using autonumbers for their primary key. The first
table is for contacts (i.e. last name, first name, etc.). The second table
is for businesses (business name, etc.) I have a field in my contacts table
that has a number format so it can be used as a foreign key for the business
table. I then set up the relationship between them & enforced referential
integrity. When I run a query, I see the name of the business (after setting
up a combo box) - no problem. When I run a report based on that query, a
number is displayed (not the business name).
Suggestions, pleas...String Table (VC6 IDE)
I have strings in English language in the "String Table" of my project
(myProject.rc). I'm loading them using:
Now, I need to internationalise my app. How can I do that? How can I add
support for multiple languages? Which is the best way to do that?
>I have strings in English language in the "String Table" of my project
>(myProject.rc). I'm loading them using:
>Now, I need to internationalise my app. How can I do that? How can I add
>support for multiple lang...Controlling printed records when report bound to multiple tables
I created a report that uses the control from a form to generate a report
based on that record's primary key. This form also has a subform which has
relationships tied to the primary key for record identification and is linked
to the main table. When preview the report the data from the subform either
does not show up in the preview when using the filter
[control]=[form]![control].[value] or makes multiple copies of the report
equal to the number of entries in the subform's table.
Is there any way around this? I have tried queries but have not found a way
to use a f...Report: "You have no transactions for the item you selected."
I've run into a glitch I can't figure out. I'm working with the Monthly
income and expenses report. There are amounts listed under the Income -
Unassigned category. When I double-click the category to see the
transactions, I get the message in the Subject. I did a split-half search
to find the supposed account that it registering the amount, but cannot find
any transactions that are in error.
I tried a Standard Repair without any change.
I should add that this is Money 2007.
"Robert Berus" <email@example.com> wrote in message
news:OFn...To have a selection of year to merge
In my Form there is a commandkey to merge to the All records and below is
the VBA, my question is how can we make it like a combo box to chose the
year, because the user is not a programmer, and is not able to open it in
design view and change the VBA.
Private Sub cmdMergeAll_Click()
MergeAllWord ("select * from PelayanJemaat Where TahunPel=2008")
'Note that you could use a condtion in the above sql
Thanks in advance for any help provided.
H. Frank Situmorang
Put a control on your form where the user can enter the date. For exa...pivot table %
I have 2 columns in a pivot table - decription and
amount. I need to calc a % of each value of the total.
I don't know how to do that.
...Enable Canadian Tax Detail option should update cost on receipt la
Would like the Enable Canadian Tax Detail option in the Company Setup Options
window to work like how Landed Costs work. For example, if I select to post
my tax detail to the Inventory account, I would like it to not only update my
Inventory account in the General Ledger, but also to update the cost on the
Receipt Layer in Inventory so when the Item is sold, it will sell at the Item
Unit Cost plus the tax amount. The voucher created in Payables Management
would just include the Item Cost without the tax amount.
This post is a suggestion for Microsoft, and Microsoft re...With a Query in Access 2007, How can I Create This Query
I need a query that will list all records in table 1 for which there are no
auditor records (Table 3). Somehow, I need to use the relationship between
tables 2 and 3 to find what's not in table 1. The following query gives me a
list of all records that do have auditor records. I'm at a dead end on this
AuditDet...Exchange 2003 Content Filtering
Is there a way, through Exchng 2003, to block e-mails that contain certain
words like "viagra" etc.
If so, where abouts do you do it?
Any help appreciated
Grab the IMF (intelligent message filter).
"Mark Griffiths" <firstname.lastname@example.org> wrote in message
> Hi All,
> Is there a way, through Exchng 2003, to block e-mails that contain
> certain words like &quo...Can't send e-mails from Outlook 2003 after SP1
After installing service pack SP1 for Office 2003, I
can't send e-mails anymore. They are stuck in the outbox
folder. The error message states that the connection to
the server was interrupted. I did not change any settings
and checking them confirms that everything is as it
should be. Did anyone else experience the same issue and
how did you resolve it?
Thanks for your help
See if you can manually move those messages from your Outbox and then check
all your settings again.
"Mattliusa" <email@example.com> wrote in message
news:cb7401c48a5...Can Line Chart Overlaps be Highlighted?
Can the overlap portion(s) of two lines in a chart be shown in a different
color, without having to manually draw a shape? I would like to show the
areas where Line A is above Line B as red, and the areas where it crosses
below in blue - is it possible to do this without manually drawing in shapes?
To some extent it depends how many times the lines cross. If it's just the
once then you can use area charts to provide the shading.
This may help if the used one line as a base line...no change pivot item.
i want to can not change pivotitems in the pivotfields.
namely pivotitems restircted.
How can I do in VBA?
*** Sent via Developersdex http://www.developersdex.com ***
...Case select returning error when cell contains #N/A : how must i avoid this error
Title says it all
maybe this will do what you want
If Not IsError(Range("C1").Value) Then
Select Case Range("C1").Value
"Luc" <firstname.lastname@example.org> wrote in message
> Title says it all
Thanks for your help !!!!!
"Gary Keramidas" <GKeramidasAtMSN.com> schreef in berich...Conversion Errors Table
I'm new to working with Access, I just converted an Access 97 databas
into Access 2002. It tells me there were errors, and to look at th
Conversion Errors Table. But nowhere in the message or in the MS Hel
is there anything telling me where to find this table. Can someon
pshaw's Profile: http://www.officehelp.in/member.php?userid=493
View this thread: http://www.officehelp.in/showthread.php?t=125029
Posted from - http://www.officehelp.i
I'd expect to find it in the new...Query cross two table
I have two tables, tbAdmission and tbCode. In my tbAdmission, I have Code1,
Code2 and Code3. In my tbCode, I have Code, Description1 and Description2.
In my Form, frmAdmission, I have txtCode1, txtCode2 and txtCode3 that are
all bounded to tbAdmission. And txtDescription1Code1, txtDescription2Code1,
txtDescription1Code2, txtDescription2Code2, txtDescription1Code3 and
txtDescription2Code3 that are unbounded and only for displaying the
txtCode1, txtCode2 and txtCode3 all refer to Code in tbCode to retrieve
Description1 and Description2 for displaying in the unbou...Transferring Field from Existing Table/limitations and change of d
Thank you in advance for your help! I have two Excel spreadsheets that I
successfully imported into Access 2003 and created tables for. I need to add
the field from one table to the other, but there is not a direct match in the
relationship. The large table uses the Employee ID as the primary key. The
smaller table contains one field that lists a subset of these Employee ID
numbers (a selection of certain employees). I need to transfer this field to
the larger table, but I do not know how to tell Access to match up the
corresponding numbers (i.e., the large table lists all employees, bu...if value not found in table ?
I need to display a msgbox if a value is not found in a table.
If value not_in table.field then
I know that code wont work is just an ilustration of what i am looking
Thanks in advance
Use DLookup() to see if the value is in the table.
If it's not found, the result will be Null.
So, use IsNull() to test the result.
Here's how to get your Dlookup() expression working:
Getting a value from a table: DLookup()
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access us...Can't sign in to 2004?
Now, another problem. I can no longer sign in with my hotmail and password
if "use Money's online features that require a passport" even though I am
signed on to MSN with that passport. I tried resetting the hotmail password
for both MSN and Money 2004 but still can't get it to work.
In microsoft.public.money, MrEKJ wrote:
>Now, another problem. I can no longer sign in with my hotmail and password
>if "use Money's online features that require a passport" even though I am
>signed on to MSN with that passport. I tried resetting the hotmail password
&...Auto Filter not working
I have a strange problem which occurs from time to time whereby I am unable
to activate the Auto Filter function on a list. The filter buttons simply do
not appear! Does anybody have any idea why this might happen??
Is the worksheet protected?
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Chris Jenkins" <email@example.com> wrote in message
> I have a strange problem which occurs from time to time whereby
I am unable
> t...Linked Table Manager Doesn't Work in Access 2003
I recently upgraded to Access 2003 and have found that the menu option:
Tools/Database Utilities/Linked Table Manager no longer works correctly for
re-linking my front end database to the backend. No tables show in the table
list. If I click “Select All” and then fill in the path to the backend
database I get the following error message: Method ‘List’ of object
‘IfieldListWnd’ failed. As a work around I have to delete all the table
links from the front-end and then File/Get External Data/Link Tables. Is
anybody else having this problem?
Thanks in advance for your help.
"...Can't open files
Hello -- I'm sure this isn't the proper place to post my problem, but thought
I'd start here anyways. Let me start off by saying that I'm extremely
computer-stupid, so please forgive my ignorance. I'm running Windows Vista
Ultimate, and yahoo email. For some reason, I'm unable to open attachments
that have been sent to me, and saved to my computer. PLEASE HLP!! These are
important documents that I really need to access. Thanks for your help --
It's not very informative to say you are not able to open attachments.
What happens when you try? Is ther...Pivot Text
I know that excel is probably not the place to be doing this but.....
I am wanting to create a matrix of information that is currently all in
I have tried to use pivot tables but obviously whenever I drop text into the
values area it is ecpecting a number.
What can I use as an alternative
Excel 2007 PivotTable
With Text (and tricks)
...Multiple Filters in a Form
I need some help. I have a form based on a query which lists wine in a
cellar. I want to allow the users to filter the content on the form by using
multiple filters. The following code works well.
Private Sub CmdApplyFilter_Click()
Dim strWhere As String
strWhere = ""
Dim strNonZero As String
Dim strType As String
Dim strYear As String
strNonZero = ""
strType = ""
strYear = ""
' from a check box to show either only current wine in cellar or all wine
included that which has been drunk - no bottles in cellar
If CheckNonZero = True Then
...Select Working TV Signal
Hey peeps, I've been looking for an answer to this problem for a couple
weeks, done lots of google searches and searched around these forums to
see if my question had already been answered.. as far as I can see it
has not been. If it has, please point me to a link. thanks.
Can not get Media Center TV Setup (win7) to see STB signal.
The STB itself is a Scientific America with 1xCoaxial in, and 1xCoaxial
out. *NO* RCA/COMPOSITE/HDMI. It is connected to the computer from the
Coaxial out to the antenna in on my Hauppauge PVR-150
It asks me if I have a set-top box. ...why I can not definition a variable in My Dll.
It's a dll support MFC
INT __stdcall RemoterPrint()
INT booklet1 = 1;
INT Pages1 = 0;
INT m_FileID = ::InitUMFFile(szFilePathName);//Insert Breakpoint;
I found the value is as follows
why ???? I am really puzzled.
I added someting in stdafx.h
using namespace std;
"zhang" <firstname.lastname@example.org> д����Ϣ����:u1SbT%23FbHHA.4656@TK2MSFTNGP03.phx.gbl...
> It's a dll support MFC