Search results

Thanks, DT. It does now! Here it is Highlight Database Sample Edit Here is the same form for Access 2K. [This message has been edited by Talismanic (edited 06-07-2001).]

Here is a quick tip for you. Take any macro and Right click on it and choose SaveAs/Export > Then choose Save as Visual Basic Module > Then uncheck the next two options and click OK. Access will convert the macro into a VBA Module for you which can be cut and pasted right into a control's...

I am still missing something obvious here because when I try and put the code in my own form the color changes the first time I mouse over but does not change back like it does in the demo. DT, what am I missing? And is ok to put your sample database on my website and provide a link here for...

Ok, I feel really stupid now, there is "code" behind the form. Did I just hear a great big duuuuhhhhhhh. I am sorry, my brain is not working this morning. By the way, this code was inside the form and not in an external module. Option Compare Database Option Explicit '**************** Code...

Sorry about that I was going to post it but opted not to for no good reason. There is actualy no "code" involved. Put a control on a form with some text and then put this =fSetFontBoldRed("ButtonName") in the On Mouse Move Event, not in the code builder but right in the space that usualy says...

Thanks, that did the trick.

I am trying to change the text of a button when the mouse pointer moves over it. Does anybody know of a way to do this with Access. I would like to change it to magneta when the mouse is over it and back to black when it isn't. I just can't figure out how to capture the event and then let go...

Is this Access 2000 or 97K? Open a new module and check Tools > References to see if any are missing.

You can check for missing references by starting a new module and then checking Tools > References. There will me a missing next to the reference, just check it and retry your function.

To keep things on topic, here is the other post. Topic: Date Reminders???

As far as I know, there is no direct way to convert Access forms over to HTML forms. They are very different in structure. However you may be able to duplicate many of the Access events using VBScript and ASP. I am no VBScript/ASP expert but if you would like some help with it, let me know and...

You use the LineSlant property to specify whether a line control slants from upper left to lower right or from upper right to lower left.

Two answers, 1. Use the properties and set the size using measurements. 2. Select the line, hold down the shift key and press the arrow key in the direction you want to size it. Left makes the line smaller and right makes it bigger. [This message has been edited by Talismanic (edited...

I have had this happen when a forms event is set to a macro/module that no longer exists. If you know what form is causing it go through each of it's events and remove any reference to a macro/module that is no longer needed.

This is more a Visual Basic question then it is a VBA question but I am hoping some one here can help. I have a device on a Windows 2000 machine that I need to be able to enable or disable on the fly. I was shown a solution using Send Keys like this: Set WshShell =...

This should work, eh? txtString = StrConv([txtString], 3)

Ok if it is Access 2000 all you have to do is reference that the recordset is DAO to make it work. Make this change to your declaration: Dim eventrec As DAO.Recordset By the way the reason you were only getting the 1 with your code was because without the loop Access only accesses the...

If you are using Access 97 this should work for you: Private Sub Command0_Click() Dim eventdb As Database Dim eventrec As Recordset Dim eventcount As Integer Set eventdb = CurrentDb() Set eventrec = eventdb.OpenRecordset("Pending Bookings query", dbOpenDynaset) Do Until eventrec.EOF...

This may help you get started: Forms: Cycle through controls with common names

Is this what you are looking for? Convert Currency ($500) into words (Five Hundred Dollars) HTH