Attendance Dbase
Feb 12, 2007Dear fellows
hi
I need sample access dbase records and retreive attendance of students in course
thank you for help
moheb morcoss
ADVERTISEMENT
Chat Through Dbase?
Mar 27, 2006Hi!!
I am creating a dbase which can be accessed through a lan
Would like to know whether it is possible to have a chat window EMBEDDED into the dbase; whereby multiple users can chat and modify database accordingly....
Prob simple, but the access help doesnt offer much support
Your efforts will be greatly appreciated.
P.S. Can u just create a small sample for the same??
P'se Critque My Dbase
Feb 15, 2007Hello there,
I'm trying to develop a database for an organisation for their partners....see attached. I would like you to take a look and tell me if what I've done is the right thing. Secondly, (I'm just learning Access) I would like to have a query that give a count of 3 how many CBOs, how many NGOs; by 8 (location). Third. Is it possible to have (sub) grouped into expertise?
The mission and vision field was a multiple answers field, is this the way?
Thank you in advance,
Samia
Export To DBASE III
Sep 29, 2005I need to export ms access table to dbase III format.
When I use export something is missing and the file format
is just not good.When I try to open dbf file with
program Dbase I get message "not a dbase database".
I find out that excel do the same, so if anybody know
how to export to dbase III using ms access or ms excel
please help.Ms access help is to install borland database,
I downloaded some from Internet but I don't know what to do with it.
PS: Even when I import dbase III file and try to export it back
there is a problem.
Please, please help.
FoxPro/DBase III Import??
Oct 12, 2006Okay,
First I was thinking to write a little app in Access to work with a DBF file, that I assumed was a DBIII database. It was exported via a 3rd party software, and the primary interface up until this point has been Visual FoxPro. My problem is two fold:
1st:
When I tried to import it as a dBase III file, Access just closed. I mean, disappeared, no longer running, closed. I didn't even get an error message or anything.
So I tried to import via ODBC, using a "Machine Data Source" Microsoft Visual FoxPro Database (or table, either works) and selected the directory of the dbf file and selected the table listed once it scaned the directory and all imported fine.
So: If the Visual FoxPro Machine Data source worked, though I am confused why the DBIII driver just booted me, I am now concerned as to how I would write a connection string via DAO to access that dbf file at run time.
Basically I want to go to a static location on a network and access a dbf file, and perform query manipulations upon it. My connection will be READ ONLY to the actual DBF file and i would subsequently use MS Access to create any other relevant tables/queries based on the table in the dbf file. Since the Visual FoxPro MDS diver worked, do I need to write a connection string to access it, and if so, how would I do that?
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
Prob With Many2many Dbase..
Dec 27, 2006I'm trying to create a little dbase for personal keeping track of a number of companies I deal with, so that i store their details and also the products they distribute.
In more detail, I want to have 'fixed' product categories, which will be assigned to supplier, and each category will include the product models I have set, including their details (such as price, manufacturer, country of origin, etc).
My point is to be able to create several customised reports and listing:
1. All product models I have in a category including their details.
2. Report per supplier to view their details and the products they distribute
3. Certain product models in a list with their local distributor (companies I deal with).
I assume it involves a couple of many2many relationships, however I have created a file in MS Access but never managed to have it work properly.
Any1 have an idea, or template maybe?
Regards ;)
Scheduled Shutdown Of Dbase
Jan 24, 2007Hi,
I've searched the forum for a sample code on how to automatically shutdown database at a given time of the day, but i can't find any. There are lots of codes pertaining to inactivity / idle users but none on scheduled time.
My idea is to kick-off all users every 12:00nn, Monday to Saturday and then compact / backup database after.
I hope someone could assist me.
Thank you!
Sheila
Access-Dbase Or Remarry
Apr 13, 2007I have been married for 36 years. I really don't want a diorce, but I think I might have to in order to get access to work for me. It appears to get the best way to get D base to work with access it to get divorced and remarried, ha. We have tried several ways to get import data into access from a Dbase IV file. We have tried by a Dbase import and a text delimined file import. We get a subcript out of range. There seems to be several issues here. One of them is if you have numbers in a dbase text field, and try to import them intp access, the documentation and access says we have to put quotes around the numbers. That didnt work.
Actually, rather than going into great detail of what we have tried, let me just tell you that we cant import the file. Can anyone help? We have the folling type of filds in dbase: date fileds, text field with numbers, and numeric fileds. Please help.
:mad:
Bob
P.S. I am happily married, so i would prefer not to go the marriage route with dbase.
Exporting Table To DBase IV (*.dbf) With VBA
Feb 22, 2008Hello guys,
I am working on a database that requires a user (with very little access knowledge) to export a table into .dbf (DBase IV Format) using a button and VBA.
I realize this can be done by right clicking on a table and click export. However I did not give the end user access to the tables (being a good DB Developer!) and also I don't believe I can teach this particular user how to do the steps to accomplish this.
The scenario: Third party software needs (SwissSys, which is a chess software) to grab information about players and ratings from a .dbf file (and will not work with access). I have developed a database for the association so that they can edit players information, and update the ratings directly off the website (www.chess.ca) and it automatically updates in the database.
The idea is, the Access Database updates the ratings from the website, and then the user exports that data into the dbf file (players table) that is directly linked to the third party software.
I am looking for a way to use VBA code to either 1. Create/Overwrite the existing dbf file when exporting the tblPlayers, or 2. Append/Update the current dbf file with the updated ratings, and creating new entries when necessary when exporting the tblPlayers.
Unfortunately I have had little success in finding code to export to a dbf file, anyone have any ideas?
Programmaticaly Add User To Secured Dbase
Jul 20, 2007Can anyone help please
How do you add a user to asecured database using vb
Thanks
Can't Convert Dbase To Design Master
Dec 19, 2007I am trying to replicate a database for mobile working. When I attempt to 'create a replica' I get this error:
"MS Access can't convert to design master
Cannot make the Table "[TableNameHere]" object in tables container replicable."
The table in question is fairly large and has 248 columns and is linked to 3 other tables of similar size as well as 3 smaller ones. Got about 2000 or so records and set to cascade deleted and updated records. 248 columns should leave enough spare columns for replication though, shouldn't it?
Any suggestions as to what I should look for to fix this?
Duplicate Access Dbase Without Data?
May 29, 2005This mind sound like a pretty lame question to the pro's....
Is it possible to duplicate an Access database creating a new blank database - retaining only the database/table structure? I have a website content management system and I want to duplicate the database for each new site.
Also, is it possible to reset the 'auto-numbering' to zero?
Whilst I've build a reasonably advanced web-based system based on a database containing a dozen or so relational tables plus queries, I'm no expert on advanced Access functions.
Cheers!
Penny.
Linking MS Templates To Create Integrated DBase?
Dec 10, 2007Hi everyone
I am just about to start a database project for the company. The last one I wrote was over 10 years ago in Borland's ObjectPAL and has served us well.
After doing quite some research I have decided (well... almost) to use Access as the basis for the new project as I need the most efficient and 'slick' solution in the speediest time-frame (don't we all!).
The downloadable Templates from MS seem actually quite good as a starting point, but we would need to 'glue' them together to prevent replication of clients, prospects, employees etc.
Has anyone had any success with doing this? For example, we would need to integrate Marketing Projects; Customer Service; Sales Pipleine plus our own custome stuff besides modifying these standard templates.
Looking forward to your replies
Regards
CD (UK)
General :: Import Images From DBase DBT File
Jul 27, 2013I've been asked by a friend to extract approx 50 images that are stored in a dBase 5 'DBT' file.
I know Access can import dBase 'DBF' files, but is there a way that I can use Access to import the data in the 'DBT' files and convert to jpg format?
Committee Attendance
Apr 29, 2005I have a task of creating a database to track committee members attendance at meetings. Members can be on more than one committee. I have created tables for committees, committee population and committee members.
The meetings would take place once a month and do not need an exact date. A Yes/No would suffice for record of attendance. My question is what would be the best way to set up the table to track this since members can be on more than one committee?
I'm thinking that having a separate meeting table for each committee would be a bad idea. But haven't come up with any other ideas. Any suggestions???
Thanks :)
Attendance-Query
Apr 11, 2008Hey,
for some days i've a problem with an Access-Query and up to now i didn't succeed to find an answer, i'm not even sure if there is one.
So, how to explain my problem.
I'm trying to compile a Database for my small department to organize our computer-short-course
students (application, grades, attendance...)
And with the grades i have a problem as well as with the attendance. Up to now we are just using paper sheets for grades and attendance. So i just thought that it would be the easiest thing to create a similiar-looking form, drawing of planned Query-output-layout is attached.
The attendance should be set with a checkbox. New days are set with a small subform.
For the attendance i've this table-layout:
tblAttendance
aSID
aCID
aDate
aPresent
When a new day is set, every student gets a new record at the tblAttendance, which shall be compiled together for the later Attendance Form.
So now the big question comes, is it possible to create
a query that fits my needs (variable amount of days and students and the possibility to set my records)? It is important that i've a big sheet with all the days, students of a course
at the same time.
Any suggestions - i'm completly lost.
Thanks in advance,
protos
Calculating Attendance
Mar 17, 2005i have tblmember tblclass and tblattend
the tblattend is
member 1d
class id
date of class
Attended (check box to say or no on a form)
i need to produce a quey which will calculate % attendance after each month and after each year of each member and class
how do i do this
Sample Attendance Database?
Sep 7, 2006I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.
Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!
I posted this here but didn't get any response.
http://access-programmers.co.uk/forums/showthread.php?t=114099
Access Attendance Register?
Jan 24, 2007Hi,
Well I'm stumped...
I am creating a new database system for my cadet organisation, and I am in the early stages of learning how to use Access. (I am using this as a learning curve, as I need to get to grips with Access for University, there's no better way to learn than by doing.)
I want a system that stores the attendance of cadets on each night we meet, so far I have:
|Table| Cadets
CadetID - AutoNumber (PK)
FName - Text
LNAme - Text
Flight - Lookup from Flight Table
|Table|Flights
FlightID - AutoNumber (PK)
Flight - Text
|Table|Attendance
AttendanceID - AutoNumber (PK)
Attendance Type - Text
The table that actually contains the register I am unsure how to structure, it would have to contain Cadet Name/ID, the date and Attenance type, from attendance DB.
The table would be updated every Tuesday and Thursday, when we meet. I've been thinking for a while about how to do this and can't find a good solution.
As the data will be entered by a user (who won't know Access from Adam) I'd like a form that lists all the cadets in the Cadet table, as each of these will have to be registered, and then a drop down box listing the options from the Attendance table next to each cadet, doesn't have to be drop down, can be optionbutton, image....
In the final version I would like the cadets to be sorted by flight in the form, but lets not go mad yet!
Can anyone help me with this? Or am i simply being silly?
I haven't used Access for long, but have used VBA in Excel before and am a fairly experienced user; I will attempt anything but bare with me if at first I don't succeed.
Any help appreciated
Tim
Attendance Data Type
Apr 19, 2007Hello everyone, I am buiding up a database for activity school. Here first step of buiding the base, I got an attendance data type problem. i am now using "yes/no", but if i want to query about the number of student each class, is that possible?
Thank you for your help.
Help! Need To Make Attendance Form!
Mar 20, 2006I am trying to make a class attendance form, where user chooses classType
ex:"English, French" then the program shows all of the students from tblStudents that are enregistered in that class. And some how make it so that user could select on or many users in the same class and press add button which will add the students into attendance table for the current class and the current day,
**Allso what I would like to do if possible after the form above works, is to if the student has been allready added for the current day, the check box becomes un editable with appropriable comment in the comments line for that student or for examples the student registered for 12 classes, the attendance keeps track of the classes and when the student tryed to go to 13'th class the check box is uneditable and in the comments line for that student metions the reases.
Sample Attendance Project?
Sep 7, 2006I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.
Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!
Any Way To Record Weekly Attendance
Nov 26, 2011My next challenge/task is to create a way to record weekly attendance. I have looked at several databases available online but not that really reflect what I need. Also I am trying to do it the simpliest way possible (for now) with my limited knowledge of VBA code.
Here is what I am hoping to do. I have a form linked to a query that will select the students assigned to a faculty member in all the courses that faculty teaches. I would then like to be able to use the same form, and a second combo box, to create records in an AttendanceTable that stores the attendance for that student in that course for that week. I have created a key using StudentID-CourseID to identify each student with each of the course they are enrolled in. It is also used to relate all the involved tables.
Table Design Query - Attendance
May 26, 2006hi,
i'd like some initial help with how best to set-up my tables for a database i need to create. if anyone could give me a synopsis of what i need to do it would be great and then i can try and piece it together.
here are the requirements;
one student can attend many different courses.
each course runs for 10 weeks.
i'd like to be able to have forms to;
- add a student.
- assign classes to a student.
- record absence via a combo box for each student for each week
i'd also like to have a report mechanism that can record if a student is absent for 3 or more classes.
as i said, some pointers or examples would be great as i am new to this. i pressume i need;
a table for students
studentid
firstname
lastname
a table for the courses
courseid
coursename
a table for attendance
attendanceid
courseid
studentid
present/absent (combobox)
week
Am most stuck on the date part. the data may not be entered every week so i can't really use a date function. instead i need a combobox or something to be able to select the week.
cheers
mark
Time And Attendance Coding Database
Oct 21, 2006Hi All,
I am setting up a database to help me prepare codes for employees timesheets in order to upload them into our payroll software. The table structure below is just my preliminary thoughts and current ideas and I guess I'm looking for ideas on how to work with my codes.
EMPLOYEE TABLE
EmpID (PK) - Employee ID # [Autonumber]
Surname - Employee's surname [Text]
Firstname - Employee's first name [Text]
ATTENDANCE TABLE
ShiftID (PK) - Shift ID# [Autonumber]
EmpID (SK) - Employee ID# [Foreign Key]
Date - Date of shift [Date/Time]
Start - Start time of shift [Time]
Finish - Finish time of shift [Time]
CostCtr - Cost centre being billed for shift. [Integer]
When employees work they are entitled to the following:
* Ordinary hours (code 001) for all hours worked.
* 10% penalty (code 006) for all hours worked when shift finishes after 18:00
* 12% penalty (code 007) for all hours when shift crosses midnight
* 50% penalty (code 008) for hours worked on a saturday
* 100% penalty (code 009) for hours worked on a sunday
The following shows data that in my Attendance table for an employee who worked shifts on the 16th (Mon), 17th (Tue), 20th (Fri), and 22nd (Sun).
ShiftIDEmpIDDateStartFinishCostCtr
18443416/10/0610:0019:00
28443417/10/0610:0019:003002
38443420/10/0622:0006:003001
48443422/10/0614:0022:00
From the above data I believe I will need to make another table that contains the entitlement codes generate from each shift.
For the first shift on Monday 16/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0019.00
0069.00
For the second shift on Tuesday 17/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0019.003002
0069.003002
For the third shift on Friday 20/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0018.003001 'Ordinary hours worked
0078.003001 '12% penalty as shift crossed midnight hour
0086.003001 'Only worked 6 actual hours on the Saturday as 2 hours were on Friday night.
For the fourth shift on Sunday 22/10/06 I need to collect the following codes for the total calculation:
CodeHoursCostCtr
0018.00'Ordinary hours worked
0098.00'Hours worked on the Sunday
From that information the only data I really need to store in a table would be the totals grouped by code and cost centre. Eg.,
CodeHoursCostCtr
00117.00
001 8.003001
001 9.003002
006 9.00
006 9.003002
007 8.003001
008 6.003001
009 8.00
Does anyone know the best way to go about this? Should I generate a new table that links these codes to an employee? Should I make a function to calculate the codes for each day and store them in a table or make the function only sum the code totals for the week and store them in a table?
Brad
Problem Creating Attendance Records
Feb 3, 2007I've got myself a little stuck!
I'm trying to create a database for our new theatre group. I've created a table for membership details (ID, Name, DOB, Address, etc.)
I want to create an attendance register - kind of the way a school register looks, so it will show on screen like a spreadsheet (names down the left-hand side, dates of the sessions across the top, and a grid for the attendance codes).
I know I could paste the membership details from Access to Excel and use a spreadsheet, but I'd like to keep it all together.
The attendance codes don't just contain present or absent, I would like to keep a record of payment 'P' or on holiday 'H' etc.
I'll keep searching and scratching my head, but any help would be appreciated.