Runtime Code - Microsoft Access / VBA

Can someone advise if there is code that i should avoid when writing a
database that will be packaged using Runtime.
thanks in advance
dd

Nov 12 '05 #1

Subscribe Reply

1501

Allen Browne

Hi David

It's not difficult, but some of the issues are:

1. Don't use macros. If anything goes wrong, your application will close
(which to the user looks like a crash) because macros have no error
handling. Use error handling in every routine. If you need to use a macro,
it should contain only the RunCode action, which passes control to a
procedure that does have error handling.

2. Don't try to open forms/reports in design view. That also means Filter By
Form is not available. Using an MDE catches this anyway.

3. If you code for different printers, PrtMip etc won't help.

4. Use fonts that will be on the target system such as Arial and MS Sans
Serif. Although it is possible to specify fonts in the installation package,
doing so confuses users if the font is already on the target system (e.g.
when they re-install).

5. If you split (shared back end, local front end), be sure to included code
that verifies the data file on start up. You may choose NOT to install the
data file by default (i.e. user has to copy it to desired location) so that
a) it does not get installed multiple times for different users, and b) it
does not get overwritten in a re-install.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DD" <da**********@b igpond.com.au> wrote in message
news:14******** *************** ***@posting.goo gle.com...

Can someone advise if there is code that i should avoid when writing a
database that will be packaged using Runtime.
thanks in advance
dd

Nov 12 '05 #2

Trevor Best

Allen Browne wrote:

5. If you split (shared back end, local front end), be sure to included code
that verifies the data file on start up. You may choose NOT to install the
data file by default (i.e. user has to copy it to desired location) so that
a) it does not get installed multiple times for different users, and b) it
does not get overwritten in a re-install.

One thing to consider is a separate install just for the tables rather
than having the tables and/or code as an option as in most cases the
installation will be mutually exclusive.

Nov 12 '05 #3

Similar topics

1301

System DLLs runtime checking

by: jon morgan | last post by:

Hi, I am trying to clean out all the VB specific code in a project before porting to C#. Having removed all the import references I still see the VB runtime is loaded at startup. How can I pin down what is actually causing the VB runtime still to load? Thanks for any help.

.NET Framework

15111

Access Runtime and Security

by: Nathan Bloom | last post by:

Hi, I have a secured database that runs fine on the computer the database is installed on. I have several workstations with access runtime installed that also need access to the database. Access runtime runs fine when accessing an unsecured version of the database. However once the database was secured it generates a runtime error after asking for the user and password and won't open. The shortcut to the secured database is: "path...

Microsoft Access / VBA

1564

A2KReportSpecs.mde as reference in XP runtime

by: Bob Darlington | last post by:

I've got the Stephen Lebans Report Utilities add in as a reference (A2KReportSpecs.mde ) so that I can export Access 2002 reports to rft instead of Snapshots. It works fine in my app in both mdb and mde formats. When I create an XP Runtime, I can't get it to work with the mde. If I create a runtime using the mdb (which I won't distribute for security reasons), it works fine. I presume it is a referencing problem, but how do I get around...

Microsoft Access / VBA

6724

Dynamic runtime controls, postbacks, Page_Init, Viewstate et al

by: Chuck Ritzke | last post by:

Hi, I've searched the newsgroup and other sources to understand how to handle runtime controls and see I'm not the only one who's confused, but I'm still not quite sure of the best way to handle from all the various explanations/answers. I'm attempting the typical scenario... I create a variable number of controls at runtime based on parameters from a database.

ASP.NET

10564

Idiomatic way to change web service endpoint at runtime.

by: Andy | last post by:

If I use Visual Studio.Net 2003 to generate "web references" for clients using either sproxy.exe (for C++) client or wsdl.exe (for C#) clients, the web service endpoint gets "baked" into the generated code, making it difficult, if not impossible, to change the server that the client connects to at runtime. e.g. sproxy.exe generated code that looks like this ... static const _soapmap __CCluProvider_GetCertificate_atlsoapheader_map = {

.NET Framework

755

Can't use System.Runtime.Remoting.Channels.Http in WebService?

by: Kirk | last post by:

I'm trying to use a Web Service to be a Remoting client of an existing ..NET 2.0 server. But I get the following error when I try to use System.Runtime.Remoting.Channels.Http in my WebService. The same code works fine in a standalone app. I have inspected System.Runtime.Remoting.dll with ildasm, and I can see the ....Channels.Http namespace there. I verified that the virtual directory is configured to use v2.0.50727 (the error message...

.NET Framework

3230

DISP_E_BADVARTYPE error at runtime

by: zfraile | last post by:

I'm getting this error from the JIT compiler at runtime, but only on my boss' machine, not my development machine. I believe the error is generated from a call to an Excel object, but I can't tell why or what specific action on the object is causing it. We both are running version 2.0 of the .net framework with Office 2003 installed, though I am running XP and she has Win2000. Also, I do not get this error when running another sub in...

Visual Basic .NET

5418

Compile time vs runtime?

by: desktop | last post by:

I have read that using templates makes types know at compile time and using inheritance the types are first decided at runtime. The use of pointers and casts also indicates that the types will first be know at runtime. But is there some strict definitions that defines runtime code and compile time code that can be used in general?

C / C++

7659

Access 2007 Runtime on Machine With Older Version?

by: Neil | last post by:

A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running Office 2003 to be able to run the database. While I use multiple versions of Access on my...

Microsoft Access / VBA

8443

MSI error 1638 from depending on VC runtime

by: Norman Diamond | last post by:

A project depends on VC runtime from Visual Studio 2005 SP1, and DotNet Framework 2. Options are set in the setup project properties, so if these two dependencies are not already installed then this installer will install them. But what about the situation where VC runtime has already been installed? In fact it's been installed twice. Although the project was built on a Windows XP system with Visual Studio 2005 SP1 and the results were...

.NET Framework

8861

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++

8778

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

8549

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

8636

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

7375

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6187

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

5660

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

2764

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

1759

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