Validating Field data within a Table
I have a Table "Tbl_Log_Receipt" which has a field where the user must input
his unique Id, this field is named "User_ID"
I want the user to enter his ID in this field and if the entry does not
match a record within another table called Tbl_Users, it will display a
warning message and blank his entry.
Is this possible??
Thanks in advance for any assistance.
Rather than make the user key in an id, why not pick up his/her network ID
and use that?
There's code in http://www.mvps.org/access/api/api0008.htm at "The Access
Web" to let you get that ...How to merge to tables (
Good morning everyone!
My financial system's database (general ledger) keeps seperate tables for
each year. Each table (GL2007, GL2008 etc) has 14 fields:
* Account_number, Cost_account, January_balance,
Now, I have not encountered this before but I did make some calculations and
then merged this two tables into 1 table with 26 fields (12 + 12 months +
Account_number and Cost_account).
HOW do change this summary table into one table with 5 fields
(account_number, cost_account, year, month, balance).
3010, 10, 2007, J...Best way to add tables?
It seems difficult to draw precise tables in Pub 2002. Word offers more
flexibility, but when I use Paste or Paste Special into Pub all formatting
is lost, and it's time consuming to reformat everything. Is there a best way
to do this?
Have you tried the "Import Word Document" from file?
Once the document is in Publisher, select the table, copy, paste special, new
table. Delete the Word document. You shouldn't lose formatting.
Mary Sauer MSFT MVP
"Doug" <doug@loc...Unable to bring back all results from table with query
For a uni assignment we have a designated query that we have to create.
But when I run the query, I get one result returned to me. I should have two
returned to me, as I have two records in the Problem table.
The SQL is:- SELECT Problem.[Problem Number], User.[User ID], User.[User
Name], User.[Job Title], User.Email, User.[Telephone No], Asset.[Asset Code
No], Problem.[Problem Description], Problem.[Current Activity Log],
FROM [User] INNER JOIN ((Asset INNER JOIN Problem ON Asset.[Asset Code No] =
Problem.[Asset Code No]) INNER JOIN [Contact Log]...capitalization table
Operating System: Mac OS X 10.5 (Leopard)
I am looking for a free template to create a capitalization table for my business. Where can I find one? <br>
On 21/04/10 5:58 AM, in article 59bb731f.-1@webcrossing.JaKIaxP2ac0,
"PAV@officeformac.com" <PAV@officeformac.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am
> looking for a free template to create a capitalization table for...Pivot table formatting
I have a pivot table that pulls its source data from another worksheet in
the same workbook. I have some columns that have "x" in them and also some
columns that have dates. I have formatted both the source data and the
pivot table to center the columns with "x" and use date format 1/4/03. When
I refresh the pivot table, it seems to randomize the formatting. Some of my
"x" cells are centered and some are left justified. Also, some of my dates
are 1/4/03 and some are 1/4/2003. How can I get the formatting to stay?
Thanks for any help.
Set the pivot table t...Is there help for beginners?
I just bought this wonderful computer from Dell, and Microsoft Outlook came
with it. I cannot figure out how to use it! I can get email, but I cannot
send it! It stays in the Outbox forever, and when I try to send it from
there, I'm told it's not possible. Aren't there any beginner tutorials I can
look at? I really could use some help! Thanks!
drexlori <email@example.com> typed:
> I just bought this wonderful computer from Dell, and Microsoft
> Outlook came with it. I cannot...CT Tables
I've several of tables loaded into my company database. I am looking at these
tables and they have some interesting fields. Can anyone tell me what modules
these tables are for? I cannot find any information on these tables in GP
tables description. They all start with CT.
Any help will be highly appreciated.
These tables do not appear to be native to Great Plains, unless they are new to
version 8. What third party products do you have installed along with Great
Plains? Any developer worth his salt would ...updating pivot table #2
I have pivot tables that I update weekly with new data. Unfortunately, the
prior week's options are included in the updated drop down lists. The old
data is not included in the calculations so it doesn't affect the report in
that regard but although I only have 18 weeks of data in the source
worksheet, the drop-down lists show the 32 weeks I have been running the
report as options. It is confusing to users of the report.
There's information here on clearing old items in a pivot table:
> I have pivot table...Grouping dates in pivot table
I am pulling data from a SQL Server database to create a pivot table.
Excel (07) is not recognizing the field as a date. This is a field I
would like to group by in the pivottable. I am aware of all the
techniques to convert this to a date field, but I am searching for an
answer as to why XL pivot tables cannot consume the dates directly
from a sql query.
I have played with bringing the dates back in a number of differenent
formats with no success.
Any insights into this would be appreciated.
Probably coming in as text and yuo may only need to copy an unused cell and
paste sp...formatting inside table/text box in form
I have a form that asks users for several types of information, mostly in the
form of drop down boxes. But there are some fields that require text and the
user needs to be able to add bulleted text if necessary. I cannot find a way
to protect this document without the bullet option graying out. Can someone
In a protected document, you cannot apply formatting to text.
What you can do is add a section to the document and leave it unprotected.
In such a section, users will be able to format text more freely. In Word
2007, you are limited to applying styles via the...Help for a Beginner Among Beginners
Hello, would anyone kindly point me in the general direction of
a solution to a very basic database question (I'm not even sure where
I have a small consulting company of a dozen employees, with no IT
We have info from approx 1000 clients stored in an Access 2000
which is 10MB in size. A former employee made a simple form, which we
with client info, and we just add records. The file is on a file
all 12 of us access it simultaneously. Recently, I hired a guy to
a VPN, so that employees can add data to the database while on the
Howeve...Export a Table to a Text File
How do I export a Table to a text file?
I need Fixed with and have a import specification.
I can import from a text file to a table but now I need the other way.
I have the table ready using queries and all I need is this last step.
Create a macro with the TransferText action.
It's quite easy to set the options in the lower pane of the macro design
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Lillian" <firstname.lastname@example.org> wro...Earn $200 per day without a website
Tired of wasting your time & hard earned money on "intelligent"
programs which promise to make you rich overnight? Then read on,
because I am going to show you.............
How I made over $2000 in just 10 days using a ridiculously stupid
technique I stole from my own affiliate
Click the following link to see the entire procedure explained step-by-
I Got MY Own ATM. J
...pivot table help? #2
I need some help with an issue I cannot seem to solve!
I have a pivot table in Excel that is based off of a data
input sheet. The data changes every month and the pivot
table is always linked to the specific data tab. When the
underlying data changes, the "old data" still displays as
options to check in the pivot table. The refresh option
does not seem to fix this, nor does the "Save data with
table layout" option.
I only want the options to check to be current data. For
example, my data sheet only has data for July and August,
but the pivot table has options ...How do I combine 2 tables?
I have 2 tables in a database. Each table has 1 data field, "Slot", in common
with the other.
How do I create a new table or query that combines data in one table with
data in the other table based on the slot number? In other words I have the
Table 1 Table 2
A 1 2 3 4 A 4 7 2 9
B 3 5 1 3 B 4 9 1 2
C 0 7 8 3 C 5 1 4 2
Where the capital letter is the data for the slot field, the desired result
is a new table or query that looks like this:
A 1 2 3 4 4 7 2 9
B 3 5 1 3 4 9 1 2
C 0 7 8 3 5 1 4 2
I am new to this so ...Excel 2003-Beginner
I'm using Excel 2003.
Sorry, I'm if not explaining this well. I'm trying to put information in a
column that comes from another worksheet in the same book but it depends on
what is entered in 2 other columns in the first worksheet. I'll try to give
Let's say Column A asks you to pick 1 of 5 gems: Agate, Turquoise, Garnet,
Let's say Column B asks you to pick 1 of 6 Countries: US, Can, UK, China,
The other worksheet has a table with data (its a number in each cell)
representing all the possible permutatio...Creating a Lookup Table
I'm going to create a lookup table for my charting application.
There aren't going to be very many items in this table, most likely
less than a 100. For the majority, no more than 20 items.
This table is to hold a symbol reference for the charts the user
creates. For example, say the user is viewing a chart of Cotton. How
this chart is actually named will be different for each user as they
can name it whatever they want. So what I want to do is give the user
the ability to assign the symbol (CT) to any chart that refers to
Cotton. This way, when the user pulls up a chart of...Beginner Here!
I'm looking for decent internet resources to learn how to use Great Plains
software. I'm a VB developer starting a new job with a company that uses GP,
but I've never used it. Any information would be greatly appreciated.
Your best bet is to read through the manuals that come on
the Great Plains cd. Then log into the sample company and
try each transaction type, report option etc. It's just
sample data so you can't hurt anything. This hands on
approach is the best way to learn the system.
We provide personlized one on one training via r...Table Information
I'm trying to use Crystal Reports to pull data from GP v8, however finding
the correct table is difficult. If there is a report in GP already made, how
can i find out which tables the fields link to?
A little of a wide open question there. Can you be more specific? What
report are you trying to produce? A report in GP already made for what?
You can find table information and field information under File > Resource
Descriptions, and can find table relationship information in the Software
Mariano Gomez, MIS, MCP, PMP
Maximum Global Bu...Pivot table subtotals 100%
This is what I want:
...table of contents
I am trying to build a table of contents from the headings
in my employee handbook. I have heard that this is
possible, and if I change the content of the handbook, the
page numbers, etc. will automatically update. What is the
process to accomplish this?
I would appreciate any insight given. Thanks!
...recreating ME tables and stored procedures
Whenever a client is performing such tasks as voiding payables checks, he
will receive an error message saying somethng along the lines of "a
get/change" or "an open operation" on table 'ME......'" cannot find the table
or cannot find the stored procedure.
Now, thanks to the "More Info" button on these error messages, you get the
name of the table and stored procedure. So, the short-term fix is to go into
the SQL Maintenance window and easily create the table and stored procedure.
Fortunately, these errors are just "nuisances&quo...Pasting Access table into Excel; can't use SUM function
We have 200+ Oracle database tables that we use to create queries and make
tables. We create select queries on a daily basis that are comprised of
approx. 8,000 to 14,000 records. We usually take this information and paste
it into Excel for analysis. Recently, we upgraded from NT 4.0 WS to XP Pro.
We noticed that when we now paste our information into excel, the formatting
is changed. Numbers that we could easily SUM before, no longer respond to
the sum function. When we use the SUM function, the function does not
recognize the cell as a number and responds with '0'. When...Access Smartlist tables
Is it possible to see the tables in the basic Smartlist queries?
For example in the Company Module under Tax Detail Transactions can
you see that table or tables that SL references? I am using GP 10
Thx in Advance
On Disc 2 of the install CDs, in the Tools>Dex>Doc>PDF folder, there=92s
a file called IG.pdf, which is the Dexterity Integration Guide.
There=92s a section called SmartList Objects which contains a cross
reference of all the tables
and joins used in the standard SmartLists.
MCP-GP, MCT, MVP
East Coast Dynamics