Search results

Hello all, Attached is a test version of my database. I'm trying to create a form which can search through my one table dynamically. Everything works great except for when I try to search by the Tech ID. I get a data type mismatch error. The form which I'm testing is the Test Form. The...

Hi everyone, I have a little project here that I started awhile ago and at the start didn't fully understand databases, not that I do now, but I'm further along in my knowledge. I believe my database here is normalized and set up to have data inputted the way I want it. I was hoping someone...

Hello one and all, I'm back with another problem that I'm not sure how to handle. I've made up a database to help track work done by our technicians. I would like to be able to add to my main form a way of keeping track of work done by technicians if they are grouped up on a special project or...

Hello all, I have this code in my afterupdate event for a combo box: Dim rs As Object ' Find the record that matches the control. Set rs = Me.RecordsetClone rs.FindFirst "[TechID] = " & (Me![TechnicianList]) Me.Bookmark = rs.Bookmark Set rs =...

I'm not very good with coding yet so I thought I would turn to these forums for some help. I have a form for my technicians and when the form loads, the first thing they have to do is select their name from a combo box. I have some techs that are cross trained for 2 different areas, eventually...

Does anyone know if it's possible to password protect certain forms from a switchboard? I have a database which technicians will enter in data about their line. I'd also like on that same switchboard an option for the supervisors to enter in data for say a new technician when hired or to be...

Hello everyone, First I'd like to thank everyone for all the advice and help they've given me on this project. I think I've come a long way in understanding Access and databases. If it's possible, I'd like to ask another favor and have you review my database. I've zipped it up in Access 97...

Hello everyone, I've been searching through the forums here looking for a possible solution to my question. I'd like to hide a subform until data is entered on my main form. Specifically from a combo box which lists the first and last names of the techs using the form. I am trying to keep...

Ok I'm running into a small problem here. I have set up a small database to eliminate our end of shift report paper trail. I have a table with our techs, a table with the lines that are worked on and a table with the problems common to those lines. I want to keep my form simple and less prone...

Quick question for anyone out there that could possibly help me :) I've set up this database as a project for work. Nothing that is needing to be done to soon, just something I wanted to learn how to do. I've made 3 tables: tbLine (LineID, TechID, LineName) tbLineproblems ( LineProblemsID...

I have a small db I'm working on for my boss. A side project I thought I'd attempt to in order to familarize myself with Access and databases in general :) I think I've got some fo the basics down. My question is this. I have a form which I want to be able to use for data entry. I don't...

Hello everyone :) Hopefully someone can point me in the right direction. I have the following tables set up in my little database tblLine(LineID, LineName) tblTech(TechID, FirstName, LastName, etc...) tblLineProblems(LineProblemID, TechID, LineID, Date, ....problem categories...) I'm having...