Search results

Since it's a Rich Text field, the formatting is imbedded in the text. I found this out by putting a debug stop in the AfterUpdate event of a rich text memo field. I then typed "This is a test" in a Word document in Algerian font, then copied and pasted it to the field. In the Immediate pane...

Maybe my terminology is messed up, but I thought the Ribbon replaced the 2003 Menu Bar, so I'm not sure what you are referring to. If you had created custom menu items in 2003, they would appear under the Add-Ins tab on the ribbon. Maybe you're referring to the Quick Access Toolbar?

I haven't tried any of this, but this article might get you on your way. http://msdn.microsoft.com/en-us/library/office/bb258192(v=office.12).aspx

I'm not usually very good at deciphering what people are trying to say & do, and I'm a little vague here, but I'm not sure you're understanding the purpose of forms and subforms. Generally, the main form (form1) has a table (table1) as its datasource. The primary key to table1 will have unique...

From what I see in Access Help, the "MinimizeRibbon" is the parameter passed to the CommandBars.ExecuteMSO method, identifying which commandbar command to execute. If you right-click the File menu, you'll notice that the "Minimize the Ribbon" option is a toggle, with the value indicated by a...

I concur with jdraw. We have no context with which to answer the question. Run-time error '429': ActiveX component can't create object. What object are you trying to create? Whatever it is, I don't know why failing to create it would corrupt the database. Regardless, it never hurts to run...

The record layouts of your Copy From and Copy To tables would need to match, but if they didn't you would be getting an error message, which you didn't mention. Something might be happening that causes your paste buffer to be lost. I experimented by opening an Acces table, selecting a record...

For future reference, please be specific when something doesn't work. We have no idea what that means. Did it blow up? If so, when, and what was the message? If the results not as expected, please explain. In this case, I'm assuming it failed because you have a subroutine (Private Sub...

I've been helped a lot here, so I'm glad I could pay it forward. I also know the frustration of posting questions and getting zero responses. Blessings!

Where are you defining the variable? It needs to be in a separate code module, e.g., Module1, so it has global scope. If you're defining it in one of the forms, it's not global.

I'm assuming that if they choose the List option, then after they've viewed the report they'll still need to pick Yes, No, or Cancel to proceed. That being the case, I'd suggest defining a global variable, Dim gintResult as integer. Then use predefined constants in your click events: Private...

You are correct, hk. As written, the BeforeUpdate event would simply open the DuplicateName form and then proceed to the end of the subroutine. Change it to: DoCmd.OpenForm FormName:="DuplicateName", WindowMode:=acDialog Then it will open DuplicateName as a modal form and wait for it to be...

One of the nice things about vb is that if your objects and variables are appropriately named, it's pretty well self-documenting, which is the case with your code, plus, there are already additional (mostly redundant) notes added, so I'm not sure what it is you need. The first two subroutines...

I wasn't familiar with DMAX, but I love it! Now I have to go back and rewrite every app I developed in the last 15 years :( Always more to learn!

Please refer back to my earlier post containing the code. The ButtonClicked subroutine should only be there once. And it needs to use the strButton parameter, rather than a hard-coded "POP" value, or there's no purpose in having a subroutine.

I just threw "formfield" in there. You need to replace it with the actual name of the hidden textbox on the form.

Assuming you have a text field in your table for that purpose, add a textbox bound to the field to some random place on your form, and set the Visible property to No. Then modify the code: Private Sub Good_Click() ... your code ... Call ButtonClicked("Good") End Sub Private Sub...

So are you still unsure how to proceed, or do you have it? Are you trying to put the click results in the table associated with the current form, or in a different table? What type of results do you want stored?

Automatically saves what? If data is entered into a record and you Tab or Return out of that record (or close the form), the data is saved automatically. You didn't answer if they can click more than one button, but I assume they can. You can either have a separate field in the table for each...

It also depends on if the form is bound to the table you're updating, and if you can only click one button or several. If it's a bound form, and only one button can be clicked, then you may want to switch from command buttons to option buttons in a frame control, and bind the frame control to...