What i want to achieve is that when i login that automaticly the name has been filled in on every form.
I have a login form. I put my name in there like "Michiel" and ofcourse the password. After that its going automaticly to the mainpage. In that mainpage i want to create a field that automaticly filles in my name (so if somebody else log in that their name will be filled in). After that i want when i go the incident form that automaticly the employee form has been filled in. (The person that at the moment is logged in that his name automaticly been filled in) Ive tried various ways to achieve this goal but nothing worked.
Im not that very expert in Access but im trying to understand and learning pieces by pieces the Access world. So if somebody could help me because im getting desperate! Thanks in advance all! :D
I am stuck for over a week now, and tried just about everything I am capable off ...
I have two forms: COMP (where I fill in fields for Company Table) and PERS (where I fill in fields for Person Table). On the COMP-Form I have a button, named: 'Add Person/Employee to Current Company'.
The two tables (Company and Person) are linked by PK - FK (PK_CompanyID & FK_EmployedAtID).
I can't get it to work properly. The PERS-form must be filled with the company info I filled in the form COMP, after I press the button. But the PERS-form also must be filled out normally (not via COMP, but seperately), choosing the company in the comboboxfield 'Company Name' on the PERS-form. Do you stick with me?
So I want to start the PERS-form with the filled in company Info by pressing the button. And I want to be able to start the Form seperately (which I can off course) and choose the company myself , by selecting the right company in the combobox.
I have a attachment sent with this.
Can someone look at this for me, and explain what I am doing wrong.
I tried to do it with a autofill macro, and with some code ...
I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record.
How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being blank.
For example if I have Charger12345 open in the Asset form, I'd like to click the Add New Job button and it automatically have Charger12345 in the ChargerID field of the Jobs form.
I have a requirement to categorize a field in the employee database.
The requirement is: for any given user designation, if the total number is 10 or more, I need the actual designation itself as the output. However, if a particular designation in the organization is less than 10 in total, the output should be 'Misc - and the grade'.
Also, this will need to be done for each grade as well. For example, though the staff designation 'Software Engineer' count is 15, the designation is present across two grades A and B. So, in the output, for the staff with Grade A will show the actual designation as the count is 11, and for Grade B staff with the desgination 'Software Engineer', since the count is 4, it should display the output as 'Misc - Grade B'.
I have a button on the school form that opens the venue form. I want the school field that is on the venue form to auto fill with the same information that is in the school field on the school form. Any help would be awesome.
My table called Table1 has a primary key field (called RefID) with AutoNumber format. My problem is I want duplicate value of RefID field to another field called DupID. I want DupID to be changed, but I don't want any change on RefID field whenever I make changes.
Here is what I want to do. I have a table called "TblRates" and in the table are two fields called "Description" and "Rate" the description field has data in it like "PC Repair", "Onsite Repair" and the "Rate" field has currency data "$50.00" and "75.00". I have a for called "FrmRates" and I want to be able to select "PC Repair" from the "description" field and have it auto fill "$50.00" into the "Rate" field and the same for "Onsite Repair" and have it bring up"$75.00". That is the best way I can describ it. I would like to either know a macro or somthing easy I can type in VB code which I know nothing about. Please Help
I am fairly experienced with Access but am stumped. I have a table with a primary key ID field, product name, and product price. On an order form, I want to select the product from a combo box and have that product's price automatically populate a text box beside it for further calculations. Any help would be much appreciated, thank you!
I am trying to autofill a field based on the value of a previous field on a filtered form. I think the fact the records are filtered is throwing me off. Any help for me?
I want to Autofill one of the field in my form, by checking specific conditions in my database. Example of which is as below:
1. Date of Maintenance : 2. Loom No. : 3. Component Replaced : 4. Component Type : 5. Latest date for same component replacement :
I want to autofill the Sr. No. 5 in the form itself by checking database, and if Sr. No.2=Sr No.3=Sr. 4, then latest date should be autofill in Sr. No. 5
Say, A component was replaced in a Loom on 01/01/2013 & again after six month same component is replaced on 01/06/2013 so while filling up the form, In sr. no. 5 latest date 01/01/2013 of replacement of same component in same loom should be pulled from data base.
I have 2 tables: A and B with field names: ID, Title, Link
and one table C with: ID, Title
The Link in each table "points" on another table.A points on B that points on C.(When you fill in column Link in table A or B, a Lookup table is used so that I can select one of the titles in the linked table).I want to add a new field name called Position in table A and B. The Position is supposed to describe the cells place in the tree.
Example: if A with ID 1 points on B with ID 2, and B with ID 2 points on C with ID 3 then in A Position data field it would say: "3.2.1".I would like it to autofill Position when I add a new title.
I have a review pop up form (frmReview) where a user selects their Name (StaffID), the type of check they are doing (QuailtyType), and the client they want to do it on (clientID). When they press on the 'do review' command button from this form another form opens (frmReviewDetails) which shows the client they selected from the frmReview form as well as a its subform which shows all the sessions that have been entered for this client along with some fields that have not been complted yet regarding review data. I am trying to have it so when they check the 'review check box' in this subform that today date auto populates in the Review date field (this is currently working). I also want it to auto enter the staffID that they selected on the the initial frmReview form.
This is my currunt code:
Private Sub Rev_AfterUpdate() If Me.Rev = -1 Then Me.[RevDate] = Now Else: Me.RevDate = Null End If End Sub
I really don't want a staff to have to enter their name each and every time they check the review box. Not all box's are going to be checked, so it needs to be on a record to record basis.
I know all of the main features and can even do a bit with macros and VBA. I need creating a button to auto-fill a field in all the records in a table.
I have a database centered around a table called tblCand; each record contains a date field called intDate. On the main form, initDash, when the user hits a certain button, a window pops up (either a message box or perhaps a separate form) that asks the user to type in a date, which would be stored as intDateDB. When the user hits OK, I want the value of intDateDB to replace the value of intDate in all the records in tblCand.
I'm not sure whether this is called auto-filling or auto-populating...
I have an Access database with several tables and a multitude of subforms which are displayed on a single master form. The subforms are used to facilitate data entry. In several of the tables there are fields which are related and I would like to have some of these fields updated based on the results entered in the related field (i.e. the answer for one field depends on the other). Field 1Field 2 [facing][DISC_CODE] un3 up1 dn2
Field 1 is a simply a description of the basic dataset. This field is already set-up on form as a combo box that allows the user to choose one of three options. Field 2 is a code number used by another piece of software to identify a particular symbol. It is a new field being added to the database. There are 200 codes that identify a wide range of symbols for different types of data and I don’t want to have to look them up when I, or my assistants, are doing data entry.
My question is this; is there anyway to have the DISC_CODE value, Field 2, automatically entered in the table when the value for Field 1 is selected in the combo box on the form?
I am very new to access and I am trying to figure out how to build an expression for one of my fields. I have a field called Order Date, which holds the date of when an order is filled. I then have another field called Fill By Date. This new field I want to be 2 weeks after the Order Date. Is there a way to auto fill this information so that when I enter a date into the Order Date, it will enter the date that is 2 weeks after into the Fill by Date?
I am new to Access (using Access 2012) and All I am trying to achieve is to autofill the field [Frequency] from Table FullList based on the value of [Frequency] from Table Courses using a DLookup code used to update the FullList form. The code is not updating anything! It is frustrating! Frequency is a number (integer) and while Course is a text. The figures of my Access database are below.
Autofill text field using combo box selectionHello,
I'm trying to autofill a field on a form using MS-Access 2010 Web version sharepoint using macros without coding.
The form has an existing Combo Box field called Segment, using the row sources "REW", "WTT", "DBM".
A user begins filling out the form and eventually selects the Combo Box for Segment and selects any one of the segment no Multiple selection
There is another text field, which is actually alpha-numeric, called Job_No. I want this to autofill based on their Segment selection, using this format:
REW-YYMMDD-TTTT, or REW-131210-20001 for example, for today with the time displayed as military time and last Job No.(20001) for REW and Also for WTT (30001) as starting number.
Hi all, I am looking for an employee record template for data including sickness, vacation, skills, CVs etc. I would have thought there would be loads available but alas, I can find none
Can anybody point me in the right direction please.
Trying to setup a database to track employee compensation and need some advise on the setup. I was told in a previous post to normalize my tables which I think I've done. I would just like some other input on this to know if I've done it right.
I created a table called Employees with the following fields: autonumber id field, firstname, lastname, department, position, hiredate.
Next I am creating a new table for each year which will contain the following tables: autonumber id, base, bonus, addbonus, overtimecomm, car, 401kcon.
The autonumber ID fields in each table have been set as the primary keys and I've setup a relationship between Employees and each of the compensation tables.
Does this sound like it will work? Or do I need to go back and rethink some of the process?
I have a form which has a drop down box which links to a table with Employee names. One employee quit and I want to delete her name from the table. But... if I do that, I will delete her entirely from all previous records. Is there a way to keep all previous records, but take her out of the drop down choices?
I'm trying to use a query to calculate the payroll for all the employees but it won't work. The two tables I have are 'Employees' and 'Employee Payroll'. In the 'Employee Payroll' table there are three fields- Employee ID, Days worked and Earnings. I need to calculate the sum of the earnings field but it just displays a blank list of records when I try it. Can anyone help? Thanks
I'm trying to create a database in Access to track various employee data for the company I work for. We have about 44 employees. There are about 7 different groups of data our poor secretary now has to keep up with. These include: a list of the employees, with name, address, phone, etc. A handmade form with salary information like current wage, raises and when they were given, etc. A bonus section, how much and when. A list with attendance information including tracking missed days and tardies. A list of temporary employees and when their incremental reviews are due. There are other lists we use and others we are thinking of starting having to do with training, etc. It’s too much to keep up with manually now. One of my questions is: can there be one table with the basic employee information that other tables can access without having to enter the same names again into other tables? (Why enter all those names more than once)? My other question has to do with linking tables together, I just can’t seem to grasp the concept even after reading two Access training books on the subject. I made a simpler database for another project and gave up on linking tables and the database seems to work just fine. Any help is appreciated and sorry for the long post.
I have an Employees table. I have a form to Add Employee and a form to Remove Employee. Remove Employee works great. It's a drop down box, they select the employee and click on remove. With Add Employee, I have a textbox where they enter the name and a button to add that employee to the database. I setup a VBA script to take the value in the textbox labled "empname" and insert it into the Employees table when the button is clicked through the onClick event.
Is there an easy way to do this? I need the UI to be simple. I know you can bound the textbox to the employee name, but then when they open up the form it will show all the records and they have to click the new record button to add someone. I know this question was asked very recently, but it wasn't answered very well.
I have the db attached. It's in Access 2003 format. The macro in there is the VBA script that I wrote, so don't worry, it's not harmful. I'm very good with SQL, and I would've chosen to use ASP for the user interface, but the people that need this don't want to run any servers (IIS). They just need a file they can double click on and work from there.
I am nearly ready to release my ACCESS 2000 database to 150 employees in our office (client/server network). However I have two problems, I have looked through countless posts and cant find exacly what Im looking for.
ACCESS automatically defaults to each individuals network ID when it is opened, so I have set that as UserName for each user, I have created a UserDetails table with this netowrk ID as a primary key, linking that as a foreign key to various OrderDetails tables. My question is how on earth can I get ACCESS to automatically enter this UserName onto each order a particular user makes? to be able to run queries for specific users etc? I dont want the user to be able to manually type in this because it can compromise the integrity of our data.
secondly, what is the best way to set up the FE, BE situation on our network? I tried the wizard and it gets a bit technical
Cheers for the help and congrats to a very helpful site, Russ :)
