Search results

  1. mresann

    Sunday is a special day... your "four"-warning!

    oof...came back a day late... HOO-RAW CJ London!! And for the record: clng(#April 5, 1991#) 33333
  2. mresann

    Create report of images that need to be resized

    Not really sure what to post. Basically, I want to import monster-sized images into my report, as the images would have to be resized to 9% exactly of their actual dimensions. The problem is that if I pre-downsize the images to the proper size, the quality goes bad, but if I try to import them...
  3. mresann

    Sunday is a special day... your "four"-warning!

    Sunday, September 5, 2021 is a special day for VBA (and VB in general). Something is happening on this day that hasn't happened since April 5, 1991, over 30 years ago. First to figure it out (hint in thread title) gets a big hooraw!
  4. mresann

    Create report of images that need to be resized

    OK, I've manually created the same dimensions for all images, so I don't have to calculate control size for the images. But I have another problem (image quality) which I will have to address in another way, and beyond the scope of the original post. Sorry there is no resolution here, and thanks...
  5. mresann

    Create report of images that need to be resized

    I'm preparing it, but I've gotten word that this may require more than what access is capable of internally. But give me a couple hours. Thanks.
  6. mresann

    Create report of images that need to be resized

    Thanks for the twips info. I have the same information. I apologize about the crossposting, but to be honest, I thought that this was going to be a bit easier than what is turning out to be. I'll have to farm this out to someone to create. Many thanks to all who tried to help.
  7. mresann

    Create report of images that need to be resized

    :) Thanks for the help. Without the extra details, let me simplify the process to bare facts: 1. Create a report of images with information derived from query. 2. All images in query correspond to an image in a folder. 3. All the images in the folder are high-resolution. 4. Report code should...
  8. mresann

    Create report of images that need to be resized

    Exactly. I have to dynamically create the image (control) size that corresponds to the size in the Target width/height fields according to the image record. I cannot just use a "zoom" or other image method as these are crossword-like puzzles, and don't want different sizes of squares that would...
  9. mresann

    Create report of images that need to be resized

    I have a folder of 366 high resolution images that I want to put on a report, of which there are 366 records in my report source query that correspond to each one of those images. The images are similar to crossword puzzles, to be honest, but they are of differing sizes (seven different sizes as...
  10. mresann

    Create report of images that need to be resized

    This is a problem I've been wrangling with for over two weeks. I have very high resolution images that I need to import into a Microsoft Access Report. The dataset (query) source for the report contains the following information: Field Datatype Description ImageID Text Unique ID...
  11. mresann

    Move Item in Listbox Function

    Fair enough. In fact, the module was created with the idea that others can follow the logic of the code and how it integrates with what they can accomplish in their own projects, which is why it is heavily commented as well. In more commercially distributed applications, I always break down my...
  12. mresann

    Move Item in Listbox Function

    A common occurrence in working with Access interface forms is to be able to move a Listbox item up or down a list, sometimes to the top or bottom of the list. The programming for such a relatively benign function is involved. The Listbox must use a Row Source Type of Value/List with delimiters...
  13. mresann

    About UpperCase

    You are probably right. I am only used to the English alphabet, which is but a subset of the entire Latin script that comprises the characters of languages originating from Western Europe, along with the Cyrillic script of eastern Europe.A very comprehensive summary on Wikipedia for the Latin...
  14. mresann

    About UpperCase

    Yo, peeps. Am I missing something? How about using the StrConv function? Specifically, strExample = StrConv("ÿ",vbUpperCase) ...would assign "Ÿ" to strExample This function can do a whole slew of conversions, including upper case, lower case, and proper case characters for the entire unicode...
  15. mresann

    Is there a cleaner way to repeat this code?

    Note: The original answer is "no." Each control must be programmed with code to call the function, or process the statement, on its own DoubleClick event. As other posters have mentioned, the code itself can be simplified and accessed through its own subroutine, but each control has to be...
  16. mresann

    Obtain positions of text character string from text block

    This is a simple but handy function that allows you to obtain the positions of characters within a text block. Say you have a line of text, or block of text, as follows: An apple a day keeps the doctor away. Now you would like to find the all the character positions of the letter “a” within...
  17. mresann

    Dlookup Type Mismatch Error

    You may wish to put "Solved" in the title as well.
  18. mresann

    Refresh listbox in database 1 on the close event of database 2

    Insert this statement at the end of the procedure that closes the external database. DoEvents Me.Listbox_Name.Requery ...where Listbox_Name is the name of our listbox control. NOTE: If you have other calculations on the form, you may wish to precede the listbox query statement with a form...
  19. mresann

    Extract Text from Text Block

    In many cases, I’ve had the need to extract text from text blocks, such as HTML source pages, in a quick but highly comprehensive manner. The text is identified by providing the string for the text immediately to the left of the desired text, as well as providing the string for the text...
  20. mresann

    number to ordinal list (1st, 2nd, 3rd...)

    Here is a much simpler one-line code (wrapped for clarity). The variable "lngNumber" is any whole number. The Switch function works somewhat like Select Case function, in which expressions are evaluated in order, the first one that produces a True statement (or non-zero result) provides for the...
Top Bottom