Search results

Hi Simon_MT, This works exactly as you said it should - and when I run this with the same 'variables' with my code, the outcome is correct. It just won't open the browser at the appropriate record. If I copy the string from the Immediates window and paste it into the web address of the...

Thank you. It wasn't as complicqated as I thought!

Sorted! I had the Filter string in the wrong place because I missed a comma! Brilliant, plog, thank you. Pete

I've had a go at using your code, but I'm getting a bit stuck with understanding this bit: strFilter = "(1=1)" When I use this: If strAuthority <> "" Then strFilter = strFilter & " AND ([Authority] = '" & strAuthority & "')" I get the following value for strFilter: (1=1) AND ([Authority] =...

Cool. I've used the following (longest) code to start the If, Then, ElseIf statement. Would I be correct in thinking this could be split in to 6 lines and replace everything I've written? If strReference <> "" And strAuthority <> "" And strLocation <> "" And Not IsNull(dStart) And Not...

I see what you mean. Would this work if multiple options were selected, though? Pete

Good idea. I've used this as an alternative... If chkLocation.Value = True And chkLocation2.Value = True Then rResponse = MsgBox("...click OK to return to the search screen", vbOKOnly, "You can't use that combination...") GoTo NoSearchString End If Using this kicks them out at the...

Hi plog. A user can enter data in any combination of the fields in the form I uploaded a screenshot of. They then click a commnd button that opens another form with the results meeting the criteria they selected. I've managed to write the code with a few of the combinations and where a single...

Hmm. 120 combinations might make this a bit too cumbersome!

I have a form with 6 unbound fields on it to enable users to search for records meeting one or any of the criteria they've entered data for. There are a few 'requirements', as identified below: fldA can be used on it's own fldB can be used on it's own fldC can only be used with fldB, if it's...

Thanks, plog. All sorted. I did have duplicates within the tables, so allowing this enabled the merge to work properly. Pete

arnelgp? You're a genius! Thank you :-)

Further update... When I changed the formatting on my work laptop and sent it back to my iMac, the formatting was correct. When I sent it back to my work laptop, everything was OK except the front color on one of the command buttons. Funnily enough, when I looked at the form with the command...

Hi arnelgp, Did as you suggested, but loads of the text has gone red, so have I copied it incorrectly? Thanks, Pete

I didn't want to, but have now decided to make the forms in my database 'moveable', but I was wondering if there's a way of doing this without the form's caption being visible (i.e. when setting the border to 'Thin'). I appreciate I can make use a space " " to hide the form's name, but this...

...and I'm still struggling to do so. Before I trundle further down the path of getting the MoveSize variables from one form and setting the next form to them, here's simple question: I open a search results form from another form, which can have none or many results. Can I limit the number...

Hi Galaxiom, I looked at that and changed all the controls last time I copied it over, but that was a bit of a pain - but it worked. The settings on my iMac for the Back Color of the FormHeader, for example, is '#FFFFFF' when the db is open on my iMac, but 'Text 2, Lighter 80%' on my laptop...

Nope. Shows as it was designed to do when I copy it back. D'oh :banghead::confused: Pete

So, after a load of work and help from this forum, I've finally got to the test release stage of my database, but something wierd is happening to the formatting of a form when I move the database to my work laptop. Each form was designed on the same template, with the same colours and fonts...

A college professor was doing a study testing the senses of first year schoolchildren, using a bowl of fruit Polo's. He gave all the children the same kind of Polo, one at a time, and asked them to identify them by colour and flavour. The children began to say: "Red............ cherry,"...