Recent content by o1110010

Hello friends and strangers! I am guessing this problem I have has been resolved already but the closest sounding post so far is this which still leaves me wondering. In a form I have four unbound text boxes. Each of these textboxes I was hoping could be used to narrow a search if data is...

i know of two good reasons to promote VBA over macros. when using VBA, you have more control of what's going on (aka allows more customization) and you can sometimes notice the processing times are shorter. Some could also go for the "wow" effect since using VBA looks more confusing than a...

I believe you need to keep the autokey as a macro to work correctly. You could have it trigger a RunCode command to trigger vba code?

Yay! :D I'll probably use this solution.. but.. Is there a way to go about this without a macro?

Ah hah! Finally found one of the replies that I have been searching for. Pat Hartman, have you described how to make a hidden form on startup in a post elsewhere? ghudson has informed me how to use it via doCmd's acHidden property but I haven't figured out how to do it for a startup form. Anyone?

:confused: what do you mean by a hidden table? have an example either a file or explaination?

Upon putzing (general use) of .mdb files, the office assistant pops up every once in awhile. Is there a permanent way to disable the office assistant in desired .mdb files? (..other than uninstalling that feature?) I know one could disable or reassign F1 but I am not looking to disable certain...

During the events triggered when opening a form (OnOpen, OnLoad, OnResize, OnActivate, & OnCurrent), Visible is always False.. Or atleast that's what my MsgBox is saying during the events. I was guessing that I could just set it to False to keep it not visible during one of those events but it...

I know you can set a form to start when the database gets opened with Tools.. Startup.... Is there a way to have this form load as hidden?

That sounds right. How does one make a hidden form? So it not only doesn't exist on the taskbar (with your code!) but it's window doesn't appear either. (I'll be searching in the meantime. :)) Thanks.

What exactly is meant by invisible form? I know I've seen it mentioned a couple times on the forum but I was not able to find those threads now that I have the question. :( Also, a semi-similar question... I noticed when moving from Access 97 to Access 2000 when using .mdb files.. each form...

I know there is a macro command named PrintOut or something like that. (If you can't find it, I will be on a computer with Access on it later today to double-check. :p) You can set the print range via that command.

What is the property or command to use the active object? How about event? I have a function that basically timestamps a certain table with username, time, object, and event(action) that I call in only particular events. I used the Computer Class that Mile-O-Phile posted in sample database...

If you use a query, you can use a Group By option for the UnitType field and also use a Sum option to get the corresponding Sums.

When you are in design view of the query, click View then Totals. This adds the Total row to the query. From there, add the corresponding field and click on the Total: editbox to get a drop down list of available options. (Group By, Sum, Avg, Min, Max, Count, StDev, Var, First, Last...