473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Global Fields In Access

Hi all:

I develop in both FileMaker Pro and Access. FileMaker has a global
field type, whereby the value of the gfield is the same for all
records.

Is there an equivalent in MS Access (2002)?

I don't want to set a variable in VB, since the value of the global
will change and requires input from the user.

Thanks!
===
Nov 12 '05 #1
3 3210
You can place a Const statement in the declaration part of a standard module.
Examples:
Const conAge As Integer = 34
Const conWage As Currency = 35000

conAge and conWage can then be used anywhere in your application.

BTW, do you have a website?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...
Hi all:

I develop in both FileMaker Pro and Access. FileMaker has a global
field type, whereby the value of the gfield is the same for all
records.

Is there an equivalent in MS Access (2002)?

I don't want to set a variable in VB, since the value of the global
will change and requires input from the user.

Thanks!
===

Nov 12 '05 #2
On 12 Jan 2004 09:14:27 -0800, am*******@verizon.net (amywolfie) wrote:
Hi all:

I develop in both FileMaker Pro and Access. FileMaker has a global
field type, whereby the value of the gfield is the same for all
records.

Is there an equivalent in MS Access (2002)?

I don't want to set a variable in VB, since the value of the global
will change and requires input from the user.

Thanks!
===


No. The way this requirement is usually handled in Access is to have a
separate table that is only allowed to contain one row, and put the fields in
there. For the forms that interact with this table, set Allow Additions and
Allow Deletions both to false.
Nov 12 '05 #3
am*******@verizon.net (amywolfie) wrote in message news:<33**************************@posting.google. com>...
Hi all:

I develop in both FileMaker Pro and Access. FileMaker has a global
field type, whereby the value of the gfield is the same for all
records.

Is there an equivalent in MS Access (2002)?

I don't want to set a variable in VB, since the value of the global
will change and requires input from the user.

Thanks!
===


If you need to keep the value of the what would be the global field in
Access, you would have to write the value to either a table or to a
custom field, which you could retrieve as needed. Probably easier to
use the method Steve suggested, though. One way to change the value
is to let the user enter it in a form, validate it, and then write it
to the table. If you're going to just use the global field like an
accumulator variable or a counter, as you would if you were doing
loops in FileMaker, then you could just declare a variable in your
subroutine in VB.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Julian | last post by:
Hi I have code in my login.asp which sets the online field in user database to true or 1. I am trying to use the same code in global.asa to change back the online field to 0 but it doesn't work....
3
by: Dalan | last post by:
I need some assistance or advise in composing code for a global function module or a related one for populating values in text boxes on reports and forms with a name, actually several different...
19
by: laurenq uantrell | last post by:
I'm using Access 2K. I'm hoping someone can tell me which method performs faster- (currently I'm using a mix of both methods) a.) creating custom properties and then calling functions to set and...
25
by: Sahil Malik [MVP] | last post by:
So here's a rather simple question. Say in an ASP.NET application, I wish to share common constants as static variables in global.asax (I know there's web.config bla bla .. but lets just say I...
15
by: randyr | last post by:
I am developing an asp.net app based on a previous asp application. in the asp applications global.asa file I had several <object id="id" runat="server" scope="scope" class="comclass"> tags for...
4
by: RoadRunner | last post by:
Hi, I have a question. I am asked to produce a global search of a given corporate name, in more that one database. Each database has different table names and different field names in the tables....
5
by: tech.rawsteak | last post by:
I have a function that retrieves a user's login name from their workstation and looks it up on an employee table to return their full name (ie: jsmith -John Smith). Their full name is then...
5
by: simon.robin.jackson | last post by:
This requires a table called tblReplace with two text fields, old and new. Code: On Error Resume Next Dim db As DAO.Database Dim td As DAO.TableDef Dim f As DAO.Field Set db = CurrentDb
1
by: Web Search Store | last post by:
Hello, Is there a place I can put a class of global variables and have them available in the page_load routine? Here is a class: Public Class globalvar Public ddd As String = "howdy"
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.