Search results for query: *

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...

A possibility is that there may be a leftover .ldb file in the same directory as the database. If no one is using the database at all, there should be no .ldb file. It can be deleted. Even if it is set to be shared, the person compacting the database need exclusive access to it, I believe...

When exporting to Word, the Documenter exports the relationships themselves, but does not display the boxes around the tables, nor the line showing the relationship. It defaults to export in rtf. Is there any quick solution to get these boxes to display, short of drawing them in there myself...

In order to change the design of any of the database objects, a single person must have exclusive access to the database, no one else can be using it. The best way is for the designer to open the database in exclusive mode while he/she is making changes so that no one else can enter the database...

Using the Count function, you can count each record. Thusly, Count([fieldname]) putting this in the details section of your report will number each record. Hope that's what you were looking for.

If I am understanding correctly, you want to print a single page of a report based off a record that is currently on focus in a form. The following code, placed in the OnClick procedure, will print off a single record. Private Sub cmdPrintPO_Click() Me.Refresh Dim strRptName As String Dim...