Copy field data to multiple places
Newbi here.... I have a access 07 file of about 1000 records (rows) and a
field (column) I'll call the "project number". All the records do not have
the project number inserted as of yet. Is there a simple means to insert a
project number in say 50 records at a time, another project number in
another 75 records etc. Copy/Paste will do it but may take months to enter.
Any suggestions appreciated. TIA
On Wed, 27 Feb 2008 15:31:05 -0500, "Meebers" <firstname.lastname@example.org> wrote:
>Newbi here.... I have a access 07 file of about 1000 records (rows) and ...last 4 wk average using calculated pivotitem
I am trying to create a pivot table/chart from data that is listed b
week. So my table has "week" as the row field and "total X" as th
column field. I want the chart to display the total for each week as
bar (the easy part) and also to graph the average of the last fou
weeks as a line on top of the bar graph. I have tried to figure ou
how to add a calculated pivot item but I can't seem to get it to wor
right. So for each week there would be a second almost subtotal lik
entry that calculates the average for the previous four weeks (if ther
aren't four previo...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...Viewing an Excel sheet w/out all the empty fields...
How do you create a spreadsheet that only shows the fileds with data in them?
-How do you get rid of all the empty rows/columns, to ease viewing for those
who are easily confused by excel spreadsheets?
(I don't know how else to emaplin my question... I just don't want the
extra columns & rows there, if that's possible...)
>I just don't want the extra columns & rows there, if that's possible...
Just hide them!
Suppose the last column in your sheet that contains data is column H. You
can hide columns I:IV so that after column H all you ...Workflow Manager 10-16-03
I have the same problem as discussed here. But no solution suggested here
was successfully :-(
I've played with the rights of the workflow service, and so on. Alwyas the
same error: "You do not have sufficient rights ...".
Any other ideas?
there is a fix for this -
"Ralf Eisele" <email@example.com> wrote in message
> Hi all,
> I have the same problem as discussed here. But no solution suggested he...Validation Rule for field values
I have a database that includes a phone number field. I want to prevent a user from creating a new record that contains a phone number that is currently in a record that exists in the database.I am using a form for data entry into the table. Somehow I'd like for there to be a check to see if the phone number typed into the phone number field to be checked against existing phone numbers in the database.I've researched various sources but haven't been able to find the solution. I'm not familiar with VB so any replies that suggest using that will probably not work for me. Sorry, j...Pivot table fields missing on all computers
I have Excel 2007 installed on two computers. I also have Excel 2010
beta installed on one of the computers.
I am unable to create a pivot table on ANY of them. None will show the
field list. All copies of Excel work fine in all other aspects.
I have searched the net for solutions and found many others have the
same problem but few suggestions to fix it. Many questions never got
any response at all. I did find a reference to try removing the .xlb
file from the XLStart folder. I did, with no results.
I have done all the proper show/hide clicks. I even tried using the
...Using XP Briefcase with money file
I put a copy of my money file into the laptop briefcase
and I am able to keep them in sych for a while. For some
reason I get locked out, the computer knows the file has
been updated but it will not let the desk top file update
the laptop file, I get the following message;
"The source file can not be opened"
"Check to see if the other program has the file opened,
and close the file before updating the briefcase."
Other files update just fine. When I get this message, I
can't even drag a new copy of the Money file to my
briefcase, I have to rename the file an...Using a VBscript to copy/delete/move Outlook messages
I need to write a VBscript to:
- open my Outlook (2000 or XP) mailbox
- read the list of the folders in either the Exchange Mailbox and in local
- open each folder and subfolders
- read information about messages (i.e. sender, recipient, creation date,
and so on)
- move, copy or delete messages based on the above information
Can anybody please provide a pointer to a sample I can start from?
...Exchange Features Tab in ADUC when using Windows 2000 SP3
I would like to run Active Directory Users and Computers with Exchange 2003
I'm limited to Windows 2000 Prof/SP3
Everything works,except from the Exchange Features tab.
When selecting this tab, ADUC hangs.
Any ideas. (I have to stay on SP3!)
Terminal Services is always my first choice.
On Wed, 13 Apr 2005 23:35:22 +0200, "newsMS" <firstname.lastname@example.org> wrote:
>I would like to run Active Directory Users and Computers with Exchange 2003
>I'm limited to Windows 2000 Prof/SP3
>Everything works,except...Conditional formatting help #4
My problem is that, that i want to ignore blank i mean i had set a
conditional formatting say
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
If value in ColA is less than value in ColC, cell A1 is shaded blue OR
value in ColB is greater than value in ColD, cell B1 shaded blue.
I have done above formatting but my problem is that if i dont enter
anything in colC then also colA is shaded in blue similarly if i dont
enter any value in colD then also col B is shaded.I mean i want to
ignore the blank.I need , if col C is blank then the Col A must be
normal .& if col D is blank & i ent...Using a variable for a chart limit
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.
See Jon's information
Vince F wrote:
> Since I got instant help on my last query, is there any way to use a cell
> reference as an axis minimum or maximum in format axis? It seems impossible,
> but there is a lot of experience out there. Thanks in advance.
Andy Pop...How do I make door hangers using publisher?
Is this even possible?
Mary Sauer has a website with a generous collection of goodies including
Take a look at just above George Washington's portrait (way down the page)
Don - Publisher 2000�
"medinapie" <email@example.com> wrote in message
> Is this even possible?
I have a sample on my web page. Scroll down -- on the left.
Some cute ones here that you could mod...using program to record audio comment and compress audio to MP3
I can use VBA to record an audio comment into a Word file using
Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", FileName:="", _
LinkToFile:=False, DisplayAsIcon:=True, IconFileName:= _
"C:\WINDOWS\system32\sndrec32.exe", IconIndex:=0, IconLabel:="Wave Sound"
BUT but by default the file is stored as a PCM at 44kHz and 16 bit stereo
whcih is about 200kB per second
Sound recorder (which is used to do the recording) allows me to manually
convert this to a MP3 and a much smaller file e.g. 3kB per second
Is there any way I can aut...Getting an UnBound control value into a Table field??????
I have a form that calculates a production rate in "parts per hour". This
form needs to be able to differentiate between Line work, Cutter work, Side
work, and Blister work.
I created a drop down list for selecting the "Study Type" as listed above. I
then created a text box for each "study type". When I select the "study type"
each text box checks to see if the selection applies to it and makes the
calculation if it does apply. The code for the "Line" study is as follows:
=IIf([StudyType]="Line",2700?/[SecondsPerPart])...subjects validation in workflow manager
Anyone who met this issue before?
Subject “A” has 2 sub-nods “A1” and “A2”, the sub-nod “A1” also has 2
sub-nods “A11” and “A12”; how to set the conditions to validate entity
subject value “A1”, “A2”, “A11” or “A12” is the sub-nod of subject “A” in
Can you explain further
Microsoft CRM MVP
"Joey Chou" <JoeyChou@discussions.microsoft.com> wrote in message
> Hi all,
> Anyone who met this issue befo...Can I use oulook from home and have access at work?
When I set up my outlook I lose all my inbox messages online and would not be
able to read my email from work. Is there a way to have my inbox available on
outlook and remain online?
Just to clarify, are you asking how to set up Outlook at home to receive
email from work? If that's your question, you need to ask your IT Admin or
Exchange Admin if you can use OWA and how that's done. That wouldn't have
email coming into your Outlook account but it is a form of Outlook, Outlook
This may or may not be allowed. Your IT staff would of course have all kinds
of securi...Jscript to hide unpopulated fields
We have created two custom entities named suppliers and business partners.
We would prefer not to create account records and use the relationship type
field so we created these custom entities.
We now have on the Contact form three seperate fields that a contact could
be related to. These fields are parent customer, parent supplier and parent
business partner. A Contact should only be associated with one parent record.
We would like to write Jscript which hides the remaining fields if one of
the fields is populated. If a user associates a Contact with a parent
customer then the ...how do I find the equation of a line using a scatter plot?
I am taking a chem lab and right now we are studying rate laws using
kenetics. we had to graph the results of our experiment and then find the
equation of the line. such as y=mx+b but i cant fiugre out how to do it. or
if i am supposed to put a trend line in the graph, but if that is what I am
supposed to do how do I find the equation of it?
First: to make trendline. Right click on the data in the chart; use Add
trendline; specify Linear; on Options tab, check shoe equation
Secondly:To get slope and intercept:
Let's say you x-values are in A2:A11 and y-values in B2:B11
for slope us...Using Rept function
I want to repeat one cells entry somewhere else in my (same) worksheet and have used the Rept function successfully. However, ifthe 1st cell (e.g. A3 is in date format like 12/12/2003, when I use the Rept A3,1 function in another cell (e.g.cell R3), it returns the date as a number (37967). What I want is for the date to be repeated exactly as is (12/12/2003 or whatever date is typed).
Can anyone help please
Don't use the REPT function. Just enter =A3 and apply the date format you
want using Format, Cells if you do not automatically get it.
You can't unless ...Schema validation using Visual Studio .NET 2003
All Iam trying to do is validate a group of schemas which inturn references an external XSD schema(tried putting both in local webserver/as part of project),Iam getting errors
This is what Iam doing
1. Open a blank Biztalk solution
2. Add all the schemas to validate
3. Validate Schema
Am not sure what Iam doing wrong.Any help would be appreciated
...How to use Or in txrbox
Working in a relational db in Access 2003 I have a continuous form (MyForm).
In Header section of the form I have an unbound txtbox control to enter
words separated by Or. After entering the word(s) user click a button to
trigger searching the word(s). My form is based on Allen's Browne search
example. Thus searching controls are in Header and founded records must be
displayed in form2 rather than in Details of the Myform.
On Mon, 26 Apr 2010 13:20:02 -0700, sebastico
>Working in a relational db in Access 2003 I...Check boxes and conditional formatting
I'm still working with a worksheet, and I got it so if you type or
select from a list the word "TRUE" into a cell in column G, then
columns A-F in that row will have their font changed to bright red.
So that's figured out.
But if I want to get all fancy and put a checkbox or radio button in
each cell of the G column that will do the same thing (change the font
color of the row to red, then back to black when unchecked) how do I
do that? I got a macro to work on checking the box, although I don't
know how easily I can copy and paste it all for 1500+ rows) but I...Office is in use by other person?
I have the student version of Office for Mac. No problems until today when it says it is in use by another person. It says my installations exceeds the number of installations allowed by my license agreement. I don't understand what is going on. I received my own product key and everything. Is there any way to fix this?
On 10/6/09 6:23 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> I have the student version of Office for Mac. No problems until today when it
> says it...How to Unhide and Use Columns to the right of the worksheet
I wanted to hide columns AP and everything to the right of it in my
worksheet. So I selected column AP hit CTRL-SHIFT-RIGHT KEY and I
could confine the visible area of my worksheet to A-AO
So far so good.
I now want to be able to insert columns between A and AO.
I get a message saying that it cant shift non-blank columns off the
worksheet (which is now supposedly confined to A-AO.
I inserted the line
ActiveSheet.Range("AP1:AZ1").EntireColumn.Hidden = False
in my Worksheet_SelectionChange macro and found that only column AP
was visible, but that I couldnt select it. I still can...