"Calibration" Database (1 Viewer)

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Hi,

I have finally completed (if it's ever complete) my "Calibration" database. It was intended to capture measuring equipment calibration records & nominate a future re-inspection. I guess it would work for any logging of any periodic maintenance task (forklift maintenance etc). I make no claims about the (laughable) quality of the software, but it utilises a number of well recognised published routines. It is the most "complete" database I've written & it can optionally save a future task to outlook as well as saving attachments to a separate file. I provide no documentation, but would be happy to assist with any potential issues. I feel that the database is a "collaboration" between forum members whom have assisted immeasurably & I'm happy to share. Constructive criticism is welcome. (I know of a few things I'd like to change). If my projects of interest, I'd be happy to post a copy.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 00:54
Joined
Oct 29, 2018
Messages
21,322
Hi. Congratulations!
 

June7

AWF VIP
Local time
Yesterday, 23:54
Joined
Mar 9, 2014
Messages
5,399
That's what the subforum you posted in is for. Go ahead and attach to your original post.
 

Sticky99

Registered User.
Local time
Today, 00:54
Joined
Nov 9, 2019
Messages
61
Hi HillTJ,

I am just about to do the same for our calibrated tooling, could I have a look at your DB structure, could save me a lot of time.

Cheers.
 

isladogs

MVP / VIP
Local time
Today, 07:54
Joined
Jan 14, 2017
Messages
18,164
NOTE to HillTJ
I moved this thread from Sample Databases to the General forum a few days ago to allow you to upload your file more easily & so that others can reply without needing moderator approval. If appropriate we can copy the application to sample databases later
 

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Sticky99, happy to assist. Please have a go with my application. I have plans for a few tweaks, but not important for the concept. Logon with "Password" and "Password". I deleted the logo from the front tab, you could simply add your own or delete the control. Cheers & thanks to all who were involved at various stages & supported me when I got stuck. Upon load press 'shift' key to open edit mode.
 

Attachments

  • Calibration V11.zip
    290.4 KB · Views: 149

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Micron, Really odd. They all work for me & I gave it a test prior to uploading! I'm running 32bit access 365 latest version! See whether anyone else has the problem.
 

Micron

AWF VIP
Local time
Today, 03:54
Joined
Oct 20, 2018
Messages
3,476
I just altered my level in the table. You have it as 1, which locks everything. If you are looking for feedback here's what I see so far (have spent most of my time with it getting around the obstacles):
- you can't click login button unless you leave the password field (e.g. you must tab out or click the combo again)
- many developers don't design with Track Name Changes turned on
- 7 form modules don't have Option Explicit set, although the code does compile. When I look at the vb editor option, Require Variable Declaration is on, but I suspect that's my setting and not yours, but I don't know.

If you don't want constructive criticism or such observations, please let us know.
 

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Micron, Cool I'm here to learn. Problem I have is that I've grown with the app. I welcome other users feedback
 

Micron

AWF VIP
Local time
Today, 03:54
Joined
Oct 20, 2018
Messages
3,476
The only other things I have to offer at this time is
- I clicked on Browse, thinking that's how I see calibration records for a site and location. Got the file dialog, which I closed. You should trap the error message for when nothing is selected.
- you might consider UNC paths rather than S:\, unless no user will ever have a different drive label

I assume that your application will not be used to calibrate tools or equipment where the use of said tool/equipment falls under the auspices of a quality management system, so it will probably suit your purpose quite fine and is a good start. Lack of data in the tables means there's not much to play with, but I suspect you weren't expecting anyone to do that. I haven't read through a lot of the code; figuring I'll give others a chance to chime in.
 

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Micron, excellent, yes I should have thought of supplying some demo data.
 

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Sticky99, Upon using the database, I added another table & another field to capture "Category" so that I can filter by "Electrical Test & Tag", "Fire Equipment","Inspection Instruments", "Forklift Inspection" & so on. If the database shows promise for you, then I'd be happy to upload this version.
 

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Sticky99, Am in the process of making a few mods. Found that the code for saving PDF's added an extra "". Also got to fix print filtered records routine, but have improved form layout. I found these issues when I went to add real data. Give me a few days to fix & I'd be happy to post a revised version. Meantime, you should be able to have a look @ my database structure that is essentially unchanged.
 

HillTJ

To train a dog, first know more than the dog..
Local time
Yesterday, 20:54
Joined
Apr 1, 2019
Messages
712
Sticky99, See file attached. I've made some improvements & debugs. Still prints reports as PDF's to file (that you nominate). You can print out the report from there. I'll do a print button, but it may take a while before I can get around to it. File has data that you can test. Let me know how you go. Cheers HillTJ. PS - To log on select user as "Password" & Password = 'password" (note all lower case. You should then have administrator rights.
 

Attachments

  • Calibration.zip
    333.3 KB · Views: 132
Last edited:

Sticky99

Registered User.
Local time
Today, 00:54
Joined
Nov 9, 2019
Messages
61
Hi HillTJ,

Thanks for that, I'll have a play around with it and try and fit it to my requirements.

Cheers!
 

Users who are viewing this thread

Top Bottom