VBA code to say Yes or No if any VBA code is present in ActiveWork
Using XL 2003 & 97
Would like hit Ctrl+Shift+V and have an answer either yes or no as to the
presence of Any VBA code in the Active Workbook.
I do know that about the VBA editor/Explorer or to press the Run Macro
button and get a list from various sources .
I would like to stay at the keyboard and process a series of macros
including one to let me know if I even need to evoke the VBA explorer.
There is no bootstrap macro to tell you whether you have macros
or not. If there were there would be no limit to virus writers.
David McRitchie, Microsoft MVP - Excel ...SQL Not Working
What is wrong with this SQL? I am trying to use a Median function and trying
to have the median calculate for each JobCode.
SELECT tEmployeeMasterCopy.JobCode, (SELECT
Median("tEmployeeMasterCopy","HourlyRate") FROM tEmployeeMasterCopy as M1
WHERE M1.JobCode = tEmployeeMasterCopy.JobCode) AS MedianByJobCode
GROUP BY tEmployeeMasterCopy.JobCode;
Thanks in advance.
It seems that
FROM tEmployeeMasterCopy as M1
WHERE M1.JobCode = tEmployeeMasterCopy.JobCode)
...Can I make child frame dock to main frame in MDI?
I have a question.
I want to make child frame dock to main frame without maximization in MDI.
For example, in Visual Studio 2008's case, Class View pane is splitted
between classes and member functions.
But, CSplitterWnd works on CFrameWnd. right?
So, I guess Class View pane in Visual Studio 2008 is a CFrameWnd.
Then, I don't know how to make child frame dock to main frame.
On Feb 1, 11:22=A0am, MuMbi <Mu...@discussions.microsoft.com> wrote:
> I have a question.
> I want to make child frame dock to main frame without max...Use VBA to update Access table or Query from Excel
Can I use VBA to update Access table or Query from Excel?
Thanks in advance
> Can I use VBA to update Access table or Query from Excel?
Of course, using ADO or DAO.
Jan Karel Pieterse
Thanks. I think ADO is what I want.
But I am not only want to export from excel to access.
I want to edit some data in access table.
For example, Access has a table "ProductList"
I want to use Excel to call the product by "Pro...Hyperlinks that I recieve in e-mails don't work in outlook 2003
LMT <LMT@discussions.microsoft.com> wrote:
Ask your question in the body of the message, not the subject.
If you're using Internet Explorer, try this: click Tools>Internet
Options>Programs>Reset Web Settings
"Brian Tillman" wrote
Thanks Brian worked great.
> LMT <LMT@discussions.microsoft.com> wrote:
> Ask your question in the body of the message, not the subject.
> If you're using Internet Explorer, try this: click Tools>Internet
> Options>...Print, Merged Cells, and VBA
I'm looking for a code that will help me with a print job
for a worksheet. There are a lot of merged cells and a
lot of "IF"s to be used in the VBA for range selection.
Thanks in advance,
...Access 2007 closes without updating recordsource
If I change the recordsource for a form using the query design grid in
Access 2007, and then click on the top "X" to immediately attempt to close
Access, a popup asks if I wish to save the changes to the recordset. If I
select "Yes", the pop-up closes, and Access itself closes, but the changes
in the recordsource are not saved.
If I change the recordsoure, then close the query design window, clicking
"Yes" to accept the changes to the recordsource, I return to the design view
of the form. If I then click to immediately attempt to close Access, t...VBA and Scheduled task in Outlook
Hi, how can I:
a) pull the query from somewhere and send it by e-mail automatically. E.g. I
want to take a temperature table from
where 2009/7/10 is the date of yesterday put it into an e-mail and send it
automatically each day at 8 o'clock?
b) if this is not possible, how can I send an e-mail with the attachment
c:\Documents\query20090710.xls each day at 8 o'clock?
my boss wants this automatized, I know how to write the VBA code for Excel,
but don'...2007 search not working with Vista with new profile
It stopped working after I deleted my mail profile and started from scratch
again. Who would have guessed doing that would break the search feature? I
thought maybe it was indexing, but this is even after indexing has finished.
Take any word from any subject line in any message and put that same word
into the search box and it doesn't find the message.
Using Vista with Outlook 2007 with Exchange 2003.
Also the desktop search no longer looks inside my emails.
Is there a cheat to make Outlook 2007 use the old simple search feature we
love/hate from Outlook 2003 and befor...vba select field
having a button on a form, is it possible to select only some fields
(all from the same table) of the current record instead of all fields?
I've tried this code:
Forse dipende dei dati nel record.
but it selects ALL fields in the form.
On 10.04.2010 18:01, remigio wrote:
> having a button on a form, is it possible to select only some fields
> (all from the same table) of the current record instead of all fields?
> I've tried this code:
> RunCommand acCmdSelectRecord
&...MS Access and Sql Server
I am new to SQL server and am having some problems with Access and
connecting to it. I have read so many articles but have found not one
that spells it out in pure english! Hoping someone can help?
OK, I just built a new machine, bought all sorts of software, and now
I am ready to go. I have previously been just using MS Access 2003 /
2007 but now I want to store my tables and quarys in SQL Server. I
have SQL server 2008 and 2005, I also have visual studio 2008 along
with my MS access 2003 / 2007. So far I cannot get a file to connect
to my SQL Server. How on earth does o...JTDS support for shared memory access
Can anyone tell me if JTDS supports shared memory access?
I would like to access the DB with TCP and Named Pipe DISABLED
Appreciate your replies. Thanks!
Posted via DevelopmentNow.com Groups
On 2010-03-12 2:48, xbluewho wrote:
> Can anyone tell me if JTDS supports shared memory access?
No, it doesn't.
> I would like to access the DB with TCP and Named Pipe DISABLED
Then you're out of luck. jTDS requires at least one of those.
...VLOOKUP in VBA
On the worksheet I can insert in a cell
=VLOOKUP(C5, Hobokee.xls!AcsLow, 2)
and it works perfectly, looks up the value in column 2 of the range named
AcsLow in the same workbook.
But elswhere I want in a macro to lookup the same table and assign the
result to a variable BalAmt.
BalAmt = VLOOKUP(AccNum, Hobokee.xls!AcsLow, 2) does not work.
It gives a function not defined error on Hobokee. If instead of Hobokee I
put Workbooks("Hobokee"), it gives function not defined error for VLOOKUP
which it changes to VLookup.
I have been overVLOOKUP in the Help file and see nothing wrong.
W...Who want to make friends with me?
I would like to know some foreigners increased their friends circle. And
I have been the same person can add interest to me Oh, but I accept all
First to introduce myself, I come from China, 18 years old. Get to know
the purpose of foreign friends to practice their English
Hopes to have increased!
...Excel VBA/Macro programming for beginners
I know a bit VB 6.0 programming. Will it help me to write exce
vba/macro(same thing?).can anybody help me by providing some fre
websites where i can have informations/codes for VBA/macro.
Please tell me how could i make a *command Button * in a cell in th
sdebu_2000's Profile: http://www.officehelp.in/member.php?userid=430
View this thread: http://www.officehelp.in/showthread.php?t=118812
Posted from - http://www.officehelp.i
Try David McRitchie's "getting started with mac...Making a Logarithmic Graph
I'm somewhat of a newbie in terms of using MFC and I'm continuing work
on a project that already has a linear graph class. What I need to do
is implement a logarithmic graph.
I know that there is no short-cut for making graphs with MFC and that's
why the linear graph class draws everything manually. I would like to
know how anybody here would proceed to achieve this.
I have a basic idea of how the scale might be made but considering the
pre-existing graphing architecture that allows the user to rescale the
linear graph. Jumping into this seems overwelming considering all the
p...Turn pc speaker on/off with vba code
Is this possible?
I found something here on how to do it withVBScript. You can probably modify
it to work in VBA
> Is this possible?
I'll have a go
(I need to improve my web searching skills)
"Barb Reinhardt" wrote:
> I found something here on how to do it withVBScript. You can probably modify
> it to work in VBA
> ...Loading a Form from VBA
Hi all, I'd like a module to open and load a form in my Access 2003
database... How can I do this?
Use the OpenForm method. Look in the Help file for details.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Mike" <firstname.lastname@example.org> wrote in message
> Hi all, I'd like a module to open and load a form in my Access 2003
> database... How can I do this?
On Jul 18, 10:58 am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com&g...Publisher 2007 "working folder"
How do I set a new "working folder" in Pub 07? There are no "File Locations"
settings under "Options" as there have been in past versions for opening and
saving files somewhere other than My Documents. It's a real pain to
constantly have to navigate through 3 folders every time I want to open or
save a project.
It isn't an option in 2007.
A workaround, File, save as, navigate to the folder you want as default,
right-click the "Look in:" task pane, add the folder.
Mary Sauer MSFT MVP
http://msaue...Excel and VBA
I am very interested in learning more about using VBA in office, especially
Excel. Can you post some resources (online, books, etc) that can be used to
help learn about using Visual Basic in office.
Here's a good place to start:
Does that help?
"Bob Sinclair" wrote:
> I am very interested in learning more about using VBA in office, especially
> Excel. Can you post some resources (online, books, etc) that can be used to
> help learn about using Visual Basic in office.
>...Cannot Access Email Contacts
I have been running Office 2007 and Outlook 2007 on an XP Pro system that
was fully up to date for about 6 months on an old 3GZ single processor
system with 2GB of RAM. I decided to upgrade to a Duo processor about 3
weeks ago and to move upgrade to Windows 7. For the upgrade I choose to use
the Windows Easy Transfer program to setup all my accounts. Since moving to
the new system I have been unable to connect my Contacts to my email system
in Outlook 2007. If I select NEW email and then click on the TO: and type
in a name to search for the email address it gives me an...Form Controls vs VBA controls
I am new to VBA so just finding my feet, can anyone help me with th
differences between an excel control (i.e. one from the form toolbox
lets say a checkBox and a vba checkBox?
From trying the two controls the I have noticed is that you canno
capture the change event of the VBA checkbox in the code module, it ha
to be done via the sheet (i.e. checkbox on sheet1, code goes in chang
event on sheet1) the control is placed on, is this correct? What woul
you do if you have three sheets with the same controls just differen
data, do you really have to code the control 3 times?
The excel control ho...Making a wizard
I have a table with several lookup fields to other tables. E.g. the Course_Details has a Venue field combo box that looks up the ID from the Venue table. I can not save the Course_Details record until the venue field is populated. However sometimes I may not yet have added the venue. Therefore my idea is to create a series of forms that work like a wizard, the first would ask to select the venue form the dropdown but if it didn�t exist you would click a button to open another form and create it.The problem I have is that when I move onto the next stage of the wizard (because I have not yet sa...Run VBA without show
I want excel to run the VBA code without showing me what it is doing.
Which code should i use for that?
Application.ScreenUpdating = False
'Paste the vba code here
'end of code
'Change screenupdating property to true
Application.ScreenUpdating = True
I hope this helps...
Selva V Pasupathy
For more on Excel, VBA, & other Resources
Please visit: http://socko.wordpress.com
You may also
(inserting into quote from code example bellow from Socko)
Use Application.Visible property to hide the application entirely
Is there a way to get the name of the current company through VBA in Great
Thanks for all your help.
open GreatPlains. Add the current window, it will add the
Toolbar then add fields choose the company name on the
top left after the user id.
>Is there a way to get the name of the current company
through VBA in Great
>Thanks for all your help.
Thanks. I tried, but I couldn't add company name to the field list. It opens
up the login screen instead.
Any thoughts? Thanks again.