Proper Table(s) Layout
I have created a couple of Dbs which the table structure seemed to simply
fall into place, it was just logical in my head.
That said, I am working on a new db and for some reason I am doubting myself
and wanted a second opinion.
The db is basically a contract db to input all the info, and there is a lot
of info, for each contract. Where I am 'lost' is the fact that the contracts
are broken into categories: clients, components,engineering, warantee... For
all of the components (with the exception of clients) there are a number of
fields but only 1 entry per contract....[ANN] Office 11.3.8 update
A new security update just came out.
I suspect it requires 11.3.7 to install.
Anyway, time to run the Microsoft Updater or to grab it from
--- Mac:MS MVP http://www.cortig.net/wordpress/ ---
http://www.mvps.org - http://mvp.support.microsoft.com
MVPs are not MS employees - Les MVP ne travaillent pas pour MS
Remove "NoSpam" to e-mail me - Retirez "NoSpam" pour m'�crire
I just let the Microsoft AutoUpdate do its thing. The only Office...Worksheet Auto update
I need to find a way to automate a process.
Is there a way to automatically replace the content of a worksheet with the
content of another one?
Every morning I get a sales report in excel for the previous day sales. I
save it in a folder and then I do a pivot table on this sheet to determine
sales by product category for example.
The following day, I open the previous day file, replace the sales report
with the new one and then refresh my pivot table.
Is there a way to have my sales report update anytime I get a new sales
To be more clear
I have a workbook with two tabs: Pivot...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Table link documentation
I am having trouble trying to locate A/P check data that has project related
costs. I found the check data but it is does not indicate the projects, I
found the project data but can not determine thye logical link between the
two tables, I may be using the wrong tables the tables I am using are PM80500
and PA31102. Is there any documentation of how all the tables in the system
are logically link. I am trying to write reports in MS Access, but there
are 1500+ tables in GP (version 10)
In an effort to find the correct table you can do a number of things (believe
me I do)....Pass parameter from FORM to QUERY
I have an append query that I trying to call from a cmd btn...but it
prompts me for the parameter(ie QuoteID)...
How do I tye it into my call:
Dim stQueName As String
stQueName = "Quote Query"
DoCmd.OpenQuery stQueName, acNormal, acEdit
On Apr 13, 12:56 pm, jlt...@hotmail.com wrote:
> I have an append query that I trying to call from a cmd btn...but it
> prompts me for the parameter(ie QuoteID)...
> How do I tye it into my call:
> Dim stQueName As String
> stQueName = "Quote Query"
> DoCmd.OpenQuery stQueName, acNormal, acEd...Office 2007 forms
I am creating a form with office 2007, will those people who do not use
office 2007 be able to fill in my form? should I save it in a particular
Provided you start from the normal template, don't use fonts that were
introduced with Word 2007, and save the form in Word 97-2003 document
format, anyone with Word 97 or later should be able to open it. Use only the
legacy form fields, to which end
http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will make things
<>>< ><<> ><<> <>>< ><<...Content of emails is changing without any reason !
I changed operating system last week. From Win XP to Win 7. Used to work
with Outlook Express at full satisfaction.
I could transfer most of my emails automatically with export/import features
of Microsoft software.
But I suddenly discover 1 very big problem (bug ???)
I am used to work with several maps, and hereby go to several levels deep.
Such as :
Date of action
Name of patient
So sometimes maps can go several levels deep.
When I check ema...About Exit and close window.
I have a dialogue base application. There's an Exit button in it. Eachtime
when exit the program by clicking Exit button, fun() and OnOK() executed,
but if the window is close by clicking (x) on the upper-right coner, fun()
will not be executed. How to make this function--fun()--executed when click
(x) button on the upper-right coner?
Rather than calling your fun() from the Exit event handler, call it from the
dialog closing event handler, so that no matter how it is shut down, that
method is called, and so is fun().
hope that helps.
"sxy7711" <sxy771...Duplicate record in RM tables
We experienced an issue in Apply Sales Document that may have caused a
duplicate record somewhere. We found this when running Paid Sales
Transaction Removal and received this message:
Violation of PRIMARY KEY contraint PKRM3101. Cannot insert duplicate key in
I ran the RM duplicate tool found in the automated help area of this website
and found the following:
--- Begin copy here ----
Duplicates between RM Open and RM History
Document #: 07-003021-17 Customer #: 079100 RMDTYPAL #: 7
--- End copy ---
It looks like the duplicte tool also logs the qu...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam firstname.lastname@example.org> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Problem with Update function of CRecordSet class
When I use from Update function of CRecordSet class, it apply to table
after a few time(for example 1 second) when I need to see it at time.
...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...140 MB file went to 5.08 MB after editting 1 table
Hello All -
I need some ACCESS insight...please...
Several years ago, I built an access db to track my business
scheduling and accounts payable/receivable.
So this database is EXTREMELY IMPORTANT TO ME.
The file has grown to 140 MB.
Today I made a copy of the file and then edited my calendar table.
I removed all columns which had 2006 data (72 totals columns) - the
table had about 144 columns originally.
I then added 72 columns with 2008 headers. These columns are now
blank since I have not added any 2008 data yet. Afterwards, I looked
around and everything looks good - my 2007 data is the...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Updating Credit Card Information
I have been trying counless times to update my credit card information from
several Banks, but Money states that the system is unaavaible or the
transaction cannot be completed at this time. What can I do to correct this
On 2005-03-23, Lou <Lou@discussions.microsoft.com> wrote:
> I have been trying counless times to update my credit card information from
> several Banks, but Money states that the system is unaavaible or the
> transaction cannot be completed at this time. What can I do to correct this
Well it depends on how long you've been tr...cursor missing from form textboxes
I believe that I know 98% of the little intricacies of Publisher, but I'm
stumped on this one. I created a website with a contact page and none of the
standard textboxes will show a cursor to indicate with field you are in (I've
even made the site live to double check). If you tab between textboxes, the
tabbing works, as does typing, there is just no visual cursor to indicate
where you are. If you click on the first textbox and type, all is good you
can tab to the next box and type, and it's fine. I'd like to have the visual
cursor show and can't get it. I also have ...Pivot Table Defaults
In the pivot table field list, whenever I create a new pivot table and I am
inserting fields into the value area, I generally get as default field
setting the 'Count' value. Is there a way to format the spreadsheet to make
Excel recognize the data as all numbers so it defaults to the "Sum" function
as opposed to "text"?
The rule that the PT Wizard adopts is,
If all the values in the field being added to the data area are Numeric,
then it uses Sum.
If any of the values are Text or BLANK, then it uses Count.
It sounds as though you have defin...Like a pivot table
Hello every body
I'm first time requesting in this group, so I opologize in advance for any
mistakes or something annoying
I repeat what I have sent before 10 min because I see it unclear when it
goes to news group
If any one can help me
I'm working with data which most of it comes like a table with feilds as
columns and records as rows. I want it to be as many rows with each feild
what is exist
name age Joining Date Tele
John 20 Jun-90 4321251
Iqbal 30 Jul-95 6583752
George 40 Sep-85 7843125
What I wa...VBA form
Im using a form/macro that i linked to through another thread and a
tailoring it to my needs. I basically have it doing what i need but
cant get a button to do what i want. When the user starts the macro i
brings up the form with a message and 2 buttons (Continue/Cancel). Whe
continue is pressed i want the message on the form to change to aniothe
message and so on until all messages are shown. Ive attacehed what i
working on and apprecaite any help offered.
|Filename: Excel.zip ...how to automatically update inventory list with sales
Please provide the help on how to update the inventory list when some items are
Do you want to check this out while you wait for an answer?
"lalani" <email@example.com> wrote in message
> Please provide the help on how to update the inventory list when some
The page that Epinn points out is probably as good as any. Excel is a rather
poor tool for trying to track inventory. You'll notice that the actual...Money Updates #2
Was wondering about money updates. What exactly is the program downloading
during the update process? And if the program is updated on a daily basis,
why would I ever need to upgrade to a newer version?
In microsoft.public.money, invalid wrote:
>Was wondering about money updates. What exactly is the program downloading
>during the update process? And if the program is updated on a daily basis,
>why would I ever need to upgrade to a newer version?
It is mainly changes in online bank setup.
Despite appearances is typically does not change anywhere daily.
"invalid" <...Duplicating one Field from One table to Another
I have two tables - one position, one personnel - which has a 1-to-many
relationship (1 position record to many personnel records). The department
had a new requirement which made it necessary to change some coding (I
inherited this). I'm using tab forms so that when a position is pulled up,
you can click on the tab that has the personnel information (if there is
any). There is a button on the Personnel form that allows the user to add a
new Personnel record. Since I am using an Auto-number field in the Position
table (which doubles as the PK) the functionality is fine. Wh...How to receive photos sent to me without having to click on them
I have just started using Outlook 2007. I am unable to receive photos in the
text email message. They all come as attachments.
I cannot find any settings to allow direct insertion of photos into the
email text message area.
Outlook doesn't support inline images. See
http://www.slipstick.com/mail1/inline.asp for options.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newslett...Scroll Wheel effecting a form
Is there any way to keep a mouse scroll wheel from having an effect on a
This is a single form for data entry and if are part way thru the form and
for what ever reasom use the scroll wheel all the fields on the form are
effected (they dissapear - like going to the next new record).
My suggestion to get a mouse without a scrool wheel was not met with
Any help here will be appreciated.
Thanks in advance
The scroll wheel is moving you through the records. Nothing except your
view of the records is disappearing. The records are still there. I
wouldn't think y...