Search results

I have a parts order form to suppliers and the order form is made up of item lines. The Order header and the order item lines are linked by the order number. My problem is I have some fields on the item line that are not on the order header and I want to create a file that has all the Orders...

I have a continuous list of records, I want to change the selection criteria . How can I do it in vba. SELECT Orders.OrdersId, Orders.OrderNo, Orders.Arrived, Orders.DateArrived, Orders.AdditionalComments, Orders.OrderInstructions, Orders.Supplier, Orders.DateOrdered FROM Orders ORDER BY...

I found your code jdraw and don't think it suits my needs

I now get the above error. It's because the field Description is a Long Text field. How can I get around it

Yes they are

Private Sub Form_Current() ' ----- I need to find the latest Contact Log entry for this matter Me.CLogIdFld = DMax("MatterContactsMadeId", "[MatterContactsMade]", "[MatterId] = " & Me.MatterIdFld) Me.DescriptionFld = DLookup("Description", "MatterContactsMade", "[MatterContactMadeId] = " &...

I have a subform related to the parent, I also have an add new record button on the subform. The subform won't display all the transactions until I attempt to add a new record, When I click on the Add bNew Record button all the transactions that should be on the subform are displayed. Can...

Thanks guys I eventual used automation and sent the emails out without Outlook. I used the following code Public Function CreateEmailWithOutlook( _ MessageTo As String, _ Subject As String, _ MessageBody As String) ' Define app variable and get Outlook using the "New" keyword...

Thanks guys , I have tried acFormatRTF and acFormatHTML same result. The text comes out with all the html code DoCmd.SendObject , , acFormatHTML, varName, varCC, , varSubject, varBody, False, False DoCmd.SendObject , , acFormatRTF, varName, varCC, , varSubject, varBody, False, False

The table filed is specified as Rich Text, the same field on the form is specified as Rich Text. When I include the field in the body of the message I have all the html showing I use DoCmd.SendObject , , acFormatRTF, varName, varCC, , varSubject, varBody, False, False Any help would be great

I want open a new form (B) when I'm in a form (B) that's open. Form (B) is opened in the background --- why ? I want it to open on top I know this is a simple thing - any hel[p would be appreciated

Thanks arnelgp. I should have tried that. I feel a bit embarrassed about putting up such a trivial request. I was making the problem bigger than what it was. Thanks again for your solution (y) :)

I want to concatenate an extra email address (from a variable) to the following variable Me.ToEmailFld = "nick@onegrp.com.au; & """ Me.InitiatedByEmail"""" any help please

I reverted to only one combo box and it's now OK Thanks theDBguy :)

I have two combo box and their source is the same table ComboBox 1 Control Source = PartNo Row Source = SELECT Parts.PartsId, Parts.PartNumber, Parts.Description FROM Parts WHERE (((Parts.PartNumber)<>" ")) ORDER BY Parts.PartNumber; ComboBox 2 ComboBox 1 Control Source = Description Row...

arnelgp you were spot on - thank and everyone else who helped (y)

I have the parent and child relationship on the right fields for both files. I can add a record into the subform - no problem. I check the source file to the subform and the new record is there and correct. I can run the query datasheet view for the subform and manually enter the criteria and I...

WOW theDBguy - you were right onto it. OrdersSubform Data SourceObject - OrdersSubform Link Master Fields - OrderNo Link Child Fields - OrderNo Filter On Empty Master - Yes Enabled - Yes Locked - No

I have the parent and child relationship on the right fields for both files. I can add a record into the subform - no problem. I check the source file to the subform and the new record is there and correct. I can run the query datasheet view for the subform and manually enter the criteria and I...

Thank you very much "The Doc Man" ours is a Monolithic Database with 16 users on a network. You have answered my question perfectly and and the other scenarios are good knowledge for our future development and expansion. Once again thank you :)