#Delete Mark in Bound Memo filed
I have form that has bound memo field, sometime, no sure how it happen, the
memo filed is filled with #Delete. My application is a stand alone program.
Kindly advise what can cause this and how to avoid it from happening.
When was the last time you performed a compact and repair?
Is you db split? Does each user have their own copy of the front-end?
http://office.microsoft.com/en-ca/access/HA011865661033.aspx - No very
helpful but directly from MS ...CSV File Problem
Can any one explain why the following problem occurs please?
A colleague has a small list of data which is a csv file exported from SQL.
Column One is a serial number from 1 to 29.
Column 2 is a number of transactions which have occurred.(it should look
like example A below in Excel)
1 475 1,475
2 1732 21,732
3 1670 31,670
4 2176 42,176
5 608 5,608
6 1579 61,579
7 43101 743,101
8 54512 854,512
9 51258 951,258
10 61050 1,061,050
If I double click on the csv file, it opens in Excel but c...CFile (delete file)
How can I delete all files that end with ".temp" in some folder?
"Petar Popara" <firstname.lastname@example.org> wrote in message
> How can I delete all files that end with ".temp" in some folder?
SHFileOperation() will and it supports wildcards! DeleteFile() will operate
on one file at a time.
"Petar Popara" <email@example.com> wrote in message
>...Opening an *.MSG file with it's respective attachment.
The file *.MSG is a message file. This can be viewed by any editor, like
Notepad. However, when there's an attachment to it, we see garbage.
Is there a way to open the attachments present inside the *.MSG files ?
Yes, by opening it with Outlook.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
mailbox!...Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP
and MS Money 2005. I am now unable to open my previously converted 2005 file
or restore any backup version. I consistently get the following error
"Money cannot locate filename or cannot open it, possibly
because it is a read-only file, you do not have
permission to change it, or your disk drive is write-
protected. If you have chosen the correct file and it
cannot be accessed, you will need to click OK and then
Restore your most recent backup file."
Any help or thoughts would be greatly ap...import a 123 file
My excel version cannot open a Lotus 123 file. Is there an import feature to
move the data from Lotus 123 to Excel?
No, you need to convert the file either from Lotus 123 or get commercial
"Frank" <Frank@discussions.microsoft.com> wrote in message
> My excel version cannot open a Lotus 123 file. Is there an import feature
> move the data from Lotus 123 to Excel?
...Where is the cache files folder located for windows media player?
Does windows media player have a cache files folder? Where is the cache
files folder located for windows media player? Or how do I find the cache
files folder for windows media player?
Thank You for your Help.
Background info: I have a desktop AMD 4400+ 64X2 4GB memory 320GB HD(way
bigger than I need) Acer computer (AM3100-U3201A) I purchased new February
2008 running 32-bit MS Vista Home Premium SP2 box. I use MS auto updates.
I think it has onboard shared memory for video and sound. My ISP is Comcast
12mbps with Motorola SURFboard SB5101 Cable Modem direct to...chart MAcro to change on activecell
Here is the macro below.. The only problem is that the columns change every
month. so range (columns)keeps widening.... I have sorted it by selecting
range upto column N. so it is provided for all 12 months.
But now the "Grand total" column which is always the last column also gets
included..(.which shouldnt be included in the range for the chart)
Is there a way to modify this macro ?
Dim ThechartObj As ChartObject
Dim Thechart As Chart
Dim Userrow As Long
Dim CatTitles As Range
Dim SrcRange As Range
Dim SourceData As Range
If Sheets("summary").Ch...Public Folder link to Excel File
I have a user that claims that he had a shortcut to a spreadsheet "in
his public folders" at his old job. Obviously, he's an end user that
may or may not know what he's talking about.... I'm trying to figure
out the best way to accomodate him.
He basically wants an Excel file stored on a shared folder to be
available to all user as either a shortcut, or a link in the public
folders (can't post to a folder as he will be updating the sheet
regularly). When a user clicks on the shortcut/link, it would just
launch Excel and display the file.
Anybody have any ideas...Macro for Sharepoint List and another Table?? Same # records?
I am creating a database which we have a form made up of prepopulated data
(from a sharepoint list) and also data input needed by a user (for example,
I have two tables: one sharepoint list that is linked to sharepoint website
and another table that houses the additional user inputs [table 2]. I have
linked the files based on the primary key. So, every record in my table 2
has a plus sign and it will expand and you will see the linked data from the
Is there a way that I can automatically create a record for every
corresponding record ...Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter
which is using Publisher 97
The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200
Richard this is caused by Publisher 97 not been printer independent.
Even if you went back to Publisher 2000, unless you have the identical font
versions and printer driver you would have issues with formatting.
It sounds like the person sending you the file has a garbage HP inkjet
printer. Get them to install the HP5P laser p...Renaming Partial File Names
Is it possible to rename part of a file name? (almost like a find and
replace) My database pulls in the excel file names from a directory, with
it's subfolders and contents as well. Every file begins with "Kay Form".
Kay no longer works in our department, and I'd like to run a loop that
replaces "Kay Form" with "Featured Track". I don't know how to do a partial
Thank you in advance!
Message posted via AccessMonster.com
Checkout the Replace function. I...How to unlock locked cells by MACRO?!
I have locked Sheet and I need to change particular cells. But when my
macro wants to change it => ERROR :/
Is there any way to unprotect these particulary cells by macro and
change them? - after that action, of course, I want to lock them again.
Please help me, Pedro
Just unprotect the sheet, do the work, and reprotect the sheet. Kind of like:
'your code to change stuff
Petr N�me�ek wrote:
> I have locked Sheet and I need to change particular cells. But when m...printing imported gif files in Excel
When printing gif file with transparent background on the
grey(25%) background of Excel non-transparent part of the
picture has white border around it. Is there any way to
Thank you in advance...
...unknown .edb file
I have error messages in the log files that references a corrupt database
named C:\Program Files\exchsrvr\Exchangeserver_Outlook.edb. "Outlook" is the
name of the server. The problem is that this database is not listed in any of
the Mail Stores or Public stores. I want to run the repair utilities on it,
but since I'm not sure what it is used for, I don't know how I can restore it
if the repair goes bad. Does anyone know what this is used for or how I can
determine that myself? BTW, the database always has a current time stamp, so
I assume that it is used by something....Copying dbx files from a CDR back into Outlook
My computer was recently hijakced and I had to reinstall
everything. I did however save all of my folders in
Outlook onto a CD Rom and I do not know how to transfer
them back so I can use them. Also I had an animated
version of outlook where you could choose loads of
diffent stationery and I cannot seem to find that upgrade
Can you help me?
Tee <firstname.lastname@example.org> wrote:
> My computer was recently hijakced and I had to reinstall
> everything. I did however save all of my folders in
> Outlook onto a CD Rom and I do not know how to transfer
> them back so...Macro to seperate data
I seem to be struggling to find a macro that will work in previous threads.
In sheet 1 is a list of data in columns A:N and the number of rows will
vary. It is a list of sales with each sale record ocuppying one row. The
salesperson's name is in column C and each salesperson will have multiple
What I am trying to do is create a seperate summary sheet in the workbook
for each salesperson. Therefore sheets 2 to 20 are templates that already
exist with a different salesperson's name entered into cell C3 on each of
I am trying to find a macro that ...how to make macro work even a sheet is hidden.
I have macro assigned to a button in Sheet 1 which goes to sheet 2.
Press a button to Refresh and then PRINT preview
It does work in normal state.
I do not want the user to see the Sheet 2. I hid sheets from
but the macro is not working when sheet 2 is hidden.
how to overcome this error
"can't execute code in break mode"
the macro code is
Application.Run "'Latest 2009Payslip.xls'!Sheet2.HURows"
...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...DB_Backup.MDB file has appeared beside DB.MDB.
I have a local DB.MDB which accesses a DATA.MDB on a network drive.
I use a user-level security file.
It has been working AOK for a year or so.
Yesterday one of the users reported an error dialog when attempting to open
the DB.MDB (unfortunately the wording of the dialog was not captured!)
After this 'event', the database started working correctly once again.
The result was a DB_Backup.MDB file appeared beside the DB.MDB.
That backup file is created when ACCESS "crashes" during use.....
<MS ACCESS MVP>
"Andrew (UGL)&quo...Adding a Macro to a VLookup Function
In Excel 2000 -- I would like to create a summary spreadsheet (sheet2).
For each time that "Name" appears in sheet 1, row *, take information from
the same row, but columns 2 and 6 and bring it over to sheet 2 in the
I know that you need to do a "VLookup" function and I got that to work. I
know that you also need a "Loop" statement, so that it will continue to
perform the Vlookup and bring over the information for each time that the
name appears. I don't know how to write the formula so that the VLookup and
the Loop are combined.
I need a macro that help me to transfer name and address information from an
specific table in excel to a template in words on specific areas and then
print the word document.
The reason for this is that i need to create diferents letters to be sent to
the customers from the excel table.
Example of the table is:
soc seg, customer name, child name, customer code, add 1 , add2, city,
estate, zip code. all this information will be paste on word letter template
on specific areas or fields.
IMHO the best approach would be to set up a mail merge documen...macros entering data
How do I create a macro that goes to one cell
then waits until I enter new data, then goes to another cell
and waits until I enter new data etc?
How about something like
NewValue = inputbox("Enter the value for cell A1: ")
range("a1").value = NewValue
NewValue = inputbox("Enter the value for cell G2: ")
range("g2").value = NewValue
NewValue = inputbox("Enter the value for cell I8: ")
range("i8").value = NewValue
...Creating a Macro to Delete Commas #2
I have an excel file that the size will varry. I need a macro that will
check all the fields for a comma. If there is one I would like to get
rid of it. Does anyone have any idea how to do this? I have no idea and
I have been assigned this task.
Message posted from http://www.ExcelForum.com/
No macro required.
ctrl-H for find/replace. find , replace nothing (leave the
replace field blank). You can of course record that within
a macro if you wish.
>I have an excel file that the size will varry. I need a
macro that will
>check ...Macro to change default setting on startup
I am in need of a macro that can change a default setting in excel and for it
to run on startup
The task is:
uncheck Update links on save
Below is the recording of the macro:
..RelyOnCSS = True
..OrganizeInFolder = True
..UseLongFileNames = True
..DownloadComponents = False
..RelyOnVML = False
..AllowPNG = False
..ScreenSize = msoScreenSize800x600
..PixelsPerInch = 96
..Encoding = msoEncodingWestern
..SaveHiddenData = True
..LoadPictures = True