The database is in an unexpected state; Microsoft Access can't open it.
This morning I encountered an unusual and scary problem.
While trying to open one of our databases I recieved this error.
The database is in an unexpected state; Microsoft Access can't open it.
This database has been converted from a prior version of Microsoft Access by
using the DAO CompactDatabase method instead of the Convert Database command
on the Tools menu (Database Utilities submenu). This has left the database
in a partially converted state.
If you have a copy of the database in its original format, use the Convert
Database command on the Tools menu (Database Utilities submenu) ...Max Limit for Values in List Boxes and Combo Boxes in Outlook forms
Folks, a user is setting up a form. She wants to have several combo
boxes and list boxes with between 75 and 300 (yes, 300 -- that's not a
typo!) possible values in the combo box or list box. Before she starts
work on this, she would like to know if there is a limit on the number
of possible values for a combo box or a multi-select list box.
Is there a limit? Is it defined by the number of characters in the
values box, or the number of actual values? What is the limit? Any help
here would be appreciated. Thanks.
...Stop advancing in form with the "next" arrow at end of "list"
I have an editable form for users where they can query by date, etc.
However, the next entry arrow allows them to advance beyond the result. For
example, if their query resulted in 1 of 4, they can still click to 5, 6, and
so on which only adds blank lines to the database table. How do I set this
to stop at the last entry of their original query?
You can cancel adding new records like this:
Private Sub Form_BeforeInsert(Cancel As Integer)
Cancel = True
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"Duchess" <Duchess@discuss...Microsoft Icons for Web Use
I have several Office documents I'm linking to on my web site and I'm
looking for where I can download the icons for the Office
applications. Anyone? Specifically, I need an icon for MS Word and
MS Excel. It was much easier to find the Acrobat icon for use. :(
If you have Office you already have access to the icons. Select one of the
applications in the MS Office folder then Command+I for Get Info. Click the
icon in the Get Info window & Command+C to copy it, Paste to wherever.
NOTE: As an FYI, as with all corporate logos & trademarks there are
copyright restrictio...Automatic transactions download setup
I would like to set up transaction downloads for an account at a mutual fund
brokerage. I have one account with seven different funds. When I tried to
add this account for auto downloads, it made each of the funds accounts, and
ignored the exsiting account. I have not had this problem with other
brokerages. Why on this one? It is American Century.
When you go onto the web site of American Century, does each fund show up
under 1 account or under separate accounts?
"Globfly" <Globfly@discussions.microsoft.com> wrote in message
news:BE23B547-5E89-4...Resize Forms in Access 2007
I thought I read somewhere that Access 2007 had a new function, or
something, enabling you to have forms automatically resize to fit the screen
resolution of the user. Is this correct, or am I wrong? If I am correct, how
do you use this feature?
On Aug 9, 8:41 am, "BobV" <rk...@earthlink.net> wrote:
> I thought I read somewhere that Access 2007 had a new function, or
> something, enabling you to have forms automatically resize to fit the screen
> resolution of the user. Is this correct, or am I wrong? If I am correct, how
> do you use this feature?...how do I have contacts and companies name is tasks
I'm new to outlook, When I create field chooser and have the Company Name &
Contact name in fields Sometimes both Company name & Contact name shows up
when I schedule a task. (That is what I want) However most of the time only
the contact name shows up??? and no Company Name? Does anyone know why this
is inconsistant? And How I can display both all the time?
Thanks in advance
...Update Download problem
I downloaded the latest update for Outlook 2000. I did
NOT have the installation cd handy. Okay, usually no
problem, the instal quits. However this time, it did
quit, yet now I am unable to open excel. It launches the
instal program. The download was for Outlook. It has me
boggled. Outlook, Word and Access open with no known
problems. I have tried to open excel different
times/ways. It continues to try to load the update.
Any reasoning on the subject???
...Form Based Auth.
I have checked the option to use form based authentication but I don't get
the web page login - still the pop up login box. I have restarted IIS. This
is all internal at the moment till i get the forms working. Any ideas.
Do you have "require SSL" checked on the Exchange (and Public) virtual
directories in IIS? Have you tried going to the https:// site manually?
Forms-based auth only works with SSL. If you haven't required SSL and you
go to the http page, it will still work just fine and will pop up the login
...Check if Form is Open
I need to check to see if a form is open in the Onclose of another form.
And if it is to requery it, if not do nothing. I did find a Function on
The Access Web web site but I'm not sure how to utilize the function.
Function fIsLoaded(ByVal strFormName As String) As Integer
'Returns a 0 if form is not open or a -1 if Open
If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0 Then
If Forms(strFormName).CurrentView <> 0 Then
fIsLoaded = True
I need to run this in the OnClose of a form to see if frmHome is o...Multi-field search form
I am rather new to this place, so I would like to thank you all up front
for any and all assistance you may provide. :)
It has been a while since I worked with MS Access last. What I am trying
to do is create a multi-field search form, where any of the fields can
be filled which will display a result set. Preferably if no selection in
the fields is made, the entire resultset should be shown - this is not a
I seem to be a bit at a loss on how to procede with this task or to find
any resources to help me get along.
Again, thanks for any and ...Microsoft Exchange/Outlook thoughts
We are currently being forced into Microsoft Exchange and have been
using Lotus Notes for the past 8 years. Never a problem with Notes
EMail, and now I am forced to look for answers to simple questions.
Why doesn't Mail get delivered to my current Email address?
Answer : Now way to tell. There aren't any tools to allow me to track
this. Reboot and call me later. If the problem still exists I am up
When will you allow applications to be delivered to remote users?
Answer: Never or check out .net stuff and if you can figure this out
let me know. Lotus has delivered th...stop mail from automatically downloading
Please help! How do i stop e-mail from automatically
downloading when I start Outlook? I don't always want my
mail downloaded and can't find any help on this subject
I was also advised to try this:
When you close Outlook while working in Off-line mode
File-> Work Off Line. Outlook will also start in Off-line mode.
I'm going to try them both
>Referring to Outlook 2000 (assume other versions not too
>Tools>Options>Mail Delivery. Uncheck "Check for messages
...." Messages will not be down...How the heck do I find tables, views, forms etc... in Access 2007
Can Access 2007 navigation be any more convoluted? I've been spending close
to an hour trying to find a single table, query form, etc... now that the
navigation has been changed. Is there a way to get the old style back?
It does take some time - more than an hour :-) - to become familiar with the
new interface in A2007 (NavPane, ribbon, ...)
- The title bar at the top of the Nav Pane includes a tick box for:
All Access Objects
- Set Category to:
- The categories (Tables, Queries, ...) collapse.
- Show and use the Search Bar. It filters objects as...show pictures in a form
i am trying to make a database and i have a record that has a hyperlink to a
i have two question
1) is the hyperlink the best choice to use for the picture
2) how do i make the picture visble on a form
thank you for your help
sorry i sent this to the wrong newsgroup
how every any advice would still be appreciated
"William Storey II" <firstname.lastname@example.org> wrote in message
> i am trying to make a database and i have a record that has a hyperlink to
> i have two question
&g...TargetInvocationException in Update Invoice in Microsoft Dynamics
Hi, we get the follow error mssage when we try update the invoice object.
But, in the same class, we update the salesorder object with sucess.
Obs. Our code is a custom page.
Any ideas what this could be caused by?
>Crm Exception: Message: , ErrorCode: -2147197184, InnerException: System.Runtime.InteropServices.COMException (0x80045F00): <details></details>
Caller, String InvoiceId, String InvoiceXml)
[2006-10-10 12:16:47.4] Process: w3wp |Thread: 8708 |Category: Platform
|User: d12c7...Microsoft Dynamics RMS Live Chat on August 7th, 2008
The Microsoft Dynamics RMS team will be hosting the next Live Chat on
August 7th, 2008,
at 10 a.m. Pacific Daylight Time.
Is there a topic that you would like to discuss in depth? Do you want
additional insight into a certain area of the software? Have you always
wanted to know what to do when you encounter a particular scenario?
If so, we'd like to hear from you! Please feel free to post any ideas on
this thread, use the link in the Live Chats section of the RMS Using site
(h...User Name prompts
I am using Microsoft Outlook 2002 and have a two word
username separated by a space. I have been having this
problem with Outlook wherein I have entered my username
and password in the account setup process, but it still
prompts me for it whenever it is checking for new
messages. Also, when it prompts, it shows the username
without the space. Does Outlook not accept usernames with
space, because I tried changing the original settings
many times, but every time I open the Edit window of
email accounts, I see my user name without space.
...Dynamically Setting a forms Input Parameter Property
Hi , I'm working with a ADP project, I have a form where I set the recordset
property at design time to a SQLServer stored procedure that has one
parameter. If I set the Input Parameter property of the form at design time
all is well. However I'd like to be a little more flexible in that I have the
calling object that Opens the form using Docmd.Openform pass OpenArgs to the
form. On the Form_Open event I set the InputParameter property of form using
the value in OpenArgs. The problem is I'm still prompted with the parameter
popup..if I press Ok everything continue on and ...how field name output same as input
Thanks for any help.
I have a query from a couple tables, and one of the field names in the table
is 'IGP' and I have a field in the query that was
and now I changed to
IGP: iif(blah IGP blah)
which gives me a circular error.
The table is used by a bunch of other things, so I don't want to change the
field name there, and the field name for the output is used by a bunch of
things, so nor do I want to change the name there. I am using Access 2007. I
thought about changing the output field to IGP_, and I could change the
embedded queries in Excel that use it, but...Sort column with first and last name by last name
I have a mailing list with 10,000 names. The first cell has first an
last name in the same cell. First name is listed first. Is there
formula to sort and/or separate text in a cell. I would like to sort o
separate the first name from the last in the cell to allow for a mai
merge by name. Using Excel 2002. Thank you
Message posted from http://www.ExcelForum.com
If you have just first and last names separated by a space, Data>Text to
Columns would be the easiest method to split into two columns.
If more than that, like names with van or von or de etc. you may need a
different m...Outlook/Inaccurate Check Names Resolve
I currently have Outlook 2002 with Exchange 2000 and am in
a network environment. I've noticed that if I modify an
existing contact to reflect perhaps a new email address,
when I compose a message in Outlook and use the check
names feature, where it populates my TO field
automatically by typing a few of the letters of the name,
it pops in the old address of that contact, even though
I've modified it to the new address. Also, if the few
letters that I type match a few different contact names, a
suggestion list comes up and the incorrect (old) address
for this person is also ...Can get UserProperty Names but not Values?
>From C++ using UserProp->Name I can get the name of a UserProperty,
but UserProp->Value.bstrVal always returns nothing, anyone have any
ideas what I could be doing wrong and has anyone ever accessed
UserProperties from C++?
UserPropertiesPtr UserProps = Con->UserProperties;
if (UserProps->Count > 0)
tot = UserProps->Count;
for (i=1;i < tot + 1;i++)
UserProp = UserProps->Item(i);
MessageBox(NULL,UserProp->Name,"Test - Name",MB_OK);
sText = (char*)UserProp->Val...Getting machine name when connecting to db
We have an application in Access 2000, front end/back end design,10-12 users. I want to save the dates and times they enter and exitfrom the app from their workstations in a table in the back end.How do I get the name of their workstation to save to that table? Theworkstations have names like "sales1", "sales2", "Reception", etc.Paul Fenton Add error handling as required. Place in a module and call functionwhen needed.'example by Donavon Kuhn (Donavon.Kuhn@Nextel.com)Private Const MAX_COMPUTERNAME_LENGTH As Long = 31Private Declare Function GetComputerName L...To auto-fill using names no longer in address
Is there a way to remove the names for the auto fill
feature that are no longer in the address book or contact
list? If they are selected the properties for the entry
states name is no longer valid Address Book entry.
State your Outlook version and what you mean by "autofill." Outlook has two
different functions this could be: autoresolution or autocompletion.
"Ernie C" <email@example.com> wrote in message
> Is there a way to remove the names for the au...