Class Certificate

Nov 8, 2007

I have been asked to create a certificate for completion of classes given at work. Is there any way to use a report or will the need to be done through word?

View Replies


ADVERTISEMENT

Modules & VBA :: Print Certificate From Form?

Nov 11, 2013

I have a participant table listing name of candidates and course name of training they have taken (1 record per instance, so someone may have 5 records if they have attended 5 courses)

I want to be able to print a certificate for the candidate once the course is complete, ideally from the form itself using a button.

I think the way to do this is to design a report as the layout of the certificate and then print the current record, but I cannot get this to work!

View 1 Replies View Related

Printing Date In Words On School Certificate

Mar 10, 2012

I am trying to create a report which is basically a School Certificate. The requirement is that I need to print the Issue Date, means the current system date be printed in ENGLISH WORDS rather Alpha-numeric format, i.e.: instead of 11 Mar 2012, I need some thing like this: Eleven March Two Thousand and Twelve.

View 4 Replies View Related

Modules & VBA :: Setting Up Certificate Request Database - Attach PDF To Form

Aug 11, 2015

I have been tasked with setting up a certificate request database. I have an Access 2032 FE & SQL 2012 BE. I need to store PDF documents from all our branches.

I have been working on this for the past 3 working days and I have seen a great deal about saving the file path to the database vs saving the actual document in the DB. The documents would be located on each users computer.

I have a Form with all the information that is required by the certification department. On the form is a button (Called InsertID(ID in this case is the persons Identity Docuement)) and the button is linked to a table called dbo_CertificationSupportingDocuments. The table is referenced to the Main Certificate Request table.

The dbo_CertificationSupportingDocuments table is structured as follows:

Code:
[CertSupportingDocID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[CertificateRequestNumber] [numeric](18, 0) NOT NULL,
[RequestBlob] [varbinary](max) NULL,
[RequestFileName] [nvarchar](50) NULL,
[RequestFileExtension] [nchar](10) NULL,
[RequestFileMimeType] [nvarchar](50) NULL

When I click the button I get a Run Time error 3075 "Syntax error (Missing operator) in query operator.

The code I am using is:

Code:
Dim fd As FileDialog
Dim strFileWPath As String
Dim FileNoExt As String
Dim FileExt As String
Dim StrSQL As String
Dim db As Database

[Code] ....

I have been looking at this code for so long that I cannot see what is wrong.

View 14 Replies View Related

General :: Create A Field With Start And Finish Date On Certificate Formatted Correctly

Aug 22, 2013

I am creating a access db for use with a training company. All is working great.

What I want to do is create certificates within Access and then print by the Course load. Easy enough and I can do this.

The courses usually last two or three days, so i want to create a field which has the start and finish date on the certificate formatted correctly.

I currently use this

Code:
CourseDate: DatePart("d",[StartDate]) & " & " & DatePart("d",[EndDate]) & " " & Format([EndDate],"mmmm") & " " & DatePart("yyyy",[EndDate])

within a query which returns this

29 & 30 May 2013

what i want to print on the certificate is this

29th & 30th May 2013

I need to have the 'st' or 'nd' or 'rd' or 'th' in the date.

View 3 Replies View Related

Showing Grades Of Students In A Class?!?!

Jun 13, 2005

Hello,

I can't quite get my head around this - any help is much appreciated.

I have (amongst others):

tblStudents (containing basic info. name etc)
tblClasses (containing a list of studentIDs with classes they are in, so, for example, there may be 3 entries of studentid "1", each with different classes next to them, to show that studentid 1 is in classes: a b and c for example.
tblGrades (containing studentID and masses of fields with different grades for different subjects in.)




What I would like to do, is select the class name from a list (which I can do, no problem).
Open up a form listing all the students in that class, with all their grades next to them.

This SOUNDS simple - but I don't think it really is! I could just be having a VERY simple moment though too - if so, I apologise!

Thanks in advance!

View 1 Replies View Related

Access Help .... Design .... 1st Class... Should B Easy

Feb 9, 2006

I have a project in which i have to make a database. Its nothing real complex it has to have 3 tables.

heres my idea

An address book database.... "I know how orignal lol"

anyways here is what i have.... Looking to get my primary keys and forign keys established


tblAddress
AddressID "Pri Key"
First
Last
Address
City
State
Postal Code

tblContact
Email
HomePhone
CellPhone
DateLastTalked
DateUpdated

tblPersonal
Nickname
Birthday
College "Yes or No"
If Yes Where
Hobbies

So I need to get 3 FK keys and 2 more primary keys... This isnt jumping out at me as to what i should use.

View 3 Replies View Related

Class, Sessions, Attendees, What Is The Relationship?

Feb 6, 2007

After long, long, long hiatus of doing other stuff, I wanted to get around to update the database. One thing I had set up wrong was the attendance rosters.I just need to be able to create a new class, which may have more than one sessions, then make a list of registrants for a particular class, then be able to track their attendance per session for this class.However, my Google-Fu is lacking as every templates I've looked at doesn't really answer my question, which how three entities relate to each other.I know for sure that Class-Attendees is a one many relationship. Same attendee can register for more than one class, so that's no brainer. Likewise, Class-Session should be also be one many relationship for obvious reasons. However, if I relate Session to Attendee, it would create a circular relationship between the three entities. I've toyed with the idea of having a hierarchial tables of Class -> Attendees -> Sessions, but that does not relate the sessions to the class, which is necessary. I wonder if I should create a fourth table to contain attendances and use Session and Attendees as FK, but that still wouldn't fix the possiblity of a circular relationship?Any insights will be greatly appreciated. TIA

View 14 Replies View Related

Modules & VBA :: Class Does Not Support Automation

Jul 31, 2015

I get the message "The expression On Click you entered as the event property setting produced the following error: Class does not support Automation or does not support expected interface"

I receive the message on a PC running Windows 7 Professional using the Access 2013 Runtime. This pc does not have Access 2013 installed.On my pc, I do not get the error. I have Access 2013 installed and run Windows 7 Professional SP1. The "code" which gives the error is as follows and is invoked by clicking a button on a form

Code:
MsgBox "1"
Dim rst As ADODB.Recordset
MsgBox "2"
Set rst = New ADODB.Recordset
MsgBox "3"

[code]....

The error takes place after Msgbox "2" and before Msgbox "3".The strange thing is that I can run without a problem a sophisticated software package on the pc which gives the error, using Access 2013 Runtime. This package I converted from Access 2003.

View 3 Replies View Related

Object Or Class Not Supporting Set Of Events

Nov 12, 2012

This is the error I'm getting. A little obscure, I know, but this is happening in an executable Access application (2010 accde) when I click the close button on a form.

The code behind the form is checking a lot of stuff (data validation, etc.), but "Object or class does not support the set of events" is the error. Then the application continues as if nothing had happened.

The app was converted not long ago from XP ACC2003 to Win 7 ACC2007-2010.

View 10 Replies View Related

Report Deleted But VBE Class Object Remains

Dec 8, 2005

Hello all. I have deleted a Report but the underlying reference in the VBE editor in the CLASS OBJECTS list remains for the report and is giving me errors during run and compile.

Any idea how to delete the Class Object once the object has been deleted?

Any other suggestions?

Version: Access 2000

View 6 Replies View Related

General :: Object Class Does Not Support Set Of Events

Aug 14, 2015

I have Access 2007 database.

I and trying to link to Outlook 2007 using the "External Data/More/Outlook Folder option and keep getting the "Object Class does not Support the Set of Events" error message.

I can link to a DBF and Paradox file without any problems.

I am running Office 2007 Professional and Access 2007 and Windows 10.

I have also done the following:

1. Removed Office 365
2. Decompiled the Access VBA code and corrected any issues
3. Compacted/Repaired the database

I have attached a screen shot of the references that I have selected.

This is a new setup as I recently purchased a new PC and Windows environment. I still have the old PC running Windows XP with the same configuration and it also experiences exactly the same error message.

View 6 Replies View Related

Modules & VBA :: Object Or Class Does Not Support Set Of Events

Mar 19, 2014

I have this below which some people cant run and some people can. All are using 2010 runtime version. Apart from the one guy who can run the macro who has full 2010 version. I have 2010 runtime installed and i can also run the macro fine.

Private Sub Option12_Click()
On Error GoTo Option12_Click_err
Dim CntlPay As String
Dim Lable As String
CntlPay = "D"

[code]....

View 1 Replies View Related

Queries :: Function To Show Players In Certain Class?

Jun 2, 2013

Any function or how to create query that shows the players in a certain class.

I have a table for class, for players & and one that shows the players for each class...

View 1 Replies View Related

Forms :: Creating A Class Roster From Combo Box

Jul 15, 2013

I have a form that the Training Admin will use to select students to a new class.they select the Class Name from a ComboBox tied to TblClass.they select an Instructor from a ComboBox tied to TblInstructor and then, I am trying to to use some method to select students by identifying information (EmplID, LName, FNAme, MName, EMP# from TblEmployee) one at a time (from a combo box, or some other easy select method) that will pass the students information to a list, viewable and editable (remove a name) before it is committed to a TblCompletedTraining

I looked at a cascading combo-boxes, and that looks like a good method to selecting from the large number of employees in TblEmployee, but I am unsure how to store each selection on the form, and then allow the Training Admin the ability to delete members from the pool prior to committing. I am reluctant to use the multivalue field as a solution for a couple of reasons;

- It explicitly states to be used for relatively short lists only (no value limit given; so I assume 100 or less items)
- will probably need to convert this database sometime in the future.

I thought I had figured this out, by using a combo-box selection to generate a filter, but it leaves me with only one selection in the end..

View 8 Replies View Related

Modules & VBA :: Auto Initialize Class Module

Sep 16, 2013

How you automatically initialize a newly instantiated class?

So when you create a new instance it will run a procedure to set attributes.

View 4 Replies View Related

Modules & VBA :: Object Or Class Does Not Support Set Of Events

Oct 21, 2013

I have wrote a database in access 2010 and the database works fine for me (I am the db admin with full control).I gave the database to a group in which most of them also have no issue with the file. They are able to use the database with no issues..One of those members gets an error message when completing the initial step in the database: (select a drop down item from a combo box)

Code:
The expression After Update you entered as the event propoerty setting produced the following error: Object or class does not support the set of events

Something I cant seem to understand is why is this happoening on 5 machines but not on the 6th, they all have the same PC set up so there should be no error on one particular machine.

View 6 Replies View Related

Modules & VBA :: Returning Values From A Class For Date

May 19, 2014

I have two class variables (both arrays) among about 10 other class variables, that are not returning any values but "" for the string or #12:00:00AM" for a date. Here are my class variables:

Code:
'UPSData Class Module
Private p_LetterArray() As String
Private p_date() As Date
Private p_LetterArraySize As Integer

My Properties

Code:
'Properties
Public Property Get LetterArray(index As Integer) As String
LetterArray(index) = p_LetterArray(index)
End Property
Public Property Let LetterArray(index As Integer, NewValue As String)

[Code] ....

As I said, tLet and tDate result in "" and #12:00:00AM# respectively. When I step through the code, the values for tmp.LetterArray(0) is assigned "src" and tmp.UPSDate(0) stores "12/25/2013" correctly.

When I assign tLet and TDate, the same thing happens when stepping through the code. I'll use the LetterArray property to describe what happens:

Get LetterArray is called. p_LetterArray(0) does equal "src"
Let LetterArray is called. NewValue is "src" and p_LetterArray is "src" when End Property is highlighted in the debugger
Scope returns to Get LetterArray with End Property highlighted. In checking the values, LetterArray(0) = ""

Same steps happen with the same results ("12:00:00AM" vice "")

View 5 Replies View Related

Modules & VBA :: Collections Class On Continuous Forms

Jul 31, 2013

Any way to make objects to support adjusting continuous form controls making them unique in a sense to be able to change info like captions or whatever.

I've been working with collections for a while now tapping into event handlers such as the mouse inputs and or sizing of objects real time using collections but I can't seem to nail down any un-documented way to serialize controls on a continuos form.

I have tried when the new user creates the record adding another control to the collections class tying it to the id of the record but still this does not seem to be enough.

I do not know if there is a paint method or something of the sort I can override to get the desired results and most people without even trying will tell you this can't be done but how many have said that you can't move and resize objects in access but we are doing that now...

View 14 Replies View Related

Modules & VBA :: Referencing ActiveX Control In A Class

Jun 26, 2015

I'm using Access 2003. In "References" (Tools > References > Browse...), I've added in "Microsoft Windows Common Controls 6.0 (SP6)" (c:windowssystem32mscomctl.ocx).

I've then created/inserted an instance of the control "Microsoft ListView Control 6.0 (SP6)" on a Form ("MyForm") and given the listvew control the Name "MyListView".I wanted to decorate MyListView with some custom methods so I've created a new class module ("DecoratedListView") which contains a member field called "lvw".

I want 'lvw' to point/reference to MyListView, but I don't know what reference type to use in its declaration. Importantly, I also want to capture lvw's ColumnClick event.

I've tried:

Code:
Public WithEvents lvw As Object
Public WithEvents lvw As Control
Public WithEvents lvw As MSComctlLib.ListView.2
Public WithEvents lvw As MSComctlLib.ListView
Public WithEvents lvw As CustomControl

and none works when I

Code:
set lvw = Forms!MyForm.MyListView

The first try (Object) doesn't even compile. I get the exception "Expected: identifier"
The second try (Control) doesn't compile either. I get the exception "Object does not source automation events"
The third try (MSComctlLib.ListView.2) doesn't compile and throws the exception "Expected: end of statement"
The fourth try (MSComctlLib.ListView) compiles but fails at runtime with the exception "Type mismatch". Using TYPENAME() on the control returns "CustomControl".
The fifth try (CustomControl) compiles but fails at runtime with the exception "Object or class does not support the set of events".

I can't believe I'm the first person to have tried to capture an ActiveX Control's events in a separate class.

View 1 Replies View Related

Class Payments Form - First Record Value Changing

Oct 12, 2015

I have built a simple database for a dance school.

The junction table that handles enrollments is behaving a bit weird.

I have a form that deals with class payments. This is linked to the enrollments table via datasheet.

When i refresh the datasheet (which is embedded in a form) after a payment the first record in the enrollments table changes its value.

Effectively the first student changes to whatever class i am currently viewing.

View 5 Replies View Related

Modules & VBA :: Class Event For Multiple Controls On Userform

Mar 5, 2014

Basically I have a class event that works for all controls on any userform.

Its all working fine but I can't add an event to trap the click or mouse move of the userform itself.

Basically so when the cursor moves away from a control the label clears.

User Form Code

Code:
Option Compare Database
Option Explicit
'Define a collection and initialise the commandbutton event class
Private col As New Collection
Private newCmd As New clsEvents

[Code] .....

And here is the class Module

Code:
Option Compare Database
Option Explicit
'catch the event of Commandbuttons
Private WithEvents C0 As SubForm
'Private WithEvents C1 As CheckBox

[Code] ....

View 11 Replies View Related

General :: Front End - Object Or Class Does Not Support Set Of Events

Oct 17, 2014

I have distributed my front end on the shared drive for users to copy to their desktops.

In one form I have a formula in the query that show's the word 'Gap' if any of the 15 questions on the form is equal to 'fail'. It runs on current when the user is in a record it shows the word 'Gap' at the top header part of the form.

When the user opens the form they get an error message pop up that says "The expression On Current you entered as the event property setting produced the following error: Object or class does not support the set of events."

Once they click 'ok' they are able to work in the form until they attempt to filter records by their name it pops up again.

I've tested on my end and no errors or issues come up.

View 1 Replies View Related

Modules & VBA :: Creating And Initializing Custom Class / Object

Jun 13, 2013

I've been playing around with creating my own class in VBA but I'm having problems calling its methods. My class is pretty basic, its called cDentist and the properties are just Name, Address, DOB etc and one method AddDentist. AddDentist will add the details to a sql server table.

So I create an instance of the class in a module called Dentist. At the very top of the code i put..

Code:
Option Compare Database
Global Dentist As cDentist

I have a method then in module Dentist, where I initialise the instance of class cDentist and i populate it's properities...

Code:
Sub RecordDentistDetails()
Set Dentist = New cDentist
Dentist.Name = Forms!frm_enterdetails!txtName

[Code].....

When I click 'Save' I get error, Method or data member not found. And '.AddDentist' is highlighted. I'm a little confused why it's not seeing AddDentist as a method of class cDentist.

View 14 Replies View Related

Modules & VBA :: Error Passing Variable To Class Module

Jan 30, 2014

I am trying to pass a boolean variable to a class module

Code:
Set rps.ViewS = View

the code in the module that this in theory is calling reads as

Code:

Private ViewC As Boolean

Public Property Set ViewS(ByRef ViewA As Boolean)
Set ViewC = ViewA
End Property
Public Property Get ViewS() As Boolean
Set ViewS = ViewC
End Property

However I am getting the error message

Quote:Definitions of property procedures for the same property are inconsistent, or property procedure has an optional parameter, a ParamArray, or an invalid Set final parameter.

View 6 Replies View Related

General :: Error - Object Or Class Does Not Support The Set Of Events

Oct 9, 2014

Couple days ago our database was not opening, Access would open but show a blank workspace. Anyhow, we restored the database from Server and it worked on all 5 shared systems on company's network but this one computer. It is giving the error, "Object or class does not support the set of events."

I tried to copy new local folder but nothing. I checked the links and target folder it looks fine.

I tried to import the everything into new database but it said I don't have permission for that.

what's causing this issue and what can I do to fix it?

View 3 Replies View Related







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