Search results

I have a form called 'Order Details' that contain a field called 'Name' and combobox called 'Product Code'. The combo box is sourced from a table called 'Titles'. When the value in the combobox 'Product Code' is changed, I would like the 'Name' field to lookup the corresponding value from the...

I want to add a full stop to the end of my date field, so i use this code: =[Return Date] & "." It adds the "." but it changes the format of the date to 'General Date'. I want it to be long date. If I take the "." out of the field, it reverts to long date. Is there a work around?

I've created a report that uses a Word OLE for most of the text. Is it possible to embed a field into the OLE so that it looks seamless?

I've created a report that uses a Word OLE for most of the text. Is it possible to embed a field into the OLE so that it looks seamless?

My mail merge to Word doesn't work properly: Access opens the Word document then adds the first field into the first bookmark fine, but then does nothing with the other bookmarks. What is wrong? This the code: Private Sub Command188_Click() On Error GoTo MergeButton_Err Dim objWord As...

Please see the attached zip. I want to synchronise the data in the Sales subform so that, when a different record is clicked, the data in the subfrmSales2 changes. IE, when a user clicks on OrderID1 in the Sales subform, then the data for OrderID1 shows in subfrmSales2. And when a user...

I've created a form (callled Contact) that contains a subform (called Sales). The Sales subform is a datasheet that displays sales for each contact and changes when the record in the Contact form changes. All works fine. My problem is that I want to display some big text fields from the Sales...