Please Help Structuring Db For Future Expansion

Jan 12, 2007

first thing's first... i've never set up a Access db. I have, however, worked with php/mysql so I understand dbs and the basic principles behind them.
i was hoping you could help me set up my db to accomplish my goals now and help me in the future when i want to make this system more advanced.

the purpose of the database is to track the 'stages' of several different projects as well as keep account of which contacts are involved.

example

I have projects A, B, C
I have contacts I, II, III
the stages of the projects are 1, 2, 3

I already have these tables (projects, contaces, stages)

the first issue is, i dont know how to assign mutltiple contacts for specific projects
i.e. project A involves I, II, and III while project B only involves I and III. I would like a form to have a listbox with all the contacts in it and i could hold ctrl and select mutiple contacts for a specific project

the second issue... i would like to db to store dates of when a specific project moves from stage 1 to stage 2 for instance. i know i can set up fields in the projects table for these, but what happens when i add a new stage? will i need to go into the projects table and add a new field? can i make this dynamic?


i hope this makes sense to you. if you could give me direction, i would greatly appreciate it. before doing something that i will regret later, i hope you can give me some tips based on your experiences.

thanks in advance.

View Replies


ADVERTISEMENT

Form Expansion

Feb 1, 2006

I'm using DoCmd.Maximise on open, I've also got rid of the toolbar, Windows min/max buttons and the close button no longer work. However I still have my taskbar and the bar that you get at the top of all your windows in Windows which contains the program name or in this case the form name (the bar that the min/max/close buttons are on). How do I get rid of these? Cheers :))))

View 1 Replies View Related

Help With Basic Structuring

Oct 3, 2005

I will try and be as concise as I can...

I am trying to create a database for our organization that will keep track of our "Gift Fund". I have a table with all of our personnel that includes all of their basic info with a customer ID field as the PK. I then have a table that is for all of the transactions. Deposits, withdrawls, description, date, customer ID to relate the two tables and transaction ID as the PK.

So we have a table with our personnel and a table to record transactions. Transactions occur anytime we put money in or take money out as well as when one of our personnel becomes a member of this fund by paying their "dues".

I have created a form to update our personnel table. It works fine. I also have a form to enter basic transactions. It also works fine. My problem lies where I try to make a form that will add a member to this fund (which in the personnel table is a yes/no checkbox) at the same time entering this as a transaction. Ideally the form would have the user pick personnel from a drop down list, click the yes/no checkbox making them a member and then entering their "dues" as a transaction.

Ultimately I would like to be able present this info in several dif reports showing all the silly statistics that boss' love to see.

Any help would be appreciated and if I have left out any key info, let me knw and I will be more specific.

View 2 Replies View Related

Structuring Table Relations!!

Aug 9, 2007

Hi all,

I built a database and I was wondering if anyone has any suggestions on how to normalize my DB. I think my table relations are wrong.

I'll post my DB for you people to view.
18354

Any Help will be appreciated

View 5 Replies View Related

Hypothetical: Structuring A Sm/med Business' Data Infrastructure...

Jul 28, 2006

Hello,

I am fishing for advice on what systems people would recommend...

Currently, our system breaks down like this:


We use Peach Tree (old version - sucks) for accounting (this is where my question will kick in)
We use a rudimentary database I built for contact/prospect management (I intend for the above to become much more advanced as I learn, something more than "rudimentary as soon as possible)
We are incorporating a new phone system that will allow us to track may things and incorporate into our database (as far as area code reports, things like that as to track advertising effectiveness in specific areas


My question is this:

To eventually get to the point of having a fairly seamless infrastructure, what accounting software would you all recommend? Being able to integrate with an access interface is vital. We will likely get to the point soon where we hire someone to build a database so as my responsibilities will shift to more of a maintenance role, with support, rather than design...

This is a company that is built on paper, not a huge one yet, but decent size, and we want electronic info to increase efficiency...

I am looking into suggestions for a 20 - 40 person company. Currently, I am starting to look into MAS 90, and would love to get some insight.

Thanks!!!

View 3 Replies View Related

Future Version Of Access

Oct 17, 2005

When will Access support the .Net framework?

Will Microsoft ever consider making another RAD program similar to Access that supports the .Net framework?

Just think of an IDE of a RAD program similar to Access that has a full set of toolbox items already built in .Net that supports all of the functions / options that Access currently supports in its forms, reporting etc. and have the ability to interface with all of the .Net database engines... :cool:

View 2 Replies View Related

Calculate Future Dates

Feb 2, 2006

Help Help Help - I have a database which I need to calculate a date 3 years from now, then report on it 6 months before the 3 years expires...

Hope that makes sense

Fay1136:confused:

View 9 Replies View Related

Expression For Future Date

Dec 30, 2006

Could someone please help.

I have to fields in a form for a membership database that I want to relate to each other, 'date joined' and 'expires on'.

I have been trying to build an expression in the 'expires on' field that calculates the date which would be 12 months from the date entered in the 'date joined' field.

Can anyone please point me in the right direction.

Thanks

Adrian

View 9 Replies View Related

Finding Dates In The Future

Oct 12, 2005

I have a table that holds the info on our fleet of company vehicles. One of the fields in the table is called ServiceDueDate. I want to be able to set up a query that shows any vehicles that have a service due in the next 30 days.

I know I'll need to use DLookup in there as well as Date - 30 but not sure exactly how to write the query.

Any help would be greatly appreciated.

View 3 Replies View Related

Query By Future Paydays

Aug 18, 2006

I have a table of checking transactions. Some are past, some from today, and some are dated with future dates (such as recurring payments).
Is there a way to set up a query that will exclude transactions that occur after upcoming paydays (1st and 15th) dynamically? For instance, if I have a transaction scheduled for the 2nd of next month (after payday on the 1st) I'd like to be able to separate it from the transactions that are coming out of this payday.
Thanks for your help.

View 1 Replies View Related

Calculate Future Date

Mar 1, 2006

Hi, All...

Can someone tell me how to calculate a future date in a bound field on a form? The form includes "date created", "life expectancy" and "review date" fields, all bound to the same table. I want the "review date" to be calculated by adding the "life expectancy" (number field, in days) to the "date created" field. I found some posts that were similar but none using bound fields.

Thanx so much for you help with this...I've spent quite a lot of time trying to come-up with a solution...to no avail.

Thanx ;<)
Karen

View 2 Replies View Related

ASP, Access, And Future Dates

Oct 25, 2005

I'd like to create a recordset from an Access database that reads the 'Date' field and only selects dates in the past. That way I can enter info ahead of time, give it a date of a week from now, and know it won't show up on my pages until next week.

It should be simple, but what I have isn't working. Here is my code:

Query = "SELECT Id, Date, Info FROM OldNews WHERE DateDiff('d', Date, date()) <= 365 ORDER BY Date DESC"

It lists all the records that are 365 days old, but it still shows any future dates as well.

Does anyone have a better idea?

Thanks!

View 4 Replies View Related

Link To Future Spreadsheet Tabs

Dec 14, 2007

It's easy enough to link to someone else's Excel spreadsheet and get their data into my Access database but I have to do it each month. They create a new tab each month (OCT-2007,NOV-2007,DEC-2007) for the month and the spreadsheets always have the same structure.

Is there anyway to tell my database to go out and look to see if the new spreadsheet has been created and if it has then import the data?

View 2 Replies View Related

Query Based On Future Paydays

Aug 18, 2006

I have a table of checking transactions. Some are past, some from today, and some are dated with future dates (such as recurring payments).
Is there a way to set up a query that will exclude transactions that occur after upcoming paydays (1st and 15th) dynamically? For instance, if I have a transaction scheduled for the 2nd of next month (after payday on the 1st) I'd like to be able to separate it from the transactions that are coming out of this payday.
Thanks for your help.

View 3 Replies View Related

Future Modifications To BackEnd Database

Sep 15, 2006

I've created a database to track my client information. I've split it into front end and back end databases. Everything there works fine so far.

I have other co-workers who track their own clients who I will be giving this database to. So we will soon have the same database with completely different data stored in them.

If I want to make changes in the future, I should easily be able to change the front end, get them a copy to install, and all should be well.

But what if I want to make changes to the backend? Like if I decide I want to track some completely new data in a separate table on the backend. I won't have the ability to just go out to the central server and change 1 backend database. There may be 10 identically structured backends on 10 different machines that all need the new table added to them, without effecting their unique data in the existing tables.

So, assuming my explaination made sense, is there a way to make backend changes like I'll need to? Or would I have to go to each backend database and manually make the changes?

View 3 Replies View Related

Forms :: Preventing Future Date Use

Nov 26, 2014

I have a form for the user to enter new units which arrive in our warehouse, one field in DOM (Date of manufacture) which cannot be a date in the future obviously but could be todays' date. there is table level input mask to make the date 00/00/0000.i have this code on the form:

Private Sub dom_BeforeUpdate(Cancel As Integer)
If Me.DOM > Date Then
MsgBox "Please enter a Valid DOM", vbInformation, "Check again !!"
Cancel = True
End If
End Sub

which doesn't accept any date whether it's today, last week, last year or in the future!

View 3 Replies View Related

Tables :: Structuring Categories And Sub Categories

Dec 27, 2012

Suppose I receive boxes and store them in a room. Each box can contain items that are either shaped as cubes or spheres and I have to allow for the addition of more shapes in the future, but only one shape can be in each box. Each box contains a random number of shapes and two boxes may, or may not, contain the same number of shapes as another.Cubes can be either Red or Green, Spheres can be either Blue or Yellow.

I wish to set, and have the ability to change, how many cubes and how many spheres, on a percentage basis, I wish to have (e.g., 60% Cubes and 40% spheres).I also wish to set, and have the ability to change, what percentage of cubes I want to be Red and Green and which percentage of Spheres I wish to be Blue and Yellow (e.g., Cubes -Red 70%, Yellow 30% )

e.g. -- I have several boxes totaling:

Cubes
Red 30
Green 40

Spheres
Blue 10
Yellow 20

My goal is to produce three reports.The first report would provide the Target and Actual number of Cubes and Spheres expressed as a Value and %. The #'s would simply be calculated from my desired % . So, if I wanted to have 60% cubes and I had 100 Shapes, my target # would be 60. If I had 200 Shapes it would be 120. (i.e., The actual number of shapes I have is simply a factor of how many I receive and I have no control over this.)

The First Report would look like this

Target % - Actual % - Target # - Actual #

Cubes 60% 70% 60 70
Spheres 40% 30% 40 30

The second and third reports would be the same format but would break down cubes into red and green and spheres into blue and yellow.I can accomplish the Report that breaks down the shapes but I am running into problems with the next level as I need the total number of shapes and the the total number of only Cubes or Spheres to insert into the expressions.

View 2 Replies View Related

Converting From Access 2003 To Future Versions

Aug 26, 2005

I've been hired to clean up and convert a flat filemaker database into access 2003 and I've spent the last two weeks learning the ins and outs of access and doing preparations. Well, today some high up database guy in another department told me not to use access because in the future when a new version of access comes out we will have to recreate the database from scratch because there are lots of problems converting between versions. I'm aware there might be some hiccups but I don't really agree with him. Plus once the database is up and functioning I don't see why we'd even have to upgrade it to a new version. It's just a small health centre patient database with info about patients and their treatments. Does anyone have any opinions about this. Thanks.

View 3 Replies View Related

Future Date - Taking W/e & Holidays Into Account

Feb 22, 2007

Hey all,

I'm designing a query that must calculate a future date based on a recorded date. Unfortunately it's not as simple as just using adddate (unless I was using Excel!). Here's my requirements:

Future Date = [StartDate] + 45 business days

I am able to take weekends into account, but haven't been able to figure out how to bring holidays into the equation. I have an existing holidays table that I am using for another query within the database (calculates # of business days between 2 existing dates).

Hope this makes sense... I've been staring at it all day so I may not be thinking clearly anymore.

Any help is greatly appreciated.

View 1 Replies View Related

Calculate Future Dates Based On Inputs

Jun 14, 2007

Hello,

Was wondering if it is possible to create a query or another method that would calculate future dates based on inputted info ?

For example a person inputs on a form a date completed (06/14/07) and then also selects a frequency of when this has to be revisited....monthly, quarterly, semi-annually.

So based on the date completed that the person inputs I'm trying to get the date if they select monthly of 7/14/07 (using above date example).

Any help would be greatly appreciated.

Thank you

View 3 Replies View Related

Forms :: Add Future Dates On Button Click

Jan 14, 2014

I am very new to Access and have virtually no experience with vb, I'm trying to build a customer database with some forms that enable myself and a couple of others to keep track of customer contact.I have designed my form with 5 buttons at the bottom of the page with different future date values, I have made a field in my database called FollowUpBy and i would like to be able to click the buttons and have access take today's date plus the relevant follow up time-scale and insert that into this field. Also but on a separate note, I have the yes/no box for follow up required is there a way to make the buttons at the bottom and the date picker unavailable (perhaps shaded or crossed out) unless this box is checked?

View 1 Replies View Related

Modules & VBA :: Capturing ID Number Of Record For Future Use

Mar 12, 2014

I trying trying capture the ID no. of a record for future use. I have tried different combinations on different form events. Nothing works, what am I doing wrong? The latest I have tried is the following, on the load event,

Code:
Private Sub Form_Load()
Dim LoadNo As String
DoCmd.GoToControl "ID"
LoadNo = Me.ID
txtLoadNo = LoadNo
End Sub

View 7 Replies View Related

Calculating Future Dates Based On # Of Working Hours

Mar 16, 2008

Any ideas on calculating future dates based on # of working hours. For example... If a task is suppossed to be completed in 32 business hours, when would that be? Considerations include standard working hours M-F, no working hours on weekend. I have to believe that someone has written this before and I don't need to reinvent the wheel. ANy help is much appreciated!

View 5 Replies View Related

Forms :: Calculating A Future Business / Work Date

Sep 14, 2013

I am trying to find a simple way to determine the work date based on knowing the Start date and how many days ahead I want the date for. These means I need to exclude weekends and holidays.

I tried Pat Hartmans solution located at

[URL]

I discovered that the function in there that is supposed to do this does not account for weekends, only holidays.

View 7 Replies View Related

Tables :: Autofill Future Date Based On Another Field

Dec 1, 2014

I am very new to access and I am trying to figure out how to build an expression for one of my fields. I have a field called Order Date, which holds the date of when an order is filled. I then have another field called Fill By Date. This new field I want to be 2 weeks after the Order Date. Is there a way to auto fill this information so that when I enter a date into the Order Date, it will enter the date that is 2 weeks after into the Fill by Date?

View 4 Replies View Related

Forms :: Auto-populate Field With Date / Time In Future?

Dec 15, 2014

I'm currently building my first database for a research project. When we enroll a participant, we need to have an enrollment date/time as well as an activation date/time (and they are not allowed to be the same because, rules). I was able to figure out how to auto-populate the current date/time when we've marked a person as enrolled. What I'm wondering is if it is also possible to auto-populate another field with the date/time, ten minutes in the future?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved