I'd like to first thank you for any help you can offer on any of the following issues.
Situation: I've been tasked to streamline our in-processing requirements for new employees and told that the Access program can help tremendously. In order for this program to work I need to make it as easy to use as possible for some of my more computer illiterate bosses.
Tasker: Design a one-stop-shop program that is in-depth and both easy to input data and easy to show multiple outputs if we want. For example: If Jon Doe is coming into our business then I might need his prior work experience, social security number, date of birth, name, address, phone number, supervisor name etc. I know how to do some of this but I don’t know how to:
1. Make a drop down menu in a specific field to allow only the pre placed answers to work.
2. Allow a supervisor to see a 90 day forecast of only the employees who will require an evaluation. (this would require an easy to navigate program that allows the supervisor to click on the desired output and time frame to see the info)
3. Make it a clean and professional tool that will be relatively simple to maintain for future employees.
Thank you again for any help or reference material you can offer. Have a great day.
I have a database that will be used by a few users who are not very comfortable with Microsoft Access. I have a login screen and a introduction/splash popup. I was wondering if it is possible to bypass the Microsoft Access pop-ups that ask the user if they want to "block unsafe code.." or The security popup that says "This file may not be safe" so that the users go right to the login screen I created within the database. I am worried that there will be variations in answering/clicking these Microsoft Access questions thus causing a variety of complaints when trying to access the database. Thank you
Hello, I'm new to Access. I've recently started helping here at a non-profit literacy org. They have a small library and they were keeping track of it in an Excel spreadsheet. I moved it over to an Access database which seems much more appropriate and better in a lot of ways... Anyway, I'm not sure where to look or even exactly what I need to ask but here goes.
I think what we want to do is something like an invoice. The current database has one record for every book in the library and each record has fields like: book name, checked out (yes/no), date due, and borrower name.
It was nice and easy to write a little query with "<date()" on the due date field to generate a list of overdue books, then we used Word to merge the data and generate letters to send to the people with the overdue books. The problem is that most people have checked out more than one book so our simple merge ends up making one letter for every overdue book.
The first thing we'd like to accomplish is: how do we make a table? querry? report? which makes a new table with one record per borrower then each of the books that borrower has checked out?
It doesn't matter to me which way we do it, just so long as we can end up making just one letter per borrower, with that letter having each of the books listed. This seems kind of like an invoice to me, so maybe if I looked at invoice examples that would help? But that might just be more complicated and confusing?
If it's not too hard, there's a 2nd thing we'd like to do, and that is to, either from a 2nd database, or from data in the same database, but in a different "table"(?) get the person's address and merge that into the letter too, based on the borrower name.
Sorry if I'm being an annoying NOOB ~ if you think there are some things I should read first before asking these sorts of questions, perhaps you can point me too them? I'm at the stage where I don't even know enough to know what I don't know yet.
Just for reference, I do have tons of general PC & software experience, and have learned the C/C++, BASIC, Pascal, FORTRAN (77), 65816 assembly/machine code, and even a little LISP.
First, if I have a table, and I want to combine two records together, how would I accomplish this? For example, say I have the following table.
NAME SALES Bill 2000 Jim 500 Ted 1000
And by some miracle of science, Bill and Jim are able to fuse together to become Jill, combining their sales together. So the new table would look ilke this.
NAME SALES Jill 2500 Ted 1000
My second question is, say I have an extended list of the same table with 30 names and corresponding sales. However, I want to find out Ted's percentage of sales of the TOP 15, not all 30. How can I accomplish this?
Thanks so much in advance for helping out a complete newbie. :)
Hi all, I've played a bit with MS Access 2003 the last week. I've made a form wich should contain information about stores (phone numbers, locations e.g.).
I'm trying to imagine myself (what could be a real) scenario, that way it's easier to give myself practice and tasks :)
As I'm new to MS Access, I'd like you to take a look at my forms. I want to know if there's better ways to do what I have done, and if I have done something wrong.
I also got a couple of questions; Lets say I want to print one post by clicking on a button, is that hard to implement? Is it possible to make a button, which exports the form to an .xls -file by clicking on it? I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen :confused:
I think that's all.. Thanks! :)
Here's the access -file (http://www.home.no/f00b/stores.rar) (180kB) (use winrar to extract it) I've tried to transalate to forms into english, sorry for the bad english :o
After learning that 2007 has no User Security roles, and not having Sharepoint or a SQL server, I decided to work starting with Bob's Simple Login script located here (http://www.btabdevelopment.com/main/AccessSamples/tabid/54/Default.aspx).
I've got it functioning fine and incorporated some of the options also made available here (http://www.databasedev.co.uk/login.html).
You'll see the code below used to store info in a hidden form that is holding the username and permissions level. I'm looking to try and store this information into a global variable instead of a hidden table.
I know that I could define it as a variable right here in the code, but how do I define it as a Global variable so I can use it later in the application in the VBA?
Private Sub cmdLogin_Click() Dim strUser As String Dim strPWD As String Dim intUSL As Integer
strUser = Me.txtUser If DCount("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'") > 0 Then strPWD = DLookup("[UserPWD]", "tblUsers", "[UserName]='" & Me.txtUser & "'") If strPWD = Me.txtPwd Then intUSL = DLookup("[SecurityGroup]", "tblUsers", "[UserName]='" & Me.txtUser & "'") Forms!frmUSL.txtUN = strUser Forms!frmUSL.txtUSL = intUSL Select Case intUSL Case 1 DoCmd.OpenForm "frmHome", acNormal Case 2 DoCmd.OpenForm "frmHome", acNormal, , , acFormReadOnly Case 3 MsgBox "Not configured yet", vbExclamation, "Not configured" Case 4 MsgBox "Not configured yet", vbExclamation, "Not configured" End Select DoCmd.Close acForm, "frmLogin", acSaveNo Else If MsgBox("You entered an incorrect password" & vbCrLf & _ "Would you like to re-end your password?", vbQuestion + vbYesNo, "Restricted Access") = vbYes Then Me.txtPwd.Value = "" Counter = Counter + 1 If Counter = DLookup("[OptionValueNum]", "tblOptions", "[OptionsID]=1") Then MsgBox "You have entered an incorrect password too many times. This database will now close!", vbCritical, "Wrong password!" DoCmd.Quit End If Else DoCmd.Quit End If End If End If End Sub
I'm trying to build up a database for Multiple choice questions quiz in MS access 2010.My requirement are as follows
My quiz consist of 15 questions. Each questions carry some weightage. Suppose a question carries a weightage of 5 and there are two correct options like A & C. If user selects option A then he gets half marks.Multiple users can access the test at the same time.
1) There are some databases here at work that I can open in BOTH A97 and A2K. I thought A2K won't open in A97, and before you can open an A97 in A2K, you have to convert? At least that's been my experience thus far. Any idea what is happening and how I can determine which version these databases are currently in?
2) With those same databases...assuming some were A97, the option to Convert them under Database Utilities is greyed out. Is this most likely a rights issue? Could it be anything else?
Recently I created a database using MS Access for the company and I am the Admin for it. The database is in the share folder and many employees are using it but if I want to take backup or modify any thing a message is appearing saying that one user open the database.
Is there any method to know which user is opening the database and in which PC (workstation) it is open. --------------------------------------
Is there any way of adding export fuction to the toolbar using modules or macro
Is it possible to have a table of 10 random questions and an inital form created with those questions in the form of checkboxes. When you chose random questions from that pool of questions a new brand form and table have the option to be created.
Basically, I have many external databases to research and some of the questions are the same in each database. Each database must be saved as individual tables and forms.
I have few questions so please bare with me 1- i want the text box to change automatically according to date so i tried this: if date>text14.text then text30.text=sea else text30.text=port but nothing happens 2-i made a form but not all the data rows in the table are in the form(there`s still some rows) so if i delete a data that are in the form how i can automatically delete the data that are in the other row ?
3-this may sound stupid..but is there a way to stop the access logo from apearing when loading the database?and how to make access directly open a specified form?
I am designing a database and have a couple of questions.
I have designed a form that I have opening at startup. How do I force this to maximize on opening?
I have set up a report based on a query. It works fine. The query requires a parameter to be entered when it is run. The parameter comes from a list (of teachers in my school). How do I set up the query so that the 'Enter Parameter' dialog box provides a drop down list of teachers from which the user selects their name?
I am new to Access and have just designed a new database and was wondering if anyone could help with a few questions.
1/ I am setting up a Macro to send an e-mail on the change of a form. When the e-mail is generated by Access I get a message from Outlook stating that "A program is trying to automatically send e-mail..." and asks you to confirm that it is ok to go. Is there any way to bypass this check or alternatively send the e-mail from a specific e-mail address rather than the database user.
2/ I have changed the background colours on a number of my forms but the Record Selector's and Scroll Bar stay the standard Access Grey. Is there anyway to change these?
3/ I have used the User Security Wizard to setup users, groups and access but I can't seem to see a way to limit the number of simulateous logins a person can have i.e. I can log in more than once with the same user when I only want to be able to login once. Any ideas?
Hey guys, I'm just doing this database and have suddenly realised I dont know as much about MS Access as I thought!
Q.1 - I need to run a query that displays the top 5 records in a table, how would I go about doing this?
Q.2 - In my tables, I have of numerical data like the following... http://img276.imageshack.us/img276/2695/11ch1.png is it possible to make a Totals column which automatcily adds up the data in the Fraud, Competition, Loss of data, etc rows? (similar to MS Excel if possible)
Say your got a database that has many users & in which quite alot of information is added to it on a regular basis. Basically its getting slower, what could be the problems & how could you fix it???
Hi all, I built a system in access for my a level IT course a few years back but haven't had need to use access since. just been asked to build simple system at work and i'm forgetting some really simple things. trouble is i think i'm overcomplicating the terms and can't find anything in the help file!
basically the system is to keep track of how many hours various people have worked on various jobs.
I've got 3 tables:
Jobs - job id, location etc etc Staff - staff id, name etc link - job id, staff id and hours worked.
the job and staff tables have the id as the primary key, and i've set the relationship to link them to the corresponding field in the link table. which is all fine if i remember rightly?!
now what i'm trying to do is set up a form for entring the hours worked etc into the link table. we use job id numbers all the time so i have that as a drop down box. what i want is to have a drop down for employee names, which will insert the employee id into the link table- basically so we can work with names rather than numbers. for the life of me i can't remember how to do it. i know is really simple but i can't find a way to express what i want to do to search for it in the help or online!
if anybody can refresh my memory it would be much appreciated!
First...I have a table called company rates which will be used to calculate time and materials. In the material field, I need to enter .10 for 10 percent. When I enter .10 the field changes back to zero. I have it set to long interger. Is this wrong?
Also, I am working on the form that will calculate all of this. I have a field that needs to look in a flex price field. If there is a number in the flex price than that is the labor, if not, it needs to multiply the estimated time (Text43) times the quantity, times the CurrentLaborRate contained in the CompanyRates subform. I can't seem to get it right...
Allrighty, some questions about replication. I have gotten the Replication Manager from the helpful IT folks here, have made the database, and it works well to synchronise between different files locally on this computer. However, ideally the other people in the department would be able to carry replicas around on their laptops, while ideally the design master and overall database tidying should sit on mine. The setup is typical intranet here - computers are invisible to one another directly, and so are their virtual My Documents drives, while shared network folders are visible to all.
Questions;
1. Since I can't see any of the other laptop drives, and the database would have to be accessible offline, I assume indirect synchronisation is the only choice, correct?
2. Does the Replication Manager need to be installed on each of the laptops that will use the database offline?
3. If yes, what's the process? Do I install RM on each laptop, then use the Create Replica function to create one locally on each? No hidden pitfalls here?
4. If yes, is it sufficient to keep RM shut all the time unless specifically wanting to synchronise? Would happen at least once a week.
5. If Replication Manager doesn't need to be installed on other laptops, how do I move replicas there? I tried moving one through copy/paste, but that broke the link to the Replication Manager.
6. (Optionally - I've seen some references to 'replica farms' - what is that?)
Very much appreciated if anyone is able to answer..
I am trying to build a db for the office I work at. And I have a few questions about how I should design it.
1. My vendor number should be an autonumber, but it has a relationship to the vendor name on a report. I cant create a relationship btwn text and autonumber.
2. Right now I have 3 main tables. Vendor, builder, and job. All of this is for the marketing aspect of the business. But I want to include other aspects, like collections and payroll. Should I add columns to the jobs table, or create a new table? For example, on the jobs table, I already have job info like details on the job and who referred it to us. Should I add invoiced amount, amount collected, etc., or create a table called collections to store all of this info? Im really confused about this.
Hi I'm new to the forum, and i have a question (don't we all)
I need the following, i tried some turorials but couldn't find it.. I'm creating a form, that has 2 fields that I want to relate,
let me explain a little: the database if for a Church I work for. The church has 3 sites (3 different buildings in 3 different parts of the city) Each site has it's own schedule of day and time. I need to create a field that asks for the site, and depending on the site that is selected, it should display in another drop down menu the possible days and time of only that site. I have no idea how to do this. I have created a table with the sites, days and time How do i make one field depend on the other.
The other question is regarding a field that I want to add for the Cities of States. I want the field to remember the new ones, and add them to a drop down menu, so that if it is there it can be selected without not having to write it again, and if it isn't there yet, it can be written and then it would be added to the list....
thanks I want to thank you in advance. hope i can be of help soon enough:cool:
I've run into a problem with my db :( When I'm trying to create users for it, apparently Access won't accept them when they try to log in from different computers.
Is it a general problem with Access, or is it just me who's a noob with this?
I've been working on a database for a while now and I believe the outline of it is complete, all that's left is the data inputting and security.
I tried to make my own security based around usernames and passwords but I was hopeless at applying MD5 encryption on the password field and working with the permissions afterwords.
I went through the user level security wizard and I set up the accounts and there's permissions to read tables, etc.. but there's no good tutorials or help files to do anything more complicated and I wouldn't know how to without reference materials.
Now.. the thing I wish to do is limit users by record, each record has a "worker" assigned to it. I want the user to log on, open the main menu form, open the client's form, then only that worker's clients would be available to go through with the forwards and back arrows, or the drop down list would be filtered.
Is this too complex to do with the user level security built into access?
Are there any alternate methods of doing so?
I can upload my database if anybody wants a better look.
T_Problems F_ProblemID (PK) F_Title F_RelatedProblems (FK to F_ProblemsID in same table)
1. Is having a FK to the PK in a one-to-many relationship in the same table allowed and desirable? 2. How would I ensure that, say, if problem ID 20 was related to problem ID 50 then ID 50 was similarly related to ID 20 or would this happen automatically? 3. Is this the 'adjacency list model'?