Hi
I am a teacher using Access 2007 for the first time.
I have downloaded and created a Student Info database which contains details of nationality, guardian's contact info, etc.
I also have an Attendance Excel Sheet which calculates daily / monthly attendance in its most basic form.
How do I link the cells that show the current attendance of each student to the Access db? Can I link it so that it appears on the db forms / tables / individual student page?
Please advise.
I'd appreciate the coming to me in painfully simple steps.
I teach English and Humanities and am not well versed in computer language ... although I enjoy its challenges and use a lot of it for teaching and administratie purposes.
Thanking you in advance,
Kscape.
I am a novice user trying to set up a db for small business and am needing a little direction. Most of the company's sales come from the contracted work for remodeling homes; however a small amount of sales are over the counter sales within their showroom. How do I set up the db to track the following: customer info, contract sales amount & date & payments & balance due, labor costs by employee and sub contractor, materials costs, and net profit from contracted amount vs deductions of costs? Payments made are directly related to contracted sale and not labor or material costs; with the exception of the over the counter sales. My boss currently tracks the above info in an spreedsheet ... please advise. Any help will be greatly appreciated.
Okay my access skills are low at best and I'm trying to build a database for work so hopefully this isn't to stupid of a question.
I'm trying to creat a query that will allow the user to type in a work type and have it generate the all records containing that work type. The way the data is in there to get it to generate just a specific work type without the input I have to use Like "*newacct*" for example. Is there any way to do this since there are more then one work types for some records?
Hi all How are you? I have a small problem... I have an access db called MainDB, which has tables, queries, data entry form. This db (MainDB) is located in the network server. I have another access db called BranchDB. This db (BranchDB) has no tables, it has linked tables to those tables from the MainDB, and it has the forms for view only (No Data Entry). The problem is that users from there local machines can not access the BranchDB at the same time. What can I do? Your help will be highly appreciated.
Hi, I am trying to create a button that upon click it moves the slelected item in list box one to list box 2 but i am not sure how to go about it, cany anyone help?
I have database that i am working on , i want to give a user a time limited accsess ( one week ) to the reports section for example !!
after a certain date he will require a password or the report button will be inactive ...
-at program start up , it will check for today's date if it is greater or equal to (lets say ) 24-9-2013 then it will change a field in an X table from "yes" to "no" ,
-after that the code will check table X for the yes no field , if yes then open Form A if no then open form B / or make report button inactive
how to do that in VB ... and is there is a better way to do it ? can it be done in the macro builder ?
Hi Im currently building an Access aplication and Im looking for some advice.
What Id like to do is use a list box which has a list of items in it, once an item is selected and a button clicked for this information to be sent into a text box to then be stored by the database. Each new item should be added to the end of the list.
I was wondering if its actually possible and how you would go about doing it.
Ok guys, im going to be flat out honest, Im new to this whole database thing. I've been doing a lot of studying and Decided that I am going to try my hands at a real simple and straight foward database. It seemed fairly simple but i guess not so im asking for help. I think my problem lies in understanding how the keys work, and what exactly they do for the database itself. And two the relationships, im not really sure of, i understand how to set them, but again i dont know what they do for the database in the end. Ok so heres what i got:
The object of this DB was to collect, store, retrieve, edit and display data for a fictious Print center that deals with Black & White copies and Color Copies.
3 tables:
Company Customer Job
these tables contain:
Company Table: CompanyID Set to AutoNumber *SET AND PRIMARY KEY* CompanyName Set to Text Address Set to text City Set to text State Set to text with 2 Character limit for input ZipCode Set to text with 5 characrtr input Description Set to Memo Webaddress Set to hyperlink
Customer Table: CustomerAccountNumber Set to autonumber *SET AND PRIMARY KEY* CompanyName Set to Text JobNumber Set to number FirstName set to text LastName Set to text PhoneNumber Set to text with mask set FaxNumber Set to Text with mask set Email adddress Set to text
Job Table: Jobnumber Set to autonumber *SET AND PRIMARY KEY* Jobname set to text Jobtype Set to text JobDescription Set to memo DueDate Set to Date and time
Ok now hers the relationships I set up:
Company Table: CompanyID ------> Customer table:CompanyName
I tried and thought this would keep things simple but for some reason when i go to create my querys, i get this thing telling me that i have other data from another tabel and cant be edited, i figured out that i had to put the job in first to get a job number and when i go to enter the customers information i have to manually enter the job number in. (Kinda Sucks) I entered some sample data, and tried to make a form, I used the autoform and created a general form but when I flip to the last record in the DataBase it wont let me enter any new information, I thought i was suppose to do that, so i went to the table properties and set the table to Data Enrty Only, and i still couldnt enter new data.
:confused: Ok so theres my problem, I made a boat with duct tape and now im wondering why im sinking to the bottom. Any help would be GREATLY APPRECIATED and if possible a broken down real world explanation on how the keys and relationships work, and what they actually do for the database. I also probably didnt set up the data in the fields correctly, I was trying to normalize everything but im not sure.
Thanks guys! Im really greatful for any help you can offer! ~[MikE]~ :)
Hope nobody minds but I don't really know Access and I have a table that needs sorting pretty desperately.I have a table with 5 columns that I need to filter out so just the remaing records are left over.http://img208.imageshack.us/img208/7328/untitled1wb8.th.jpg (http://img208.imageshack.us/my.php?image=untitled1wb8.jpg)The column 'fax' is the column with the records in it and the following columns need the record removing if the box is ticked.TimFPS, OurFPS, OnFPS, NeedsToBeFPS, however the column 'NumberWeHave' I'm not too sure about so I'll ignore it for now (I may need to take them out later)Sorry to be a complete noob and if anyone can help it will be muchos appreciated.
Hi all, I need to develop a relational database to track new construction -builders, subdivisions and employees and additional info about each subdivision. I want to be able to set it up so that the end user can click on a drop down list of builders and then have another drop down list of subdivisions to choose from when updating or doing data entry. Any suggestions would be greatly appreciated. As basic parameters I have around 80 builders with up to 150 subdivisions. I would also like to be able to use this in other areas besides mine.
Hi! Let me explain my little problem:confused:: I have in a form two comboxes an a listbox. On the first combobox you can introduce the TAG, on the second one a machine. I need that the listbox show the values of the first and second combobox separated by a comma.
The first combobox= TAG The second= machine listbox=TAG machine value together without using the table
If you can help me I will appreciate your information:D
Okay, i need to know if there is a way so that more than one person can be in an access database at one time. Both need to be able to edit, add, delete, etc. within the database.
Hi I am a first time access user so i would like you to go easy on me. I work in an export firm where I have to maintain Order Dispatch schedules for different customers with different products. I becomes very difficult as at the moment I am using Excel andd have to maintain different files for each customer. I was hoping if a common base for the same can be created in access so that i am able to input all data pertaining to different customes in a single table and get reports of the same according to my need.
Is there a way to automaticaly close a database after it has been open for a period of time? I am having trouble with users leaving their database open after use. This causes a problem when they shut down their computers at the end of the day not knowing that the database is still open. What I want to do is to set it so that after mayby an hour of inactivity on the database, the database opens a warning message. The user can then click on the warning message to continue working on the database or the database would automatically closes. Any help would be greatly appreciated.
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
Help!!! I am setting up a database with 'open' and 'close' dates of an event for each record/ID. I want to be able to sort/query my results into the next event (i.e. open or close) as it will be happening so that I can plan for each event, but I am not sure how to go about doing this. I have tried various queries but because the information is linked to one ID it does not want to duplicate the information in the record. I can set up separate queries for the 'open' and 'close' dates but I can't seem to be able to tie it together =>I have 2 queries, but I really need it to be at least in one report in date order each record appearing twice ...once at the open date, once at the closing date. anyone....please!!!!!!! :) thank u
We have a database created in access 2000 laying on a server that two clients connect to using access 2000 from WinXP Pro. We have just moved the database from our old win2000 server to a 2003 server. The clients now logon to a 2003 domain instead of the old 2000.
Since we moved to 2003 only one user can open the database at a time, when the second user tries to open nothing happens. There's no error message, there's just nothing happening! When the first user close access the other user can open the db.
I'm trying to create a multi-user application for the first time and am confused on the proper set-up. (Access 2000)
I first created the app as stand-alone, then split it. I then map the fileshare containing the back-end table and copied the front-end to the remote system. It's a simplistic application so security isn't an issue. Will this scheme work ok for me?
I can view the records fine this way (using queries based on the BE table), but am having a problem when iItry to delete a record from the remote table.
I'm guessing I'm not properly opening the recordset??
Here's the bit of code that's giving me the error when I try to delete the remote record:
Set db = CurrentDb() Set rec = db.OpenRecordset("BoutRecord", dbOpenTable)
Actually, this doesn't even work on the system where the B-E file resides, yet it worked fine before I split the DB...
Do I need to open the table differently when it's linked/split?
Sorry if this is a dumb/basic question...(so basic, I couldn't find references elsewhere in the forum...) I'd appreciate any giudance as I'm just getting started with Access development.
I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!
For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...
e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student. I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...
The relationships are all ok, the fields for Student ID are lookup, etc.
I don't understand. It's driving me insane. I need help with this, I'm struggling so much.
I have done some searching to find a method for logging & timestamping when users log in and out. I have no problems with capturing the Log IN information my problem lies with the log out portion where I am trying to use a Update query to update when the user logs out of the database:
I can get the update query to do what I want, but for some reason it is creating a duplicate record (exactly the same as the last record updated)
Here is the code I am using:
UPDATE LogInTable SET LogInTable.LogOutTime = Time() WHERE (((LogInTable.LogOutTime) Is Null) AND ((LogInTable.UserName)=LogUserName()));
Basically I am trying to tell the Query to ONLY update records where the "LogOutTime" is Null AND where the UserName field in the table = the username of the person trying to run the update query.
Please help I can't figure out how to prevent these duplicates. :(
There are between 10 - 15 users at one time. It is a shared network, the front_end is on individual hardrives and the tables are located on the server. We just converted to Access 2003, our data file size is 47kb.
Users who are not active in the database get disk or network error message and have to close out. Is idle time a possible factor? Some users maybe entering information sporadically through out the day, but need to have the database open, they may need to refer to a member record upon receiving a phone call.
