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 Replies
ADVERTISEMENT
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
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
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
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
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
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
Oct 30, 2007
I'm kinda lost in here so I'd appreciate some help in pointing me in the right direction please. I've no doubt the answers are out there but I'm having trouble finding what I need, probably because I don't know how to frame my questions!
Basically the story is this - there are three guys covering various aspects of the business, they each visit three separate locations - all guys visit all locations. We have made a "big plan" that has 14 key deliverables in the locations as a "region" .
For each Key Deliverable there will be Actions, some Actions will be done in all locations, some might only be needed in one location. Each owner will describe the Action and link it to the Key Deliverable it supports.
What we want to do are things like
Take Location 1 and Guy A and show all the things he is doing to support Key Deliverable X.
or
Show all the Actions in Location 2 that are being done to deliver Key Deliverable Y by all Guys.
That sort of thing - progress reporting and identifying where we have nothing happening to support a Key Deliverable or too many actions in one Location etc
We have all our plans in Excel spreadsheets at the moment, each guy fills in a sheet and at present the idea is that we copy and paste it into the mother of all spreadsheets to present to the Gods - it's not happened yet because it's clumsy and well, it's my job to present it and I thought "there's gotta be a better way!" I can import the sheets into Access but then it all gets a little tricky and I run out of tallent.
OK so if you've read this far you're wondering if I have any idea what I'm talking about when it comes to Access! Well I am pretty much self taught and rusty but I can see that Access could help us get organised and
My limitations - I'm using standard Access 2007, I doubt corportate IT security would allow me to add in any useful plug ins or upgrades etc.
Am I using the right tools? I'm limited to MS Office really so I mean should I stick to Excel or carry on pursuing an Access solution?
Thanks for reading this far :-)
View 14 Replies
View Related
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
Jul 18, 2006
I am desperate for some help. I have been asked to establish a database for our office use and I have done the best that I can without any 'education' or 'instruction' on access, but now I am just absolutely stuck.
I have made forms, and tables, and a switchboard but I think I am having major 'relationship' issues and thats why my forms are not 'cooperating' with me.
My questions I think are so specific to the database that I just created, or tried to anyway, that I really can't ask a question in 'general'. I could send someone my database and let ya look at it and then perhaps you could assist, if anyone is interested.
Thank you so much, like I said I am very much inexperienced in this and am desperate.
View 7 Replies
View Related
Oct 24, 2006
I got an MS Access 2003 db which I think has an general option disbabled or so dnno, here's the case:
When I create a query, and choose to close the query (just be clicking the "X" button at the top), Access doesn't ask me to save the query or not.. it directly displays the box to fill in the name of the query
When I execute an action query, Access just executes it when I click "!" button, without asking me if I want to "deleting, updating, adding xx records"
I've been searching ages to find an option to enable but I can't seem to find anything
Can anybody help me?
View 3 Replies
View Related
Dec 28, 2007
im trying to upload a document with screen shots on the forums. Its 336kb, how do i make that smaller so ican upload since the limit is 100kb, if i take a screenshot and put them into 1 docuemnt per screen shot it still 115kb.
any help
View 1 Replies
View Related
Mar 25, 2008
hi
i'm getting annoyed by Access 2003 (and 97 for that matter!) just corrupting records in a table and then i have to scrabble around, kicking people out the database, compact & repairing, maybe installing the back up copy and in one case, doing a make table query from the data table that excluded the corrupted record
:(
are there any general things i can do to avoid these things, or am i just going to have to roll with them?
View 9 Replies
View Related
Apr 20, 2005
:confused:
Could Someone point me in the direction of some info on relationships.
I have a basic understanding but I start to get lost on when to use certin types of joins.
View 5 Replies
View Related
Sep 7, 2007
Hi,
I'm very new to Access DB developing, but I'm learning loads, thanks to this site.
What I'm trying to do, and it's driving me crazy, is the following:
I have a Table that has to fields (Total Daily Weight) and (Total Yearly Weight) and I have a field that calculates the percentage of yearly weight based on the total daily weight.
Now I know you're not supposed to store calculated values, so my question is..How do report on this calculated value?
A little more backround on the database:
The Database tracks waste for companies. They supply me with a total for the year, I weigh the total for the day, and then calculate to % and report on it for them....The problem comes when I go to print a report...I don't get the calculated % of yearly waste..
I keep reading on here that it should be done in a query? Can someone please guide me what I should do? I can put a copy of the DB up if it helps.
Any help would be appreciated.
View 7 Replies
View Related
Oct 6, 2006
Alright I have two tables, one is a user table, the other is one that holds the users roles. A user can have multiple different roles (up to 9). If you do a regular join on the tables you will get one that shows all the user information repeated each time for the number of roles they have. What I would like to do is design a form or something where the user can specify which role (1-9) they are interested in and the system will display all the users with that role. So for example show me the users that only have role 1 and no other role. I did this manually for one role by the following
1) Joining the two tables.
2) Setting a count to see which users have more then 1 role.
3) Eliminate any users the had more then 1 role.
4) Specify which role I want to display.
So is their some type of front end I can create where the user can specify what role they want to filter for with and without the exclusive roles?
View 1 Replies
View Related
Feb 3, 2013
I am using outlook to send/receive mail. That is OK but I want to know that who send me mail(from: name of sender mail).
View 6 Replies
View Related
May 11, 2014
I am under pressure from the client to import data for individuals into the database despite not having their preassigned unique identity number available for every individual. This ID number is the primary key for the table in which individuals' records are stored.
solution that will allow me to import the individuals with a temporarily assigned ID number but that allows that field to be updated with the correct ID number once it becomes available?
View 4 Replies
View Related
Jan 19, 2013
i would like to log every action any member does on my database.i will have a log in screen(passworded) and i would like to record every button clicked. the only thing is i would like to include other things in the record aswell. like record changes. is there a neat little trick to do this or is it just going to be very labour intensive.
View 11 Replies
View Related
Jun 9, 2015
Will copying the database file while it is still in use, cause corruption in the original file?I've read numerous places that you shouldnt copy the file while it is being opened by another user because you dont know what sort of state the db is in.How to interpret that sentence? Is the consern here that the copy may be corrupt, or that copying the db file corrupts the "active" db file?
I have a script that copies the file each 15 minutes. I also take regular backups manually simply by CTRL+C ->CTRL+V
I then check the "new file", and do a compact and repair. If nothing seems to be wrong, I save it in my backupfolder. Is this actually a problem?
But now, I read that simply copying a db file may cause corruption..Split db, backend about 10mb, 15 concurrent users, all users are writing to the db, all users have their own frontend.All users are on citrix terminal server.
View 4 Replies
View Related
Sep 2, 2014
I have a form that should give me all values below " 0" but I am getting zero
but when I click on that value I see this
-1.52587890625E-05
View 3 Replies
View Related
Jan 24, 2013
Is it possible to have a form in access which is always visible - say on the left of the screen - then if a button is pressed alternate forms appear on the left?I realise I could create one tabbed form with a menu on the left and sub-forms on the right but I wondered if there was another way which is "smart" looking?
View 1 Replies
View Related
Apr 4, 2013
I have a program abc.mdb and abc.mde, I made some changes to the codes in abc.mdb and now I have been trying to convert the access file from abc.mdb to abc.mde so that the users are able to use the updated file. However, whenever I make MDE file. It doesnt work but creates another file called db1.mdb instead.
View 9 Replies
View Related
Jul 2, 2007
Hi I am in the process of designing a new database using Access 2003 for my company. I have very little knowledge of access and what knowledge I do have is self taught!
The database is to hold medical records about patients that we see (we run a small medical centre)
The information that we put on it will include the patients personal details (name address etc..) and also details about treatments given to them.
Could anyone give me some advice on what type of database sounds best for this type of information. At the moment the database will only be used in the medical centre but will be accessed by more than one person at a time (not sure if that is relevant !
I really would appriciate some advice as some of you guys have helped me before and i value your opinions.
Many thanks in advance
Paul :)
View 11 Replies
View Related
Apr 12, 2008
I'm building a simple database for my church but I'm uncertain how to inter-relate/connect the tables in order to pull some data into a report.
In one table I have the primary parish member, his or her spouse, with their birthdays, anniversary date and other information (e.g., address, phone numbers, e-mail, etc.).
In another table I have their children, birthdates and other information.
How do I create one report with the names and birthdays from both tables?
Any help would be appreciated.
View 1 Replies
View Related
Dec 22, 2006
Please see the attached two files.
I have tried to figure out what the difference in functionality would be between 1 and 2. In the latter I have just created a series of relations between the last two tables (but that structure could be used throughout the whole DB instead of hanging it together with one relation between tables as is the case for the rest of the DB in this picture).
So there can be three different situations with this table structure:
- linking all tables together via multiple relations
- linking all tables together via a single relation
- a combination of both, such as in the images.
Why would someone choose one versus the other? "Which is better in what situation?"
I've been fiddling about for a while now, but in a structure such as this it doesn't seem to make a difference. Or maybe there are differences in use/design, but on a level that I have not explored yet.
Could anyone explain this to me a bit? I have multiple books, all of which handle basic relations but I have not yet seen an explanation for this question. I think understanding the whole relationship topic is critical to be able to see other pieces of the puzzle fall into place later on. And as of yet, this is really fuzzy to me.
View 4 Replies
View Related
