INI file perhaps? - Microsoft Access / VBA

Mark

All,
there has recently been a re-structure of out network drive at work
which has highlighted quite a few flaws in my coding. I am no expert but am
learning as I go. Throughout the code within the database, there are many
references to network folders and files. I have had to go through all the
code to updates these values to reflect the recent change.

I was hoping that somehow, I could create a text file with these paths
listed. This way, I would only have to ammend the text file rather than
ploughing through pages of code.

Could anyone offer any advice on the best way to do this???

TIA,

Mark

Jan 25 '06 #1

Subscribe Reply

1469

Larry Linson

You can certainly save settings in an INI file. You can also save them in
the Registry. You could save them in a text file, or you could store them in
a table in the database itself.

And, if you didn't realize it, there is some reliable, well-tested code for
using Windows APIs at http://www.mvps.org/access -- a site which is a superb
source of Access information. One that I use often... not in every database
I create, but in many: is the API001 entry on using the Windows Common
Dialog from VB/VBA code to let the user browse for a file.

I can't remember if there are examples of the "ProfileStr ing" and
"PrivateProfile String" APIs for dealing with INIs. There are native VBA
commands/builtin functions for writing to and retrieving from the Registry.

Larry Linson
Microsoft Access MVP
"Mark" <ma*********@nt lworld.com> wrote in message
news:ua******** ********@newsfe 2-win.ntli.net...

All,
there has recently been a re-structure of out network drive at work
which has highlighted quite a few flaws in my coding. I am no expert but
am learning as I go. Throughout the code within the database, there are
many references to network folders and files. I have had to go through all
the code to updates these values to reflect the recent change.

I was hoping that somehow, I could create a text file with these paths
listed. This way, I would only have to ammend the text file rather than
ploughing through pages of code.

Could anyone offer any advice on the best way to do this???

TIA,

Mark

Jan 25 '06 #2

Tom van Stiphout

On Wed, 25 Jan 2006 08:07:01 GMT, "Larry Linson"
<bo*****@localh ost.not> wrote:

The VBA functions are GetSetting and SaveSetting.
-Tom.
<clip>

I can't remember if there are examples of the "ProfileStr ing" and
"PrivateProfil eString" APIs for dealing with INIs. There are native VBA
commands/builtin functions for writing to and retrieving from the Registry.

<clip>

Jan 25 '06 #3

Similar topics

5548

Encrypted File Transfer

by: Philipp Brune | last post by:

Hi all, the following problem occured to me and I hope somebody can help me : I need to implement an encrypted File download with a PHP script on the server side and a c# client application. I know there is a way to symmetrically encrypt files with the php mcrypt routines and already did implement a

PHP

1463

Injecting information into signed file

by: wschaub | last post by:

We need to inject information (i.e. server details from where a signed file was downloaded) into a signed file, without breaking the signature or integrity of a signed file. Apparently there are areas and ways to inject custom information into signed files, however, we cannot find the "how to". It is needed to inject server source when customer downloads signed files from a site, allowing the downloaded file to query the information and...

.NET Framework

32307

How do I check if a file is empty in C??

by: wetherbean | last post by:

Hi group..I am writing a playlist management protocol where I have a file that holds all the playlists and a file that holds all the songs....before a playlist is created I need to check to see if the playlist file is empty so that I can assign an integer value to a playlist id field if it is the first playlist being written to the file....can anyone help?? Thanks in advance wetherbean

C / C++

49065

Fastest way to search text file for string

by: Julie | last post by:

What is the *fastest* way in .NET to search large on-disk text files (100+ MB) for a given string. The files are unindexed and unsorted, and for the purposes of my immediate requirements, can't be indexed/sorted. I don't want to load the entire file into physical memory, memory-mapped files are ok (and preferred). Speed/performance is a requirement -- the target is to locate the string in 10 seconds or less for a 100 MB file. The...

C# / C Sharp

1231

Perhaps an XML file might do this trick?

by: Stephajn Craig | last post by:

I've got an application that many supervisors are going to use. However, each one needs to see a different part of the information. Some supervisors will all have the same view of the information with the same fields showing. Others have variations on those fields to see. The idea is that when an error is made in a certain business process, a log entry of it would be made. The department responsible would have its supervisor notified...

ASP.NET

1136

Bug reporting impossible

by: Nick Maclaren | last post by:

Currently logins are disabled to sourceforge.net, and (despite the comments) it won't let me report a bug anonymously. Does anyone know whether this is short or long term? I have a bug in 2.5 to report - which has been there for a while and isn't overwhelmingly critical and has been there for a while. Create a file called '<stdin>' in your current directory containing 'print "Oh, yeah?\n"' and then import a module that doesn't exist....

Python

3543

URGENT: window.open does not render server-side code when aspx file pulled from a resource file

by: Bob Jones | last post by:

Here is my situation: I have an aspx file stored in a resource file. All of the C# code is written inline via <script runat="server"tags. Let's call this page B. I also have page A that contains some javascript code that calls window.open. I pass the resource url of page B to Page A's window.open call. Page B is then loaded and executed but none of the server-side code is rendered. If I view the source of the page, the code (and page...

ASP.NET

3532

No. of 'a' in a text file

by: ume$h | last post by:

/* I wrote the following program to calculate no. of 'a' in the file c:/1.txt but it fails to give appropriate result. What is wrong with it? */ #include"stdio.h" int main(void) { FILE *f; char ch; long int a=0;

C / C++

185

7007

Getting the file name from a FILE *

by: jacob navia | last post by:

Hi We are rewriting the libc for the 64 bit version of lcc-win and we have added a new field in the FILE structure: char *FileName; fopen() will save the file name and an accessor function will return the file name given a FILE *. Questions: What would be the best name for this function?

C / C++

14935

How to play a sound from an embedded resource file? (.resx file)?

by: raylopez99 | last post by:

I have the latest version of Visual Studio 2008 Professional, which allows you to create resource files (this is the .resx file, no?), unlike the Express version, which does not. I am trying to cut and paste code that MSDN recommends for playing a simple wav file from inside an embedded file, like presumeably the 'resources' file .resx is. I want to embed the .wav file in a 'resource file' since I don't want the user storing the file on...

C# / C Sharp

8462

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

8382

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

8893

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8802

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

8586

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8658

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

4206

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

4384

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2028

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP