Access :: Guidance Needed For A Text Database Project Please

Basic MS Access With VBA Project Guidance Please

Dec 28, 2005

Hi everyone,

First off sorry for jumping in and asking questions on my first post. I have been searching the net templates and answers and while it has got me so far I still cant find specifics I'm stuck on and would appreciate any help.

I have an access design project to do for uni. To give you some background I've done some VBA programming in excel and have a good grasp of office and windows but haven't really used access before.

I have got Ms Access Inside out (bit over my head) and Ms Access Step by Step and have been working through their tutorials which have helped my understanding of access but dont arnt really specific enough to my project (or maybe i'm missing something)

The Brief is as follows:

"You have been instructed to design and develop and information system to capture students module choices for the business school. The system will run on MS Access and be supported by programs written in visual basic. Spec is as follows:

The system should be designed so that students can automatically select their options for semester 1 and 2 from a screen which will indicate to them whether they have broken any of the following constraints:
-> choose 30 credits in both first and second semester
-> business 2 cannot be selected unless Business 1 is
-> Programming 2 cannot be selected unless programming 1 is
-> Decision making and Data analysis share topics so students cant do both
-> Bus Finance and Corp Finance share topics so students cant do both

There is a table with 7 module options for each semester and their credit weight, either 10 or 20.
The outline is deliberately vague, 20% of marks will be for supplementary features that will enhance the systems functionality and usability.

------------------
Based on the examples I have worked through, I see it like a basic ordering system:

3 tables

Customers (Students)
Products (Modules)
Orders (Chosen Modules)

I need a database that will let me input customer information (that I can do)

Then allow me to Create an order for the customer Using a form that lists the products available from the products table

When Creating the order, with the form, rules need to be enforced to ensure the order is valid (ie certain products are not chosen together, the products value adds up to 30 for semester 1 and 2).

Once the order is complete a report is generated to show the products ordered (modules chosen)

Is this the right way to look at the database design?

I see the module choice form as having all the modules listed and tick boxes, however the only order forms I have managed to find have drop downs, any pointers here?

Am I right in thinking it would be VBA that will allow me to set and enforce the rules on module selection? If so any pointers on how?

Is there a way to get VBA to validate the inputs on the order form in real time, eg grey out one selection if another is selected, not allow more module to be ticked than 30 credits. I guess the code can be looped to do this? or is it easier to check the inputs after ok is pressed then give a warning box if its incorrect.

Again apologies for coming in on my first post and asking a torrent of probably basic questions, but I have tried my books and the net and would appreciate any guidance

Kind Regards, tom999

View 1 Replies View Related

Access Novice Taking On Large Project - Need Guidance

Feb 13, 2008

Greetings Access Geniuses,

I am currently in the midst of conversation over at utteraccess.com about a large database project I am working on.

I will post the most recent updates here, but if you want to download the database for your own review, you'll have to go over to the other forum. By the way, this is NOT an advertisement. I am a real person with a real, significant, and immediate need of as much assistance as possible for this project.

Before I go on, a few things about me. Though I am in the legal profession, my technological background is very strong, including a high level of proficiency with MS Office apps with the exception of Access. I know my way around the program (the result of its homogeneity with the rest of Office), but have not made a real database in the past. I also do not know any programming languages.

I have recently indulged in an Access crash course of sorts, including some book and online study on things like planning, design, and normalization, but I am still having difficulty wrapping my head around making it work.

That said, the link to the other discussion is: [W W W DOT]utteraccess.[ADD DOT COM]/forums/showflat.php?Cat=&Number=1590364&page=0&view=collapsed&sb=5&o=&fpart=all&vc=1

Feel free to gloss over it to see how things have progressed. Below is a paste of my most recent substantive post. Any help anyone can give me is of great value to me and I really, really appreciate it.
_____________________

Hi Everyone,

Attached is the most updated version of my database project for your review. I have also attached a sample of the output we would like to have for each product. This sample is not based on actual data, but it clearly shows what we are trying to achieve via a form of some sort. More on this in a minute.

The following changes have been made to the DB:

-Changed tblTrustProspectusVersion to include the appropriate data, based on our business model.
-Added descriptions to all non-PK fields.
-Created relationships to illustrate how things fit together. Note that these are NOT the actual relationships, but are for illustrative purposes to help everyone here (including myself) further understand how things fit together.

Our Business:

I am part of my company's legal department. Our team handles a number of different things primarily associated with Securities and Exchange Commission (SEC). filings. We have two major product lines. Everything that happens with one in this DB happens with the other as well.

Each product within a product line has certain features and other necessary information we need to see when doing our filings (see the attached sample output). These features and necessities include, but are not limited to, various statuses, various numbers associated with the SEC, various important dates, etc.

In addition, each product has a certain "fund lineup" associated with it. These funds are made up of two components: the name of the fund (aka "portfolio") and the name of the subadvisor to that fund.

Futher, each of these funds is associated with a certain Trust. The SEC requires us to send prospectuses to clients based on these Trusts, which, as I mentioned, are comprised of the said funds.

Basically, we need to be able to select a product from a drop-down list and have all of the aforementioned information populate instantly.

Before I close, one question with respect to my "tblProductFeatures". Like I mentioned, each product has a certain set of features associated with it. Each feature has a certain fee associated with it. These features come in four basic categories: Living Benefits + fees, Death Benefits + fees; Maintenance fees (just short list of the possible fees); and 12b-1 fees (another short list of fees).

Since the features can be so easily broken down, should I add them to their own tables?

Please consider this as you give your advice on how to acheive my desired goal.

I hope this makes sense.

And again, thank you all so very much for your help thus far.

Best,

Gilbert

View 12 Replies View Related

Help With Project Needed.

May 31, 2006

Ok, well basically i am trying to write my own database. and i have not the a very good working knowlage of access and some many bits that are over my head, Would any of you guys be willing to help me out with this?
I would be willing to pay someone to do this, if you could give me prices per hour ether here if permited. or via Private Message.
for comunication purposes i could use skype or msn messanger. as there will probably be some bits i would need to explain. I am a little bit of a perfectionist so i would try and explain as clearly as i can as to what i want. there is no desparate rush on this project altho july would be great, one of my friends was meant to be helping do this as he is good with access but i have been waiting for him to do this for about 6 months.

Thanks

Shrew

View 10 Replies View Related

University Project - Help Needed

Nov 6, 2005

Hi, im making a database for one of my modules this year and im having some trouble getting it off the ground.

Would anyone be willing to take a look at it and basically tell me areas where im going wrong or suggest areas for improvement?

(The database im making is for Students who will be going on workplacement soon and needs to store all their information, the employers details, and a list of the mentors who will be looking after the students and wroking with them while on placement)

View 7 Replies View Related

Access Admin/Contractor Needed, Easy Project.

Jun 27, 2005

Hey i need some one that knows Access to help with a work Database, and just make sure everything is working and set properly.

This is for a Construction Managment Company.

Email me at *email removed* for more info, and i can send out the DB to be looked at.

Thanks

Kevin Maguire
President
GOT LOCAL MUSIC

View 1 Replies View Related

Project Database

May 4, 2007

Hi all

I have extensively searched the forum to try and find an answer.

Im trying to develop a Project tracker database which will track the progress of my ongoing projects, does anyone out there have an example or another link to get me started.

I know MS Project would be the answer but we do not ned it in as much detail as this and they definately want it written in MS Access.

Many thanks for any help

View 4 Replies View Related

Database Project Help

Jan 20, 2008

I am in need of assistance in producing a database. The database is simply a "log" or "record" which i need to work in the following ways:

> a user enters a password to log onto there own little area of which they can fill out forms asking thing such as: how many hours done, what they have done etc.

> an administrator can then log on and look at everyones accounts and print off reports etc.

I have had ago at this and made some progress but i am very stuck so any help is greatly appreciated.

Thankyou!

View 7 Replies View Related

Help With A Database Project!

Oct 9, 2005

I'm having a problem that I have been trying to sovle for a while.

I have two tables. What I want to do is to have the user tick a box in one of the fields on table 1 and for it to mirror that change on table 2 in a specified field. I really don't know how to go about doing this. Any ideas? :confused:

Thanks Guys

Andy

View 1 Replies View Related

Create EXE From Database And Have Several Project Using Same Database

Oct 24, 2013

I created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.

the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.

Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?

I was thinking to create a VB code for the database to delete all data on the tables when the database is open.
and before closing the database exporting all the data to a txt file or something.

Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.

This way we can have several txt file for several project and use always the same exe database.

View 4 Replies View Related

Tables :: Project Name To Be Text Data Type

Jul 23, 2013

In my database I have the following:

1)Projects table:
- Project ID - Number field (Primary Key)
- Project Name
- Location
- (other fields)

2)Working details: (this table has a form based on it and it's used to enter data by users)
- Project ID (this field has a lookup for the same field in the first table)
- Project Name (this field has a lookup for the same field in the first table)
- (other fields)

My problem is : in the second table, Project Name field has "Number" data type because the relationship between the table is on the Project ID which is number field. I want the Project Name to be "text" data type in the second table.

How can i do that??

View 3 Replies View Related

Help With Project Manhours Database

Feb 15, 2005

Hello. This might sound silly but I am totally lost and confused. I have been given an assignment to create a Project Mahours database. This is a place where the project managers can go in pull up information about an employee from a list box or combo box it then pops open a subform that has all the projects and manhours by percents this employee is working during any given week. I was thinking that I could use cascading Comboboxes to pull the employee information and the week information but unsure how to do that since they are on two separate forms. Also, they would like to have each week calculated for a total of time to equal a total of 100% of time.

The would also like to do this with the Projects where is lists what employees are working on each project and for how many hours each week.

They would also like to query the information and print reports to be taken into meetings for an overview. Eventually they would like to use the database as a way to do a cost analysis of what to charge the client for with regards to manhours on the job. There is a lot and the file is 4MB and attached.

You can see that I have created 5 tables and a couple of forms - one of the forms is complete data entry but I have no clue how I did that. And I have not made any subforms because it is all very confusing to me. I am unsure if my relationships are okay and I can't seem to get a query to work by pulling information from 2 tables. Please if you can help, I am in desparate need of it. Thank you.

View 1 Replies View Related

Access 'project' Versus 'database'

Apr 5, 2005

I seem to be missing an understanding of the difference between a project and a database. I am using a .mdb and writing code with success until I try to use the recordset feature which I took from my "VBA programming" book.

My code is simple...

Dim db As Database
Dim rec As Recordset
Dim strSQL As String
Dim intCount As Integer
Dim listEmails As String

strSQL = "SELECT Email from Member"

db = CurrentDb()
rec = db.OpenRecordset(strSQL, dbOpenSnapshot)

Do Until rec.EOF
listEmails = listEmails & Chr$(10) & rec(Email)
Loop

rec.Close

MsgBox listEmails

But when I run it I get a compile error because in line 1 the term 'database' is only a class in "a project".

Can anyone explain the issue and better still the solution.

Thanks

Phill

View 1 Replies View Related

Changing A Desktop Database To A Access Project

Dec 17, 2007

I built a database application, and I need for more than just myself to use it at the same time. I have just learned that I should have built a project instead. Can I change my application "Maintenance.mdb" to a project or do I have to start over?

View 5 Replies View Related

Connect An Access Project With A Remote MDB Or SQL Server Database

Jan 28, 2007

Hi,

I am finishing an Access database for a customer that may want, in a later stage, to have a website(probably ASP) that would connect on the same database. Is that possible? I mean can an Access project on a pc connect to remote database(mdb or SQL server) used by the website?

If so can you give me some quick steps to do so or a good article on it?

Thanks.

View 6 Replies View Related

Modules & VBA :: Database Project - Update Entire Column Of Subform

Oct 31, 2013

I am working on a database project where I will Select a record on a subform

See the picture attached.

I know that using DAO recordset, i can update the checkbox one by one, but it become way too long when I have thousands of record...

May I know if there is a way to Select entire column of the subform?

View 1 Replies View Related

How Do I Complete This Project? Need A Few Answers To Finish DB Project.

Apr 25, 2005

I have tables and forms setup but I have 3 general questions on how to finish the project.

1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?

2. How do I get the form to launch as a self-contained form without the Access application in the background?

3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?

4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.

View 5 Replies View Related

Needs Some Guidance

Nov 5, 2007

Working on a database that tracks codes, descriptions etc.

One of the items they would like is a 'change' report.

On this report, they would like it too list 2 things. They would like it to list if any entries that refer to a expired edit type (determined by the end date field).
Then if the code was updated to a new edit type it would display this too.

So the report would look something like this.

If the code that refers to a expired edit type, and has no update it would say
code# removed <then list the edit type that expired>

or

If a new entry for that code was created with a new edit type, it would say something like

Code# Changed from <old edit type> to <new edit type>

Is this possible?
I'm not even sure how to visualize it, so hard time moving forward with it.

View 3 Replies View Related

General Guidance

Sep 25, 2005

I need to be pointed in the right direction if you don't mind. I understand underlying database structures pretty well, but I am not sure how to create a form in Access so the user can enter new data. I am tring to create a form based off of the classes table first and then go from there. I was hoping to be able to allow the end user the ability to enter all information from one form.

I have attached the relationship structure that I have setup but I am not sure where I need to go next. Should I create queries and then insert the queries to my form?

Thanks for help
Steve

View 4 Replies View Related

Design And Query Guidance Please

Dec 1, 2006

I have two tables in my database.

Table 1 contains telephone numbers and rates per minute
Table 2 also contains telephone numbers and rates per minute

I am trying to check the rates in one table against the other.

The problem I have is that the telephone numbers in each table are of differing lengths.

For example ......
Table 1 contains telephone number 01234 567890
Table 2 contains a rate for numbers starting 01234 5

I have split the numbers in Table 1 in to 0, 01, 0123, 01234, 012345, 0123456, 01234567, 012345678, 0123456789 and 01234567890 but I am stck on how I can now use this to match to data in Table 2.

In 'words' I would like the database to 'say' ...

0 in Table 1 - Is there a match in Table 2, if so what is the rate? If not then look for .....
01 in Table 1 - Is there a match in Table 2, if so what is the rate? If not then look for .....
012 in Table 1 - Is there a match in Table 2, if so what is the rate? If not then look for .....
0123 in Table 1 - Is there a match in Table 2, if so what is the rate? If not then look for .....
01234 in Table 1 - Is there a match in Table 2, if so what is the rate? If not then look for .....
012345 in Table 1 - Is there a match in Table 2, if so what is the rate? If not then look for .....

etc etc etc ....

The numbers in Table 2 are varying in length.

Can anyone provide guidance on database design and / or help with writing queries ?

Many thanks !

View 2 Replies View Related

Guidance On Backend/Frontend

Apr 18, 2007

A simple personal database created by me is to be deployed on a home network having two PCs. I did splitting to FE and BE. The BE shows only tables. I would like to have the guidance of experts in this forum for the following:
1. Whether BE to be copied first in the host PC?
2. FE to be copied in the other PC?
3. After copying the Access DB how to link FE and BE between the two PCs?
4. Whether data entry, edit, search etc. possible from both the PCs?
5. If I test with dummy records, how do I delete dummy records, from BE or FE?
Shall be grateful for help.

View 2 Replies View Related

Soliciting Expert Guidance

Jun 20, 2006

Good Morning,
I am new to Access and I welcome expert guidance on the relationships of my database. The database will be used to track employee training and although I've enjoyed limited success so far I'm hoping that eventually I'll get it right.

The database has to do just a few things so it doesn't have to be very complicated. It basically has to store employee, training event, and completed training event information. The attachment shows the tables and their relationships.

The are basically two types of training that the database needs to store. The first is training that applies to everyone and the other is training that only applies to certain job specialties. These types of training are identified by the ProjectMandatoryCode and the JobCode respectively.

The ProjectMandatoryCode is a default value that is automatically entered everytime a new employee is entered into the database (EmployeeInfo table) and it is also a default value when a training event is entered into the (TrainingEventInfo table) that applies to everyone. The employee JobCode is a selection when a new employee is entered into the EmployeeInfo table.

When the user wants to enter a training event that is job specific, they are able to select a JobCode from a combo box/option group and this code is written to the record. Selecting one button from the option group writes a default value (ProjectMandatoryCode) to the TrainingEventInfo table while selecting the other button enables the combo box so that a specific JobCode can be entered against the event.

Everything works fine except... so far I've been unable to produce a report that lists every training event that pertains to the employee whether it be ProjectMandatoryCode or JobCode related. I can query and produce completed events or a list of what events are required but nothing that is complete. Ideally, I should be able to produce a complete training plan for the employee which shows all necessary events and where the employee has completed the task I should be able to show the DateCompleted.

This failure has led me to doubt my table relationships since all my efforts at various query joins have failed. Is there anyone who could enlighten me so that I could learn from this, complete this task, and apply this new knowledge to future databases? To the person with the answer, thank you in advance for your assistance. Respectfully,
Dale Gagnon

View 5 Replies View Related

Noob Need Search Guidance

Dec 11, 2007

Hey everyone,
I'm new to access, I have been using Excel for quite a while and I am familiar with VB and macros.

I have never been much of a book learner, mostly hands on, which means a lot of reverse engineering to figure out why/how things work.

I have a scenario, and found a DB that had some functionality that I liked and I had reverse engineered it to do a lot of what I want.

Where I need some guidance:

1. on my opening form (Clients) I would like to be able to type in Client Number and have it return the correct info.

2. in my Who Has It is there a way to do data validation (or dropdown box) I mean I only want them to be able to enter valid names not crazy stuff like MickeyMouse.

Thanks a bunch!

View 5 Replies View Related

Text Import Assistance Needed

Jul 12, 2006

I am attempting to import a comma delimited text file into access into a predefined table. On a regular basis I have been dumping them into the table this report is generating the error "Records could not be added to the exceptions Table" every time I try to import. After this occurs I then get an error invalid argument after every subsequent attempt until I restart access.

The comma delimited file equates to 1 million records with 16 columns in access. I have not been running into the problem until now. I have looked around and information is scarce on this issue.

Does anyone know a way around this or how to fix it.

View 3 Replies View Related

Help Needed With Database

Jan 6, 2006

I have constructed a seven table database for dealing with holiday cottages.

The seven tables are:

Bookings
Cottages
Customers
Ratings
Owners
Regions
Sales Reps

I have created the 7 tables and created the primary keys (BookingID,CottageID,CustomerID,RatingsID,OwnersID ,RegionsID,RepID)

The ratings table because cottages come under different ratings (Family, Sporting etc..).

I need to create a form which

*Adds a new booking, and also adds the new customers details
*Checks the avalibility of the cottage for the chosen week
*allows the user to choose a rating from a combo box, which then filters the cottages availible for selection in that category.

If anyone could help me with this I would be very grateful, I have emailed my lecturer but he is not replying and the assignment needs to be in on the 12th!

View 5 Replies View Related

Help Needed On Database

Mar 17, 2007

While searching for Access help through Google, I found your forum which has greatly helped me in building my database in Access. I got all answers through your forum for many of my doubts and �How To�s. I thank all the members for their excellent and simple way of explaining for a novice like me.

As to the Database I built, it is almost complete and working fine. I have built a switchboard with menu choices. I have distributed this to all my colleagues and they are using fine.

I have three problems still to be addressed. I have tried to protect my database tables, forms etc through the security wizard, user permissions etc. But nothing is working. I have hidden all tables, forms etc. and unclicked the �Display database window� in Startup so that only the switchboard is visible. I have also changed the switchboard properties to cover the entire screen and no maximize/minimize/close button. When a user double-clicks the desktop icon the database file opens with the switchboard menu. There is an Exit button in the switchboard which the user can click to he can click the close button of the Access window. Apart from this, the user can do nothing to corrupt the tables, forms etc., so I believed. However, one colleague clicked the �View � Design View� in the Access menu bar and the Switchboard became ready for modification. Is there a method to block the View � Design View� option in the Access menu bar?

My second problem is that we want a new database file first of January every year. Is there a method to create a new DB file with the same table, form and settings from within Switchboard? (The only option I found was to copy the DB file to another location, delete all records and rename it for the new year). Is there any other procedure?

My third problem is that I designed a Crosstab Query as given in the Help menu with criteria LIKE �*� & [Enter any character to search by: ] & �*� but when I execute the query it displays all records containing the character entered. This is not what I want. My search criteria everytime changes (it is text based). So I am unable to save Query form with a specific criteria as it will execute only defined parameters. Is there a way to make Query form where any user input (i.e. any word or number) is taken for search?

Shall be grateful for reply.

View 5 Replies View Related