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

Thanks very much, ShaneMan. It works great.

Shane, what post are you refering to?

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

Thanks for your reply, but that doesn't seem a very elegant way of editing the fields. Surely there must be some code or another way of that will enable me to edit the fields without opening another dialogue box.

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