Multiple Qualifications With Expiry

Oct 24, 2011

We work in 7 states I want to build a skills database so i can search for particular skills, sometimes excluding people based on home state for travel reasons..

I am editing a free student template..

View Replies


ADVERTISEMENT

Formal Database Qualifications?

May 4, 2006

Hi all,

I'm looking to formally advance my knowlegde of databases and their design and was wondering if anyone was aware of an institution that offers a course (Diploma or MSc) in that area. I found one at the University of Winchester but they don't offer distance learning which is what my preference would be.

Any help would be greatly appreciated.

Best Regards,

Aaron

View 1 Replies View Related

Date Expiry

Sep 26, 2006

Hi I am doing a date expiry query which has worked for one of my other queries i have copied the same criteria for another table but for some reason it does not work now

Below is the SQL i am using

SELECT Computers.[Machine ID], Computers.[Machine Type], Computers.User, Computers.Department, Computers.[Installed Applications], Computers.[Serial Tag], Computers.[OS Installed], Computers.[Pc Brought]
FROM Computers
WHERE (((Computers.[Pc Brought]) Between DateAdd("d",30,Date()) And DateAdd("d",-30,Date())));

I have 3 records which are within the criteria but for some reason i do not get these.

Any idea why this does not work but works for my other query


Many thanks

View 2 Replies View Related

Expiry Date (edit)

May 25, 2005

I have a issue date and an expiry date feilds,

the below script in my query is to automatically increase the date by one year, this works fine but i would like to be able to back date the script if necassary.

i have checked the properties and the field is not locked. but it wont let me change the date.

any ideas

Expirydate: DateAdd("m",12,[Issueddate])

View 4 Replies View Related

Expiry Date In Access

Jan 23, 2006

Hello, im new to this forum, and i need some help fast.

I have a database which is a list of all of member with some information and an expiry date for there membership. What i would like to be able to do is run a query and for it to search a table and give me the names of the people whos member ship has run out or is going ot run out within a month of the query being run.

I have tried several things already but access isn't realy my thing, i do Visual basic .net .

If any one has any ideas about how i could sort this would you please be able to respond, thanks in advance!

View 5 Replies View Related

Forms :: Expiry Date Warning In A Popup

Dec 9, 2013

Can a Form/Query warn when a date is approaching; like in a pop up or any other behaviour?

View 7 Replies View Related

Queries :: Maintaining Proficiency - Expiry Of Count

May 25, 2014

I have a table for logging experience for employees related to a given requirement.

The requirement is that any employee, to maintain proficiency ("be current") , must maintain an event count of minimum 5 within last 3 months. Or else the employee is not current and other measures must be taken.

I want to know when the currency expires for each employee (= at which date does the employee no longer have a count of minimum 5 within last 3 months).

So with the data below

tblProficiency
--------------
ProfID (PK, autonumber)
ReqID (FK)
EmpID (FK)
Completed (Date)
EvenCount (integer)

Code:
ProfID EmpID ReqID CompletedDT EventCount

10 2 1 10/04/2014 4
11 2 1 11/04/2014 3
12 2 1 12/05/2014 2
13 2 1 13/05/2014 5
14 2 1 14/05/2014 3
15 2 1 15/05/2014 2
16 2 1 16/05/2014 1
17 3 1 17/05/2014 3
18 3 1 18/05/2014 4
19 3 1 19/05/2014 3
20 3 1 20/05/2014 1

The result should be:

EmpID Expires
2 14/08/2014
3 18/08/2014

I need a hint for some SQL to do this.

View 4 Replies View Related

General :: Automatically Store Expiry Date?

Nov 18, 2013

i need a method to store an expiry date. i have a column prepared in my table but i do not know how to reach the desired result.

the date will always be different depending on certain criteria

the course length. some courses we have are valid for a month. some for 6 months. some for a year and some for only 14 days.

i can use the date add to add the date period to the purchase date but i do not know where or how to store course length to be able to use it.

i have approached this before and i had a column in my courses table as below

("m",3,Date())

i pland on haveing this type for each course and varying it as applicable but this did not work and apparantley i was breaching the fundamental rules of relational data.

View 8 Replies View Related

Validation Text For An Expiry Date On A Credit Card

Nov 20, 2005

Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this:

MM/YY but i cant find a way of doing this!

I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this:

>=int(now())

So the input mask has to accept this validation...

If you could help, i would be very greatful!

Cheers

View 1 Replies View Related

Queries :: Check For Expiry Date And Stock Levels

Apr 23, 2013

What I am trying to do is create a stock database and iv imported a blank version of the northwind template and filled it in with my own products which is fine up to a point.

What i also have though is i get weekly reports of the stock of each product with their batch numbers, expiry date and quantity remaining for that individual lot sent to me from another company. (So i might have several lines with the same batch number and expiry date but diffeent quantities) So what i want to ask is:

Is there any way for me to combine the data in the weekly reports with the stock level data in the northwind template?

What i want to be able to have is where somehow i can see the total quantity of eac product with the same batch number and expiry date and then it tells me when that batch has expired and it also automatically deducts the stock from my total stock when it gets to within e.g 9 months of the expiry date as we will not likely sell those.

I need to do this as at the moment all i can get from my database is how much stock has been ordered, sold and what we have in total on hand but if the stock is close to expiring then i wouldnt know and i need to be able to see when to order stock in advance as i want a minimum of 6 months cover and ideally 9 months cover as orders for stock dont come in straight away.

Also, how i can import the data from the weekly reports into excel/access easily as they come as word files presented as a table but the data is put in frames i think and iv tried removing them but then it all looks messed up.

View 1 Replies View Related

Queries :: Show Data About Certain Checks - Expiry Date

Aug 7, 2015

I have a query which shows data about certain checks that are carried out employees. One of the fields is Expiry Date of the check. What I want is for the query to show only records that have a expiry date which has expired or is going to expire within the next three months of today's date. But I cannot work out how to do it!

View 2 Replies View Related

General :: Data Input Mask And Expiry Message?

Jul 12, 2013

I want to have an input mask on an 'Expiry Data' Field so that the input method is 'MON-YY" and I need access to realise it as a data. And then I also need when a user opens a record an anything that is 2 weeks from expiring I need an error message to pop up.

View 1 Replies View Related

Auto Email To Client Before 30 Days Of Expiry Of Loan

Oct 29, 2013

I'm using access database. i want to code my database so that my database automatically send email notification to client and also to admin of loan expire information ( Expired date and Loan Limit which is already in my database).

View 14 Replies View Related

Queries :: Expiry Date - How To Show Remaining Days Or Over Due In Query

Mar 5, 2014

I have a query call courses and field name expiry date I have add additional field within the query to show how many day left and how many days over the expiry date

Code : DayLeft:[expirydate]-now()

but i just get a error when i run the query

I also would like to ask is this possible to be done within the table e.g adding another field dayleft and some how add formula to calculate number days left or over due .

View 2 Replies View Related

Forms :: How To Display Nearest Date To Expiry On Form In Text Box

Aug 7, 2014

I have main form call frmemployee and subform call frmlcourse subform the main form hold's employee information e.g. first name addresss the sub form hold's all the training courses that the employee has been on

I have a text box called txtnextcourse due to display when the next course due date is

Code:
=DMin("Expirydate","tblcourses","[ID]=" & [empID])

this works perfect. I have check box on my subform called ex course if this is true. I don't want the dmin to count that record I have tried

Code:
=DMin("Expirydate","tblcourses","[ID]=" & [empID]) [forms]![frmlcourse subform]![ex course]=false

View 14 Replies View Related

Reports :: Training Records - Calculating Expiry Date Of Certificates

Aug 18, 2013

I am very new to access and I would like to pull some information from my tables.

I am using this for training records, I can calculate the expiry date of certificates using a query. What I would like is a report (even better an alarm of some sort) to show when things are due to expire. I can't seem to find this option as a report.Also, is it possible to have reports go into excel?

View 3 Replies View Related

Forms :: Setting Popup Reminder On Form Load For Expiry Date

Jul 26, 2015

I have a form (Access 2010) in which i insert contracts; each contract has a start and an expiry date, but instead of dd/mm/yyyy i would like the user to be able to insert just the year, while the day and month are predefined values and they are automatically inserted (i.e. 01/10/yyyy; the year being the only value that changes, and it is manually inserted by the user).

I would like to set a pop up remainder (on form load) x days before the expiry date, but, because too many of them have the same expiry date i am wondering if the reminder can be set on different days, based on another field (i.e. partner location [country]).. i.e. reminder for contracts with Austria to pop up 60 days before expiring, for UK = 67 days and so on.. or even a specific day for each, i.e. for Austria = 01/08/yyyy, for UK 01/09/yyyy).

View 2 Replies View Related

Queries :: Task Completion Database - Search Records With Specific Expiry Date

Nov 17, 2014

I have a task completion database. Each record of model consists of an expiry date. I need to review and update the records before the expiry date. Each model may have more than one record as I have updated the models a couple of times. I would like to select all of records with the expiry date less than 30 days so I can plan to review and update them on time. How to select all these records.

View 2 Replies View Related

Queries :: Calculate Expiry Dates Of Training Courses - Due Dates Not Shown

Aug 28, 2013

I have built a query to calculate the expiry dates of training courses but I am trying to input a criteria so that only dates within 90 days of todays date show. I am using Date()<90 but it doesn't return the correct information. What the criteria should be for this?

View 1 Replies View Related

General :: Export Access Table To Multiple Excel Workbooks With Multiple Tabs

Dec 13, 2012

I am using Access 2010 and Excel 2010. I need to have VB script to export the access table 502 records by 38 fields into Multiple Excel workbooks each having multiple tabs. In the Access table each record has two fields: Div and Tab that will be used to name each workbook and each tab (sheet). There are 6 unique "Div"'s to name the 6 workbooks and there are several "Tab" names for each Div (workbook).

Note: These 6 workbooks with multiple tabs were originally imported into Access from one common folder on my desktop by this routine:

Option Compare Database
Option Explicit
Private Sub Command1_Click()
Dim blnHasFieldNames As Boolean, blnEXCEL As Boolean, blnReadOnly As Boolean
Dim lngCount As Long

[Code] .....

View 7 Replies View Related

Export Access Table To Multiple Excel Workbooks With Multiple Tabs (sheets)?

Dec 13, 2012

I am using Access 2010 and Excel 2010. I need to have VB script to export the access table 502 records by 38 fields into Multiple Excel workbooks each having multiple tabs. In the Access table each record has two fields: Div and Tab that will be used to name each workbook and each tab (sheet). There are 6 unique "Div"'s to name the 6 workbooks and there are several "Tab" names for each Div (workbook).

Excel workbooks would take names from the "Div" field and the tab names would come from the "Tab" field in the Access table. First need to find workbook name (Div - Field) then the look for each sheet name (Tab - Field) to create 1st Excel workbook with all the sheets (Tab) and repeat the process. I think you need to approach of read the Access table one record at a time keying on the "Div" and "Tab" fields in creating each Excel workbook with the associated multiple tabs (sheets) that are written to a common folder.

Note: These 6 workbooks with multiple tabs were originally imported into Access from one common folder on my desktop by this routine.

Option Compare Database
Option Explicit
Private Sub Command1_Click()
Dim blnHasFieldNames As Boolean, blnEXCEL As Boolean, blnReadOnly As Boolean
Dim lngCount As Long
Dim objExcel As Object, objWorkbook As Object
Dim colWorksheets As Collection

[code]....

View 12 Replies View Related

Forms :: Inventory - Allow Users To Update Multiple Fields For Multiple Assets

Sep 25, 2014

I want to create a form that allows users to update multiple fields for multiple assets. Below is what I came up with:

Ideally, I'd like the subform to be filled in by having the user select multiple Assets from the S/N combobox field which would then auto-populate the "Type" field. Then they would fill out the appropriate fields they want edited in the top part of the form. They hit save and magic happens. This would also be nice because only assets they want edited would be displayed (easier on the eyes) and no distinguishing would be necessary. To do it this way, I know I would need to use a temp table but I wanna avoid using temp tables.

I know I can do this by adding a Yes/No field in the "Asset" table, setting the "Asset" table as the subform's recordsource, and then putting a checkbox in the subform and allowing them to check the assets that they want to edit (which would also allow me to sort it instantly so that checked Assets are at the top of the datasheet for easy viewing), but I would like to know if there's a way of accomplishing this without the use of checkboxes.

I know I could also use a listbox and that allows them to multi-select items, but I'm not sure if that allows me to group all selected items at the top of the listbox for easy viewing of selected items. Plus it would involve a lot of scrolling (there are over 2k assets).

View 2 Replies View Related

Modules & VBA :: Inserting Multiple Records From Multiple Unbound Text Boxes

May 6, 2014

I have a form with 15 unbound text boxes (daily temperatures) and what I am trying to do after entering the temperatures into the text boxes the user clicks an add button which will add 15 new records into the temperature table

the code I have started off with is

Code:

CurrentDb.Execute "INSERT INTO ColdTemperatures (ProductID, ColdTempDate, Temperature) VALUES (" & Lettuce & ", #" & Me.RealTime & "#, " & Me.Lettuce & ")"

which adds 1 successfully however if i repeat the code above for all 15 this Im assumming will create a potential bottleneck and slow the system down

is it possible to add all 15 records at once? do you think Im going at this the right way

View 5 Replies View Related

Modules & VBA :: Import Multiple Files To Multiple Tables On Button Click

Sep 20, 2014

I made a database that in one of the forms, I like by clicking on a button the user be able to select 5 excel files with different file names (in the same directory) and then based on the imported file's names, it be stored in 5 different tables.

At the moment by using the bellow code, I can import multiple files (with the same formats) only into one table . My vba code comes as follow:

Function GetAllFiles()
Dim fd As Object
Dim strFilter As String
Dim lngItems As Long

Const msoFileDialogOpen As Long = 3
Const msoFileDialogViewDetails As Long = 2

[Code] ....

View 4 Replies View Related

Queries :: How To Count Records Based On Multiple Criteria From Multiple Tables

Jan 4, 2014

I need to count records based on multiple criteria from two different tables. I have two tables (i.e. "tblTasks" and "tblTaskHistory"). The tables have a one-to-many relationship based on the "TaskID" field. "tblTasks" has a field called "AssignedTo" and "tblTaskHistory" has a field called "TaskStatus". I need to know how many tasks have been "reopened", the "reopened" status is located in the "TaskStatus" field in "tblTaskHistory". I need this count against a unique listing of employees which can be found in the "AssignedTo" field in "tblTasks".

View 4 Replies View Related

Import Excel Data From Multiple Sheets Into Multiple Tables In Access

Aug 25, 2012

I would like to know which way is the best way to import excel data from multiple sheets in to multiple tables in access.

For example data from Sheet1 -> Table1, Sheet2->Table2, Sheet3->Table3 etc...

I have tried using this:
Cmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "Table1", "C:Importedfile.xlsx", True, "Sheet1!"

Ironically, data from Sheet2 and Sheet3 seem to be properly imported in to table2 and table3, but some of the data from Sheet1 seems to be missing in Table1 after import.

Any other ways to import the data?

View 1 Replies View Related







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