2455 Error when navigation bar set to not show Access 2007
I get this error
2455 You entered an expression that has an invalid reference to the property
If I have the navigation bar option unchecked on Access Options Current
database and I close the database using the X in th etop right corner, with
my main form open and AFTER just slectign a new record via a vombo box which
runs this code.
If the nav bar is there - no error.
Private Sub btnSelectCase_Click()
'Click to make CboSeletCase combo appear
On Error GoTo CCError
MsgBox Err....clear the list og "open other users folder"
When you use the open an other user folder, it could be a
calendar, the persons name and folder is put into a list
under the menu File/Open. I would like to clear that
numbered list of folders, does anyone know how to do that?
...drawing of lots
Can a macro be written in order to draw numbers between 1-100 and keep
drawing excluding the numbers beeing drawn before?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.714 / Virus Database: 470 - Release Date: 02.07.2004
J.E. McGimpsey has a userdefined function that you could put in A1:A100. It
will provide unique entries.
Martyn Wilson wrote:
> Can a macro be written in order to draw numbers between 1-100 and keep
> drawing excluding the...One-to-Many Connector in Auto Shapes
Hi I'm tring to draw a database diagram in excel. Does
anyone know where I can find a 'one-to-mamy or many-to-
one question: Do you think Excel is the right tool for that :-)
It's neither a database nor a design tool. I would suggest VISIO for
that (for small scale projects). So AFAIK Excel has no 'connector
> Hi I'm tring to draw a database diagram in excel. Does
> anyone know where I can find a 'one-to-mamy or many-to-
> many connector?
> Cheers, Lynne
...draw geographic object on windows form.
I have some lines that are described by geographic coordinates (x1,y1)
to (x2,y2) in UTM coordinate. What I'm trying to do is draw these
lines onto a windows form to visualize what they look like. I can
draw lines onto the form using the code below. my question is how do
I convert my UTM coordinates to a form that can be drawn on the
DrawArea = new Bitmap(pictureBox1.Size.Width,
pictureBox1.Image = DrawArea;
g = Graphics.FromImage(DrawArea);
Pen mypen = new Pen(Color.Black);
g.DrawLine(mypen, 0, 0, 20, 6...Forms Permissions
We are using Outlook 2003 and Windows SBS 2003 (Exchange SP2), we have
created a number of simple forms as OFT files and stored them in a shared
folder on the network. The users can open the forms by looking in "User
Templates in file system" but some users get an error mesage when they try
to send a message using the forms, the error message is "You do not have
sufficient permissions to perform this operation on this object". If they
save the message into their drafts folder first they can then send it, the
users have full access to the directory that has the forms....How to print a simple list of tables, queries & forms ?
How can I print a list of all the tables, queries and forms in my data
I've tried Tools | Analyze | Documenter | Tables | Options | Select
... Include for Table = Nothing
... Include for Fields = Nothing
... Include for Indexes = Nothing
We only want a simple list of tables, queries & forms.
thanks for any help.
Dim o As AccessObject
For each o in currentData.AllTables
For each o in currentProject.AllForms
For each o in currentProject.AllQueries
On May 1, 10:38 am, Mel <MyEm...Excel 97 change default settings in print dialog box
In Excel 97 My print dialog box shows by default number
It's a bore having to change this setting each time I
want to print single copies
How to change this default setting to number of copies=1
This is probably set in Windows.
Close XL, and go to the Windows Control Panel.
Dbl click on "Printers".
Right click on the printer you're using, and choose "Properties".
There should be a "Features" tab, where I'll bet you find that the setting
for the number of copies is "3".
Change it to "1", and then <OK>, and y...User no longer in the company
One of our users has left the company and we would like to have Exchange
send an email to all that send emails to this user indicating that he now
logner works for us. I ma new to Exchange 55 and can not find where to do
this. (if it can be done)
I'd probably just create an out of office reply from the users desktop.
if you like, you can logon to the mailbox and set an "Out of Office" reply
and leave it in place for awhile...
"George D. Lake" <NoSpam@bla.com> wrote in message
&g...user account lockout and sa user lock out
What is the procedure if you lockout the sa user from too many bad password
Is the standard on regular users that you just change their password?
Is the lockout due to SQL server or a 3rd party addon?
Can you use Windows Authentication to log into the SQL Server Management Studio and reset the 'sa' password?
It would probably be safer if 'sa' is excluded from the password policies and expiry.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
M...how do i defalt save as excel 97 ?
one user on our network has office 2000. when she saves an excel file
created in excel 97 it automatically saves as excel 2000. When another user
with 97 then saves this file it says that this file was created using a more
advanced version. How can I set the 2000 excel to save as 97 as a defalt?
normally the file format between Excel 2000 and excel 97 is fully
compatible. You'll only get this message and Excel will re-calculate
the file. AFAIK no chance to prevent this
"ironpowder" <firstname.lastname@example.org> ...Form
I am using Access 2007. Have created a combo box on a form with the wizard
to "Find a record on my form based on the value I selected in my combo box."
I have used this feature in previous versions of Access and it always worked
properly. But this one stops on the first record with matching info and then
must use navigation keys to get to correct record ... e.g., list shows Allen,
James; Allen, Kevin; Allen, Leon ... if click on Allen, Leon, it moves to the
first Allen in the list instead of the Allen chosen. How can I make it move
to the record selected instead?
Are yo...How to goto a specific record in a continuous form?
The title doesn't really reflect what I am looking for. I couldn't think of a
good brief description.
Heres what I am looking for:
I have a continuous form with several thousand records.
I want to be able to be able to go to a specific letter of the alphabet (I'm
guessing I'll have A-Z in a combo box).
For instance, the user selects letter G in the combo box and the form will
go to the first record in the continuous form that starts with the letter G.
thanks in advance
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImproveF...a new drawing not erase previous drawing?
visual studio c++ 6.0, mfc, graphics
in my program a new drawing erases previous drawing. How to manage that all
that is drawn stays alive on the window? And is not erased when the window
is covered by another window, as well. And that the image does not
Those last two have from time to time appeared in my attempts to solve the
first problem. And that I didn't manage at all - make the first drawing,
then the second, see them both at the same time on the window.
I have tried the following and maybe more: Invalidate(false),
InvalidateRect(false), override OnEraseBkgnd, ...Help with Excel #2
Im new to Excel and need o do a work place shift roster. I need to put in the
shifts people work eg: E (early) L (lates) N for nights ... but i also need
these to have values eg an E is 7.5 hours a N is 12 hours ... i need this so
at the end of each week i can sum the total hours each member of staff
does... can anybody tell me how please
change ranges to suit
"Jezzer" <Jezzer@discussions.microsoft.com> wrote in message
news:A4E5DB47-DD0B-4EFE-98CA-916925ABAC6A@microsoft...Excel XP Pivot Table in Excel 2000
How do I Convert Excel XP Pivot Table in Excel 2000
...Cannot delete checkboxes from form
My forms are suddenly quite uneditable. I am only halfway through creating
them and now I cannot cut or delete anything from it. Nothing! The properties
give no hints as to why all the forms are now seemingly locked.
(As Dave Attell once said) Helpo! Helpo!
On Thu, 23 Aug 2007 07:04:01 -0700, Dr. M <DrM@discussions.microsoft.com>
>My forms are suddenly quite uneditable. I am only halfway through creating
>them and now I cannot cut or delete anything from it. Nothing! The properties
>give no hints as to why all the forms are now seemingly locked.
&g...WMP on Windows CE
We are trying to use the Windows Media Player on Windows CE R3 to play an MP3
stream from a Shoutcast server. WMA streams work fine, as do some types of
MP3 streams. But the player uses the User-Agent "Mozilla/4.0 (compatible;
MSIE 6.0; Windows NT 5.1)". Given this User-Agent string, Shoutcast servers
reply with an HTML page, not an audio stream.
Normally I'd expect the player to have a User-Agent string like
"Windows-Media-Player/12.0.7600.16415" or "NSPlayer/8.91 WMPCE/8.91.01.7741".
The CE build does not include OCX 7 controls, but it doe...RMS should provide a discount associated with payment form
Not all forms of payment are alike. Credit cards have a commision the bank
charges for us to accept it, credit has a risk implicit.
It would be very valuable for Retailers if a discount on the sale could be
associated to one or more forms of payment. I.e. if the customer pays in
cash he or she would be eligible for a special discount, because those forms
of payment does not cost the retailer any extra risk or commision.
This could be an advantage for those customers paying in that particular
form and could be used to attract this kind of consumers.
In many countries most small retailer...Changing shape
Is there a way to change shapes once they are on the screen.
I have a bunch of rectangles I would like to change to a different type of
rectangle and keep the text. Is there a way to do this without having to
cut and paste the text, delete the 1st rectangle, add the new rectangle,
reposition the rectangle and then paste the text. This would have to be
done for all the rectangles.
The only shapes that allow "changing" are the org chart shapes.
Shaun Beane, MCT, MCDBA
"Thomas Scheiderich" <email@example.com> wrote in...When saving a worksheet in excel message "document not saved"
When saving a worksheet that I use every day and changing data everyday today
I am getting a message saying "document not saved" and it will not save the
new information either through the icon or File Save as. Any suggestions what
is going wrong.
Can you save it as a new name in the same folder?
If no, can you save it as a new name in a different folder?
> When saving a worksheet that I use every day and changing data everyday today
> I am getting a message saying "document not saved" and it will not save the
> new information either th...Insertion point disappears in outline view of PPt 2007
When typing the content of my presentation in outline view, if I pause for a
second, the insertion point "disappears". If I continue to type, the new text
does not show up either in the outline or on the slide. I can click back in
the outline pane and continue but the insertion point soon disappears again -
sometimes in the middle of a word.
I provide training and support to faculty and staff at a 2-yr college and
one of my faculty members called this morning with the same issue.
I have used the outline pane extensively in multiple versions of PPt
(including 2007) a...MSCRM login and the Users Control Panel
Is anyone aware of any way that the settings stored under Control Panel -
Users - Password Management might interfere with the process of Single Sign
On into MSCRM?
It seemed to have somehow cached someones login and prevented logging in as
the logged in user, until cached credentials had been "deleted". However I
have never seen this mentioned as being relevant.
I am not too sure what the architecture model is there, but it appears to be
a single domain.
If this area has any relevance, it would be useful to know....thanks
...Printing Graphs with drawing lines added
I have a graph and I have used the drawing line to add a target. It
looks fine on the screen but when I do a print preview or print the
line goes away. I have another graph with the same type of drawing
line but it will print. I need to know what to do to get the drawing
line that is overlayed on the chart to print like my other chart.
Message posted from http://www.ExcelForum.com/
Instead of drawing a line, you can follow Jon Peltier's instructions to
add a line to a chart:
For your existing lines, it sounds...Converting Visio (2002) drawings to Autocad (R14)
I am having trouble exporting data from visio drawings to autocad. I
open the visio drawing & 'Save As' an autocad drawing (DWG). But in the
converted drawing the text is misaligned, the scaling is wrong & also
some of the data is lost. I have tried looking for a tool that
reproduces the data accurately in AutoCAD, but I haven't got a solution
yet. I realize there is no direct way to accomplish this but is there a
macro I could add to the visio drawing or change the layers/properties
in AutoCAD for accurate conversion? Is there a solution at all? Any
help would be appreciat...