Search results for query: *

Hi All. I need help on crating a Query that from this table: Name ! Project ! Area ! Jan ! Feb ! Mar ! --------------------------------------------- John ! A ! Boston ! 1 ! 1 ! 0 ! Peter ! B ! NY ! 0 ! 1 ! 1 ! Paul ! C ! NJ ! 0 ! 0 ...

...if outlook is close? Is there a way of knowing if outlook is running? Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem '***creates an instance of Outlook Set objOutlook = CreateObject("Outlook.application") Set objEmail = objOutlook.CreateItem(olMailItem)...

...Outlook is open. How can I do to send it still if outlook is close. Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem '***creates an instance of Outlook Set objOutlook = CreateObject("Outlook.application") Set objEmail = objOutlook.CreateItem(olMailItem) '***creates...

Hi I need to send an email with some information inserted on an Form. The body of the emal has to be like this: ROCHELLE PARK Date: 07/25/04 Time: 03:12 PM User: dhenriqu Tracking Number: A04NHPKOL10002_850_021104 Sites: 1234 1234 1234 Type of Error: HOPP PARAMETERS/...

Thanks is a good idea... but sometimes there can be blank spaces at the end, like "XXXX XXXX XXXX XXXX " so the result is not going to be correct. Maybe if you know a way of deleting these blank spaces it would work. Thanks again Dan

Hi all, I'm trying to find the way of doing a query that counts how many ELEMNTS are in a field (Always 4 DIGIT ELEMENTS separeate by a blank space). Table: Field1 Field2 A XXXX BBBB YYYY EEEE DDDD B JJJJ PPPP C IIII QQQQ PPPP D LLLL Query that I need...

Hi... I found how to do it with VBA Thanks a lot for your help Dan

OK, let me see if I can explain this.... I got a form X with 4 comboboxes/textboxes (Combo8 (request), LogIDTxt (ID), cboStartDate (date), ComboMarketText(market)). The form also has a subform that is a table result of a query that takes the texts of the 4 comboboxes on form X for the...

Mndrlion, That is what I'm doing ([forms]![FormName]![ControlName]) also I tried with [forms]![FormName]![ControlName].text, but this only works when the focus is on the combobox you whant to use as a filter. If you need to refer to 2 comboboxes at the same time (AND) it doesn't work. Thanks...

HI. I have a query where the result depends on different comboboxes that are going to have the values for the filters. When I run the query only uses the value of the combobox that GOT THE FOCUS. It is possible to have focus on 3 objects at the time? If not, how can I do force the query to...

Hi experts, I'm trying to read an excel file password protected using the module "Spreadsheet::ParseExcel::Simple". Somebody did this question before but nobody answered It works fine if the excel file is unprotected. But, if it has the option "Protect and Share workbook activated, the script...

Hi experts, I got a form for which I hided the record navigation buttons. However I found that people can move between registers on the form pressing the SCROLL WHEEL of the Mouse. Is there any way of locking this wheel or avoid changes on the form when this wheel is pressed. Thanks. Daniel

Thanks Geoff. When I try to run this code I'm getting this error-msg : "user-defined type not defined" on "Dim objExcelApp As New Excel.Application" Regards, Daniel

Hi experts. Is there a way of running an excel VBA macro from a form of access or have a procedure on access that opens an excel file and then runs the macro. Thanks! Daniel

Hi I'm searching for a code that can take the name of a file, search in different folders and open it. Inputs: Var with name of file and Initial path to start searching. Output: Open file. I will need to look on different folders and subfolders for the file. Thanks.

Hi Is there a way of taking an excel file, change the name and save on an specific folder with VBA. Would be great if I can drag and drop the file to a window in the form and then do all the rename and save process. Thanks Daniel

Hi I'm searching for a code that can take the name of a file, search in different folders and open it. Inputs: Var with name of file and Initial path to start searching. Output: Open file. I will need to look on different folders and subfolders for the file. Thanks.

Hi Do anybody knows a way of taking an excel file, change the name and save on an specific folder with VBA. Would be great if I can drag and drop the file to a window in the form and then do all the rename and save process. Thanks Daniel

Hi. Is there a way of showing an hyperlink on an table as a icon. Thanks. Daniel

Hi. I got a Form "X" that has a lot of comboboxes and texboxes. This form also has a subform "Y" that display a table with the results of a query that depends on the comboboxes and texboxes of Form "X". Now I'm using in the criteria of the query the texts of the...