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!

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

Recent content by ajorge

  1. ajorge

    changing a selection of an images color.

    Select the Bird with any of the selection methods you feel comfortable with. Then go to Image>Adjustments>Replace Color. Use the defualt dropper to select the color, if it doesn't select all the tones then use the Dropper with the plus sign to select the rest. Once the bird shows up highlighted...
  2. ajorge

    Help Exporting data to Excel

    I have a query that gives me the sum of five fields. I need to export that information to an excel sheet. I already the excel sheet set up to generate a Pie chart wiht the data. I just need to populate the fields. Can some please help. Thank you in advance Alexander Jorge City of Miami...
  3. ajorge

    Form resizes on other computers

    Where can I find an api to do your suggestion number 3 Alexander Jorge City of Miami Information System Analyst [pc]
  4. ajorge

    Linked Photo Images

    I had the same issue, and the only way to solve it was do a report with image frame and in the detail_Format section use the following code Me!Image1.Picture = "path of the image" & Me![indentfier for each image] & ".bmp" or if the image is a jpeg use ".jpg" i...
  5. ajorge

    Linked Photo Images

    There is a way to do it, but let me ask you are the images in a seperate folder and then linked in the database? Alexander Jorge City of Miami Information System Analyst [pc]
  6. ajorge

    Adjusting the Monitor settings with code

    Thank you for the idea. Alexander Jorge City of Miami Information System Analyst [pc]
  7. ajorge

    Adjusting the Monitor settings with code

    I have a database that is shared by 10 users each user has a different setting on their monitors is there a way to adjust the setting with code so when they login they all see the same screen sie and when the log out the screen goes back to there normal settings. Alexander Jorge City of Miami...
  8. ajorge

    Access - Virtual memory loss when trying to print images

    When you say you get 300, do mean 300 images or pages Alexander Jorge City of Miami Information System Analyst [pc]
  9. ajorge

    Problem with Form and Subform

    I have a subform called "HOME Building Subfrom" in this form I have a command button that prints a report based on the current record and when I Veiw the form by itself it works perfect. When the form is open with the main form the print report function doesn't work. The code I...
  10. ajorge

    MS Form...Picture Thumbnail

    Hi there, One thing you could try is on the picture's OnDblClick enter this code Dim stAppName As String stAppName = " ENTER IN HERE THE PATH TO THE EXE FILE " Call Shell(stAppName, 1) Good Luck Alexander Jorge City of Miami Information System Analyst [pc2]
  11. ajorge

    Input Box

    I had the same situation and I resolved it with this code. Dim rst As New Recordset Dim strSQL As String Dim cnn As Connection Dim Year As Integer Set cnn = CurrentProject.Connection Year = InputBox("Please Enter the Year.", "Approved Projects", 0) '****** Approved...
  12. ajorge

    Blank form

    I have a form that displays information according to the year that the user enters, the recordsource is a query and ask the user first to input the year. If the year is available the form displays the fields and if the year is not in the records then the form comes up blank. What i want to...
  13. ajorge

    Lost Authentication Certificate

    Have you tried in the web at the Microsoft Online Assisted Support the site is http://www.microsoft.com/products/works/homepages/TechnicalSupport.asp#. Microsoft indicates that it is free and it deals with Works and all of there products.
  14. ajorge

    Form Filter

    Everything looks right except the fact that workyear is a global var. and is not display in any records its only stored until the year is change again
  15. ajorge

    Form Filter

    This is the code I have. Report year is the year that was assigned to each record the user enters. workyear is the global var. that is assigned once the use enters the year Private Sub Form_Filter(Cancel As Integer, FilterType As Integer) [Setup Master]![Report Year] = [WorkYear] End Sub

Part and Inventory Search

Back
Top