Recent content by sdebo2

Thank you that worked.

I am trying to call an Oracle stored procedure from VBA on a form. The Procedure takes 1 parameter and does not return anything, it just validates data and update some tables. I have search this forum, help and Microsoft support and am confused on how to accomplish this. Below is the code I...

To change your subform to be in Continuous instead of Datasheet view, you need to get to the form properties of the subform. It sounds like you were on the subform properties. In design view click the subform, if you have the properties window open it will show the subform properties. Now...

Just do a search in Access help for “SendObject”. Put[FieldName] where you want to pull information from a field in the form. I put the below in the OnClick event of a button in one of my databases to send and email. Note mine sends an email to [USERID] & "@Hotmail.com”, [USERID] only store...

In a record where the combo box appears to be blank, check the value that should be in the combo box, is it a value that is currently in the drop down list? If not, this could be an indication of a data integrity issue. If you want values to be displayed when they are not available in the...

Looking at your forms, when your curser is in one of the subform fields, they should turn into combo boxes that allow you to pick from a list. However if you want more control over how the subform looks you could change the “Default View” of the Form Properties for the sub form. Play with the...

If you SwitchBoard remains open you can add a check box (called CheckBox) to that from, then in the on Load event of the Subform add code like: If Forms![SwitchBoard]![CheckBox] = True Then cbProducts.Visible = True Else cbProducts.Visible = False End If Since your using a checkbox you may...

You can create two queries, one for Buy records only and one for Sell records only, then create a third Unmatched query comparing the Buy and Sell queries, that should be the final result set. Note if you can have both and unmatched Busy and an unmatched Sells, you will need two Unmatched...

I don’t think you need the “FROM medi_exp_details_table” statement. All of your fields are should be coming from the form. When tested this in one of my databases, I get duplicate records if there is a table showing in design view, but if I remove the table and only use fields from the open...

I assume you grouped the subreport by Date and put the summaries in either the header or the footer to get it to sum property. As far as the “No Flow” text, there may be a better way, but the below should work. Create a new Unbound text box for each column (I am going to use EN-04 as an...

Just a note, your total Freight Charge is a calculated value, so you don’t want to save it in the Invoice Table, just display the value that’s calculated on the form. I have done something similar to your request. In the Subform create a unbound text box (it can be invisible) with the total of...

Attached is a partial database. Go to form Receiving, enter 715007 in the Vendor Number Drop Down list, and click requery. This will populate the Receiving List. The receiving list contains Items that we are expecting, so when an Item comes in we find the Item and enter the quantity_RG, and...

The query being used is an apend query, so the query window never appears, How would I make sure the query is closed?

I have two subforms (RECEIVING_SUBFORM and RECEIVED_SUBFORM) on a main form (RECEIVING). The form is used to record receipt of expecting orders. When a partial order is received I want to add a new record with the difference of what was ordered and what was received then requery both sub...

That still gave me the no object error. However when I took out the main form name it worked. The code that worked is below. RPTSQueue_subform.Visible = True Thanks for your help Scott