General :: Lock Picture Of Employee In A Form?

Apr 11, 2013

How can I lock a picture of an employee to his Employee record?

View Replies


ADVERTISEMENT

General :: Command Button To Insert Picture In Form

Nov 17, 2012

In form I want to put a command where we can browse a picture and insert it...how to do ...

View 5 Replies View Related

General :: Click On List Lookup Employee / Select ID And Then Form Will Fill In Rest

Nov 6, 2012

I have a form, "Update Employee Information" that allows me to navigate through records and change data like name, adress, etc. I would like to know how to create list (or autofill) so that it won't take long before finding an employee.For example: I have a Employee ID and would like to search on that so the form can fill in the rest of my information. I have thought of two methods that I like:

(1) Click on a list "Lookup Employee", select ID and then the form will fill in the rest

(2) Without clicking a link, typing in the ID in the form and the rest of the data gets filled in.

View 5 Replies View Related

General :: VBA To Lock Bound Date Box On Form

Feb 19, 2013

i want to use vba to lock or diable a date box on my form.

I have used[button].Enabled = False

This works ok for buttons but doesn't seem to work for my date

fieldMe.OrderDate.Enabled = False

I get an errormethod or data member not found. it highlights the .Enabled part...

View 7 Replies View Related

General :: First Appointment Of The Day For Each Employee

Feb 12, 2015

its been a while since i was last on here but i have run into some difficulty with a query

i would like to append some data to a tmp tbl.

i want to get the first appointment of the day for each employee. i have attached the relevant tables and a query that shows the information i need but it also shows more information. i have tried the nim function on the time and was successfull when i only had a few columns but when i added the colum [Items].[tblItems] it showed all the appointments for the day.

what i want to show is the first appointment for each employee.

View 7 Replies View Related

General :: Delete Employee From DB However Keep Referenced Records

Aug 18, 2014

I have a main table which records employee,date,record employee is related to tble employee. i want to be able to delete an employee however keep the referenced records with the name, date, record, is this possible?

View 3 Replies View Related

General :: Dropping Employee Number From Entry

Jan 26, 2014

I'm able to pull users that are logged into our network but our company uses a name that has their employee number as well. So deponding on when they were hired it could be a 5 or 6 digit number. so an example would be JSmith123456 or it could be JSmith12345 so is there a way to drop the numbers at the end? Meaning if they are entering data into a form that pulls their name can I drop off those last digits in the name field?

View 8 Replies View Related

General :: Spreadsheet For Attendance Hours / Employee

Nov 3, 2013

I have:

- tbl_company (containing company info)
- tbl_employee (containing employees info)
- tbl_cim (containing working contracts info, related with both tbl_company and tbl_empployee)

In the tbl_cim i have starting date of the contract, working time per day (in hors, according to the contract), ending date of the contract, etc.

I need:
- once a month i have to generate a "excel-like" sheet containing employees (rows) on a selected company, days of the month (1-31) i choose (columns) and hors worked on each day (according to the working_time from tbl_cim). The working hours i have to be able to modify.
- the days before start date of the contract have to be empty; the days after end date, also.
- the saturdays and sundays have to be marked ina different color (cell background).

I ask:
- what tables i have to create additionally?
- how can i create a form for this infos?
- is there a way to do this with less vba as possible?

In my country, Romania, this type of "spreadsheet" is called a "pontaj" and companies have to do it every month. I would like to step from Excel to Access with it.

View 1 Replies View Related

General :: How To Get Total Spent Hours In Office For The Employee

Jan 28, 2014

I am facing one problem while calculating the number of hours an employee spent in the office. Each employee will have a swipe card and the swipe data is stored in an .mdb file. Some employees will have different shifts and may come after 6pm and will go next day 5 am , while calculating their spent hours getting the problem. The swipe data is stored in IOData table , I wrote a simple query below to get the data., it is calculating correctly for the employees who come in between 11AM to 8PM but who are coming after 6PM and going next day , facing problem. Time is storing in 24 hour format in table with Status as Entry,Exit . There may be any no.of exits and entries , so i took min and max of the time in the below query.

I am attaching the mdb file data in an excel sheet(Master_Data.xls) and also the data of the below query(Swipe_Data.xls) and highlighting the employee for which we got problem.

SELECT HD.JobTitle, HD.HolderName, IO.IODate,IO.IOStatus, min(IO.IOTime), max(IO.IOTime), DateDiff("n", min(IO.IOTime), max(IO.IOTime)) AS Minutes, [Minutes] 60 & Format([Minutes] Mod 60, ":00")
FROM HolderData AS HD, IOData AS IO
WHERE HD.HolderNo = IO.HolderNo and
HD.DepartmentNo IN ('0008', '0009') and
IO.IODate between #01/20/2014# and #01/24/2014#
GROUP BY HD.JobTitle, HD.HolderName, IO.IODate,IO.IOStatus;

View 3 Replies View Related

General :: Custom Security Permissions For Employee Database

Nov 28, 2012

I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?

View 1 Replies View Related

General :: Logging Activity Of Each Employee In Company Database

Dec 11, 2013

Just a question, I am developing a database for the company I work for and being new to Access, I have successfully made a login menu when the database starts up. The employee selects there name and begins data entry. Is there any way to log the activity of each employee, which records they inputted, date and time and so on?

View 3 Replies View Related

General :: Capture Picture From Webcam?

Mar 26, 2015

I am developing a Student Database that shall capture Biometric and Pictures. I got the fingerprint on an access form. However I cannot get image directly from the webcam to an access form. I have to use the manufacturer's software to capture the image before importing to access using .picture property.

Is there any way of capturing the image directly from the cam to an access form?

View 1 Replies View Related

General :: How To Copy Picture On Attachment And Send It To MS Word

Jul 11, 2012

I want to copy the file stored on a attachment field (.jpg), so i can use it on a Word document as a picture.

I've tried it with bookmarks but no success:

' 'Paste the photo.
.ActiveDocument.Bookmarks("EidPhoto").Select
.Selection.Text = GetPath & "RE EIDPicture" & OwnerFullName & "_eid.jpg"

Then I only get the path of the file, Is there a control that i have to use?

View 1 Replies View Related

General :: Browse Picture From Desktop And Insert Into Database

Feb 5, 2014

I need codes to browse pictures from desktop or folder and insert into access DB.

I am using Access 2010.

I also want the code to only insert the name of the picture and then link its folder through the ID or some text,ok?

View 1 Replies View Related

General :: How To Lock Access DB

Jun 6, 2014

how to lock access DB Tables ,Queries, Report so other's can not import them to other access database (without encrypting my database with password ).I've noticed when forms have VBA codes it cant be imported if they locked by password(VBA) !

View 7 Replies View Related

General :: Possible To Lock View Design

Jan 16, 2015

is it possible to lock the " view design" the user at present could run a query and the view the design and change it.

View 2 Replies View Related

General :: Lock A Table In MS Access?

Aug 29, 2014

Is it possible to lock a table/macros/forms/reports in MS Access?

View 3 Replies View Related

General :: Lock Record After Approval

Jan 26, 2015

Is there a way that when I field gets a password entered into a field the form can be locked so nothing on that record or subform linking to that record can be altered ...

View 7 Replies View Related

General :: Access Will Not Save Picture Appropriately - Runtime Error 2450

Apr 27, 2014

I have a access program and recently I began getting this Error out of the blue . I really need to fix this error because it shuts down my entire program . When I go to save a pic like i always do and it will not recognize the "quote Main ".

Code:

Forms![frm_Quote_Main]![HousePicture] = Me.PicSave
Forms![frm_Quote_Main]![ZoomValue] = Me.ZoomValue
Forms![frm_Quote_Main]![GoogleZoom] = Me.GoogleZoom

Error I receive

Runtime access error 2450 ............. ? Capture2.PNG

Capture.PNG

View 4 Replies View Related

General :: Lock The Open Navigation Pane?

Jan 9, 2014

I want to keep the navigation pane open for use by the users, but I want it locked so that the users can't click on the top menu and change the pane's display from All Access objects to any of the other choices.

LockNavigationPane set to Yes is not the solution as this only prevents people adding, deleting and moving objects (such as tables/querys/forms).

View 6 Replies View Related

General :: How To Count Fields With Records And Lock Them

Feb 11, 2014

I have a terrible skill in this but I am doing my best to find ways. But I am running out of time in the development stage. I have the following form and table:

Tables:
Eqpt
EqptHistory

Forms:
frmEqpt
frmHistory

frmEqpt is the Mother form and frmHistory is the subform connected thru eqptID. Now what I want to do is count the records in the frmHistory and Locked the fields for editing. If it is new records, the fields will automatically unlock.

How do I do that because I can't find a way to count the fields with records and lock them.

View 9 Replies View Related

General :: Lock Date In Table And Query

Feb 11, 2014

I have a field that generates a date from when the first input is put into another field.

I know and can lock the "date" field in the form but is it possible to lock that date in the table and query?

View 1 Replies View Related

General :: Lock Individual Records After Saving

May 4, 2014

I have 4 users all with the same rights. What I want to do is lock each individual record created by each user from the other 3 users after they have been saved ( I am not referring to record locking/table locking while updating/creating ). i.e., They can all read each others created records BUT only update/modify their own created records. They all have individual passwords to log in.

View 4 Replies View Related

General :: Way To Get Access To Immediately Lock Record

Aug 15, 2013

I have a sales call tracking program.a list of available numbers are displayed to multiple users running the a user clicks on a record to get a call screen displayed with client info they then call the client and try for a sale.

the problem exists that two users can click on the same list record and open up the same call screen - they then both try to call the customer manually on the phone. one agent will get through the other will get a busy signal and record the call as a Busy Call. When the user with the customer is done he tries to record a Sale or No Sale and is met with an error message saying the record has been modified and they cannot save changes!!

I need a way to get access to immediately lock the record when it is clicked so only one person can open the call details screen? What is the best way to lock the records?

View 8 Replies View Related

General :: Import JPG Format Picture Size Into ACCESS Individual Input Cells

Sep 3, 2013

I saw a demo that the user could copy and paste a JPG format file physically to ACCESS, and then something happened, and ACCESS could read the JPG length and width size (e.g. 1.3 meter length and 1.15 meter width) into 2 individual ACCESS cells which is acted the same as user input to that 2 clells.

View 14 Replies View Related

General :: Lock Archived Records To Prevent Editing?

Dec 12, 2012

I want to lock archive records so that they can't be edited, however I want them available to users for viewing. So for example if the file is "closed" the record can not be changed.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved