Recent content by Wiznane

Does it really just check for the existance of win.com in the C:\Windows directory? So if that was the only file in that directory, the install would still work? Do you happen to know if it validates the .com file at all, checking for the version and whatnot?

I have a form that consists of a main group of text boxes, with two subforms below it. The form is larger than a normal screen and uses a scroll bar on the side to move to the lower parts. The problem I am having is that after entering for awhile, sometimes the screen screws up a bit when...

Nevermind. Got it with a =DSum("[Cost]","tblForkliftMaintenance","[Unit]=[Reports]![rptForklift]![Unit]") control in the outermost (Unit) footer. Still, if there any design thoughts on this, I'd still be glad to hear it. There's probably an easier way to achieve this.

I have a table set up with a repair order, the cost, date, and unit of that order. It is in a one-to-many relationship with a table holding the repair details. My resulting query returns something like the following Unit Month Order # Cost Repair description 1 10 100...

Correct, and on my replies, it is disabled. Though I can red flag my own replies if I offend myself. :-P

That sounds like an excellent way, unfortunetly, there is no security set on the database, other than a database password. This will hopefully change when I become the data administrator, but as for now, I am just doing some design. It will be in a few months, so I can tough it out till then...

I have a database that is run via a switchboard menu interface. I have an option to Design database which basically closes all the forms and unhides the database editor window (this is done via a macro). Is there any way to password protect either the switchboard option or the macro itself? If...

I think it's to prevent you from voting for yourself. There are prizes for people voted Tipmaster, so it's probably like that to prevent cheating.

heh heh, I typoed trying to correct a typo. What are the chances?

Because those aren't supported smiley's. Clicking on the Emoticons/Smileys link will pop up a list of available smileys.

Yes, the CoCmd.OpenReport that you (I assume you cut n pasted your code), should be GoCmd.OpenReport, just a typo. Also, in strwhere = "[Company ID]=" & Me![Company ID] instead put strwhere = "[Company ID]=" & Me!Company ID Though I don't know if it will work well with a...

Try enabling the Can Shrink property from the Details property tab. This should help eliminate some white space.

In order to return all records starting with "B4", replace the B4% with B4*.

Well, unless someone else can jump in with a solution, I can try to help. If you post the code you have for this and explain a little more about the report, I'll give it my best shot.

In both Access 2000 & 97, there is an option under the Tools menu - Macro - Convert Macros to Visual Basic. This will allow for faster running and also for better error handling. I am not aware of any easy way to do this in Access 95 or any version previous (I try to avoid using them whenever...