Hi everybody,
Recently I created a database for staff details in my company and I used OLE Object in Data type to make it. The problem now there are more than 500 employees in the company so it is very difficult to scan one by one photo. Is there any way that once I click on command button photo will be detected from scanner and saved directly in the field instead of doing it manually.
Thanks and regards
Hi all,
I'm relatively new to Access and would like a few pointers...
I have been asked by work to create a schedule database. We would like to be able to put in dates and see who's working on that day, pull up an individual and see his/hers rota for a week. Also see if they have meetings, annual leave, sickness etc.... We want it to be a very primitive WFM tool. Is this possible and is it relatively easy? The database doesn't have to create the shifts, they will be imported from Excel....
Which leads me to believe I need to think of it differently to excel... Attached is an excel rota, which would need to be importred - but maybe I need to be think a lot differently.
I know thats a big question but any help would be appreciated, or pointers to more resources... Thanks
Neil
Hi All,
I need a query to tell me how many staff are on holiday on the same day..here what i have so far.
A query with name, startholsdate,endholsdate, totaldays, etc, etc,,
records showing; employee A books 01/01/06 to 14/01/06 and employee B books 10/01/06 to 24/01/06 C books 01/02/06 to 10/02/06 and so on,
I need to show how many employees are off on what days eg employee A and B are on hols between 10/01/06 and 14/01/06, so only 3 more staff may take days off between the 10th and 14th. I have tried all sorts of calculations but to no avail? can anyone help..
thanks
Hi all,
I'm a bit stuck with a db relationship design.
I need to hold information in a staff table about a person's Line-manager.
My initial idea was to just have the Staff Table and use the PK of a member who is a Line-manager as a FK in the Line-manager field in the same table for their staff.
I then came across a problem.
I need to be able to select all the staff under a Line-manager. For example a head of department may have 3 team leaders who each manage 10 staff. I need to know all of them, not just the 3 team leaders who are directly managed by the HoD but their staff as well.
As it happens there is no rigidgly defined managment structure per se for this organisation which makes things even more difficult.
I assume there is a reasonably standard way of doing this as all organisations have some form of line-manager/staff relationship. Anyone care to enlighten me?
Cheers
TS
i am unsure as to whether this can be acheived in a database..
basically this task is almost calendar like.
the company operates 7 days a week.
i have a table of company drivers and each has their own driver ID.
my user would like to store what time each driver comes into work each day and what time each driver leaves. this needs to be quite flexible however because some days certain drivers wont work, but each day..if a driver has a 'come to work' time then they will for sure have a 'leave work' time.
each driver also pays rent to the company once a week. within this calendar like system i would also like to store on what day the driver paid what amount towards their weekly rent.
i cant quite imagine how this can be done in a database. but if these kind of applications are common, i would be most grateful for some direction.
thank you.
one more thing..
i would also need to record during each day what time the driver left and returned from lunch (sometimes our drivers leave for a few hours during lunch time)
i want to store this because if they miss a job while they are on an extended lunch break im gonna roast em.
hi,
i need to design and build a access database for school where staff for a business could request holidays with there holidays then appearing on sum sort of calendar which can be viewed.
does nebody know where i can find an example to help me with my desing?
thanx
glen
I have several tables and queries based on tables and cannot get them to generate the results I want when querying them (just one record shows when many should be showing), so this leads me to believe there's a problem with the way I have set my relationships;
tblStaff (Holds lists of all staff and their contact details)
queryCoordinator (Filters list of staff from all staff list based on whether they are a projectmanager)
queryLeader (Filters project leaders from list)
queryMinion (Filters minions from list)
tblProject Contains all details from project
I have the staff queries so I can choose from a list of names that are relevant to that job in a form, so we don't have to look through a huge list of staff.I then want to use a query to pull all this information together (project details and contact details of each person involved) so that I can print a single record on a report, however the query isn't working correctly and returns only one project record, not all of them.
There is only one leader, one project coordinator and one minion per project (as far as I am concerned) and I want to reflect this in the query by providing their name and contact details from the single staff list.
Is the relationship between the project and the individual roles Many-to-Many or One-to-Many. I have many projects, and many staff, however each project only has one leader, one coordinator and one minion. I'm thinking One-to-Many, however when I relate the tables together, using the name as the relationship on each form this is where I have problems.
I have a database of staff members. There is a table with the details of staff; name, dob, address etc.
I need to set something up that will record the training that staff attend and then be able to print a report of who attended the training session and also a report of training sessions individual staff members attended.
I need to set up fields in a table for date, topic and presenter and then I need to somehow mark off staff members who attended.
Hey, I am currently doing an A-level ICT project and seem to be stuck at the first hurdel. My problem being that i wish to update the 'Number of sales' field for all the staff in the 'Staff' table. I have tried serveral queries to count the number of sales, which are in the 'Tickets' table for each and indidual 'Staff ID'.
This was suscuessful although i am wondering how to transfer these values into the Staff.[Number of Sales]. Also some staff had the value of 0 so did not come up in results of the querie.
Is there any possible solution or is there a more simple way to solve the problem.
Many Thanks in advance Dan Parker
I have a table with staff in.
I have a table with the start and end of their shifts.
We have four possible locations and four weeks.
So I have four tables for each location.
I have a module that can work out hours and deductions based on time in and out. I built that into a seperate databse working on a one time in and one time out setup.
I want to incorporate the two so I can get the hours worked over four weeks at all locations and divide that by 4 to get the average weekly hours for a staff member.
Hi there, this is my first post, hopefully not too many more problems i will encounter whilst designing my database.Anyway I am trying to add some fotos to each of my records, but not having as much luck as i would like. In the tables, i have made the field OLE object. When i try to add the foto (about 97kb) jpg format, all it does is add a picture of the jpg icon on my field. If i double click on the icon my foto will open, but i wish to have the foto showing in my record. Anyone help me with any ideas? I am using access 2003
View 2 Replies View RelatedPlease help!
Does anyone know what command will allow Access to pull Dimensions from Explorer into a Query?
I wish to have a query that will illustrate the exact Dimension of an image file (Jpeg). This will enable me to filter all images which do not meet my internet standard of 100x100 dpi and/or 300x300 dpi.
Your help is much appreciated. :D
I have recently learned how to link photos to a database using a form and a table listing the path to each photo. Is there anyway to format the records in the table so that when you click on the path the photo shows up?
I have browsed around past threads and have not found and answer.
Thanks
I have written a form from a table which holds employees details. This table has a photo field. The form has a control which displays the employee’s photo. It uses the field, photo as the control source.
This works okay but if you wish to enter a photo from the form you have to click on insert. Browse for the file etc.
The Sample database “Northwind” on the access help has a similar form, but under the photograph there are command buttons to add/change or remove the photo which is obviously a much more professional way of doing it.
I have looked at the properties of these control buttons and they seem to work through a visual basic program. As someone who has a very limited knowledge of VB is there a simpler way of doing this or would I be able to cut and paste the code to work on my form somehow (If Legal)
Any advice would be greatly appreciated.
Hi all, I have a form of contacts wich I would like to put a photo for every contact, I would like to have a "ADD" button on the form wich will add me a photo in JPG or BMP in a certain field on the form, the photo ar stored in a folder in c: I also would like to have a "DELETE" button!!!
Thanks to all
Marco
When you query Photo.name, you get a line for each photo name attached to a record
1 aunt sally a.jpg
1 aunt sally b.jpg
1 aunt sally c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob l.jpg
What I would like is to have it appear like this
1 aunt sally a.jpg; b.jpg; c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob L.jpg
Hi I have a Contact form with all the details of the contacts, I would like to add a photo for each contact, how can I get to this?
Marco
I have a log in form and combo box.
Just want to ask if possible to change photo depends on combo box value?
Here is the link of my database. [URL] ....
I have a text box that is Hyperlink to a directory that opens fine and gives me access to files that I need. What I want is to place a photo of a particular button I've found (in the form) and on the click event have the hyperlink in the text box activate and open the directory.
1. I can't change the shape of the text box or place a picture within it...
2. I can set the pictures control source as the hyperlink text box but that serves no purpose...
3. Making the text box transparent and all the text white then overlay-ed the picture ...
It worked but I would like the appropriate way to do this.....being at such a critical stage of my access development......
I need to add a persons photo to their employee record and don't know where to start.
View 11 Replies View RelatedI may be going about this all wrong but I have a text box that is Hyperlink to a directory that opens fine and gives me access to files that I need. What I want is to place a photo of a particular button I've found (in the form) and on the click event have the hyperlink in the text box activate and open the directory.
1. I can't change the shape of the text box or place a picture within it...
2. I can set the pictures control source as the hyperlink text box but that serves no purpose...
3. I lazy manned it buy making the text box transparent and all the text white then overlay-ed the picture ...it worked but I would like the appropriate way to do this.....being at such a critical stage of my access development......
I'm trying to create a many to many table (which I know how to do). But this is a little complicated.
I have several photos that are part of my database, so I have them in their own table which contains:
ID
CallName
PhotoType
Source
Computer Link (to where photos are stored on my hard drive)
The photo type comes from another table, one of the types is People.
So I want to have a many to many table so I can connect people photos to places where they live. That's pretty easy, you just put foreign keys for the photo CallName and for the Place Name.
However, I want the person's photo to show up also (in a container I will put on the form). In order to do this, I need to have a field for computer link that is automatically populated based on which Photo Call Name I choose. Can you do that in a many to many form? How?
I have a log in form and user combo box.
I want to add photo of each user in this log-in form.
Just want to ask if possible to change photo depends on combo box value?
I am setting up a database with an image linked to each record. I have installed Photo Editor as required to display jpeg files. However, when I try to insert object in the table field, Photo Editor does not appear as an option under 'Object Type'. How can I use Photo Editor as my OLE server to display jpegs? Or, can someone suggest a better way to display images on forms? I'm a newbie, so although I'll try more advanced programming if required, I will need quite detailed step-by-step instructions :)
Thanks!
:confused: hi guys
i'm working on a Personnel Project that get members information & data like Name , F_name , Birth date , place of birth & some other informations , but i want to add a Picture frame that show picture of every member in my form ( each record has a diffrent photo that i can select it from hard and fit it in a for example 3x4 Frame & store it in a access database .
and then add that photo in a report with other datas !!!
would u please help me doing that ?!
thanks
I am wanting to store a bitmap photo in an access table and then want to include it in a report.
View 5 Replies View Related