Search results

Solution Found the problem, so I thought I'd share. For some reason it didn't like the field name "Position". Changed that word and it worked OK. Must be a reserved word or something.

When I run the following code I get an error (see attachment) at the last line. I've checked that all the table and field references are correct. Can anyone see a problem anywhere? (Note that GetBackendPath is a function that finds the path to the table, and it works fine. frmCurrent is a...

Does anyone how to manipulate the Show On Toolbar property of a menu or toolbar through code? I've used the CommandBar().Protection property to set the other properties, but there seems to be no constant for this property.

They are the constants you use when controlling permissions programatically. How to use them is a long story. Check out support.microsoft.com/default.aspx?scid=kb;en-us;112106&Product=acc

Solution Just figured it out. In case anyone else needs it, use the object browser. Select the DAO library and look up PermissionsEnum.

Anyone know where I can find a list of the numeric values associated with the permissions constants (Access 2000 - DAO 3.6 library)?

No I hadn't. I wasn't selecting the Tab Control object properly, so I was in the Page property sheet instead. Works great now that I'm in the right place. Thanks for the help. :D

I'm guessing that this can't be done, but does anyone know of a way to display page tabs on multiple rows rather that in a single line?

Possible solution One thing I've found that can really slow down a split database is having the tables that populate ComboBoxes in the backend. Move these to the frontend whereever possible.

I want to be able to place a hyperlink in a custom menu and change the path at runtime using VBA. How do I do this?

Yeah...I was trying to avoid macros. Just set it up...works like a charm. Thanks.

Thanks. Looks simple enough. Is there anyway to do this through VBA?

Three questions regarding the built-in Find/Replace function: 1. Can it be turned off? I have disallowed special access keys and it is not part of my menus or toolbars, but ctrl+f or ctrl+h still brings up the Find/Replace dialog. 2. If the user uses the replace feature, I'm assuming that it...

Pass user password to connection string I'm guess I already know the answer, but is there anyway to pass the password of the current user to the connection string (see previous posts). I'm guessing that the password property is not readable for security reasons, but it doesn't hurt to check...

Solved Thanks Lagbolt, but that didn't quite work. I managed to figure it out though. My setup for creating my connection string seems to result in the User ID being a part of the string already, so all I have to do is concatenate the password. Capturing the password is another challenge I'm...

I'm trying to create and ADO recordset from an external database that is secured with user-level security. How do I modify the connection string to include the username and password of the current user?

Thanks. I actually figured this out and forgot to remove my post. I used the Param Array argument. It worked, but was that necessary?

I want to create a function that accepts an array of values, rather than a predetermined number of arguments. Can anyone tell me the syntax for this? Thanks

I agree.

That's what I'm doing now. Just would have been easier to use the built-in functionality and control the error messages.