Search results for query: *

Hi Everyone: I need to know how to check whether or not Outlook is open. I have searched through the forums and have not found a solution. Any help would be appreciated.

Forgot to say that I tried that, for some reason it didn't requery correctly. I think it has to do with the way to two actions work. I know they work a little differently

It looks like I figured it out. Instead of having the software entry form requery the subform I created an Event Procedure for the On Activate Event of the subform combo box: DoCmd.Requery "SoftwareName" This is probably inefficient to requery it every time but my database is only...

hmmm new problem. the subform doesn't appear to be requerying correctly. I see it refresh but the combo box doesn't have the new software. Is there anyway I can requery the specific combo box inside the subform that is inside the form? Here is some more info The software subform is located on a...

I just used the SetFocus command and it worked. I guess before I was using DoCmd.GotoControl. I guess the setfocus command slipped my mind. wow thanks

Hi everyone. I have a subform that displays the software installed to a server. I also have another form that deals with software by itself. I have that subform on a master form. When I open the software entry form and add a new piece of software or delete a piece of software, the software...

Hi everyone: I have a subreport and in the report footer the following is located Total Number of Internal Drives x Total Number of EMC Spaces x X is the number for that particular server. Anyway my problem is that I also have a Header based on Computer ID (the linking field between the...

Hi Everyone: I have looked all over this forum but can't seem to find an answer. I have a subreport, srptDiskStorage, and I want to count the total number of drives that are of storage type 2 on the report. The would involve counting the records for each time a storage type 2 drive appears. I...

Hi Everyone: I have a public string in a module for a report. I want to place that variable on the report somehow. Is there anyway to do this? Thanks, Vinay

I would need to calculate at any time the amount of entries in the table ComputerSoftwareList named cobol. That table is basically a linking table to link software to servers

Hi Everyone: I have a field in a table that keeps track of the total number of installed instances of a particular piece of software. When a piece of software is added to a server in a form, I want to be able to increment the number in that field. Additionally I would decrement it when a...

Yeh I forgot to include a descriptive subject, and I tried to stop the previous message, but I couldn't. Sorry about that, and thanks again

Thanks BK worked great

Hi Everyone: Here is my problem When I run this code: If SelectString = 3 Then Me!lblWebDeveloperRequired.Visible I get the following error: Run Time Error 438, Object doesn't support this property or method. If I go to debug the following is highlighted: Me!lblWebDeveloperRequired.Visible...

Hi Everyone: When I run this code: If SelectString = 3 Then Me!lblWebDeveloperRequired.Visible I get the following error: Run Time Error 438, Object doesn't support this property or method. If I go to debug the following is highlighted: Me!lblWebDeveloperRequired.Visible Basically I am...

Sorry if this question seems dumb to anyone but I need some help. Can I open a form with certain criteria without creating a premade query, like putting a SQL WHERE statement in the OnOpen or OnActivate Events? The criteria would be based on a variable Thanks in Advance, Vinay

Here is my problem: I have a filter with the criteria [Enter Software Name:] that opens a report based on what the software name is. It then tell you which computers have this software on it. If the Software is not installed on any servers or does not exist, the report has no data, which is...

I had to modify the SQL statement a bit to get the code to run, but it did and worked. Here is my final code Dim vWhereClause As String vWhereClause = "(([Computer Basic].[Network Name]) Like [Forms]![CompleteComputerEntry]![Network Name] & '*')" Dim stDocName As String...

Thanks One more question. If I wanted to avoid applying a filter and instead used the wherecondition parameter of the DoCmd.OpenReport Command, how would I write that part DoCmd.OpenReport "CompleteComputerReport",AcPreview,,?????

Talonjpc (Visitor) Jul 29, 2002 I know the SQL LIKE command allows someone to search for a value that matches part of the criteria. However, how do you use the LIKE command with User entered criteria. I want the user to enter a server's network name, so in the criteria I put Like [Network...