Search results

sorry for not replying earlier. I played around with it some more and the test form I have in there I just changed the tech ID to look for the last name and based the search off that.

That was one of the first things I had checked before posting for help. I've actually have the code checking a combo box which the bound column should be a numeric field. I'm still scratching my head over this one. Thanks

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...

Edited above post with new link to repaired database, no longer split. Should open up fine in any version i hope

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...

Ah I see what happened now. I had renamed my subform, but the control stayed as the orginal name I had. Is there a way I can edit the subform controls? Thanks for the lead on what drops down after I had typed in Me. It's working now :)

Ok, I'm able to set the subform to hidden with the On Load Event. Now I'm having trouble getting the AfterUpdate Event to work to make the subform visible again. This is what I have in my AfterUpdate event code for my combobox: Private Sub Combo10_AfterUpdate() Dim rs As Object...

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...

Ok, forgot to check that last database I had zipped up. This is one is my latest attempt to get my tables and the relationships right. After that I'll work with my data entry form. If anyone could take a look at it and make sure I've set up the relationships right I'd appreciate it. Just...

Rich or Newman Hopefully I was understanding you and Newman :) I've zipped up the database project with I believe are the correct changes. This is the direction I'm heading. Once I'm satisfied the Data entry form works correctly and all data is being entered in correctly I'll whip out a...

Rich, Not quite. Ok, Currently the Techs are each assigned to a line each night. The line is broken down to a different sections, which are listed in my LineProblems table. If a technician does anything on that line and he/she usually does they note it down. At the end of the shift they...

Thanks a bunch guys :) I think I know how to get it all set up. Yes each of the 7 lines we have all have the same category of common problems. Or sections that define the line. Basically the LineProblem table consists of having the following fields: Date, Belts, Printers, Channels...

Ok, I think I know where to go on this. Basically what I'll be reportin on is a couple things. Each night I'll want to know what tech worked on what line and what he did on that line if anything. Since it's a distribution warehouse, the lines always have problems (something is always...

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...