Recent content by JRT2006

Youre right, traceability would be nice for as much as things are moved on a weekly basis. We do have an issue keeping track of equipment locations

I emailed you from my work email and attached the full version of the database leaving very minimal data and removing the reports. The training tracker is included in the database and could give you further insight on what I mentioned here. Theres a chance you may get the email but not the...

The original copy: When you open the database, a Login screen appears. Admins can enter their user name and password and it takes them to the main menu where they can select admin. users can input a basic username and password combo of Fire Fire, which takes them to the same menu, but the...

That did the trick. A lot of information is removed, it actually looks nothing like what it did before. I had to remove the reports, the log in screen for admins and users (admins had the ability to make changes to data, users have the ability to view reports), the training tracker for all...

Unfortunately, the database is too large to send via email. I've deleted most of the data and unnecessary forms, reports, tables and I cant bring it down to less than 25MB

Its a database I use to track equipment in the Fire Department. Air packs, Facepieces, etc. Each piece of equipment is either issued to personnel, placed on vehicles, or in storage. Each piece of equipment is required to be tested annually. I could send you the database, but I cant attach...

Hopefully, a question of this sort is allowed. If not, I'll take my hand slap and the thread can be deleted. I've searched all the titles and I don't see anything that would hold such a request, but do you allow programmers for hire in this forum? I've got a database I use for work...

Thats what I figured, thanks for confirming. But I cant seem to find any good information on how to exactly format it, really basic instructions. I need the Dcount function to look up prospects position, then count all other records for matching positions.

Hello, I was wondering if somebody could point me in the right direction of research to do the following: I have a datasheet form listing prospect information. Each prospect is assigned a position, there can be more than one prospect with the same position. I'm trying to get a text box to...

Alright, I will start working on it and see how it treats me Thanks

using the code in the button and adding a few fields to a table, I was able to do this correctly. the next questions is something Ive read a lot about and it frowned upon. How do I get the average of these numbers on a form to save in a query or table so a report can be generated with the...

thanks, but i give. i assume to accomplish this i'll have to make some major changes and im not willing to go that far for a database i just consider a "project" or "hobby"

Okay, understand the concept, not quite sure how to apply it considering it would need to lookup two fields; one being the position ID on the Parent Form and the second being the SkillID on the sub form. Considering that a skills importance is not absolute, for instance blocking may be of...

Okay, I'll read into that link and report back. Thanks for the info

The paragraphs were what I was told by somebody trying to help me. The issue is trying to get the skill value, as selected in frmposition when you select the skills, to appear on fsubProspectSkills, because it is part of a formula to determine final weighted average, without having to create a...