Search results

weird .. this works form filter is on main... If Me.FormFilter = "0" Then Me.FormLoadX.SourceObject = "NoSchemeSelectedfrm" End If If Me.FormFilter = "1" Then Me.FormLoadX.SourceObject = "TravelQfrm" End If If Me.FormFilter = "2" Then Me.FormLoadX.SourceObject = "OrgQuotefrm However when you...

I will give this a try later on today /tonigh How is sunny Newbury

Sorry they are cascading combo boxs the first selects from a table the second should be filtered by the first selection- fine as a stand alone but once a sub/child form - does not work i have tried various options updating a field on the underlying table and using this as a filter for...

uploaded d/b in previous post..

THat's right - stand alone fine - child /sub is the issue - what I will do is trim d/b and upload uploaded..

thanks - however, that's not the problem the problem is the queries /queries are not working on the sub/child forms..

Hi Guys I am embarking on a new database I have a main form and a subform/child form that is different for each type of business (see below) form filter is on main... If Me.FormFilter = "0" Then Me.FormLoadX.SourceObject = "NoSchemeSelectedfrm" End If If Me.FormFilter = "1" Then...

very weird have resolved - but needs more thinking about I put = "" & !EMail and it works -

references loaded Visual Basics for Applications microsoft Access 14. object library OLE automation Microsoft Office 14.0 Access database engine objecvt Microsoft Internet controls microsoft office 14.0 object library if this helps

Hi guys we have had windows 7 upgrade to 10 and I am getting the following runtime error -2147417851 (80010105) Method to of object mailitem failed I presume its a reference issue any pointers would be welcome Dim frm As Form Const bq As String = "<blockquote>" Const bqe As...

today's muppet award goes to ... Me.. thanks:o everyone G

Hi guys - have "borrowed" the code below and it does what it meant to do however i want it to point/start at a particualr folder "C\whizbang\TEMP what do i need to do to redirct it there ? G:) Private Sub Command15_Click() Const msoFileDialogFilePicker As Long = 3 Dim objDialog As...

hey how do you update to solved ?

resolved - not the tidiest and I am pretty sure a little bit wrong - but does the job I added in bq and bqe (see below) to get a return line .. THansk guys for your input Dim EndTxt As String If REquiredY = True Then EndTxt = DLookup("wording", "wording", "[endorsementid]=" &...

Thanks for this and they are on different forms (i have this where it is on the same form and this works a treat ) problem is two forms two different tables...)

Hi Guys I have a tick box that once ticked goes and looks up data and then adds it to a memo field (works ok.) but I need to add a carriage return for when I add the next one (I have a list of possible data that I may need and this is in a continuous form layout ) as you can see I think i...

Interesting ... I may go silent on this one-while I ponder...:)

OK or am I pushing it - more info I have a click a drag box (web browser) that directs to a folder say C:test\12345\ and I want to drag across a file and it renames itself - I might be clutching at straws on this one Is there code snippet around that when you click and drag a file...

i'll put something together ..

Yes. kinda select records between x and y - insured -Address select records between A and B