Search results

I don't think it used to be like this. Perhaps I'm thinking back to Access 2003. I'm using 2007 now.

I'm seeing some mixed results from this: http://superuser.com/questions/30007/is-there-any-way-to-hide-taskbar-labels-and-not-combine-taskbar-buttons

This must have been caused by a Windows update. I see it too, but I remember sometime ago, I did not. If you have the taskbar set to "Always combine, hide labels" then the icon does not appear. Any other option for that setting and the icon appears again.

Perhaps try DoCmd.RunCommand acCmdPrint

What command are you using to print? Here is what I do: Private Function TryPrint() As Boolean On Error GoTo err DoCmd.RunCommand acCmdPrint TryPrint = True err: End Function

I have a rather complex where clause that is built dynamically based on optional user input. I would like to convert this from VBA to a standard query for increased speed. I've heard access does some behind the scenes stuff that make regular queries run faster than anything in VBA. I want to...

A sample that shows how to use a subform like the built the built-in split form, or at least the way I think they should be. Perhaps I've been bored lately...

If you are interested in helping, you can run Einstein@Home on the BOINC software. BOINC is a program that distributes computational processing over the internet. There are other at home projects you can help with, but the gravity wave search project is the only one I'm familiar with...

Use an addin called mz tools. It lets you make a hotkey that inserts your error handler in vba.

So from the main form you are referencing a control on a subform? If so, it has nothing to do with the tab control. It should be something like... Me.[Neighbors subform].Form.[control name] If you are referencing this control from somewhere else, it would be more like this: Forms![parent...

Yes, like I said, it typically works fine. I've only seen this issue twice, and a computer restart fixes it.

I'm not sure what's going on. I kind of suspect it's just something with this terminal. I've never seen it on my dev pc. As I said, a reboot fixes the problem, so it seems like the answer to your question is yes. Giving a little more detail, I have a default ribbon used to open forms. Once...

I have a custom ribbon that shows or enables controls depending on what form is open. Occasionally, the wrong controls are shown and the enabled state is not correct. After a reboot, the issue is resolved. Does anyone have any idea what could cause this?

If you want to limit the characters entered into a field, you can use the control's keypress event: Private Sub Text0_KeyPress(KeyAscii As Integer) If Not ValidChr(KeyAscii, Me.Text0, 20, enumPhoneNumber) Then KeyAscii = 0 End Sub KeyAscii - the integer from the keypress event ctl - a...

Perhaps this.

See this example.

Did you change "MySearchContro" to the name of the control you want to skip. :p

I think MarkK's answer is the best. Just make sure all those name correction options are off, and make a backup before you go renaming a bunch of stuff.

Try this out. Just pass the name of the control as the optional parameter when you call the function. Alternatively, you could use the tag property of the control to tell the function to ignore it. In that case, there are no parameters needed at all, but it's up to you which you think is...