Search results for query: *

Hi everyone: In a module, Module1, I declared a public booelan variable. Later in form and its subform i can not see it. Module1 Option Compare Database Option Explicit Public ServicioActivado As Boolean In the load event of my form I do the test: MsgBox "My Boolean value is: " &...

Hi everyone, This thread thread702-1228727 has been very useful for me, it works great; But i don't know how to control a behavior. When it displays the filtered list, the user is not able to select an ítem from that list, because combobox takes the first ítem and close the dropdown as soon as...

Hello guys, Trying to retreive some user information, but I have problems when retreive Date or Boolean fields. If I incluide Date Fields, the query does not return records. Taking off that date field of the command it does returns records. I've tried to format or convertig the field using...

Hi guys: May be someone got this easy, but I spend some days around it and I already looked it up in this forum with no luck. My purpose is to record the invoices and products the company has bought. I have created a form with subform that save that information. If the subform has no record...

Hello: Ineed to know if its possible to use the group/ungroup command in a protected sheet of MS Excel. I tried but an error message come up saying that i have to unprotect the sheet first to do that. I made a little search on the forum before create this post, but no luck. Helps about it...

Hello Guys, I created a subform with chart purposes, so I change the "Allow PivotChart view" Property to yes, the others remains No. The Default view I set it as PivotChart. I set the subform chart I save it and I test it. It shows data in bar chart type. But, when I insert it and link it to...

Ui guys, I have had hard tme with a subform placed in a tab. I've spend two day woith no luck. Here is the issue: The main form doesn't have a recordSource. There is a tab control and in each page i have a ListBox on wich I load records using code. I also created a sub form that I want to tie...

Hello guys, I just create a sub form that shows multiples records, One-To-Many, I would like the users select the options needed from that list box using check marks. I search in this forum for similars posts with no luck, or that's what I think i did at least. [smile] In the tool box MS...

Hi everyone, I have a datasheet sub form with a couple of combo boxes, one depending on the value of the other one. The mian combo box is unbounded, but it has a field on the table where to store the its value (DataSource control), and the other one takes its values from a table and depending...

Hello Guys, A value was set in DOS ej: Set ThisVar=PcName. If I try to get the value from that variable using vbScript, comeup an empty value in my Msgbox. If i try to get the value under DOS mode manually, it works. If i use WSH, returns anempty value. Has anyone try to get that kind of...

Hello Guys, I have an Access DB 2007 in spanish. The screens have comboxes that takes its value depending onthe value from others combobox. In the rowsource the reference starts with "Formulario" word, because my MS Access is in psanish and the user has the english version; the rest of the...

Hi Guys, The Script below Supposes to make Software Inventory remotly. The Script takes the PC name from a file previously, then, it get connected to the computer and search for the software installed and some other information and place it into a Excel sheet. There are some cumputer with...

Hello Guys, I've been looking for this script in the Forum with no luck. I need to list all the properties names along its values from a particular WMI Class. The final report need to get is something like: PCNAME CATEGORY DATA VALUE cesarPC ComputerSystem Description...

Hi all, Can any one help me on how can I get a list of the computers in a Domain using WMI? I need name, description, and some other information related to. Thanks in advance for oyur help about it. Regards, Cesar Humberto Parrales Application Support

Hi all: I modified a Sript that I found in this forum to get an Inventory SW of my PC. I notice that It did not included the IE. I need tknow how to obtain the IE version using my Script. Here is my code: 'On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:" &...

Hi Guys, I've searched similar posts with no luck. I need to create an Access 2007 table from an ADODB.Recordset, but i do not have any clue. I can create a table from another table using this: dbsCurrent.Execute "SELECT Journal.* INTO JOURNAL01 FROM Journal;" But using ADODB, i do not know...

Hi Guys/Girls, Access 2007 I have a Datasheet form into another as a subform I have a sumary texbox unbound in the first Datasheet, that takes the its value from another unbound texbox placed into the subform. This works just fine. The problem I need to solve is the sumary. This shows the...

Guys, I'm trying to insert comments in a Excel cell, since a new macro I've created. But no success. Here is the Macro code: Sub Macro1() ' ' Macro1 Macro ' Macro grabada el 16/12/2009 por cparrales ' ' Range("A5").Select Range("A5").AddComment Range("A5").Comment.Visible = False...

Hello Guys, I'm building a query in MS-Access 2007, and using at Designe mode a Left function but I get and sintaxt error when I use Left/Izq. Functions. If I use Length function no error come up Have somebody solved this. Appreciate your help Cesar Humberto Parrales Application Support

Hi everyone, I need to read a web page already loaded. I need to take information from there and process it. It is an Application web, I guess, where I write my user name and password, then select the option that open the page I need and finally take it to MS Excel where I process it...