Search results for query: *

Did you ever figure this out GelC? I have similar code to trap 2501 when user cancels from Edit Hyperlink pop-up and I continue to get 2501 message.

It turns out my vba was correct, but the nested subdatasheets cannot be referenced until they are actually opened (expanded). I had to move the code from the main form to the subdatasheet.

Sorry, maybe I'm using the wrong terminology. I guess they are considered subdatasheets. I created them just as I would a subform - by dragging a form onto another form, but then set the default view to datasheet. So, let me rephrase my question. Can I set allowedits on a subdatasheet? Can...

The datasheet subforms look like any subform in design view, but I set the default view of each subform to datasheet. I am sure I'm using the control name - I've checked this several times. The control and object have the same name.

Within my main form I have four levels of nested subform. Each subform is a datasheet. From the On_Load event of the main form, I call a procedure to turn on/off editing of the subforms based on the login ID. I can only change the allowedits property of the highest level subform. If I try...

I have added a rich text control (bound to a memo field) to an Access 2003 form, but I can't figure out how to actually apply any formatting. When I select text within the rich text box, the formatting buttons on the toolbar, such as bold and underline, are disabled.

We have an Access 2000 database that we would like to convert to Access 2007 to take advantage of the new rich text data type, but we need user level security. Since user level security is not available in Access 2007, we are thinking of upsizing the back-end to SQL Server, and keeping the...

I don't remember that option in the wizard. Can I modify the mdw after it is created to allow runtime users to change their own password?

Does a runtime user have the ability to change their password on a user-level secured database?

User has created a conference room scheduling document, which contains a table with all available conference rooms across the top and reservation times down the left side. She would like to automatically create a 365-page document that would have this same table on each page, but each page...

I just experienced this same problem. Text control and group footer section were both set to "can grow", but memo field was being truncated at 255 chars. I had to move the control into the detail section to get the complete memo field.

I have a form containing four subforms. When we switch from form view to datasheet view and expand the subdatasheet, we always see the related data contained in the first subform. I can't find any way to control what table or query appears in the subdatasheet within a form. Is there a way to...

I agree. However, I'm new to data access pages and since the Help is really lacking, it would help to have the wizards to get started.

How do I get the wizards to work? I've been trying to add command buttons, and in one of my data access pages the wizard will run when I place a command button. On another page, I get a message in the status bar that says "Setting up wizards ...", but it never runs, it just places...

I have created some simple data access pages and have stored them on our IIS server along with the mdb file. There is no user level security, so I'm using the default system.mdw which I placed in the same folder as the mdb. The pages are working for the most part, but everytime I make a...