Search results

All. Thanks just needed some direction. Appreciate it, should be good to go now.

@June7 , a subform on a mainform. Depending upon which option the user selects either of 2 subforms are to be opened on the mainform.

This maybe simple but i could not find an example. If i have a form 'main' and wish to open either of 2 different bound subforms, say 'subform1' or 'subform2' by button press. How would i do it? Or is this the wrong approach? Appreciate the heads up.

@MajP , You were correct. I added the control to the form, made it invisible. All good. I had the field in the recordset but not the control on the form!. Cheers.

So, I tried @theDBguy's recommendation from post #6 & got 'Compile Error' Method or Data Member Not Found. Also tried Me.[ApiaryID].DefaultValue = CLng(Me.OpenArgs), thinking that OpenArgs had to be converted to long from string. Nope. Interestingly, if I start typing in the line of code from...

People thanks. I"ve got the concept. Really appreciate your points of view as always.

@ebs17 , thanks. Got the concept. Will give it a go. Thanks & thanks to everyone else whom assisted. As always I've learnt something new that makes me a bit better with my coding.

@theDBguy , so if I understand the default value is only applied to a new record?. If the user closes the record without entering any data then no 'phantom' record is added unlike my technique where it is possible as I've assigned a value to the [apiaryID] field when the form opens?

I've used the following code on the Form_Current event. Private Sub Form_Current() If Me.NewRecord Then Me.[ApiaryID] = Me.OpenArgs End If End Sub So, as written, If it is at a new record & the user saves without entering any fields, then a new record is created with only the...

Friends, i've been passing the foreign key to the related form i wish to open & on the receiving form using the onload event of the form to populate that key to the new form. I realised that ifthe user closes the form without entering data, then a 'fantom' record is added that contains the fk...

Figured it. Just needed to understand how multicolumn reports are formatted. I've learnt something new!

Also if you 'Print Preview' the report it shows a snippet of the columns on the right..

All, this is driving me nuts!. I have a report that includes a linked subreport & within that another linked subreport. When I preview the report all is well, but when I print the report to either a printer or as a PDF it is formatted so that upon change in the record on the subform (inspection...

Gents, you've both 'hit the nail on the head'. I haunt all the forums & popular access websites for new stuff & have downloaded a plethora of access related texts. I thought a structured course that i could work through may give me additional motivation. Don't get me wrong, it's a strange...

All, I've just completed a project that I estimate has taken about 500hrs & has been a labour of love. I've been forced from my comfort zone, taken all sorts of twists and turns, learnt a stack of good techniques, gotten some great support & had a lot of fun. Now it's done & in use, I'm at a...

I am in the final stages of developing my “Beekeeping” database and shout out to all the people who made it a reality. To describe the project, I purchased a ‘FlowHive’ some 18 months ago. This type of hive is unique in that it dispenses honey without the need to remove (and disrupt the bees)...

Gents, Vlads code worked. All good. Appreciate the help. Thank you. I move on....

@sonic8 , thanks. I'm away from my pc for a few days & will try Vlads code & have a look at your link. Will let you know. Interestingly, if i use the sendobject method to open the default browser all is well.

Cheers Vlad, you may recognise the code?

I put set OutApp.ActiveWindow.WindowState = olMaximized directly under line Set OutMail = OutApp.CreateItem(0) & got 'error 91 Öbject Variable or with block variable not set'. Don't understand it. Assistance would be appreciated.