I want to make database only for time spent in office. In that database i want people to login and when they finish there work press logout. The table would consist nt username, time logged in and time logged out. This would enable time spent at work. When the person presses login it would stamp the time on the table along with the username.In this only check i want to enable is if the person presses login again then it says already logged in press logout. So no duplicate entrys in the database unless person first logs in and then logs out. I want to enable check before entering the data in the table. Attached is the database for further analysis. Please advise.
Hi.. Been trying to work this out for a little while now. I run an IT workshop for adults with learning issues and although my other office skils are pretty good, my Access skills are a little lacking.
My clients login and out on paper at the moment but I would like to change this to a database type system. The entries would only be name and an automatic one to record actual time of login.
i've completed the whole access DB, but now i need to implement the login form, so each user can access their data + admin access.
what is the simples/fastes way to do this, since i've got working db. I add fields (user-log-id and password)to "userTable" and now i just need simple veryfication to login and logout.
where I can find VBA for (Tracking User LogIn/LogOut) I have tried researching to no avail.I just need a simple code to track users logging date & time in and out of my DB.When they click on the icon on the desktop id opens the DB to login screen with username & password then into the DB.
Hi I am in need of help again.. Want to thank Ghudson for his help previously.
Now I am stuck in a stupid problem.
I have a log out button, but I cannot code up the button, where when I want to log out, it will automatically saves the record in a temporary database[auto generated] and it will date the database record on the day that i save.
I have a ms access application in Front End and linked tables to sql server 2008 r2 in back end.. every time I open my application the linked tables ask to me for the user and password of the sql server user of the odbc conection. I want to connect to my sql database without login every time the user open the application, I know that can be possible if I start session from vba code...
I have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for users with limited access.
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.
I am using this [URL] .... in our project but have made a minor change so it logs people out rather than close Access completely. It works beautifully but I want to take it a step further.
Instead of hardcoding the times in these two values
I'd like to give users the options to set these themselves as not everyone will be the same. I am thinking I would have to check for who is currently using the database, this is stored in a hidden form in the following field.
[Forms]![frmwhoson]![whoson]
This username matches the users First Name in table Employees and in this table I have two fields to store these values
logmeoutafter showlogoutmessagefor
So passing these values for the current user rather than having the logout times hardcoded.
Hi guys. Back on the development trail having enjoyed a long break after the birth of my son :)
How quick one forgets!!
Project: My father-in-law would like me to develop a DB for his new company. They buy and sell plant hire (all done the old fashioned way, on paper).
His requirements are a little beyond anything I have attempted in the past so was hoping for some sound advice.
He would like to be able to record both Sales and Purchases. I have never worked with Stock before. What is the best method, any examples (did a search on stock prior to posting). He would also like to have VAT as an option (this stumped me on my last project!!).
Hi People, great forum here and i've learned loads in a few hours ive found it :D
im just wanting a bit of information or some pointers as i cant seem to find anything on the forums about it, first off i have a DB (access) with a list of employees in i have variuos reports and other tables etc, what i want to be able to do is get access to work along side Word, -
i need each employee to fill out variuos forms that come in word format , i want to know if A, is it possible to auto fill a word document out with variuos information from the DB, as im pretty new to access and have no working knowledge of VB then im stumped - then B, i want to be able to save this in a folder on a network drive and have access to the form etc or scanned form etc for each employee.
any help would be great on this as my brain is havin an overload and i only have a certain time cale for the project
thanks in advance to anybody who can show me any pointers
this Project about computer company , the Boss of this company want from me to make database help him to know :-
Customer's Information. what the customer's invoce , pay , remain. Supplier's Information. money come , money go.
that's not all , but it's the main points , I just want the any project similar to my project....... or at least , sites have examples for what I want.
NOTE : I attached Company.zip that contain Company.mdb and Company.accdb (they are the same) that what I made until now.
Hey guys, new here and I need a little help with a project my boss wants me to complete.
Basically right now, he has a huge directory of quote sheets that he fills out whenever he wants to generate a quote for a customer (they are excel files, i've attached a picture of one). He wants me to create something that will scan through this directory file by file and extract certain pieces of information from each excel file, and put them into a database. The company I work for isn't too big, so i'm going to use access as the database.
I've also suggested building a new quote sheet in VB, and programming it so everytime the form is closed, the certain pieces of information he wants will be saved into the database. So I guess after this we can forget about Excel. But also, he wants to be able to bring up the entire quote sheet again if need be.
If you guys could please help me out, what would be the best way of going about doing this? Am I heading in the right direction as far as my thinking goes?
hi every one, how r u all i really need your help i asked my friend and he told me about u guys my problem is : i want to create a database for entering student marks ^^ but i don't know much in access so could u plz help me i want to u make the Relations so that i can make any form to enter the data i made the relationships but there is problem " i can't enter marks for new student "
Please help i have to submit it this Saturday
i will appreciate for u guys if u make as soon as possible
Hi, I have a project about creating a data base of Foreign Trade, where I have to choose the country, then to determine the period (years). so, could you please tell me how: 1- to link a combo box with a query (comob box of list of countries) 2- to link 2 combo boxes with a query of starting date and ending date (the criteria is: >=[start date]and<=[end date] ).....should I separate this criteria and put it in to 2 columns of same data (years)...I tried it but it didn't work. 3- to link a Run Query command button with conditions mentiond above. When I established the command button, it showed the whole data base, so how can I link it with 2 conditions above. Waiting your appreciated replies a.s.a.p.
I am new to this forum and to Access. I have expierience with visual basic.
I am making a program in access for saving data when someone borrows something from you, to keep track of all your borrowed stuff.
Here are my questions.
1) How can I write code for buttons to change the records (movenext, movelast,...) + how can I change the current record? + how can I control a scrollbar via code?
2) How can I change the current recordsource via code and how can I run previously made query statements via code?
3) How can I change the ShowDropButtonWhen property from a combobox via code?
4) How can I control a FlexGrid via code?
5) How can I open another Form with a press on a button via code?
6) How can I save and load an OLE/object image and how can I show them via an ActiveX control?
Thats about it folks
If anyone can point me in the right direction or can give me an example database, I would be very happy:)
Ok first off thank you for anyone who even reads this.
Iv been assigned a project in using Access 2003 and only Access 2003. Im stuck and getting frustrated and was wondering if anyone would mind helping me.
What my Prof wants is a Access database with a form to do the following
Ok he wants us to input 1 of each category as if we were ordering
then he wants us to order it and print out a Recipte with the following info.
Sub total Tax Total Purchase How many Calories the entire order is.
Im attaching a .mdb file with what i have come up with but im not sure if its even going in the right direction. I would forever be in debt if someone would help me.
rename the wendys.txt in the zip file too wendys.mdb
Ok, well basically i am trying to write my own database. and i have not the a very good working knowlage of access and some many bits that are over my head, Would any of you guys be willing to help me out with this? I would be willing to pay someone to do this, if you could give me prices per hour ether here if permited. or via Private Message. for comunication purposes i could use skype or msn messanger. as there will probably be some bits i would need to explain. I am a little bit of a perfectionist so i would try and explain as clearly as i can as to what i want. there is no desparate rush on this project altho july would be great, one of my friends was meant to be helping do this as he is good with access but i have been waiting for him to do this for about 6 months.
Lately I have been using my db's on computers which did not create them (my db's). I've been seeing this message sometimes; Microsoft Access You have modified a signed project. you do not have the correct key to sign this project. the signature will be discarded.
can someone point me in the right direction. I think I've been down this road before but forget the correct path:confused:
I have over the last few months been building my own Project management system.This is based around A Phase task principle but the phases and tasks are used to create an estimate for a project depending on how much time is assigned to each Task.The system can use multiply Estimates with different billing codes plus their is a billing code system where billing can be done by a default list of codes (Rates 1-5) Or assigned rates for a client.I'm not after any money for it and will make it available to members hear.If anybody want to look at it and maybe make suggestions on improvements or let me know of any errors that would be greatIt would be an mde with an mdb back end.You should be able to update the back end that I don't think will be a problem LOL When it comes to new versions.As I said I don't want ANYTHING For you using it but would be nice to get it working better.mickp.s Ill Post some pictures if ya want. And It is a work in progress?Please use this topic from now on http://www.access-programmers.co.uk/forums/showthread.php?t=121117 this is where the beta 1 downloads available from.
I am a total NOOB when it comes to access....i am currently taking an access class at my college and its time for our first project. I really need help getting started cuz alot of the terminology is so new to me... I have been provided with a sheet of information and have to create a DB based on said information.
if anyone out there is feeling super generous with their time and is willing to help me through it...just to get me started..my aim is NIPPONLIFE86.ive found that its getting everything going that is the hardest...especially when im creating a database not just inputing data.:confused:
Does Access database support muliple users on the same data update, if so how many. What will be the best way to avoid locking up a field when somebody else is trying to update a different field within the system. It run on server:
I have extensively searched the forum to try and find an answer.
Im trying to develop a Project tracker database which will track the progress of my ongoing projects, does anyone out there have an example or another link to get me started.
I know MS Project would be the answer but we do not ned it in as much detail as this and they definately want it written in MS Access.
