changing code by code - Microsoft Access / VBA

Maercker Michael

hi y'all!

i want to implement a few macros to help me do my coding; when calling a
macro: how i can i find out in which module i'm currently in; at which
position and what text i have selected. it's gotta be possible somehow, but
the screen-objekt really isn't of much help. can anyone help me?

thanks in advance!

mike maercker

Nov 12 '05 #1

Subscribe Reply

1727

Jeffrey R. Bailey

I don't know about macros. You might be able to use them to run code you
write. But if you are up to coding, you need to set a reference to the
'Microsoft Visual Basic for Applications Extensibility 5.3'. It provides
the interface for modifying/returning information about code modules.

The CodePane object returns information about the code/module being viewed
in the IDE. CodePane.CodeMo dule property will tell you which module is
being viewed in the in the IDE. Using the CodePane's GetSelection method you
can retrieve information about the currently selected text.

The CodeModule object allows to locate, identify, modify lines of code in a
particular module.

I have not checked to see what kind of documentation Microsoft has on
programming using the IDE object. You can use the object browser to look at
it and retrieve information about its object model, properties and methods.
Some Wrox Publishing books contain reference information about the IDE
object. The "Excel 2000 VBA Programmer's Reference" does and it is what 1st
introduced me the IDE object. I don't have my copy handy ( it is packed
away) so I just used the object browser to search out the information above.

--
Jeffrey R. Bailey
"Maercker Michael" <nc*********@ne tcologne.de> wrote in message
news:bl******** **@newsreader2. netcologne.de.. .

hi y'all!

i want to implement a few macros to help me do my coding; when calling a
macro: how i can i find out in which module i'm currently in; at which
position and what text i have selected. it's gotta be possible somehow, but the screen-objekt really isn't of much help. can anyone help me?

thanks in advance!

mike maercker

Nov 12 '05 #2

What version of Access are you using?
If 97, IMHO an add in is the easiest way to accomplish this.

If 2000/2002, an add-in is the easiest way too, but its a completely
different beast, best built in VB.

I have some code examples for both, what version are you using?
"Maercker Michael" <nc*********@ne tcologne.de> wrote in message
news:bl******** **@newsreader2. netcologne.de.. .

hi y'all!

i want to implement a few macros to help me do my coding; when calling a
macro: how i can i find out in which module i'm currently in; at which
position and what text i have selected. it's gotta be possible somehow, but the screen-objekt really isn't of much help. can anyone help me?

thanks in advance!

mike maercker

Nov 12 '05 #3

Similar topics

2041

How to maintain scroll-region view while changing canvas size?

by: syed_saqib_ali | last post by:

Please take a look at and run the code snippet shown below. It creates a canvas with vertical & Horizontal scroll-bars. If you shrink the window to smaller than the area of the canvas, the scroll-bars work as advertised. That's great. However, if you click the Left Mouse button, it calls code which expands the width of the canvas by 100 pixels. The area being viewed expands correspondingly..... BUT I DON'T WANT IT TO!!

Python

1725

Changing value of node

by: Urs Vogel | last post by:

Hi When using XmlDocument, I can create nodes and attributes as I like. What I didn't achieve is changing the Value of a node (created with createElement), it claims that it's the wrong node type. When changing the InnerText, I loose all child nodes. When cloning the node and reassigning the child nodes of the original node to the cloned node, the children are not visilble in the InnerXml. To make it simple. How do I change the value...

.NET Framework

3026

changing field names

by: Michael | last post by:

Hi everyone, I am trying to change the field names for a table that is being exported via Excel. Its a spreadsheet that our National Office sends us but even after promise after promise they keep changing the field names which makes it nearly impossible to run any pre-generated queries etc. The solution really is to get someone to check the field names before importing the spreadsheet but I want to do it in code. I have written

Microsoft Access / VBA

5268

HOWTO: Iterate thru dataset rows changing field values

by: Dan Sikorsky | last post by:

How do you iterate thru a dataset to change money fields to a different value? Here's what I have. My dataset is filled directly from a stored procedure. ' Create Instance of Connection and Command Object Dim myConnection As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) Dim myCommand As New SqlDataAdapter("OrdersList", myConnection)

Visual Basic .NET

2978

How to preserve the old font properties while changing new one?

by: Sakharam Phapale | last post by:

Hi All, How to preserve the old font properties while changing new one? I posted same question 2 months back, but I had very small time then. eg. "Shopping for" is a text in RichTextBox and already formatted as "Shopping" ---Bold "for" -----Regular Now I want to underline whole text by preserving old style i.e. Bold and

Visual Basic .NET

3702

Programmatically changing RecordSource - too risky?

by: deko | last post by:

I have a popup form with a textbox that is bound to a memo field. I've been warned about memo fields so I'm wondering if I should use this code. Is there any risk with changing the form's RecordSource like this? Am I asking for trouble doing this with a memo field? Thanks in advance. Private Sub cmdNextNote_Click() Dim lngNid As Long If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord

Microsoft Access / VBA

4555

Changing page bgcolor from code (repost)

by: GaryDean | last post by:

In the original post I failed so indicate that I am using framework 1.1....... I need to be able to change the background color of a page from code. I found an answer to this question in another forum from Peter Huang that said that an id="bg" as follows... <body MS_POSITIONING="GridLayout" runat="server" id="bg"> then we could do the following in our codebehind file....

ASP.NET

2214

help with changing C light bulb (regulars please read)

by: Chris Hills | last post by:

A lesson in Posting How many C.L.C group posters does it take to change a C light bulb? 1 to change the light bulb and to post that the light bulb has been changed 14 to share similar experiences of changing light bulbs and how the light bulb could have been changed differently

C / C++

2398

Changing the execution path of methods at runtime

by: blufox | last post by:

Hi All, Can i change the execution path of methods in my process at runtime? e.g a()->b()->c()->d()->e() Now, i want execution to be altered at runtime as -

C / C++

1592

Changing Stored Procedures

by: Darkside12 | last post by:

Hi, I'm trying to build a dynamic query by form. The idea is that a user can select a table in the database via a combo box and this will then change all of the text box labels on the form to match the field headers for the selected table. It also hides any text boxes that are surplus to the number of fields of the selected table. The user can then add their search criteria into the text boxes and search the selected table. To achieve...

Microsoft Access / VBA

9716

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9596

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10360

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10105

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7646

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6876

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5542

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4323

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3007

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General