changing fields to another table's fields
I have made a form using fields from table#1. I want to use fields of same
name from table#2. Easy way to do this?
If you want to use data from table2 instead of table1 in the same form
you might edit a "RowSource" property from "table1" to "table2" in a
properties of your form.
"sparky" <email@example.com> �������/�������� � ��������
>I have made a form using fields from table#1. I want to use fields of same
> name from table#2. Easy way t...Accss Tables
I have a set of Tables that are linked to Excell Sheets. My perfomance is very slow
I was wondering if there is a way to take the existing linked table and convert them into local Access tables retaining the exsiting data in the tables.
File | Get External Data | Import
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Harold" <firstname.lastname@example.org> wrote in message
> I have a set of Tables that are linked to Excell Sheets. My perfomance is
> I was wo...Urgent!!! e02.log deleted by Symantec Antivirus
Please help, Information Store can not mount. due to virus nestsky P
I can not undeleted. How can i fix it?
Do not scan the exchsrvr dirs or M: drive.
Do you have a good backup?
On Sun, 13 Jun 2004 01:51:01 -0700, "email@example.com"
>Please help, Information Store can not mount. due to virus nestsky P
>I can not undeleted. How can i fix it?
Restore from your last backup.
"boonsitc@hotmai...Pivot Table #7
Hi -- I have a pivot table
Column A = Soldtoname
Column B = Sales #
Column C = Software
Column D = Support
Column E = Grand total
Is there a way to incorporate next to Column E what percentage Support
Take a look at Debra web
if this helps please click yes, thanks
> Hi -- I have a pivot table
> Column A = Soldtoname
> Column B = Sales #
> Column C = Software
> Column D = Support
> Column E = Grand total
> Is there a way to incorporate next to Column E what percentage Supp...Log files on wrong drive
Exchange 2000 SP3. I've moved my database and streaming file locations
in System Manager to drive F: They have moved okay but the log files
are still writing on C: Is this to be expected and how can I change
that location as well?
The log file location is found on the properties of the Storage Group.
Change it there, and it will automatically move them for you. Note that
when you move the log files, it will have to dismount any databases that are
using them while it moves the log files.
Read my blog!
http://winzenz.blogspot...cannot open excel file
I go to open an excel spreadsheet that was working perfectly fine on Friday
(it is now Monday), and I get the following error message (regardless of
"EXCEL.exe has generated errors and will be closed by Windows.
You will need to restart the program.
An error log is being created."
I did a search of all "*.log" files on my computer, and the only one
modified at the same time as the error is drwtsn32.log. Here's the entry I
get from the log file:
"Application exception occurred:
When: 6/6/2005 @ 10:28:51.290
...Adding row to a table
I have appreciated the input of g. mayor and have found his "An alternative
method of adding a row to a protected table"
(http://www.gmayor.com/word_vba_examples.htm) to be quite helpful. It is
designed to be an 'exit macro' and I am trying to use it in a slightly
My issue is that as a user tabs through a form they will always come to the
last cell and tabbing to the next formfield just creates another row. So I
am attempting to set up a button (commandbutton) that will run the macro and
add an additional row 'on demand.' I have this...find affected tables when creating a new record in CRM frontend
How can I find out what tables which new record has been added on when I
enter data through a form in CRM front end? I try to find way to map form in
the CRM frontend to the tables at the CRM database at backend? It is CRM 3.0
Thank in advances for help!
On Nov 9, 12:12=A0pm, VistaUser123 <sunmapleleaf...@yahoo.com> wrote:
> How can I find out what tables which new record has been added on when I
> enter data through a form in CRM front end? I try to find way to map form=
> the CRM frontend to the tables at the CRM database at backend? It is CRM =
> Thank in...Pivot Table Basics
I am almost certain that I can use pivot tables to make
life easier, but have no idea where to start. My
understanding is that data on a worksheet can be used more
comprehensively using one of these. Can someone point me
in the direction of a BASIC lesson on Pivot Tables, in
order that I can explore the possibility of using one?
Let's say I have a worksheet with column headings and data
under each heading....Let's also say that I have no idea
what a pivot table is used for!
There are pivot table instructions and links on Jon Peltier's web site:
...Comparing two tables
hey just a short question :-D
I have two tables, one with a list with 1330 entries and one with 720
entries, the 720 are all in the big list as well, is there a way to write
the 610 entries from the big list that arent in the small list into another
excel table without doing it one by one ?
thanks in advance
try to use the "VLOOKUP" function...it will help you to identify with values
are in both tables (sheets)... so you can mark the values that are in both
tables and separete then easily...
i don´t know if you know the VLOOKUP function...if you don´...Reorient Pivot Table Data
Is it possible to reorient pivot table Data from rows to columns? An
example is as follows:
Now (data is correct)
TYPE SUBTYPE DATA
A 1 Permits 5
A 2 Permits 3
TYPE SUBTYPE Permits Value Lots
A 1 5 $1,500,258 25
A 2 3 $1,253,000 12
To arrange the data fields horizontally, drag the Data button onto the
cell that contains the word Total. There's a screen shot here:
http://www.contextures.com/x...LOG Files #3
How can read the log files generated on my server? Is there a Log reader
utilty? The logs are not simple text files.
they are not meant to be read, really...those are your transaction log
"Lee" <Lee@discussions.microsoft.com> wrote in message
> How can read the log files generated on my server? Is there a Log reader
> utilty? The logs are not simple text files.
> Example "E0000004.log"
Well the problem is that I have had an "Explosion" of ...Ole objects in records/tables
I have a question every time I tried to go to word and powerpoint and says
type a prodect key I typed from the back of my labtop but it keeps saying it
wrong.So what do I do?
"Kevin Ramos" <kevin's email> wrote in message
>I have a question every time I tried to go to word and powerpoint and says
>type a prodect key I typed from the back of my labtop but it keeps saying
>it wrong.So what do I do?
...Anti-virus necessary on front end server?
I'm currently running Symantec Anti-virus for Exchange on my Exchange 2003
I'm adding a front-end server to be used for OWA, POP3, and IMAP
send/receive access. The server will have a store (for the direct POP3 and
IMAP connectivity), but no mailboxes on it.
Will I require anti-virus on this server as well as my back-end? I can't
find any real recommendations on this.
Thanks in advance.
On Thu, 20 Apr 2006 12:59:47 -0400, "Paul" <firstname.lastname@example.org> wrote:
>I'm currently running Symantec Anti-virus for Exchange on my Exchange...logging password changes
Is it possible to audit when a user changes their Great Plains password and
then get a report on this.
Great Plains Consultant
Are you using SQL Server? If so, I think turning on the C2 security option
will audit these changes.
"Doug" <Doug@discussions.microsoft.com> wrote in message
> Is it possible to audit when a user changes their Great Plains password
> then get a report on this.
> Doug Wilson
> Great Plains Consultant
> MCS Canada
...HR & Payroll Table Security
How can we grant read/write access to only the SQL tables for HR and payroll.
We do not want to have a GP user setup, only SQL access.
You would use Enterprise Manager or Management Studio to create a login;
assign the login to the database; and (here's the tricky part) select the
specific tables you want the user to see. For payroll tables, select the UPR
tables. For the HR tables, you'll need to assign permissions to tables with
various types of names. Use the Resource Descriptions in GP to look at the HR
tables so you will know which ones you need.
Charles Allen, MVP
...Delete rows in table if checkbox value in first cell equals true
First time caller long time observer.
I'm creating a form which contains three tables. First two tables contain
information such as heading, date, time, user details etc.
Table three consists of 2 rows and 5 columns. First row is used for column
headings and second row contains form fields where the user can record their
data. The first cell of row 2 contains a checkbox and the rest contain text
Now, I would like the user to have the ability to add and remove rows at
click of a button. After couple hours of researching I figured out the code
When a user closes a workbook I want my macro to retrieve the username
logged in to the machine and use that as the filename. Is this
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
In a general module:
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
Function fOSUserName() As String
' Returns the network login name
Dim lngLen As L...Updating table/list
I have a quarterly report of company names and tables of other data related
to it. My problem is every quarter, the company names changes (dropped some,
added some). For 2 qtrs now, I have just created a new table with the new
list and deleted the old table. This Company List table has relationships.
Is there an easier way of updating the company list without having to delete,
and re-create table? My data comes from an excel spreadsheet which is
exported from Access. Thanks for any help.
...log files #6
On the last installations of 2003SBS premium SP1 edition, i noticed that
under c:\program files\exchsrv\mdbdata\, lots of .log-files are created,
consuming lots of space. Is there a way to avoid the creation of these
files. Because after, lets say a week, these files can consume for example
and these are the things that are eating up my diskspace.
I think the way is scheduled job on 00:00
cd c:\program files\exchsrv\mbdata
del *.log /q
"Jo Lambrecht" wrote:
> On the last installations of 2003SBS premium SP1 edi...Look up wizard in tables
I have designed a table and in one field of the table I have used 'look up
wizard' to make a relationship with another table in the database. When I
open the table in datasheet view and click on the field with the 'Look up
relationship' it pulls information from the first column only, not the
second. The relationship of the tables are right, not sure why it is pulling
information from one column only. I would like it to pull from both columns
as the row information is related.
IMO, you should never ever use lookup fields in table designs.
http://www.mvps.org/acc...Adding additional column of data to pivot table
I have a data table that has 7000 rows, which I'm slicing using a
pivot table. Column A has 150 unique values. I'd like to add another
pivot table field (let's call it field F), which will have three
unique values. I will decide which of the Column A values should match
up to three field F values.
Obviously, I don't want to do this for 7000 rows but just for the 150
unique Column A rows. Can someone tell me what the best way is to do
In database theory, I guess what I want is to create another table and
then join them, but I'm not sure if that is common in Excel.
H...anti virus help
can anyone direct me in a good direction?? i'm looking to find a good and
simple anti-virus for exchange. mabey a free trial to test it out? thanks for
Trend ScanMail or Antigen are the usual favourites.
"tmolaee" <email@example.com> wrote in message
> can anyone direct me in a good direction?? i'm looking to find a good and
> simple anti-virus for exchange. mabey a free t...Pivot Table #43
One of the row headings in my pivot Table is 'Ticker'.
On the data page there are about 12 rows with a ticker of 'GS'.
These willl NOT show up on the pivot table. If I change them to something
else (GS_TEST,GS_TEMP, etc) and refresh the pivot table, they appear. When I
try to change the ticker back to GS and refresh, they disappear again..
I've been all over the knowledge base.. Looked up smart tags, checked my
autocorrect entries, etc..
I don't know of anything that would cause the problem. If you copy the
source data into a new workbook, and crea...Linking fields in different table in same database
I have a database (Access 2007) that is used for holding data on and
communicating with FE colleges. Obviously (?) each college has a number of
contacts (up to 14) and these are represented in two tables – one for College
Details and one for Contact Details which are linked by a one to many
relationship. Most colleges have one representative on one of 3 groups, but
not all colleges are represented on all groups and some not on any. The
membership of a group is noted by a field in the Contact details. Getting a
query to run to identify membership of groups is OK. But I can’t fig...