Search results

As soon as I add that option to the currentdb.execute() call, I get a compile error and can't even test the code. I'm running Access 2007, could that be the issue?

It's almost there... I don't have any errors popping up any more! But, the query isn't actually generating a new record in the table. Here's the query that's running: INSERT INTO [Dummy Routing Card Table] (ENGINEER, CUSTOMER, [ROUTING CARD REVISION NUMBER]) VALUES ('Dummy Engineer', 'Peter'...

Well, I've made the changes you recommended, and am sadly still getting the same error. Here is the query I'm executing: "INSERT INTO [Dummy Routing Card Table] (ENGINEER, CUSTOMER, [ROUTING CARD REVISION NUMBER]) VALUES ('Dummy Name', 'Peter', 123)" It's still the same error 3078. I've double...

Ok, so I've written some code that I think is on the right track, but I am still getting an error. Here is what I have so far: Private Sub CreateDuplicateRecord_Click() field_names = "(" field_vals = "(" field_names = field_names & "ENGINEER" & ", " field_vals = field_vals...

This looks like just the code I need. I do have two other questions for you on this. First, you have an extra parenthesis in your sample code, which one is the typo? More importantly, is there an easy way that I could break this code into several parts? Here's what I mean in pseudo code...

I'm working on a form with almost a hundred various fields (it's what my employer needs). He wants to be able to create new records with much of the same information as the old ones by clicking on a button that will copy the information to a new record, then clear certain specific fields (or...

I need to find a way to print the currently selected record (by clicking a button in the form) as a form. I know printing is almost always done in records, but they use the forms by hand before entering them into the computer database. One tough part of this is that this printing function needs...

Thanks for the help! It works now. For anyone having the same issue, here is the code that works: Private Sub SearchResults_DblClick(Cancel As Integer) DoCmd.OpenForm "AllEmployees", , , "OPERATOR_ID='" & Me![SearchResults].Value & "'" End Sub

Hello. I'm receiving a "Error 3464" data type mismatch error from the code below. DoCmd.OpenForm "AllEmployees", , , "[OPERATOR_ID] =" & (Me![SearchResults]) OPERATOR_ID is a text primary key (from the network, not my creation), and SearchResults should be returning a string as well. I don't...

Actually, in the structure I'm trying to model, an employee can work for multiple departments in the same day depending on the needs of the plant. Some of the competencies are general and standardized throughout all departments, such as safety training, but some are specific to departments (like...

Hello. I'm trying to make a report that a untrained user can use to review the relevant data from the database I'm creating. All of the work I've done so far has been directly in the tables (as I'm still in the design phase and am not experienced in forms or reports). Here's a quick outline of...

I'm working on the user-input end of a database used to track training proficiencies and how up to date they are. In the form I'm working on at the moment (of which I attached a picture), the user selects a department from the combo box (which filters the first subform of employees), then...

Alright, I will give it another go. Thanks for the help so far. EDIT: So, it works, though the database shows that it is calculating the entire time I'm viewing it. The focus is not changing as it was before, but it recalculates the value of the text box once or twice a second. Is this normal...

When I tried that before, it caused the subform to shift focus to the first record once a second or so. Do you know how I can avoid that?

Hello. I am working on a form with two subforms. Based off of a combo box selection in the form, the first subform pulls up a list of names. What I want, is for the selected name in the first subform to control what the second subform pulls up (a list of training competencies that each person...

CJ (or anyone), what is the purpose of tagging the Competencies table with the DepartmentID? With the current organization I have (almost exactly what you suggested), it is serving as a foreign key. However, I can't understand the need for it there, as it does not sort or organize the...

So as I've started implementing the normalized database, I've come across a couple of unique instances that I'm not sure how to handle (without ruining normalization). Is there a way for me to create a competency (Orientation or such) that a person from any department must complete. The...

billmeye, I'm getting a "Invalid use of Me keyword" compile error with the code I have pasted below. I'm trying to write it as a function so I can just have each of the 15 forms call one function rather than writing 15 of the same. I'm running the code from the form, but getting this error, do...

Dim ctl As Control For Each ctl In Me.Form If ctl.ControlType = 106 And ctl.Name <> "Not Proficient" Then ctl.Value = -1 End If Next ctl Set ctl = Nothing Billmeye, could you possibly explain the Me.Form syntax meaning? What is the "Me" object?

The only reason I haven't combined all of my competencies as you mentioned is that there are 15 unique sets of competencies (each with 10-20 check boxes) that are independent of each other. I'm also utilizing a linked master table (provided) that groups each employees information with the...