A Problem with ADODB and update
i have been progrmaing in Vb Access and this script send me an error.
"the recorsert don't allow updates"
what's should i do?
it's is the script
Private Sub button_1_Click()
Dim rs As New ADODB.Recordset
rs.ActiveConnection = CurrentProject.Connection
rs.Open "Select * From example_tabla", CurrentProject.Connection,
If IsNull(box_a) Then
MsgBox "Falta seleccionar A", vbExclamation, "Formulario de
ElseIf IsNull(box...Problem replying to emails #2
I have imported emails/address book from Outlook Express into Outlook and
when I hit reply to any emails that were NOT in my address book in Outlook
Express I cannot send the message as it does not find the email address like
Outlook usually does. Is there any way around this or would I have to
manually add an email address to each contact?
Scott Ashton <email@example.com> wrote:
> I have imported emails/address book from Outlook Express into Outlook
> and when I hit reply to any emails that were NOT in my address book
> in Outlook Express I cannot sen...create sheets from data
I would like to see I can create a new sheet from souce data that we create
a new sheet from a group of data and name the sheet after the group and copy
the data into the sheet...
so the below would create 3 new sheets called a,b,c and would hold the data
against each group...
so 1 sheet would be a and hold a1 to e5 data in it...
a b c d e
1 a aa aa aa aa
2 a aa aa aa aa
3 a aa aa aa aa
4 a aa aa aa aa
5 a aa aa aa aa
6 b bbb bbb bbb bbb
7 b bbb bbb bbb bbb
8 b bbb bbb bbb bbb
9 b bbb bbb bbb bb...Formatting all sheets in a workbook to print the same
I am having trouble getting all sheets in the workbook to print the same. I
have tried selecting all sheets and setting up my header and footer, margins,
etc. But, when I then go to print preview, only the first sheet in the
workbook has held the settings.
You need to do each sheet individually, or copy the sheet that you have set
up and use it as your sheet template.
MS Excel MVP
"mreed46112" <firstname.lastname@example.org> wrote in message
> I am having trouble getting all sheets in the w...License problem, replacing users in CRM
I have CRM1.2 with the MSDN license installed, I have
tried to replace two of the users...
Removed license from user, diabled user in crm, and
removed the uesr from the OU's.. Then addes new user,
assigned the license to them..
They are not able to login and get a license error.
Anyone know what I did wrong?
Are the old users still in AD? If you delete a user from AD before removing
the CRM license, it causes big problems. You can try putting them back in
AD, with the appr rights etc, then remove the license. MS will tell you to
re-install or restore....pretty ...Print different labels on a sheet
I'm using Publisher 2000 and trying to print 4 different labels on a sheet is this possible? If so, how
A small child turns to Ed, and exclaims: "Look! Look! A post from Anita
> I'm using Publisher 2000 and trying to print 4 different labels on a
> sheet is this possible? If so, how?
It is perfectly possible. You have two options:
1) Lay out your page manually. Use appropriate Layout Guides to position
each card on the page, and design into the four card areas.
2) Use Mail Merge. Check out the Business Card...charting problem #3
I'm running Office 2000. In my chart format axis tab
there's no pulldown menu for showing the axis in
thousands. How can I get the pulldown menu.
On the the Scale tab, there should be a dropdown list for 'Display
Units'. The default is 'None' -- change it to 'Thousands'
Another way to format the numbers on the axis is to create a custom
number format --
On the Number tab, select the Custom category.
In the text box, type: #,
For more examples of custom number formats, see Jon
Peltier's web site:
http://peltiertech.com/Excel/NumberFo...Hide a sheet
Is there a way of hiding a worksheet and only allowing it to be unhidden if
a password is supplied? Or is there any other way of achieving this?
Thanks for any help!
I do believe that this might do the very thing I need - I'll test it first
thing in the morning!
"gavin" <email@example.com> wrote in message
> Is there a way of hiding a worksheet and only allowing it to be unhidden
> a password is supplied? Or is there any other way of achieving this?
&...Why are sometimes seconds not shown in cell? timestamp format problem
I have a column in Excel which contain timestamp information.
When I right click on all the cells the format is
Much to my surprise some of the cells show a value of e.g.
At first there are TWO (!) blanks between date and time.
Furthermore the seconds are not shown.
I expected (at least) "00".
Are you sure that your format wasn't
TT.MM.JJJJ hh:MM ?
If you want seconds, what happens if you change it to TT.MM.JJJJ hh:MM:ss ?
David B...Having Problems with CFile
Hello I am new at this . But CFile is giving me trouble. I got visual
studio 6 and . The CFile is in a function. that starts a file that
will be a report file. The program compiles ok, but runs and gives a
debug error and crashes help
// begin Report function
Problem is you didnt give permission to write while opening the file
(CFile::modeCreate | CFile::modeWrite).
catch th...caps problem
in some excel sheat i can't write "a" in cell. can only write the other
Does it convert to uppercase A?
If yes, I'd look at:
tools|Autocorrect Options|Autocorrect tab
and remove the autocorrect entry that changes a to A.
Yossi Cohen - RCS wrote:
> in some excel sheat i can't write "a" in cell. can only write the other
> pls help
CClientThread* pThread = (CClientThread*)
AfxBeginThread(RUNTIME_CLASS(CClientThread), THREAD_PRIORITY_NORMAL, 0,
CWinThread* AFXAPI AfxBeginThread(CRuntimeClass* pThreadClass,
int nPriority, UINT nStackSize, DWORD dwCreateFlags,
ASSERT(pThreadClass != NULL);
and gives the following error message when the program...File Properties
Is there a way to change the details in the Summary tab of the File
Properties dialog box (e.g. Title / Keywords / Comments) through using a
activeworkbook.BuiltinDocumentProperties("title") = "Test book"
(remove nothere from the email address if mailing direct)
"Andrew" <Andrew@discussions.microsoft.com> wrote in message
> Is there a way to change the details in the Summary tab of the File
> Properties dialog box (e.g. Title / Keywords / Comments) thr...horrible problem with division in Excel
I've recently purchased Office2003 and there is a horrible problem in
Excel that none of friends can help me solve. I cannot make it divide
two cells. The formula =A1/A2 is not working and returns an #ARG!
Other calculations are fine. It is just dividing that causes the
problem. I also switched off the option for "/" as Excel menu button
but it is no good.
I would greatly appreciate any suggestions for possible solutions.
Many thanks to all.
I'm not familiar with the #ARG! error - perhaps it's a Polish
By any chance do you have R1C1 referen...shape property based on other shape property
I am documenting the electrical circuits in 90 some labs. I am using Visio
2007. I have created circuit shapes with the Property Types: Circuit ID and
Phase. The Circuit Phase can be a number between 1 and 42. The Phase
corresponds with that specific number and will be A, B, or C. I want to know
how to make the Phase Property be based on the Circuit ID property.
Also, there is another type of circuit, where the circuit ID lists two
Circuit IDs. Same numbering as before, so an example might look like "2,4".
In this case, I would need the Phase Property to be A,B.
I fi...Merge - Create New Sheets
I have a worksheet with a price list on it. I also have a sheet wit
names and addresses in rows.....column names are Customer Name
Address City State
What I want to accomplish is to end up with new worksheet tabs for eac
customer name - with the Customer Name , address ect shown on eac
worksheet that contains the pricing. Hopefully that makes sense....
mpalmer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2678
View this thread: http://www.excelforum.com/showthread.php?thr...Changing a forms properties under program control
I have a form caled "frm _Main" and that form has a Sub Form called
"frm_Sub_Address" embeded in it. I am wanting to make the "frm_Sub_Address"
get its information from two different Tables depending on what info the user
wants. The two Tables are called "tbl_Stores" and "tbl_Suppliers". I know
that you will raise the question, why do I have 2 tables containing Adddress
info but putting that pointy to one side for the moment, my code is as
follows, depending on what info the user wants :-
iF user wants this info
For...4 postcards on one sheet
How do you create 4 postcards on one sheet using publisher 2003?
All the same? In page setup select postcards.
If each card is different, page setup, landscape, Arrange menu, grid guides, two
rows, two columns.
If you know the margin limitations of your printer, be certain to create your
publication within the limitation.
Mary Sauer MSFT MVP
"dns" <firstname.lastname@example.org> wrote in message
> How do you create...can't display address properties
our envirnment is exchange2k3 sp2 and outlook2k3. In outlook,open a
message,double click local domain sender/recipient, we can't get address
properties,if we double click external domain sender,it's no problem. how do
i setup it in exchange server that we can get local domain sender address
...Problem installing MS Office 2003 Pro on New Laptop
Trying to install MS Office Pro 2003 OEM (New) on New Computer using Windows
Vista Home. It should be a simple thing, right??? Can't get the software
installed. I let my nephew try it, who graduated from college recently and
has a degree in computer programing and he could not do it. The problem, he
said, is the Windows Installer needs Updated. He clams they evidently do
not know the problem exists or have not found a fix for it. I have used
computers when Windows did not exist yet and grew with Windows and have
never had a problem putting older software on ...custom list problem
Changed from Excel 2003 to Excel 2007. Excel 2007 custom lists will only let
me enter about 18 entries. I have several longer lists than that. Is there
a way I can make it accept more than 18? I tried to import my lists from the
previous version but the newer version cuts it off.
The behavior of Custom Lists is identical in 2007 compared with 2003 for
How is it stopping you from entering beyond 18 values?
"aemorri" <neaca1> wrote in message
> Changed...Exchange 5.5 OWA Questions/Problems
We are running Exchange 5.5 SP4 on a Windows 2000 SP4 server. And have
1) We run an offline backup on every other day and occasionally have
problems with the OWA not being responsive after restarting the Exchange
services. I have added the "stop and start WWW services" to the batch files
that I use to stop and restart Exchange after the offline backup. However
the problem remains. OWA will not be responsive and the WWW service will
hang in the "stopping" state. It requires a reboot to get things going
2) Ever since we upgraded...Merged Sheet & List Problem (XL2007)
I have just merged three worksheets in the the same workbook into 1
worksheet, the resulting worksheet will not allow me to use a 'Named
Range' as a list in data validation. It lets me select the type in the
'Named Range' (=list) but will not show it as a dropdown in the new
sheet. The old workbook with the separate worksheets works as expected.
Anybody any ideas?
To be great is to be misunderstood.
- Ralph Waldo Emerson
Might be that =list is referring to a named range on a sheet that no longer
exists if you deleted sheets after the merge.
Try deleting...Adding a property sheet to System Properties
Is it possible to add a property sheet to the Windows System Properties
...Attachment problem #2
When a PC user send me an email with an attachment, it
comes through fine. When a MAC user send me an email with
attachments, the attachments don't seem to come through.
There is no little paperclip next to the email in my
inbox. But I can still get them by going to file, save
attachments. I'm using W2K with OffXP.