473,799 Members | 2,665 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to structure an access database

16 New Member
i have a combobox from table( specialization)

and i have a reports from table (managers)

the combobox name is( combo1)

the selections in the combo box are
managersjob
governorsjob
presedentsjob
employeesjob

the reports i want to open are
mj
gj
pj
ej

now i want to select managersjob from the combobox then the report mj open and when i select governorsjob the report gj opens and so on
what is the code? and remeber that the combox and the reports i want to open r from adifferent tables in the same db, so any one has an answer?
Oct 13 '09
21 2568
NeoPa
32,579 Recognized Expert Moderator MVP
I believe our karate is also Shotokan, but the licenses are in the bedroom and I don't want to disturb anyone upstairs this late.

I have stopped karate training now, but I still intend to keep fit and flexible as much as possible.

Very good luck with your training for the Black-Belt. It is something you can forever be proud of when you get it.
Oct 29 '09 #21
NeoPa
32,579 Recognized Expert Moderator MVP
A new thread (Access Security) has been split off from this one as it is a separate, unrelated question (although by the same OP).
Nov 8 '09 #22

Sign in to post your reply or Sign up for a free account.

Similar topics

24
4209
by: Michael Malinsky | last post by:
I'm attempting to create a database which will take information from one (perhaps two) tables and utilize that information to return queries to a report designed in Excel. The general idea I have is this: The "primary" or "source" table is easy. This is a trial balance (account number as a primary key, description, amount). I'll need table(s) to denote which account numbers belong to which
3
387
by: Douglas Buchanan | last post by:
Newbie to donnet This is an example of a structure given in vs.net help ============================ Private Structure Employee Public GivenName As String ' This employee's given name. Public FamilyName As String ' This employee's family name. Public Extension As Long ' This employee's telephone extension. Private Salary As Decimal ' This employee's annual salary.
0
1821
by: Oliver Elphick | last post by:
The attached proposal is written primarily for Debian. Its motivation is that the current package upgrade process is pretty flaky and also that the current packaging does not really provide for multiple simultaneous postmasters, which are wanted by people hosting several database clusters. I assume these proposals may also be of interest to Red Hat packagers. I am copying it to the PostgreSQL list in case there are any obvious...
3
3796
by: Michael Gill | last post by:
How can I hide all details from users regarding data and structure, limiting access to data through functions I create? I don't want a user to be able to see the structure of a table with \d {tablename} in psql. TIA
2
1614
by: Travis Pupkin | last post by:
Hi, I made a copy of an Access 2000 database to do some dev work on it which involved fixing a few bad data types and adding a few columns to a couple of tables. Meanwhile the original database has been continuously used and had its data updated. Is there a utility that can synchronize the two database files by
4
9944
by: jtdavies | last post by:
How can I take an existing Access database and document its structure? I want to show fields, relationships, and indexes so that a real DBA could recreate the database from scratch.
0
1416
by: [Yosi] | last post by:
I want to access a function implemented in a C-dll with the following data prototype: //// TS - Test Structure typedef struct _T_TestStructure { char Name ; int TestId; } T_TestStructure;
3
1286
by: Doug Bell | last post by:
Hi I am putting together a functional specification in preparation for writing a VB Dot Net upgrade an existing Access (VBA) and VB system. It is currently a tiered system with an IBM AS400 providing a DB2 Database. There are 5 or 6 of sites and each site has 2 to 6 PCs (involved in this system). One PC on each site acts as an application server and sub database server, ie it is an MS Access Application that is scheduled to run approx...
2
1475
by: David | last post by:
Hi all, using 1.1 I am creating a dynamic menu structure for my site, however, I may refer to the structure many times within a page. This would be fine if I was doing it all in the codebehind of the page, but I am trying to create seperate tiers for seperate areas. The menu structure I suppose is a middle tier... The menu is built using a recursive function to build the tree. My page
5
4471
by: Sergio Montero | last post by:
I have a MustInherits Base class that implements a custom IDataLayer interfase. IDataLayer expose CRUD methods. Base class constructor requires two parameters: ConnectionString TableName Another assembly, sharing the root namespace, contains a set of Custom attributes used to validate properties values, just like the Validation Application Block.
0
9689
marktang
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...
0
10269
jinu1996
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...
0
10032
tracyyun
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...
0
9085
agi2029
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...
1
7573
isladogs
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...
0
6811
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();...
0
5597
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3764
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2942
bsmnconsultancy
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...

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.