Using access to complete company forms

Brad L. Meyer

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

Subscribe Reply

1701

Larry Linson

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

Similar topics

2139

Problem using Access 2000 as a front-end to SQL Server 2000 tables

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

Microsoft SQL Server

19616

Using Access to write customised form letters

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:

Microsoft Access / VBA

1998

Using Access/Jet on Web site

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

Microsoft Access / VBA

1853

Roll-base access control with Forms authentication?

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

ASP.NET

1373

MS Access and Web Forms

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)

Visual Basic .NET

2727

Using Access for a multi user system

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

Microsoft Access / VBA

1997

Tool for converting Access Queries & Forms to ASP for Web ?

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.

ASP / Active Server Pages

7827

Disable how Access automatically saves forms into table...

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

Microsoft Access / VBA

2110

How to prevent access to certain forms in ms access database 2007?

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

Microsoft Access / VBA

9639

What is ONU?

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

General

9479

Changing the language in Windows 10

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,...

Windows Server

10311

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

8967

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

7492

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

5378

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

5509

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3639

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2874

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