Change Yes / No Field Automatically With Key Management

Dec 5, 2012

I am new with Access database and I found almost everything i needed on the internet. There is only one thing I just cant figure out when this looked like one of the easier things. Im making a database where all soorts of keys of all kinds of companies and homes are stored. In this database I want to keep track of the keys that are being used, who has the keys and when the keys are taken and brought back.

Most of these things work except one thing. In the table where I have the keys I have a field wich is 'In use'. This is a yes/no field and I want it to be yes when someone takes a key and to switch back to no when someone returns it. This is possible if it is done by the employees who use the keys but i want it to go automatically so no mistakes are made.

I have one table for the keys, one for the employees that take and return the keys, I use a master with detail form for when someone takes or returns a key and this is all shown in a query.

View Replies


ADVERTISEMENT

Automatically Change Number In Field

May 18, 2014

In a field called PSSheets I want the number to be update every new entry, if I use the AutoNumber feature it won't let me enter the number I want to start with, which is 1421001, then the next number would be 1421002 and so on right up to 1421200 and then the number would change to 1422001.

14/21/001 relates to Year/Week/Entry.

View 4 Replies View Related

Tables :: Change Field Data Automatically?

Feb 24, 2014

I have a table named days contains two columns (Day_Number, Day_Number_text)

and another table named information contains many column two of them is (Day_Number, Day_Number_Text)

so what i want to do when day_number = 1 for example so day_number_text = Frist automatically

View 7 Replies View Related

Automatically Change A Criteria

Nov 3, 2005

Hello to all the xperts out there,

I have a query with this criteria for Date field:


Where (([tblList].Date)>=#11/1/2005# And ([tblList].Date)<#12/1/2005#))

Is there any quick way, besides creating a form and run the query based on it, to have this criteria updated itself when it's a new month? I've gotten tired of changing it every month.

Thanks in advance

View 2 Replies View Related

Tab Pages To Change Automatically

Nov 11, 2007

hi...

im trying to create like a test in access. this is the idea. the user open the first form to enter the info like student number, name and so on. when he clicks the button he goes to another form where is the first question. in the top part is the student number wich was obtained from the First form and an option group with the answers to the question of the label box. Also a timer was included so the form close after one minute using the form_timer event. everything seem to work fine but when i go to the table to see the answers of the student, it look like if the student took the test for the number of questions, in this case forms, so if there is 20 questions(forms) it appears 20 times under the same student number, cuz all the questions are in diferent forms. then i try to take out this line from the first form when the user click the button:

DOCMD.GOTORECORD,, aclast

when i take that line out it seem to work fine only that when the user click the cmd button it goes to the first record instead of the active student record.
So then i thought of tab pages making them not visible until the user click the cmd button. it work fine with the cmd button but how do i put a timer to all the tab pages so that when time expires the next tab appear??

is that a bit hard??/
any help would be appreciated, thanx

View 2 Replies View Related

Automatically Change Table Links

Feb 13, 2006

I'm creating a leave (holiday) database but each year must be kept seperate for analysis. (I have split the front and backend of the database) I thought of using a dropdown on the main page which could be used to select the year which relates to the leave being dealt with. Depending on the choice selected (present financial year as default) the links would update to the required database.

Any ideas?

View 6 Replies View Related

Automatically Change Combo Box Value Trigger By Text Box

May 9, 2006

Hello,
This is the first time I am join this web & forum. My name is Angie.
I have face some problem for Ms Access. I would like combo box to be auto change when date due. Eg: combo box name: Status. Inside have info such as Expired, Active, Ignore. This info will base on the text box name txtenddate. When the date is due, (eg:today:09 May 06), combo box will auto change the status from Active to Expired.

Any VB code can be used. Thanks.

Hope to heard from you soon.

Regards,
Angie

View 1 Replies View Related

Use Macro Or VB To Change Column Title Automatically

May 26, 2012

I'm making a db that will import a spreadsheet from Excel, then separate it into 3 different tables using queries, but then I need to put all the 3 different tables together one after the other. The problem is that the 3rd column on each table have different names on each table, so I can't append the tables together.

So, how can I use a Macro or something to change the column name on all 3 different tables so that they match and can all get appended together.

View 2 Replies View Related

General :: Automatically Change Data Paste To Include First Eight Characters

Dec 8, 2012

I have a form with one control field that I paste a 17 digit alpha numeric value into. I have a command button that then runs a query based on the pasted value.

Is there a way to automatically change the data I paste to include the first eight characters, replace the 10th and 12th position with wild cards, and delete the remaining 6 characters ?

Example:

Copy: 1GTEM14M0WZ526688

View 3 Replies View Related

General :: Input Data In Lower Case And Automatically Change First Letter Of Word To Upper Case

Mar 16, 2013

Is there any way of making data that is inputted in lower case to automatically change to the first letter of each word being a capital ...

View 4 Replies View Related

Automatically Populate A Date Field Based On Value Entered In Another Field

Nov 10, 2005

I need to create a New Form control for this situation:

If I enter a date into a field and the choice for another field is equal to a certain value. How can I get the date I entered to be automatically populated into another date field.

For example:

If I enter 11/10/2005 in a date field and I choose either "BN", "BA", or "BT" in a text field, I need that date of 11/10/2005 to be automatically populated in another date field on the same form.

Any help is greatly appreciated.

View 2 Replies View Related

Tables :: Automatically Fill Field Based On Keywords In Another Field

Dec 3, 2013

I'm trying to complete a database.

It is to manage details of pupils with additional support needs, and plan for the extra arrangements the school will provide for assessments.

It has 2 Tables

tbl-PupilDetails
-ScottishCandidateNumber primary key (Unique number which identifies pupils to the exams board)
-Forename
-Surname
-DOB
-YearGroup
-Class
-NatureOfNeed (memo)
-EvidenceOfNeed (memo)

tbl-SubjectLevelArrangement
-ID Primary key, Autonumber
-Pupil foreign key to tblPupilDetails
-Subject
-Faculty
-Level
-Arrangement

I currently use forms for adding new pupils, and updating pupil subjects/arrangements/levels.

I also have forms to search for specific pupils, and to create lists for faculty heads showing which pupils are taking subjects within their faculty and the arrangements we expect to provide.

I use the forms to run queries, which can then output to reports for printing.

Where I am currently having an issue is the faculty field in the tbl-SubjectLevelArrangements. (If I didn't have to report to faculty heads I would just leave it out, but management will insist.)

Currently I have a form with dropdowns for adding subject, faculty, level and arrangement manually. This is acceptable for the subject, level and arrangement because they are completely interchangeable and dynamic throughout the academic year as pupils may drop down a level, or change the type of arrangement they require.

However as faculties are inextricably linked to subjects, I want to remove the possibility of human error. i.e. when a user (me) chooses either geography, history, or RE, then the faculty will always be Humanities, likewise if the user chooses French, German, or Spanish, then the faculty can only be Modern Languages etc.

I'm convinced there must be a very simple way to ensure that the faculty field prefills based on the limited keywords available in the subject field, but I just cannot figure it out.

View 6 Replies View Related

Reports :: Get Remarks Automatically In Field Based On Other Field In Report

Dec 15, 2013

I made a report that have 'txtRemarks' field, I just want to get remarks automatically in 'txtRemarks' field based on the other field in report. that is why I used a function like below:

Code:
Private Function Estd_Remarks(Estd_Point As Long) As String
If Me.Estd_Point < 20 Or Me.Estd_Point = 0 Then
Estd_Point = "Earlier Established"
Esle
Estd_Point = "OK"
End If
Estd_Remarks = Estd_Point
End Function

And I wrote in properties 'On Format' event this code below:

Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Estd_Remarks = "Ok" Then
Me.txtRemarks = "Ranked & Sortlisted"
Else
Me.txtRemarks = "Estd_Remarks"
End If
End Sub

When preview the report then it shows
Compile error
Argument optional

View 3 Replies View Related

Change Field Value On Change Of Other Field In Form

Apr 2, 2008

What I want to do is following.
In form ASSIGN(fields are takedate and inout) ,if TAKEDATE is different then 0 then set value of inout field to 1
My VBA knowledge is poor cause i dont think this should be hard

thanks in advance

View 8 Replies View Related

Automatically Set A Field Based On A Field In Another Table

Aug 12, 2005

I have two tables, each has a "status" for a project. In the first table there is only one instance of each project name, in the second table there may be more than 1, will always have the same name but may have a different "Status" (field).

I need the Status field of the first table to be set to "Assigned" if ANY of the records in the second table pertaining to that project are set to "Assigned".

Can I do this with my table or will I need to do it with a query/form combination?

Thanks,

View 4 Replies View Related

How To Make A Field Automatically Receive Same Value From Another Field

Apr 22, 2014

In Access 2013, in a table named DOCSDETAIL or form, I want the UTENTE (meaning user) field (Currency type €) automatically receives the same amount of PVP field (Currency type €) but can be modified as needed.

Example: Registration of documents in which the amount paid by the USER has two possibilities;

1. DifferS from PVP (Public Sale Price)
2. Equal the PVP

Looks like it might be used

= "Update your_table set your_field_new = your_field_old"

= "Update DOCSDETALHE set UTENTE = PVP"

But do not know where to put and if the syntax is correct!

View 5 Replies View Related

Copying A Field Automatically From Another Field

Apr 14, 2005

Hi

Forgive me - but i am new to db.

I have an employee field in my purchase orders from and when I do stock transactions - i have an employee field against each item in the purchase order. I would like to just copy the employee field from the purchase order form automatically next to each product listed instead of having to keep typing the same thing.

the reason i am doing this is because when people come to take stock out - i would like to see there name against each item in the products from so people can not not take more than they ordered.

thanks in advance.

View 4 Replies View Related

Changing A Field Automatically

Dec 7, 2004

hiya... he's my problem........

i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.

in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)

If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.

How do i achieve this please..????

many thanks for viewing!!

View 1 Replies View Related

Changing A Field Automatically

Dec 7, 2004

hiya... he's my problem........

i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.

in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)

If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.

How do i achieve this please..????

many thanks for viewing!!

View 1 Replies View Related

Automatically Fill In Field

Aug 12, 2005

Hi everybody,

I have a table that has 4 columns as shown below:

(*It really isn't code, I just couldn't figure out how else to keep the columns in place!)



-------------------------------------------------------------------
Store Name Invoice Number Customer Name Customer Address
Store1 1 Bob PO Box 55
Store1 2 Joe PO Box 789
Store2 3 Chris PO Box 1254
-------------------------------------------------------------------
On my input form, for entering a new invoice, when you select the customer name, I want the form to automatically fill in the correct address in the "Customer Address" field.

I think there has to be a way to do this because there is only ever going to be one address for every customer. And the same customers will be comming back very often.

Does anyone have any ideas?

-Chris

View 14 Replies View Related

Automatically Calculate Field

Dec 16, 2005

Hi guys,

I have a mainform "frm_CaseReference" and a subform "subfrm_CasesControls".

In the main form I have "DOB" field and in the subform I have "DateSlideTaken" and "AgeAtSmear" fields.

I want to automatically calculate age in the "AgeAtSmear" from the "DOB" and "DateSlideTaken" but having problems.

I have tried the following code but it doesnt work:
=DateDiff("yyyy",Forms!frm_CaseReference!DOB-[DateSlideTaken],Now()

I have read it is not good idea to store age but my work place want this so i have to include it. Can someone please help....

View 2 Replies View Related

Automatically Update Field

Sep 12, 2006

I am currently handling an insurance operation. I have 5 Sales Executives (SE) who receives certain percentage of commission for each sold insurance policy. SE receives their respective commission on a pro-rata basis. Meaning, if they give 4 equal monthly payment scheme to their clients, they will also receive their commission -- 4 times.

Example:
SE Commission for one sold policy is: 100.00. (Granted SE gives 4-month-term, SE will be receiving 25.00 monthly, upon cleared payment)

On my 2 tables lies the following fields:
[Table1]
SECom1
SECom2
SECom3
SECom4

[Table2]
CustPayment1
CustPayment2
CustPayment3
CustPayment4

Is it possible to automatically update Table1.SECom2 based on the figure on Table1.SECom1, once Table2.CustPayment2 is updated?

Thank you!

Sheila

View 2 Replies View Related

Automatically Filling A Field

Jan 25, 2006

This is probably very simple to do, but, I am most likely missing the obvious...
I have 3 fields,
UnitPrice,
NumberPerUnit, and
NumberPerUnitCost.
I would like to have the NumberPerUnitCost field filled automatically based on what I have entered into the other 2 fields. I would also like to have this saved in my table as I will use this single unit cost when calculating some production costs.
Any and all help would be appreciated. If I am going about this the wrong way, please redirect me.

Thanks, Karen

View 3 Replies View Related

Automatically Add Field To Imported CSV

Feb 5, 2015

My "MainMenuForm" contains a button that imports a specific csv on a specific location.Someone should do this import once per day. The problem is that there is no way for me, once the import has been done, to know which records are "new".There is no unique field that distinguishes the new records from the old ones.

I was thinking of adding like a Date() field to that csv (= the date where it was imported). Can this be done automatically? So if I import a file today, the final column would be 05/02/2015If i import a new file tomorrow, it would be 06/02/2015.

View 2 Replies View Related

Automatically Add New Memo Field

Jun 27, 2011

My boss has been asking me to create forms in which he can add new records at any time. He has different review cycles for each company he owns (either monthly, quarterly, or annually). I have a form called "REVIEWS" where my boss wants to be able to add a memo with a time stamp each time the review cycle is updated.

How can I use the "addNew" function so that a new memo text box appears in the form each time the review cycle is completed? My boss wants to be able to see each of his notes for each time he reviews a company so I want to be able to keep the old memos as well.

View 14 Replies View Related

Changing Field Names Automatically

Oct 15, 2005

I have an Application that I want to re-use for a second user. The only change I need to make is to re-name the fields.

Is there a tool that can do this across the tables, queries and reports for each field name change ???

View 1 Replies View Related







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