Search results

I'm still a newbie when it comes to VBA so I was wondering if someone could direct me on how to accomplish this... I have a database where floor management input productivity updates on a quarterly basis and email them to upper management from the database. The email has a .rtf attachment. Upper...

That works.... thanks!!

I am running Access 2003 and I am trying to figure out how to get this to work and would appreciate another set of eyes. I have a Holding form that runs (not visible) in the background of my database. When the form opens I want a Shift Textbox to be populated with the shift for the user...

Yeah, I know, but technically, it is not the same information. The CMMonth table contains the Top 3 for the whole shop, so there is only 3 entries per week. The CMGLMonth contains the Top 3 per GL (Supervisor) for the month, so since there are 3 Groups there are 9 entries per week. Not all...

Sorry, I should provide some more background. Each subform is a continuous form based on a query that only shows the Top 3 instances (based on cost) for scrapped parts. Each table has a field called "Countermeasure" that contains the information I want to update from one table to the other.

Help, I am running Access 2003 and have been struggling with this issue for 2 days and cannot get it resolved. I have a DB that tracks Scrapped Parts along with the Countermeasures entered by area supervisors on a weekly basis to work towards eliminating the scrap. I need to be able to update...

Thank you, both dcb and namliam.....after all this, I just got an email from the AM on the afternoon shift and he has changed the direction of this project, so I need to put the brakes on this activity as it will now change :eek: Sorry to take up your time, but I do appreciate all your...

The subform is based on the following SQL: SELECT qryZoneProcess.ZoneProcessID, qryZoneProcess.Process, qryZoneProcess.TLGroupID, qryZoneProcess.TMNumber FROM qryZoneProcess WHERE (((qryZoneProcess.TLGroupID)=1)); So the control source is ZoneProcessID

I wish I could. The DB is 5 years old and the information is not only proprietory but also confidential. Unfortunately, I don't think I have the time to create a "dummy" to just send the forms. But also, what happened to rst.MoveFirst? Also, I put this code right on the subform and not in a...

This is where I am getting confused about recordsetclone.... I have no column labelled "iProcessID" This is the name dcb gave it. My recordset contains the value "ProcessID" As for the button to trigger... its on the subform itself, not the main form. And what happened to rst.MoveFirst ???

Thank you, that fixed that....now "Item not found in collection" Stepping through the code, this is the line with the error: iProcessID = rst("ProcessID") When I move my mouse over the line I get "iProcessID = 0 but there is a value there. I opened the immediate window and...

Thank you, so much, for your help and insight. It is starting to make sense to me now. Just a couple of items to iron out, however.... Set rst = Me.RecordsetClone When I compile, I get an error that the variable is not defined. So I tried: Dim rst As Recordset But then I get...

ProcessID & EMPNumber are the fields in the table. Forms!subfrmZoneOrg1.ProcessID and Forms!subfrmZoneOrg1.txtName are the controls on the subform. EMPNumber is the employee number and ProcessID is the corresponding primary key in the Process table.

So I tried the following to loop through the form: Dim i As Integer Dim strQuery As String With Me.RecordsetClone 'get an accurate record count .MoveLast .MoveFirst 'loop through the records Do While Not .EOF For i = 1 To .RecordCount strQuery = "UPDATE...

I have come up with: Dim strQuery As String strQuery = "UPDATE EMPInfo " & _ "SET ProcessID = " & Forms!subfrmZoneOrg1.ProcessID & _ " WHERE EMPNumber = " & Forms!subfrmZoneOrg1.cboEMPNumber CurrentDb.Execute strQuery, dbFailOnError But that only takes care of...

I'm working in Access 2003 trying to build something that will allow users to identify employees' processes within their groups. I have a continuous form that shows the processes for each team. Beside each process I have a combo box for the user to select the employee name associated with...

Thank you, once again, Paul! Ah, I see what you are doing...one more question, though: MSDeficient will only ever be 0 or -1 as the control on the form is a check box, so do I still need this line in my code? If .Fields("TSMSDeficient").Value <> 0 Then

Paul, bear with me here, I am trying to get the logic clear in my head.... So the code starts to move through 20 records, for example, and the 7th record has a MSDeficient value of -1, so it writes that record to the table, wouldn't it then have to "move next" to the 8th record and continue...

Paul, after making the changes, I now get a "no current record" Run-time error '3021' pointing to: .MoveNext Can you help me fix this?

Ugh, thank you for helping me find the forest in the trees... :-)