Access 2007 Upgrade Problems
A couple of years ago I created an assets database using Access 2003.
Recently our computers were upgraded to Office 2007. I have been using my
assets database using the new Access 2007 and have updated and changed a lot
of objects. For the most part, it works OK. One thing I tried that did not
work is saving my assets database as an Access 2007 database. When I try, I
get a warning message telling me that all open objects must first be closed
before the conversion can take place. The same warning dialog asks me if I
want Microsoft Offfice Access to close the objec...Dual Displays
I want to connect my Sharp Aquos flat screen TV to my computer, and see my desktop on both the TV and computer monitor.
Windows Vista Home Premium.
HP Pavilion a1610n computer.
Galaxy GeForce 8400 GS graphics card, outputs: 1-VGA, 1-DVI, and 1-SVGA. There is no HDMI port on the card.
I connected a VGA cable between the motherboard "on-board" VGA port and the TV, figuring that I could use that output to work with the TV. The computer monitor is plugged into the GeForce graphics card.
Tried the Desktop "Display Setting". It says, the number 2 monitor is "N...adding code to sort a list in VBA
I have a user form that enters data to a file and the file should be
sorted in date order.
How can I add code to an already existing code in Visual Basic so that
after the user clicks the "OK" button the data gets entered, then after
that it automatically sorts the data according to the date column.
I tried recording a macro to do it and then copy/paste it to the code
but i get an error.
Any ideas as to what the code should look like, where it should be
placed in the program?
Message posted from http://www.ExcelForum.com/
A good start would be to show ...Vba code cannot select text pasted from .txt file
The data I'm working with is from a .txt file which was created by exporting
a .pdf to a text file.
I copy all of the text from the .txt file and paste it into a column in Excel.
When trying to reference any column, row, or range on the sheet with the
pasted text, I get the following error: Run-time error '1004':
Application-defined or object-defined error.
Sheets("Sheet5").Select ' <this works fine
Columns("A:A").Select ' <this gets the error
I've tried pasting the text with other paste special options. I'v...Display a message box "this entry is a duplicate"
How can I display a message box on a form if the shipment number is a
duplicate? I need a message box to pop up when user attempts to tab out of
Private Sub txtShipNum_BeforeUpdate(Cancel As Integer)
If DCount("*", "MyTable", "ShipNum = '" & Me.txtShipNum & "'") > 0 Then
Msgbox Me.txtShipNum & " already exists."
Cancel = True
This assumes that your text box is named txtShipNum, that the name of the
field in table MyTable is ShipNum...Folder could not be displayed
I am running Windows XP and Outlook Express 6 just fine
then one day my husband does something to my computer and
his email account won't work. My email is working just
fine but in his he cannot open his inbox. It says folder
could not be displayed, and when you send and receive it
gives you this error message:
"An unknown error has occured.
Server:'incoming.verizon.net'.Protocol:POP3, port: 110,
Secure(SSL): No, error number: 0x800C013B"
If anyone could help me with this I would greatly
T...how to display values in 3 cells into one cell
Anyone can help me how do I display the 3 separate different values in 3
cells into just one single cell ?
thanks so much in advance.
Either there was a typo or there's an echo in here.
That line should have been:
= A1 & " " & B1 & " " & C1
"Bradley Dawson" <firstname.lastname@example.org> wrote in message
> In the target cell, type:
> = A1 & B1 & C1
> where A1, B1, C1 are the cell addresses that you want to concatenate.
> If these have number...Changing Codes
I have a series of product codes that all begin with a zero e.g 0455
I want to change all the zeros to a 9 is there a quick way of doin
cj21's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2567
View this thread: http://www.excelforum.com/showthread.php?threadid=40144
Maybe using a helper cell and using a formula?
(255 is just a very big number to get the remainder of the text.)
If these are numbers just formatted to show ...Display Time in Outlook
The time setting in my Outlook is one hour behind my
actual time. I cannot determine how to change the time.
Outlook is the only item that is incorrect. Other display
times in operating system are correct. Thanks, Jodi
...Word Cells into Excel Cells #2
How does one import a cell formatted Word file *.doc into
cells within Excel *.xls.
By "cell formatted Word file", do you mean a table? I would simply select
table and click copy. Then open excel and paste it where you want it to
> How does one import a cell formatted Word file *.doc into
> cells within Excel *.xls.
> By "cell formatted Word file", do you mean a table? I would simpl
> table and click copy. Then open excel and paste it where you want i
> ap...How to select & display distinct values
I need help with a form please.
My form has two controls, the first being a combo box. This box should
select the company name from a lookup table. The lookup table has only two
companies in it, however, they each are repeated several time. Company 1 has
about 10 rows, company 2 has 3 rows. I used the query builder and came up
with the statement:
"SELECT DISTINCT Lktbl_Role_Master.CompanyName
When I run the statement directly from query view, it executes perfectly and
returns exactly two rows (one for each company, in a datasheet view) ho...Money 2007 -- QIF import
After a little trial and error, I am able to import account transactions
from another system (not a bank statement, my actual register transactions)
with little trouble except for the date format.
(Before someone gets mad at me, I really don't think this has anything to do
with my regional settings!)
As recommended by an MVP from this forum, I open my CSV file with excel,
then use a converter (add-in) called XL2QIF to create a qif output file.
The actual "data" in a date field in my original csv file is "060106"
(mm/dd/yy) which is June 1, 2006,...Import Project with Actuals to Project Server 2007
I have saved a local copy of the project that has actual work from our
Project Server 2003 environment. I am executing the Import Wizard in Project
Server 2007. When I save or publish the plan, I receive a message box status
the actual work is out of sync with the actual work updated from the
The server is configured to allow user to enter their updates via My Tasks
with unmanaged time periods. I can get more specifics from our Admin is
How do you take a local copy of a project with actuals and import the
project along with the actuals into the Projec...PK and FK Displayed
I am a complete Visio newbie, and cannot find the answer I need in books or
I am trying to create ER diagrams from scratch, and not connected to real
tables, using VEA. I have added tables ('Entities') to the form, connected
them with a Relationship connector, and, in the Database Properties window
I've assigned the end points to a Primary Key on the left and a Foreign Key
on the right. But the model shows the connector as running between the top
colums on both sides, whereas I want the keys to be in that upper box and
provide the connector's end points. Wh...area code changed
All around us the area codes are changing. How can I
universally find and replace the area codes in my
...Word 2007 doesn't catch all misspelled words 12-23-09
I posted this earlier today, but it doesn't seem to have gone through. My
apologies if it did.
Word 2007 document, saved as Word 97-2003 doc, also saved as Word doc. In
either case, it does not pick up the word "collogues" as a misspelled word. I
have done all of the suggested fixes and checks: hidden text, set language,
do not check, etc. None of them make any difference. I added the "word"
collogue as something to autocorrect--that doesn't help either.
I have had the same thing happen with other docs--Word will pick up most but
not all misspelle...Why do eMails contain "=20" and "=C3=A4" char codes ?
Occasionally (but not always) I am getting eMails which contain a lot of characters codes
beginning with an "=" in the text body e.g. "=20" and "=C3=A4".
What is the reason ?
Is this an error of the sending or an error of the receiving eMail client ?
Is this an error in the Win System or a matter of the eMail client?
Sometimes CSS statements (beginning with <STYLE>) are visible as well. Is the reason for that
the same as for the char miscoding ?
...Outlook 2007 Watermark for staionery 11-16-09
I would like to make my own watermark for stationery using a picture of my
own - is this possible if so can I get directions to do it.
You can simple set a watermarked picture as the background for that. Many
photo editor applications have a watermark filter to create such images.
For an example see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
&q...Formulas are displayed, results are not
Hello, For some reason, when I enter a formula into a cell and press
enter, the formula just stays there. Anyone know what I can do to show
I tried pressing Cntrl + `, but that didn't work.
FYI, when I cut and paste a column from a separate workbook, that
column works like normal (i.e., the formulas produce results).
Thanks for any suggestions!
Maybe your cell is preformatted as Text.
Try formatting to general then erase your =
and type it in again.
"Mike C" <email@example.com> wrote in message
news:f699bcd4-ad82-4a88-9759-5638c147b...Stop displaying a line
I have a line graph/chart and it gets its values using a formula and the values of another column. However this poses a problem because if there is nothing in the targetted column the formula returns 0 cause the line to drop to the bottom, instead of casuing the line to just end until a value is added to the target column. How can I do this?
Change your formula to use NA() if the cell is empty. For example:
To hide the resulting #N/A errors on the worksheet, you can use
conditional formatting. There are instructions here:
http://www.contextures.com/xlC...Excel 2007 does start up right
I have been using Excel 2007 since about March with no problems. Recently I
started experiencing a problem when the application is stated. It randomly
(maybe 2 out of 6 times) does not open to the "grid" screen but rather a
light blue screen with nothing on it except the Ready button in the upper
left corner. If I click on that button I get the same drop down menus as I
get when the application starts correctly and I click on the Ready button in
the lower left corner. This has only been happening for about the last two
weeks. If I just open it and close it several times withou...attching files in outlook 2007
if I try and insert a file into a message in outlook 2007 I only get options
to insert or insert as text. in previous versions there was an option to
insert as a hyperlink, is this no longer available? I am using
outlook/office 2007 with SP2 installed.
Thanks in advance for any help.
"TAFFY" <TAFFY@discussions.microsoft.com> wrote in message
> if I try and insert a file into a message in outlook 2007 I only get
> to insert or insert as text. in pre...Control Codes
I am printing labels using an old Datamax label printer that requires the
STX (hex o2) control code to start the label format. RMS seems to strip this
out. Has anyone had success in sending Printer control codes to the label
file? Tried CHR$(02) but it did nothing.
...Can individual words in a sentence be animated in powerpoint?
I am trying to highlight some individual words within a paragraph. I'd like
to give them some animation and not the whole sentence.
On 6/4/10 1:08 PM, consultkjb wrote:
> I am trying to highlight some individual words within a paragraph. I'd like
> to give them some animation and not the whole sentence.
I think you can only do that if they are in a separate text box.
David M. Marcovitz
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland
Author of _Powerful PowerPoint for Educators_
...unattached textboxes disappear when a msgbox is displayed on a tab control
I'm using Access 2003.
I have a form with a tab control on it. I was having problems with labels
flashing and I followed the suggesting from Allen Browne -
The flashing went away but now when a msgbox is displayed the unattached
textboxes that I'm using as labels disappear. They come back as soon as the
msgbox is removed from the screen.
I've searched google looking for an answer but have come up short.
Does anyone know why I'm experiencing this behavior and how to make it go
That *is* strange. Have you tr...