473,881 Members | 1,641 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using access to complete company forms

Hi all!

Happy Holidays to all!

I work for a nonprofit 501.3.c case management agency. All of the
computers have MS ACCESS database software installed. Is it possible
to recreate agency forms in access (complete with logos) and have
Access complete needed forms?

For example: We take some identifing information at the first contact.
Name, address, telephone number, ect. Could access in turn insert
some of this information into blanks on the intake documents?

I appreciate that is somewhat sketchy description of the problem, but
any help would be appreciated.

If access can do this, could you refer me to a goof primer on how to
make this happen

Thanks

Brad
Nov 12 '05 #1
1 1705
Access has something called "Forms" -- they are actually screens in which
you can enter/edit data. They need not look the same as printed forms for
you to be able to print the information entered on screen in an Access
"Report" that does replicate a printed form, with logo(s), if desired.

As for "Access completing needed forms", that would be a function of the
database application you design and create. Access can be a big help in
doing data entry...

A self-study that I recommend for the complete novice is "Microsoft Access
<versionnumbe r> Step by Step" from Microsoft Press. You can't start with an
advanced book, or you'll make the learning curve steeper.

There are superb resources available... particularly oriented to the most
recent version of Access, Access 2003, are the Access parts of Microsoft
Office Online,
http://office.microsoft.com/home/def...27011033&CTT=2.
For other links, see my user group page at http://ntaccess.tripod.com and
the FAQ at http://www.mvps.org/access.

Larry Linson
Microsoft Access MVP
"Brad L. Meyer" <br********@ij. net> wrote in message
news:69******** *************** ***@posting.goo gle.com...
Hi all!

Happy Holidays to all!

I work for a nonprofit 501.3.c case management agency. All of the
computers have MS ACCESS database software installed. Is it possible
to recreate agency forms in access (complete with logos) and have
Access complete needed forms?

For example: We take some identifing information at the first contact.
Name, address, telephone number, ect. Could access in turn insert
some of this information into blanks on the intake documents?

I appreciate that is somewhat sketchy description of the problem, but
any help would be appreciated.

If access can do this, could you refer me to a goof primer on how to
make this happen

Thanks

Brad

Nov 12 '05 #2

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

Similar topics

5
2141
by: dananrg | last post by:
I've created a small company database where the tables reside in a SQL Server database. I'm using Access 2000 forms for a front end. I've got a System DSN set-up to SQL Server and am using links within Access 2000 to get to the SQL Server tables. My forms worked fine until I made a few minor changes to the database schema on SQL Server (e.g. added a foreign key, or added a column). After that, all the links break - I click on a table...
3
19622
by: Jay Best | last post by:
Hi there The story is as follows: I write up some pretty detailed reports on people, and what I am wanting to do is speed up the process as a proportion of the reports that I am writing are quite repetitive. What I had though of was a form that you select key settings and based on that it writes out the letter in an intelligent manner: For example:
6
2004
by: Serious_Practitioner | last post by:
Good day all, and thank you in advance for your help. No - MANY thanks in advance for your help - I know nothing about using databases on Web servers. I am about to discuss a project with a client who is in the apartment rental business. He solicits "For Rent" listings from property owners and managers, advertises the apartments, shows them, takes applications and like that. His inventory, as it were, is a list of vacant apartments that...
1
1857
by: TK | last post by:
What's the best way to implement roll-base access control with forms authentication? I have a IIS6+ASP.NET server which hosts some ASP.NET web applications as separated path that's like "/app1/default.aspx", "/app2/default.aspx", .... and a single logon page as "/logon/logon.aspx" for forms authentication. I've already implemented "single sign-on" structure for those web applications and it's working fine. No one who didn't logged on...
2
1379
by: Jason L James | last post by:
Hi all, I am trying to browse a table in my MS Access DB from a web form, using a bound datagrid. The DB is populated, and the grid in on the web form. When I execute the following code: daDrawings.Fill(DsDrawings1.tblDrawing) daIssue.Fill(DsDrawings1.tblIssue)
45
2744
by: Luvin lunch | last post by:
Hi, I'm new to Access and have been asked to develop a simple Access system to replace one that already exists. There are five users of the current Access system and each of the users works off a copy of the system on their local machines. I would like to develop my new system as a multi-user system and place it on a server to be accessed remotely by each of the users. I have read that the locking in MS Access can be hellish. Most...
2
2000
by: MyEmailList | last post by:
We have an Access data base with severl tables, queries and forms. We want to put it on the web. Is there a tool that will convert the Access queries and forms to ASP? Sorta like "splitting" the database... but instead of an Access Front End... have an ASP front end? Thanks for any help.
3
7831
by: Adamowski | last post by:
Hello, I am currently using Access 2007 on an XP laptop. I have a table and a form used to add records to the table. I have noticed that if I close the form without filling out all of the information in the form, the form data is still written to the table as a record. Since the person using this form may have to unexpectedly close the form, how can I disable this functionality? I do not want incomplete records being saved to the table....
3
2116
by: damola | last post by:
Good day everyone Please how can i prevent access to certain forms in ms access database 2007. i want it to be in such a way that when i enter user login,it automatically detects the forms the user has access to and the ones the user doesn't have access to it will say access denied thanks for your help
0
9928
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
9776
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,...
0
11100
Oralloy
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...
0
10402
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
9555
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...
0
7111
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
5781
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...
0
5977
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3225
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.