Search results

yeah, but all the reports come in with "... for the Financial Year 20xx/yy" I was going to use a combo for the input field as I can guarantee that no matter how many times it is explained, I won't get 100% consistency on the translation of a financial year to the correct calendar year by the...

Hi all I have a form that allows input of historical finance data. I want to give the user a field where (s)he can input a financial year (eg 2009/10, 2007/08). Do I do this as a date field, or a string field? I've had a search, and I think this was a similar question...

And Solved again! :) Used the CommonLabels approach, but changed: ctl.OnClick = "=HandleClick('" & ctl.Name & "')" to ctl.OnClick = "=HandleClick(" & ctl & ")" so I was actually passing the control around. Thanks for your help vbaInet and ChrisO, much appreciated.

oh. :( but that brings me right back to the original problem. How do I reference the clicked Control to pass it to the function? I don't know how to do subclassing in vba. What makes ActiveControl 'avoidworthy'? If I've just clicked on the Control, doesn't that guarantee that that Control...

sheesh, i knew that :o ahhhh, so all i have to do is change my labels to textboxes, and then: manipulateControl Screen.ActiveControlworks thank you i'm now off to change 50-odd labels into textboxes :rolleyes:

Thanks for ControlType heads up vbaInet. I'll fix that bit straightaway. So it looks like I won't get out of writing different code for each _Click method? Do you know why ActiveControl doesn't work? ta mcalex

Hi twosides assuming you haven't solved this yet, I would change your front end form to just have one button for each of the five days, and a TextBox/ComboBox for the user to input his/her name. The user then clicks on the preferred day and the supplied name is then added to the table on that...

Solved: OnClick event - pass this control to method Hi all how do i tell a method to do something to a clicked control? I have a form with a bunch of labels and a bunch of buttons, and I want to run a method whenever one of these controls is clicked: Private Sub manipulateControl(ByRef ctrl...

Hi Steve oops, yeah meant RecordSource. I'm gonna start again and do it properly. This problem has partly come about because I've tried to make a stand-alone form into a subForm. The way the form started is different to how the subform starts and I think it'll be quicker if I go back to...

'bind' means give it a control source in the properties box (rather than in the Form_Open event, like I'm doing) doesn't it?

Hi Steve thanks for your help, and yes it looks much simpler. I get what you're doing, but I fell over setting the Master and Detail fields with a 'Can't build a link between unbound forms' error. How do I link the forms? I thought subforms were automatically linked to the main form...

Hi all How do I do this? I want to have a form that opens with Author info. On the form is a table with books by the author (book title, year, publisher), and when the user selects a book in the table and clicks a 'Show Detail' button, a subform becomes visible with detailed information about...

Hi Bob OK. I have a form with two subforms. Subform1 is a datasheet view of the 'main' columns of all records returned by a query and subform2 contains all fields and uses multi-line text boxes to display data for one record. The form opens with subform1 populated and visible, and subform2...

thanks missinglinq :-) ouch, got err 2100 so I bumped up InsideHeight, now getting err 2455 'You entered an expression that has an invalid reference to a Form/Report property' looks like i got some code to fix!

hi all I have a subform with a bunch of textboxes. I've set the subform to datasheet view only, so the textboxes appear like they're in a table (or a multi-column listbox). My question is: what event do i program a response to, when the user clicks the Row selection 'button' at the beginning...

Hi PNGBill OK, so I do something to guesstimate the Height of the detail section - (# of sections x section height) + (# of key staff x detail height) - and then subtract that from the page size and divide by 2??? Is there a way to get those counts (# of sections & detail rows in each) from...

Hi all, I have a report that prints data about a number of different offices, listing sections and key staff in those offices. Some have more sections than others, but the data for each office fits on one page. I want to know if i can center the information on the page, so that the data for...

Shouldn't it just be If (IsNull(DateCompleted_Tng)) Then Dunno if syntax is the problem, coz looking harder I can't see that the extra bits are wrong, but I've always opened brackets immediately after the 'If' and don't compare to 'True' if the field (or function) IS True hth

woot! nearly there only problem now is that when there's only one Solution, it is returned in both the min and max part of the queries - resulting in the following Subject |Detail |LogDate |Solution |Solution |...

Hi Galaxiom Thanks for that, but can I make the subform appear to be part of the 'row' of data that the query returns. Ie the resultant view should look like: Subject |Detail |LogDate |Solution |Solution |...