Recent content by weightinwildcat

Here is the query that seems to be the issue: SELECT AssemblyToEngineering.CollectionPrefix, AssemblyToEngineering.Base, AssemblyToEngineering.Trim, ItemList_CF.[CF_Item_CF_tem_QRY.CF_Item] AS ProductID, AssemblyToEngineering.EngineeringPrefix, AssemblyToEngineering.EngineeringSuffix...

I am working with two queries, each of which is calls on a third query for information. Each of the first two queries use SELECT DISTINCT. Lately they have both caused the message Invalid procedure call. (Error number 5.). When I remove the DISTINCT they run. When I put DISTINCT back in they...

I have been working on a form that allows users to enter information on parts prior to having work done on a CNC machine. The information will be added to the Message field of a new record, the field is Long Text. In the course of adding the information we need to get rid of some special...

You are thinking along the correct lines, but if I change an entry in the recordset it will be picked up by the recordset clone, on account of them being synchronized. What I need is to have a copy of the recordset that is NOT synchronized, so that the original data will still be available for...

That I know. The problem is that the recordset and the recordset clone tend to be pretty closely synchronized. I need a programmatic way of knowing if any field of a record has been changed in any way, and by how much.

I need to clone or otherwise duplicate a record set of a sub-form. I need to be able to look at original values to see if any changes have been made.

I am presently working on updating a form used to change requisition requests. When a change is made an email message is sent that gives information on the requisition and line items within the requisition. My supervisor wants future emails to show not only what values are entered, but what...

I am working on a subroutine for a start button that is used to select jobs for processing. Jobs are selected one at a time. However, the jobs chosen by a given user should all be deselected if the button is clicked on for any of them. My problem is that, if the first record is the one that...

An additional problem. In some cases I get the following error: update or cancel without addnew or edit The error occurs here: Me.ElapsedTimeBox.value = elBox + elTime...

This is what did it for me: Set rscl = Me.RecordsetClone rscl.MoveFirst Do While Not rscl.EOF If rscl!RedTag = UserID Then Me.Bookmark = rscl.Bookmark elBox = Me.ElapsedTimeBox...

I am updating a form that is now being used to select jobs for processing. When a job is selected the record is marked with the ID number of the system user. In some situations a record may be unselected. In this case all the other records that have been selected by the user should be...

That was the clue I needed. In case anybody else needs to know about this, here is the code I used: Private Sub UpButton_Click() Dim frm As Access.Form Dim rs As Recordset Set frm = Me.Parent.[Ship Partial Subform Two].Form Set rs = frm.Recordset If...

I have a query with two tables that are connected through a left join. The query provides data to a sub-form. The main form show information about an order, and the sub-form show the line items for the order. I am looking for a way to add a calculated field that would show the record number...

That second piece did the trick. Thank you!

Hi. I need to run a control on one subform from a button on another subform. Alternatively, I need to scroll through records on one subform by using a button on another subform. What VBA syntax should I use?