Search results for query: *

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

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

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

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

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?

am working on a form and sub-form that allows users to split a line item so partial shipments can be recorded. If my text box for entering a partial amount to be split out is bound to a data source I cannot make an entry. If the text box is not bound and I make an entry, the number will appear...

I am trying to highlight select records on a sub-form. I can easily create code to change a background color or make an object visible to mark a record. I am trying to figure out to trigger the code for some records but not others.

I am working on code for a form button to add a new record to a table. I have tried two approaches. The first approach is: Set rs2 = db.OpenRecordset("SELECT OrderNumber, OrderID, ProductID, ShipNumber, " & _ "ShipQty, DateShipped, Notes " & _...

I am capturing information and field names from an existing record in a pair of arrays. After processing the array with the data I want to be able to insert this as a new record. One of the fields is an AutoNumber field, so I do not want to try and insert a value for this one. I can string...

I am using the following code to set the value of a checkbox on a sub-form: If Not IsNull(Forms![Ship Partial Form].[Ship Partial Subform Two].Form.DateShippedTextbox.value) Then Forms![Ship Partial Form].[Ship Partial Subform Two].Form.ShipPartialCheckbox.value = True Else...

Here is a quick question. If I run a query or open a table, how do I get a count of the number of fields, as opposed to the number of records?

I am working on a form in Access 2010 that is needed to show information on partial shipments of line items from sales orders. I have a main form to show the order number, a customer name, the order date, and the total number of items ordered from all of the line items. There is a sub-form...

Iam trying to open one form from another form, using CallByName, and to call a user-defined subroutine in the form that is being opened. I have gotten different error messages depending on the exact coding I am testing. The most recent one is error 424, for Object Required. I have an object...

I am working on a form that calls another form so code in some of the second form's subroutines can be utilized. It works just fine in test mode, but today one of my coworkers has bee getting some error messages. When I look at my error log table I see the following: 3021 No current record...

I am working on a function that will cause a email messages to be sent when payment is received for an order. There can be more than one line item for each order, so I have to use queries rather than get values from checkboxes or other objects on my order form. The four fields I need to...

I am working on VBA code in Access 2010 to get information from a memo field and post it to a cloud based service. I am able to copy information from the memo field into a String variable. Since I am posting to the cloud I am going through the string one character at a time. If a character is...

am working on code to open one form using DoCmd.OpenForm from another form, using parameters as follows: FormName - the actual name of the form. View - in this case no value is passed, so the default acNormal is used, opening the form in Form view. FilterName - the name of the other form's...