Search results

I dropped the macros - can do it without them, but other problems. The topic continues here: http://www.access-programmers.co.uk/forums/showthread.php?p=1455312#post1455312

I've made a RH-menu, to move records. A2010 - open attached DB - place cursor in field Department in the middle of the form - right click - select MoveUp - do it again and again, then I get error when record is in second position from top in the table: "The expression you entered contains...

Follow this recipe exactly: http://www.baldyweb.com/immediatewindow.htm

1. Define "it will not requery" - it punches you on the nose while it screams no no or what happens exactly when you do what? 2. Your combos have one column only, so you should reset them to Null. You can get the guiding text by inserting into the Format property of each combo: @;"The text...

1. I'd suggest you actually read the text in the code. Ken Getz has carefully written what happens if no file is selected. 2. Why do you use this API instead of the FileDialog that has been built subsequent to the invention of this code in the previous milenium and been used in thousands of...

The record source of the combo needs to be requeried. If you used the nont in list event it would do it for you, as far as i recall.

You are just another victim of the tool of Beelzebub: lookup fields in tables. Don't use them in tables. A lookup (combobox) in a form gives the same visual result, but does not confuse the bejesus out of everybody, because what you see in the table or query columns is what you get. Not so...

I am preparing a right-click menu with 2 items MoveUp and MoveDown, used to reorder records in a form. A2010. I've prepared code to move selected record up. Open DB, click on a record, click on cmdMoveUp - record moves up. I can run VBA from macro (and the macro will go into the menu items)...

Not a valid reason to contravene normalization - data can be filtered, especially in queries. Users have no direct access to tables, so data shown will be theirs only. "clutter" is no argument for invisible data. For access, with proper indexing , it makes no difference. So again, like data...

Why? That is denormalized data, and it causes a problem, as you've just found. Keep all in one table and add a column so you can mark which is which.

http://www.bbc.com/news/world-us-canada-34507760

Me (to my partying friend): "So, last night, were you chaste?" Friend: "Depends on how you spell it"

You are already off of the beaten track because you use data as column names. That makes everything much harder and contravenes "data normalization" - google that term and assimilate the concept. There is no normalization police though, just huge self-inflicted PITA forever as penalty. You...

And what exactly does that have to do with FollowHyperlink method? You did not look it up did you. You still have not provided any argument for why you find it superior to have a document viewer built in, instead of using existing available facilities.

This is a case of paralysis by analysis. I gave you code, you did not comment on it. Now I have no clue what you want but being the short-tempered bitch I am also no inclination to pursue this. Wait for someone with a grain of patience.

Er ... what do you want -show the value of a variable or its name? Update: You may want to DL the free Smart indenter to indent your code. google.

Private Sub Form_Current() Dim agenow As Integer agenow = DateDiff("yyyy", [DOB], Now()) If (Format([DOB], "mmdd") > Format(Now(), "mmdd")) Then agenow = agenow - 1 Me.NameOfTheBl...TextBox= agenow End If

Why? What's wrong with looking at the doc in its native application? You invoke that using the FollowHyperlink method (look it up in the documentation).

Suggestion for what? It is not clear what you are stuck on or need fixed.

This is a forum staffed by volunteers. The "askees" are invited to do anything possible to make the life of the responders easier. You have concocted a long story, easy to visualize when you have the structure/tables/forms in fort of you but tough when you don't. I for one cannot be bothered to...