Search results

I have a pop up form that likes to change it's height after I enter design view among other things. I've searched the webs, but can't find out strictly how to set my pop up form to be height X and ALWAYS be height X no matter what. Albert's reply here was the best answer I've found so far...

Try just [Subformname].Requery Edit, no scratch that. Just get rid of the "Me.". Alternatively, ignore my suggestions and look at this handy guide: http://access.mvps.org/access/forms/frm0031.htm

Sounds like you need to requery the combobox after you update the Client. On the After Update Event of Client on the main form, insert some code to requery the combobox on the subform.

Hey, that's pretty neat. I think I'll use that if someone clicks on it, but for just hovering I wanted something a little cleaner. For now, I'm just going to hide the other controls on mouse over using this: Private Sub ActionTaken_MouseMove(Button As Integer, Shift As Integer, X As Single...

I don't comment here often, but I'm beginning to wonder if I should find another site for Access help. Getting lots of sporadic issues...

I've found some code that will let me have a textbox grow on Mouse Over. The idea being that I want to keep the textbox small unless a user mouses over it, and they can then see all of the textbox contents. I've got code that will change it back to it's normal size after leaving the textbox as...

For anyone else reading this, I want to note that Tapatalk's search function is absolutely terrible in my experience. Carry on.

Those aren't the actual field names. Wanted to describe them instead of list them and leave people confused. Desc is not used either.

Currently, I have 4 primary tables: VehicleMstr MaintMstr FinanceMstr PartsMstr VehicleMstr contains all of the basic car info i.e. Model Year, Make, Model, Owner, Purchase Mileage, MPG. MaintMstr is used to record all maintenance items i.e. Maint Type, Desc, Hours, Cost, Mileage Performed...

Their vehicle maintenance data model is pretty robust; probably too much so to manage only a few cars, but it's a good reference.

Does anyone know where to find a free access db that stores information on vehicles from general info to maintenance? I'm in the process of making one for myself, but wouldn't mind seeing what others have done. :) Edit: this will be used at home to manage a few vehicles

As far as I know, holding down shift prevents VBA and "Autoexec" macros from running. Check for those. I don't know how that would related to a pivot table though.

There are no risks that frequent and timely backups can't mitigate.

The Overlapping Windows setting didn't make a difference. Thanks for the other suggestions. I will look into these if the user decides they just can't stand the white space.

I've adjusted sizes and every other property I can think to, but the datasheet form still wants to stretch on and on which produces an undesirable user experience.

no offense, but i think google would serve you better in this scenario

Yep. Can't find anything on this. These guys are the closest I've found to my situation.

Hard to believe it isn't a built in form property, but I may be unaware of some grand design reasoning for that. Either way, thanks for the help. Edit: since we're focused on vertical, does anyone have a solution for this problem when scrolling horizontally? See image.

The resurrection. I am having this issue as well.

Thanks, that might be what I have to do. When you say reduce the size, what do you mean? Can I simply tell the form to eliminate all space below the add record sign? I'm actually more concerned with the horizontal scrolling form, for which I did not paste a screenshot.