Recent content by Old Man Devin

If you turn the property sheet off using the property sheet button in the ribbon then it should stay closed whenever you close and reopen the form. Or least that is my experience in Access 2010. If you can't stop it coming up, try putting the datasheet form as a subform on a blank regular form...

Is there a chance the message is correct? Is the report giant or full of images, or is the printer particularly old? I have seen that message appear in various situations, but in the past doing a compact and repair on both the Front and Back of the database tended to get rid of it, so that may...

That would suggest that the column either doesn't exist, or isn't visible for that combo box. By the way, don't know if you're aware but in access the first column is column 0, so .column(1) is looking for information in the SECOND column of the box you're looking at. So that might be the...

I don't think the IN route is what you want here, as having IN then a list that contains * will just mean anything can satisfy your if condition. It's strange that Like "*Her2*" doesn't work, so I can only guess it really is something strange to do with how multi-valued fields are read in code...

One other thing to check is that column 1 (which is the second column) is visible in the row source of the box and that it is set to show in the combo box. So you need to have the combo box have 2 as its number of visible columns, but if you don't actually want to see the 2nd one when using it...

I've never actually used a multivalued field, but looking at your code I suspect the line: If Immunostains.Value.column1 Like "*Her2*" Then Needs to be more like: If Immunostains.Column(1) Like "*Her2*" Then This may help!

I don't know for sure, but I believe the attachment has a FileName property you can use. Have never done this, but perhaps something like: MyFile = rsChild.Fields("FileName").Value will achieve the goal.

I'm not sure what you mean by 'bumping'? It might be stopping you deleting due to relationships with referential integrity set between your tables. Easier to identify the specific records in each table separately then delete them with separate queries, might be easier to see what is happening...

Had a look at your tables. Looks like you have a completed boolean field there, so all you need to do is delete everything from the daily table that isn't completed, right? In which case, make a delete query using this SQL and execute it: DELETE tblQiz.*, tblQiz.Completed FROM tblQiz WHERE...

My pleasure!

I know the film-maker has distanced himself from the ideas in the film since making it. I have seen some of his modern stuff on social change and sustainable living through analysing society via the scientific method that is very forwarding thinking and cool, some of which I think is in the...

You have an 'exit sub' in the middle which means it does not run everything after it. So I think you want something more like: Private Sub cmdEmail_Amd_Click() On Error GoTo cmdEmail_Amd_Click_Err DoCmd.OpenForm "frmAmendment_Master", , , "[Record_ID]=" & Me.Record_ID.Value DoCmd.SendObject...

Are you concerned about copying something from teh daily table into the master table if it is already in the master table? If so, you could set up a Unique Index on the master table that doesn't let you copy in duplicates. This is done via table design view, indexes button at the top. Start a...

Going to be very difficult if you want to have the options available be dynamic in the same way a drop down menu is. First you should ask yourself why you need it like this, as if doing this is even possible, I expect it will be very difficult if I'm understand you right. Might be quicker to...

I don't think they are all that similar, I expect they are more concerned with not being killed for their beliefs / ethnicity. If they believe uniting Syria and Iraq would do that then maybe that is their long-term goal, but for now I don't think that is what motivates them. So really these...