Recent content by PhoenixofMT

I have a button on my form that I want to change color depending on some other value on the form. With the plethora of properties involved in doing this, is there something like the format painter that I can use in VBA? My plan was to copy the properties from other butons: With...

Oops, should have googled. Found it here :D:D:D

:eek: I didn't know you could do that! or I would have done so ages ago. I've hated the stupid Bing interface since it first reared it's ugly head. Please esplain. I can't find how in a quick look through the Access properties.

I'm hoping someone can help me with this. Guess how helpful a Google search for "Access Help" has been? :( The new Access 2010 help system (select problem code, hit F1), aside from being almost uselessly based on Bing, has become partly unreadable. Keywords in the text are 3 or 4 times the size...

I just found out the hard way that hyphens are also a no-no. :banghead: InteliSense thinks you are trying to do subtraction and automatically generated code replaces the hyphen with an underline. I had thought to use a new naming convention with my keys and have fields like "AsPOID-FK" and...

I would like to use more that just the default icons for buttons in my forms. I found this thread that says what must be done, but it doesn't say how. How do I reference an MSO image "by it's MSO ID"? I've tried various things with the Picture property but it always says it can't open the file.

I found this post after realizing this might be a problem with a database I've just started developing. It might not be the exact same problem, but it is related. I decided to try out a MySQL back-end (kinda one of those "I've got a free hour..." situations :)) with this database. I manually...

Here's what I came up with, if anyone's interested: Private Sub <combobox>_KeyUp(KeyCode As Integer, Shift As Integer) Dim iPosition As Integer Dim sArgument As String iPosition = Me.<combobox>.SelStart sArgument = Me.<combobox>.Text Me.Undo DoCmd.FindRecord sArgument...

To make the navigation for open automatically: Click the File tab => Options => Current Database Choose your navigation form from the "Display Form" list On the use of navigation forms: I fought with navigation forms for several weeks before abandoning them when it became clear they wouldn't do...

Will I have to design my own Find interface around this method? I had thought of doing that, I just wanted to avoid the extra work if I could.

I have a find button on my form that opens the Find/Replace dialog. Because I don't want my users wantonly replacing half the entries in the table, my find button first sets AllowEdits to False. The problem I'm having is setting it back to True when the dialog is closed. I've found that if I set...

Probably a bit late, but here's how I did it: Me.<control to find in>.SetFocus DoCmd.RunCommand acCmdFind SendKeys "%HS%N", FalseI believe SendKeys is the only way to do this. The "%" means the Alt key, so it basically sends Alt+H (for the match dropdown), S (for "Start of Field", you...

I've gotten in the habit of clicking the compile button before I go back to the form (or whatever) the see what the changes do. It's handy for checking syntax, etc., but I still run into problems. Anyway, I found a new better way to take care of my value passing problem: TempVars I just add a...

Well, I think I got it working tolerably. I put an invisible text box called Args on the navigation form and I'm working on getting all the buttons on my forms to check for a parent form and navigate accordingly. I think I'm going to have to learn to save (more) often and reboot my PC a couple...

I think I see a pattern. I'm having a similar problem on another form I'm trying to use in the navigation form. The form has a subreport in it with some buttons and a textbox for filtering the report. The code for the filter button was: Private Sub cmdFilter_Click() Dim strFilter As String...