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

    Copying specific data from one worksheet to another (Excel97/VBA)

    I got it with some help on another Forum... I added the criteria I need to each of these sheets via another part of code. Then this get's run.. Sub FiltertoSheets() Sheets("Adams Pipe").Select Dim ws As Worksheet For Each ws In Worksheets(Array("Adams Pipe", "Adams...
  2. letaylor

    Copying specific data from one worksheet to another (Excel97/VBA)

    Hi everyone, I currently use the autofilter to copy data from my main data worksheet to 6 other worksheets in my workbook based on 2 autofilter criteria. This is done as part of my code in VBA. This doesn't seem like it is the most efficient and fastest way to do this (The code runs really...
  3. letaylor

    A97: Exporting Linked Pictures

    Hello... My A97 DB is comprised of information about Assets. I also have 2 pictures of each asset stored externally and the path stored in the table. I have the pictures showing on reports and forms, but when I try and do something like a snapshot view it doesn't work (actually for the assets...
  4. letaylor

    A97: File Size (Picts)

    Hmm.. I need a little more help: In On Format under the Detail Section I have the following: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Not IsNull(Me!Pict1Path) Then Me!Pict1.Visible = True Me!Pict1.Picture = Me!Pict1Path Else: Me!Pict1.Visible...
  5. letaylor

    A97: File Size (Picts)

    Ahhhh... Now it all makes sense.. As you can tell I haven't used Access in awhile :) -Leslie
  6. letaylor

    A97: File Size (Picts)

    Well I thought everything worked! I'm not sure where to put the code on my report. Mike mentioned 'on format' for the report, but there is no on format.. Am I confused :)
  7. letaylor

    A97: File Size (Picts)

    Thank you everyone.. Mike, that worked like a charm... Thank you -Leslie
  8. letaylor

    A97: File Size (Picts)

    Hi Mike. I like your suggestion, it sounds like something that will work for me. I'm not sure how to start though. Everything I've ever done in Access has always been done just in Access so I am not familiar with how to store the paths and creating an image control. Can you lead me in the...
  9. letaylor

    A97: File Size (Picts)

    Hello, I am creating a db to hold pictures of our property holdings at work. There are 3 pictures for each property. The database with just property info: 336KB The database with 9 pictures (with the picts showing in the form: 90MB The database with 9 pictures (with the picts showing as an...
  10. letaylor

    Popup Message when clicking on Radio Button

    Yeah I did it! Here was my answer: <input type=&quot;radio&quot; name=&quot;radio&quot; value=&quot;radiobutton&quot; onClick = &quot;alert('That is Correct')&quot;> Thanks for sending me in the right direction Caspar... -Leslie
  11. letaylor

    Popup Message when clicking on Radio Button

    I'm looking for an alert box which the user would just close.. If they click True and that is correct a popup message would say &quot;That is correct&quot; If it's false they would get the correct answer... I've been trying to find info on the onclick popup message thing & I even have the...
  12. letaylor

    Popup Message when clicking on Radio Button

    Hi all... I have a page with radio buttons. When a user clicks one of the radio buttons I would like a popup message to appear (this is actually a quiz) Could someone point me in the right direction on how to do this? -Thanks Leslie
  13. letaylor

    Navigate to last opened page..

    Thank you very much Unicorn11..
  14. letaylor

    Navigate to last opened page..

    Hi All... How do I have a back link on my page that will take the user to the last page they had up? This was simple to do in FrontPage but I am just drawing a blank with DW3.. :) Thanks! -Leslie

Part and Inventory Search

Back
Top