Search results

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

I have a sub form (RPTSQueue_subform) on a main form that I would only like only appear when the user click a check box (Queue) on the main form. Below is the code that I am using on the AfterUpdate event of the check box, but it is giving me an error "Run-time error '424': Object required" If...

I am trying to do a cross tab Report, and having great difficulty. I have made a cross tab query with Row Headings of SubGroupID, and Column Heading of Date, Value of “Count” that is Summed. So I should the list of SubGroups going down and the Dates going across. I have tried working with the...

I have a form based on a Query that shows the total number of records in the Query. This form refreshes at a set interval using a Macro and the timer Event. After the form refreshes I would like to check the number of records and send an email if the number is Greater than 5. So under the same...

I would like to filter my form based on the value in a combo box. I have a apply filter macro, with the where condition is Forms![CronStore]![Location] = Forms![CronStore]![FilterLocation], and set it to run after update on the combo box. But when the filter is applied there are no records...

I have a Report that gets exported into Rich Text Format, and it is cutting off one of the memo fields at about 490 characters. I have tried several of the other export formats, and they are cutting off the memo also. The report in Access looks fine, it only gets cut off after it is exported...