How to avoid user open the same "mde" file more than 1 time?Dear All,
Does anyone know how to avoid the user open the same Access "mde" file more
than 1 time? I know how to do it on Visual Basic, but it won't work on
Access program.
Thank you in advance.
Regards,
Daryl
"Egg" <darylchoy@hotmail.com> wrote:
>Does anyone know how to avoid the user open the same Access "mde" file more
>than 1 time? I know how to do it on Visual Basic, but it won't work on
>Access program.
API: Preventing multiple instances of a database
http://www.mvps.org/access/api/api0041.htm
ACC2000: How to Determine If Sp...
Excel 2002 Pivot Table NewsgroupThis is a multi-part message in MIME format.
------=_NextPart_000_0017_01C596A9.0B0BF6A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Is there an Excel Pivot Table newsgroup or is it the one with excel =
formulas/worksheet functions?
------=_NextPart_000_0017_01C596A9.0B0BF6A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/h...
Excel to PDF w/ Data TagsHow would I go about printing an Excel Spreadsheet to a PDF? The PDF has
some "Form Fields" in it and I need to assoicate cells in the spreadsheet to
the "Form Fields". Is this possible?
...
Duplicate filesI am getting duplicate transactions in my bank accounts.
I will create checks or download info from my bank. The
next time I open money 2004 I will have duplicate
transactions. This happens 3 or 4 times for every
transaction. They will not delete either. I have to mark
them as void to just find out what my balance really is.
When I balance an account, it doesn't even recognize
these transactions as being there, but it does show them.
If anyone has the same problems I would love to hear how
you fixed it or do I have some new virus?
In microsoft.public.money, Frank G wrote:
...
Post to GL vs Post Through GL FilesOk.....a stupid question here. What exactly is the difference is having the
boxes checked to Post to GL and Post Through GL Files? Is there any problem
with having one vs the other or both of them checked? I would assume that
not having the Post Through GL will require you to post each batch to the GL.
I am surprised that you can have both boxes checked. In that instance, I am
uncertain what would happen. Normally, you would have only one of the boxes
checked. (You could also have none of the boxes checked if you don't want to
post to the GL. For example, you might unmark these s...
CArchive for reading binary filesHello all,
My application needs to read from binary files. Is a CFile associated
with a CArchive the best way to do this? Or do I just stick to using
CFile independently?
The files are supplied by an external application and could have a
large size (say larger than a 100 megs). My application just has to
read from them and process the data.
TIA
Adeel
Adeel wrote:
> Hello all,
>
> My application needs to read from binary files. Is a CFile associated
> with a CArchive the best way to do this? Or do I just stick to using
> CFile independently?
>
> The files ar...
Backgrounds in Excel #2I want to be able to print the background in excel, and also when I PDF an
excel file the background dissapears. How can I make it to print/view. Is
there any way.
Please help me. If there's a way to do it, would you please email me the
steps to make it work.
Thanks,
Bianka
...
Where is the "File" menu?Hello,
I am using Excel for Office 2007 and I am trying to include some rows in a
header so I see these rows at the top of every page.
So I google for instructions, and got many hits.
One of the hits instruct me to go to the file menu and then the page setup
menu. Like this:
File>Page setup
But I don't even see the File menu.
How can I get the File menu to be visble?
--
Best regards
Roberto
You are looking at instructions for an older version of Excel than you have.
Microsoft got rid of the menu bar in Excel 2007 and replaced it with the
Ribbon... you w...
Error on opening file from taskbarI am using Excel 2007 with Windows 7 on a ThinkPad X61. When I right-click
the Excel icon on the TaskBar, and then click on any spreadsheet shown in the
list I get the message "There was a problem sending the command to the
program." The same error happens if I click on the same file from a folder
view although I can easily open it via the Excel menus. As I really like this
feature of Windows 7, it's a real annoyance.
--
Richard I Morris Jr
I'm not sure if this will help you at all, but I suppose it's worth a try:
In Excel 2007, click the Office Button ...
Quick Excel download for homework assignmentI have a homework assignment which requires preparing an excel spreadsheet
for a mortgage. I can't afford to purchase the program at this time. I was
wondering if anyone knew where I could get a free download in order to
complete this assignment? It can be an earlier version or a trial version of
Excel, as long as I can print the spreadsheet to turn in.
"starme" <starme@discussions.microsoft.com> wrote in message
news:11E98603-2CE2-4409-848D-0D3F35D89B92@microsoft.com...
> I have a homework assignment which requires preparing an excel spreadsheet
> for a mor...
Excel defaultI would like to change the default settings on opening Excel in a similar
way in which you can do with Word by changing normal.dot. However, I cannot
find a comparable file. I would appreciate it if someone could point the
way.
Thanks.
Bill Ridgeway
Bill
Excel does not have a Normal.dot as Word has.
There are several ways to customize Excel workbooks and worksheets.
Open a new workbook. Customize as you wish. File>Save As Type: scroll down
to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes).
Excel will add the .XLT to save as BOOK.XLT.
Stor...
Maximum file size for excel documents?Hi,
Does anyone know what the maximum file size for a excell 2000 workbook is?
I'm currently upto 38mb, just need to know how much further I can go.
Lots of data....
Hi
see:
http://www.decisionmodels.com/memlimits.htm
--
Regards
Frank Kabel
Frankfurt, Germany
Parag wrote:
> Hi,
>
> Does anyone know what the maximum file size for a excell 2000
> workbook is? I'm currently upto 38mb, just need to know how much
> further I can go.
>
> Lots of data....
Thanks
"Frank Kabel" wrote:
> Hi
> see:
> http://www.decisionmodels.com/memlimits.htm
...
Is there a way to extract data from an internet webpage using VB in ExcelId like to extract some data from a table on a page on the internet
when the user clicks a button a spreadsheet.
I could write the code that examines the html and extracts the data
myself , but is there a VB routine that i can load the html document
into memory so i can search through it to extract the data
The webpage is just a plain html document with a table 1/2 way through
with the information in it i want.
Douglas
Hi Douglas
have you checked out
data / get external data / new web query
the functionality of this is slightly different depending on your version -
so if you'ld like ...
Excel 2000 Font Drop Down MenuI'm running Win 2000 SP4 with Excel 2000 SR1 and IE 5.01SP4 with the
International Fonts package installed.
When I use the Font Drop Down Menu in Excel, it displays all the standard
installed fonts plus non English fonts: namely Arial, Courier New and Times
New Roman in CE, CYR, Greek and TUR.
I don't have this problem in any other application.
Any ideas on how to correct this?
Chas. verktyg@nospamski.aol.com
...
PST Files #5I have a freind who uses outlook 2000.
He is currently at about 400megs on the pst file.
He can open outlook, he can read, sort, view and download
more email. But the second he double clicks on an email
to open it to respond..etc. Outlook locks up, window
error message say... dangerously low on system resources.
He is running 98 with the latest patches, 25 gig of free
space on the hdd, and 512megs of ram.
Im of the opinion that its just to large of a pst for the
computer/os to handle. Ive had him clean it up, used to
be 712megs in size. He was okay till about 2 weeks ago.
No idea what ...
Expanding ExcelApologies if this is posted in the wrong Excel section.
I own a small chemical company that analyses various
products for chemical impurities. I have a
spectrophotometer connected to my PC that analyses the
product and then exports the data into Excel and producs a
graph. This is done via a plug-in for Excel produced by
the spectro manufacturer.
What I would like to do, if it is possible, is to have
manually entered into Excel (or an Access Db) by myself, a
library of information on all the impurities I come across
during my daily business. I would then like to be able to
overlay gr...
Formula in an Excel commentIf I have an item identifier in an Excel cell I would like to be able to see
a summary of info about the item as a comment. As there will be many such
identifiers possible in many rows, use of a formula in a comment to build the
summary info from other cells/worksheets would be a big help. Even better
would be if I could copy the comment from cell to cell so that the formula
addressing automatically changes to suit the identifier in the new cell.
...
Excel fileI accidentaly replaced a file with a wrong file and then the wrong one was deleted. Is there any hope of me recovering the Excel sheet I replaced??
Carice
I think that, in your heart of hearts, you know the answer to this question,
don't you ?
Yes / NO / Don't Know
Have you backed it up recently ? That's your only chance
Regards
Trevor
"Carice" <anonymous@discussions.microsoft.com> wrote in message
news:B1A17345-9395-4373-AC22-26C9B13DAF08@microsoft.com...
> I accidentaly replaced a file with a wrong file and then the wrong one was
deleted. Is there any ...
Renaming Access Query used by ExcelWe want to rename some Access queries that are used by an Excel file in an
External database query. But when we rename the queries in Access, the
Excel Query fails, because is doesn't recognize the renamed queries, and is
still looking for the old query names. Is there an easy way to fix the
Excel query so it is looking for the new query name?
Thanks.
I haven't tested this, but I'm pretty sure it will work.
Don't rename the Access Query....Make a copy of it in Access and rename the
copy.
Then, in Excel, edit the query
View the SQL code and replace the old query refe...
How to open 123 files with excelA client gave me files in Lotus 123. I have Excel 2002. Is there a way to
open these files and convert to excel. The WK4 files he gave me convert but
not the 123 files.
There is no filter that allows Excel to read .123 files. So you have to
convert them to a format Excel can read using 1-2-3 or Conversions Plus from
www.datawiz.com
--
Jim Rech
Excel MVP
"Jeff B 813" <Jeff B 813@discussions.microsoft.com> wrote in message
news:6799DB18-8FC1-4D2D-999D-A10C7BFFD7A4@microsoft.com...
|A client gave me files in Lotus 123. I have Excel 2002. Is there a way to
| open thes...
Excel: QuestionHi.
I am using Excel 2007 in a vista premium home esition. I have 3 worksheets,
Sales Order, Companys, Product.
On the sales order, I have a box I want to call company ID #, I want to
select the company and I want it to populate the Companies address, I have
the following Addess, City, County, State, Zip.
I would like a window to show me company ID and Name, and when I click on it
I want to put the ID number in the cell and like I mentioned the address
filled out.
Now I would like to know where I can find more info on this so I can read
about it and do it or else just some basic info...
Excel's Dialog BoxHi every body, I'm having trubles with excel's dialog box, I can creat and
execute the excel dialog box, but when information is request by the dialog
box and, so on answered by user, I don't know how to directionate the writen
information, I mean, cut the info writen in the dialog box and paste it in
one of the excel cell, ex. A2.
Excel's dialog box is a lot of things. But assuming you have a "excel 5
dialogsheet" in your file.
Insert a standard module if you don't have one already. Paste this macro
into it:
Sub WriteText()
Sheets("Sheet1").Range(...
2005 Excel User ConferenceJust a reminder about the 2005 Excel User Conference. Details can be found
at:
http://www.exceluserconference.com/
The conference will take place on Friday, September 16, 2005 - Saturday,
September 17, 2005 and will be held at Stockyards Hotel Fort Worth, Texas
USA. Mark your calendars and make plans to attend. This will be your
opportunity to meet some of the regular posters and learn from some of the
"masters". Don't miss out!!
Everyone is welcome to help spread the word about this event. Messages
posted in other forums in which you participate would be appreciated. We...
Need help with excel functions retrieving dataI hope someone may be able to help me out...
I have a spreadsheet that is an output of all computers on our network
and what applications are installed on them
The spreadsheet is organized by all computer names listed in column A,
and all software listed in column B.
So, in column A, you will see multiple entries for each computer and
in column B, you will see a different software name in each of the
rows next to the computer name in column A.
On another sheet, I would like to be able to choose from a dropdown
list of computer names (grabbed from column A) and have it display all
the softw...
Fill-in Word Form inside Excel Workbook?I have a 3 sheet workbook (contractor billing forms) and
wish to insert a Word "Form" (Release of Lien) into a 4th
sheet and have the inserted "form" filled in by data from
the other workbook sheets.
The workbook transfers all redundant data into the other
2 sheets. The data is completed, then copied and renamed
the next month [sequentially, ie: JobBill#1, JobBill#2,
etc.] using the prior month as the starting point.
The Release of Lien form could also use this redundant
data, but I haven't been able to figure out how to get
the Word "fields" to upda...