Search results

  1. R

    Selection box in Subform and assigment in Subform

    Hi! Is there nobody understand my problems or simply my English?? Thanks!!:banghead:
  2. R

    Selection box in Subform and assigment in Subform

    Sinking!! Anyone?? Please!! Thanks a lot!!
  3. R

    Selection box in Subform and assigment in Subform

    I create a form and subform relationship. However, problems arose in subform. Below is the field names of the subform table:- 1. nature (either "Out" or "In") 2. Title (selection query based on result of nature) 3. Plate (either "bright" or "dull") In 2.TITTLE, I had the following statement...
  4. R

    HOW to create a Hexdecimal file using VBA

    I would like to read a TIFfle to ACCESS, and store its content as hexdecimal like below to further other process..., how can I achieve this change and storage?? Thanks a lot!! 0000: 49 49 2A 00 4E 00 00 00 80 3F E0 50 38 24 16 0D 0010: 07 84 42 61 50 B8 64 36 1D 0F 88 44 62 51 38 A4 0020: 56...
  5. R

    How to import JPG format picture size into ACCESS individual input cells

    After a few days investigation, I got some ideas but lacking of concept and technique to find out the resoluation value inside the TIFF file structure. In the previously VBA code, it could read out the TIFF pixal width (tagID 257) and pixal height (tagID 258) but not the file real width and...
  6. R

    How to import JPG format picture size into ACCESS individual input cells

    Sorry! IT WORKS WELL now. I save the file in the wrong location! Thanks!! But the result is still not what I want, I want is the exact length and width of the file but not the dot length and dot width. Both previous and this coding simply give me the dot size but not the exact image size. I have...
  7. R

    How to import JPG format picture size into ACCESS individual input cells

    Story seems not over yet! When I tried TIF format file, the statement also gave me the dimennsion of the file but in fact, it is not the real dimension of the file due to the structure of TIF. Below is another coding I got from the net, and I have run but no result show!! Is there anyone or...
  8. R

    How to import JPG format picture size into ACCESS individual input cells

    Story seems not over yet! When I tried TIF format file, the statement also gave me the dimennsion of the file but in fact, it is not the real dimension of the file due to the structure of TIF. Below is another coding I got from the net, and I have run but no result show!! Is there anyone or...
  9. R

    How to import JPG format picture size into ACCESS individual input cells

    Hi! I finally find out where is the function, and I changed the 31 to 26. It works well now! The T1 finally showed me the demionsion. But I don't see why in my Access 2003 is 26 but not 31!!?? At last, just want to know why you have put the function in module instead in the VBA working place...
  10. R

    How to import JPG format picture size into ACCESS individual input cells

    Before, we were talking about to have a number 31 in the function, but why it is disappeared now!! I have changed to more ease look, and still using your filename. But still nothing appeared in T1 getFileMetadata("c:\","stock-photo-10435961-constructor-worker-with-spirit-level.JPG") .
  11. R

    How to import JPG format picture size into ACCESS individual input cells

    =getFileMetadata("c:\","stock-photo-10435961-constructor-worker-with-spirit-level.JPG") I have changed to more ease look, and still using your filename. But still nothing appeared in T1.
  12. R

    How to import JPG format picture size into ACCESS individual input cells

    Is that when I double click the readsize, figures should appear in T1 box?? If this is the case, it is not working in my ACCESS 2003. Am I missing something?? Thanks!!
  13. R

    How to import JPG format picture size into ACCESS individual input cells

    Sorry! Sir, it won't work in my ACCESS 2003!! :banghead:Am my ACCESS missing something??;)
  14. R

    How to import JPG format picture size into ACCESS individual input cells

    Here comes the DB !! Thanks!! And sorry for I don't know how to reduce the size of my JPG file. Please use any JPG you have with you !! Thanks again!!
  15. R

    How to import JPG format picture size into ACCESS individual input cells

    Sorry! I am working with ACCESS 2003, those so-called vBscript and VBP codes were getting from the internet. They are so smiilar to VBA:banghead:. Anyway, what I got from my initial coding is only wordings such as "Dimenion", "size" etc instead of figures. I don't understand why you can get a...
  16. R

    How to import JPG format picture size into ACCESS individual input cells

    or the following, still getting error 424....... Sub Main() For Each strFileName In objFolder.Items For i = 0 To 34 Console.WriteLine (i & vbTab & arrHeaders(i) & ": " & objFolder.GetDetailsOf(strFileName, i)) Next Next
  17. R

    How to import JPG format picture size into ACCESS individual input cells

    I know what's the problem. I changed 31 to 26, and I got a text instead of a figure. Then I found another code but it gave me a instant error with error code 424. What's wrong with syntax in below statment....Thanks!! For i = 0 To 34 Wscript.Echo i & vbTab & arrHeaders(i) _ & ": " &...
  18. R

    How to import JPG format picture size into ACCESS individual input cells

    I was not before! But I have just added and tested before login. :oThe result of me.T1 is empty!! And I also checked that the CTX is also empty!! I have run through all the statements posted before and nothing has happened. :banghead:Any idea?? :pThanks!!:)
  19. R

    Direct input to a field which is defined source is from a query

    I got a field which is defnined based on a query result to ease the user input. However, some input are not in the query list, if I input data directly to the field, ACCESS complained I must choose item from the query result. Is there any way that the user can either select from query result or...
  20. R

    unique option in combo box

    Sorry! I just want a list of unique description without price for user to select for other purpose!! Thanks!!
Back
Top Bottom