Search results

If you have a custom menu, created for instance in a previous version, you can select it under Access Options, Current Database, Menu Bar. Then also remove the check marks on Allow Full Menus and Allow Built-in Toolbars.

Not that this is any comfort, but I've just used both "my usual" syntax (me.parent...), and the one going through the forms collection to alter the recordsource of one subform from another subform here. If I recall correct, some of the issues that can create challenges here, is if there are any...

It should be "as easy as" me.parent!<subformcontrolname>.Form.Recordsource = "SQL... Sometimes, to get the correct reference, I'll go through the expression builder. Doubleclicking through forms, loaded forms, main form, the subform in question, then select a property/control...

If you have it in a string variable, here are a couple of operations to try: mystring = replace(mystring, vbcrlf, vbnullstring) ' replace any occurance of carriage return/line feed with zls if there's only carriage return, then mystring = replace(mystring, vbcr, vbnullstring) for tab mystring...

As far as I know, there is no intention of providing any "classic" options. I don't like that any more than you do. You can customize those ribbon thingies. Gunter Avenius site http://www.accessribbon.de/en/?Access_-_Ribbons is a good starting point, with good samples. There are some that...

1 - Check out Allen Brownes article http://allenbrowne.com/Access2007.html - near the bottom there's a "Should I buy Access 2007" section. 2 - If you want to learn about those dreadful things MS have replaced menus and toolbars with, that steals about seven toolbars height of screen real...

Global = False - only first match. Global = True, for more matches, but then you'll find the pattern looks for zero or more occurances of the characters, and that it's greedy and you'd need lazy... Mayhaps .Pattern = "(\b\w+?\b)" (btw \w equals [A-Za-z0-9_]) If what you've posted as sample...

I'll start with saying that I don't know much about mdes, and the following comments are "general", and can probably pass as "any idea" ;) What I usually look at first when encountering this error, is form corruption. Do you know which click event it is reacting on? In this case, however, I'd...

It might be version dependent, but I'm not sure whether on dirty catches programmatic changes to the recordsource, so be sure to test that, if it applies to your situation.

Funny thing, none of them are listed in neither http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 nor http://support.microsoft.com/kb/321266/EN-US/, but at least Width gives a problem in form coding if it isn't referenced using late bound style (bang or parenthesis/quote). The...

I don't know whether they have any performance implications, but I suspect they have, as what they do, is a join between the base table and the lookuptable to retrieve the description. So, say, with three table level lookups, I suspect that any operation on the base table, would involve join...

Did you try summing the field, not the control? By the query, you seem to have a field in the forms recordsource called CubicWeight, and a control on the form called txtCubicWeight. You will need to sum the field, not the control. =Sum([CubicWeight])

I'd be careful with short date = short date, as where I reside, it looks like this in Win XP dd.mm.yyyy. Though, on my Win95 and 98 it's dd.mm.yy. So - it might be localized, too, in addition to other oddities ;)

You need both carriage return and line feed, and in that order. This means for instance chr$(13) & chr$(10), vbCr & vbLf, vbCrLf or vbNewLine

Try the following validation rule Not Is Null And NOT LIKE "*[!0-9A-Z]*" For a field in a table, and just in case you'll be updating through for instance ADO, you might want to deal with ADO wildcards too. Not Is Null And NOT LIKE "%[!0-9A-Z]%" And NOT LIKE "*[!0-9A-Z]*"

Sometimes issuing a Me.Repaint might do, but you'll probably need a DoEvents just after you assign the values to the label. Note that when doing a DoEvents, the application will receive and process/start processing - keystrokes/mouseclicks received, so your app will probably need to handle...

New engine (ACE), try "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=MyDatabaseName.accdb;"

Make the form invisible while the report is open docmd.openreport "myReport" me.visible = false then in the reports on close event if application.allforms("myForm").isloaded then forms("myForm").visible = true end if (sometimes I also use a reports on deactivate event to close it) Edit: hit...

Back to the initial question. You are not missing anything, you can't assign an array to an array in the 97 version. That is allowed in later versions, though (where you can also return arrays from functions). You can assign variant arrays, as demonstrated by chergh

These two lines Word.Application.ActiveDocument.SaveAs (MSQname) Word.Application.Quit are probably the root of the issue, as they might be instantiating a new instance of Word (check the Task Manager). Change them to work with your application object variable bjword.ActiveDocument.SaveAs...