Search results

That's it - thanks.

Hi Are there a way (in Access 2010), that the text boxes will not display #### for values that does not fit into the textbox? I've got some reports where there can be quite large values in, and then the textboxes display ##### for these large values. I would rather have it to display what can...

Re: Form.Recordsource :: Runtime Error 2176 " The Setting for this property is too lo Hi I'm trying to apply a filter but the filter's length is about 7000 chars. I get the same error when I execute: MyForm.Filter = NewFilter 'where new Filter contains the 7000 chars Any way past that?

Hi In previous versions of Access it was possible to drag and drop a file onto a Bound Object Control. However, it seems like in Access 2010 I can't do it anymore. Am I missing something, or has this functionality been removed?

Just for other people who might have the same issue - it gets stranger. The problem only occurs if the subreport have items with a solid border of hairline width. Making it 1pt also works. You go Microsoft.

I did realise that Access crash when you try to resize the subreports - but only if one control on the subreport contains a control with a solid border. Changing all the borders to transparent actually works. How strange is that?

Bummer - but thanks for the reply. I also noticed today that it only happens in Print Preview mode. The Report view seems to be okay. But gives other issues. And SP1 also did not work. Let's hope SP2 will be released within 24 minutes.

Thanks for replying. First the reason: Based on the type on the parent report, users can customise which subsections they would like to see on the first page of the 'certificate'. They can choose 1 or more out of a selection of about 8. Based on the number of subsections, we show/hide the...

Hi I seems like Access 2010 crashes if you try to change the height of subreports with code. It only happens when: - you have more than 1 subreport on the report - You try to change the height in VBA in any event except the OnOpen event. - It crashes when you close the report. Is it only on...

Hi Funny problem in Access 2010. I have a report (in Print Preview). It's got nothing on except 2 subreports in the Details section. If I change the Height of the subreport in the section's OnFormat event, it works fine, but Access crash when you close the report. Simething like...

2 work around solutions: 1. If you remove the default value in the OnChange event, the Null value stays put. 2. Don't use default values via the Properties, but assign in code in the Form's OnLoad event. Me.[the unbound control] = <your default value> Both are a hassle but at least is will...

Hi Yes, I agree that is what the hashes are for, but why then do 4 different controls, with exactly the same width and same format display differently? Only thing that's different is the left property.

Hi Have something interesting. I have a control that displays a Short Time in Access 2010. However, depending on the position of the control, it sometimes displays the value, and sometimes the hash symbols (as if the control is too narrow). In the attached screenshot all the controls are...

Hi Instead of doing your checks with VBA code, it is better so set validation rules on the database. Therefore the database will force the rule regardless of how people are entering the data.

Hi I've got an Access 2010 app, which references a Library.accdb app with some generic code and forms. In my main app, I have a Navigation form, and 1 of the buttons/labels on the Navigation Control should display a form that is found in my Library.accdb file. But how do I show the form in the...

Can't say why it fires twice - something is triggering it obviously. But what you can try is have a module-scoped or static flag that checks whether the function has already run, and if the flag is true it can just bypass the 'meat' of the function. Obviously you must have some method to set...

Hi I've got a VBA function that returns a string in my Access 2010 app. To show the value on a form I can add a textbox and set the Control Source to '=MyFunction()'. Works fine. Now I move the function to another Access accdb file, that acts as a Library, and I add a reference to that accdb...

Hi I'm looking to get the base numerical representation of a date in Access 2010. For example: Today's date (2011/07/04) should be 40728 In Access 97 it was possible to run Format(Format(MyDate)) and you had it. But not in Access 2010. Running the double Format in Access 2010 does not do the...

The Navigation Pane will not quite do it. The main reason is that you cannot collapse and expand the sections that you create - like the Access Navigation pane. If you would like to use it as a switchboard in a big app, you can have 100's of tabs which will not work. But maybe I can use it to...

Thanks. I see the Navigation Control as just a fancy Tab Control. I think it will work 100% if it would have been possible to use the Vertical Tabs layout, but then create Groups or Sections into which the items are displayed. Something like the Tables, Queries, Forms, Reports of the standard...