In a simple access table, would like for FDL1and FDL 2 to auto generate
fld one is facility number (5digit)
fld two is the facility name
Table contains: field name, field number, date received, number of, number without, selection 1, option 1, selection2, option 2 ...selection 3, option3
When I can receive info with or without the facility number.......so when entering the row, I would like to be able to use the facility name from the combo box and the field number will automatically appear in the next field.
This will help to verify the correct number is assigned.
This table will intimately be used in a sub form
Help please I cannot find anyone to help figure this out. I was able to get this to work on a from, but that was a mistake to make changes on the form, because the table do not work now
Novice trying to keep her job thanks in advance
59 5409 RuralGuy 375
Recognized Expert Contributor
What value is actually recorded in the table? All that is needed is a ForeignKey from the facility table. The a query can join the two tables so you can see whatever fields you need from either table.
FACNUM FACNAME RecDate Method ENTRYDATE NumCases NUMWITHtx OHYLTR NR Total Cases Site 1 Frequency1 Site 2 Frequency2 Site 3 Frequency3 Site 4 Frequency4 Notes
RuralGuy 375
Recognized Expert Contributor
You are using a ComboBox to populate a field in this table. What is the SQL for the RowSource of the ComboBox and what are the BoundColumn and ControlSource values?
You are using a ComboBox to populate a field in this table. What is the SQL for the RowSource of the ComboBox and what are the BoundColumn and ControlSource values?
Yes I am using a ComboBox to populate the FacNum field. The SQL ( according to the access drop down is ) SELECT [surgery Services].FACNUM FROM [surgery Services];
TheRowSource is
The BoundColumn
The ControlSource value is
For the FACName field the sQL statement is SELECT [surgery Services].Field2FROM [surgeryservices]; http://bytes.com/
unable to get screen shot
RuralGuy 375
Recognized Expert Contributor
Maybe if you posted your db? Remove any sensitive data of course.
no problem how and where should i do that
RuralGuy 375
Recognized Expert Contributor
Compact and Repair your db first then zip it up. Then reply using the Post Reply button. If you scroll down you will see a Manage Attachments button. Push it and upload your db. Then Submit Reply.
rural guy am trying to do as suggested please bear with me i am in a panic
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Vladimir |
last post by:
Hello,
I have a table in MS Access database. It has one field (with BYTE datatype)
that has several properties set in Lookup tab of table Design View.
Display Control = Combo Box. Row Source Type = Value List. Row Source = "1;
"Above"; 2; "Below"; 3; "Equal"".
When I try to SELECT <field> FROM <table> in my C++ application through ADO,
I get numeric value of the field. How can I get string representation of
this numeric value from the...
|
by: Daniel |
last post by:
I use an Access database to basically take data exports, import them,
manipulate the data, and then turn them into exportable reports. I do
this using numerous macros, and queries to get the data in the format
that I need it in order to create the reports that we use. So far this
has proven to be successful for the reports that I am doing and the
data that I am pulling into it. I just have one challenge that may
require a lot of work and I...
|
by: Megan |
last post by:
I am not that good at Access and don't know much about it, so I have a
few questions for anyone who knows Access very well. First off, I
should mention that the company I work for uses Access as a Rolodex
for names, addresses, and phone numbers of clients.
Okay, first question: When I open Access and click on Enter/View
Contacts, how do I get it to open to a blank entry not the first one
on the list?
Second question: What is a Contact...
|
by: Ruben Baumann |
last post by:
Just wondered if anyone has had occasion to use, or does use, FileMaker, or
Raining Data's Omnis, or Alpha5's software, and how they compare with
Access?
Ruben
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
| |
by: Yitzak |
last post by:
Hi is there a way to run a SQL Script to Update an Access Schema.
Without using VBA code.
E.g. in mssql server I can run script like
if not exists (select * from syscolumns where name = 'newfield')
alter table mytable add column newfield varchar(10) NOT NULL
go
|
by: Robert |
last post by:
I am an attorney in a non-profit organization and a self-taught programmer.
I'm trying to create a client db that will allow me to search for potential
conflicts of interest based either on Social Security # or on Last Name.
I've created two different tables with the following fields in each table:
ClientInfo
Client# (primary key)
First Name
Middle Name
Last Name
|
by: etuncer |
last post by:
Hello All,
I have Access 2003, and am trying to build a database for my small
company. I want to be able to create a word document based on the data
entered through a form. the real question is this: can Access create
the document and place it as an OLE object to the relevant table?
Any help is greatly appreciated.
Ricky
|
by: hippomedon |
last post by:
Hello everyone,
I'm looking for some advice on whether I should break the
normalization rule. Normally, I would not consider it, but this seems
to be a special case.
I have created an "Outcomes Database" used to store response data
from measures/ questionnaires for a longitudinal health study. It is
essentially derived from Duane Hookom's Survey Database (thanks
Duane!!!), with many modifications added to fit the needs of my lab.
|
by: Les Desser |
last post by:
In article
<fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The
Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes
Thank you for that. It was very clear and I actually understand it!
|
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...
| |
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,...
|
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...
|
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,...
|
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...
|
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...
|
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...
| |
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
|
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...
| |