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

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

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

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

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

Hi. I need to write in the body of an email. This is the code I'm using: Function SendEmail() Dim email, Subject, Body As String Dim APREJ As Variant STATUS = Me.FrameToggle.Value email = Me.Market_Label & "Distribution List" Subject = "Datafill for sites:" & "Name...

I got a Form with many comboboxes and textboxes that update a table. Every time I run a command such as Refresh or Recalc (to update comboboxes for next use),exit form, or go to a different form, all the information that was in the textboxes and comboboxes goes to my table. How can I stop the...

Hi everybody I got a table refer as a RECORDSET (Name: Log). I need that when a user puts in a Textbox a number (ID), it will go to the record in "Log" (table) with that ID.

Hi Lets say that I select a "Text" from a combo box (form1), then I use that text to filter a field on a Query (only one line will result). How can I do to show the value of one of the fields of the resulted query on a textbox(form1) Also I need to show on a textbox a concatenation...

How can I add a new record in a Table using VBA. I Tried with this code, it seems to work because in the msgbox I can see the 1234 value. The problem is that when I open the table the chage is not save. Do I need to save the record at the end. How do I do that? Thank!! Private Sub...

I need to do a VBA code for navigate into a table an edit some of the info. I'm using the recordset funtion but is not working. I'm starting by creating the VAR Dim rst As DAO.Recordset but every time a run the code i got a Compile error in that line "user-defined type not...