Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. danvzla

    Help with 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 ...
  2. danvzla

    Email problem using Access VBA (Outlook)

    Hi all I already post this Q on a different thread but because theinitial subjet was for a different task I've not got an answer. This code works, but it only send the msg when Outlook is open. How can I do to send it still if outlook is close? Is there a way of knowing if outlook is...
  3. danvzla

    Problem with SendObject Funtion.

    Hi. Thanks. It looks like the problem is that I'm usinf Win2000. After 200 Char is starting to fail (no msg). So I change my code to shown below.. But it only send the msg when Outlook is open. How can I do to send it still if outlook is close. Dim objOutlook As Outlook.Application Dim...
  4. danvzla

    Problem with SendObject Funtion.

    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/...
  5. danvzla

    Count elements on query

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

    Count elements on query

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

    Combobox + Focus + Query

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

    Combobox + Focus + Query

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

    Combobox + Focus + Query

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

    Combobox + Focus + Query

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

    Reading Excel file protected

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

    Disable Scroll Wheel from mouse

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

    Run excel macro from access.

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

    Run excel macro from access.

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

    Search File

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

    Rename and save file

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

    Search and open a file

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

    Rename an save file with VBA

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

    Icon for Hyperlink

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

    Query (SQL) with VBA

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

Part and Inventory Search

Back
Top