Search results

  1. B

    PDF and VBA Code Help

    Solved I have a text field called "jumpto" which allows user to enter a page number to go to. I attached the following code to a Button Click event... Here it is: Dim AcroApp As CAcroApp Dim AVDoc As CAcroAVDoc Dim PDDoc As CAcroPDDoc Dim mypath As String Dim mystring As...
  2. B

    PDF and VBA Code Help

    Hi All, I have a code which uses the Adobe OLE. It works great, but I want to know how to open the PDF to a page number using the "gotopage". Any one know how to do this? Private Sub Command5_Click() 'Dim avCodeFile As CAcroAVDoc Set Acroapp = CreateObject("AcroExch.App") Acroapp.Show Set...
  3. B

    instantiated a control???

    I am looking to open the PDF in a form and pull up a certian page.... Someone help!!!!
  4. B

    instantiated a control???

    Hi all, I am tring to view a PDF from inside a form using XpdfViewer. It tells me to do the following: "The following Visual Basic examples assume that you have instantiated an XpdfViewer control, and named it “viewer" How do I instantiated a control??? I am clueless Thanks
  5. B

    How to add VBA to a form field

    Sweet Code...Thanks!
  6. B

    Using a Form to Populate a Query

    This should help you get started..... http://www.access-programmers.co.uk/forums/showthread.php?t=100246&highlight=search bones
  7. B

    link record to pdf bookmark

    Hi All, I've search hi and low and can't find answer. Is there a way to link a record to pdf bookmark, then open the pdf to that bookmark? Thanks Bones
  8. B

    To Replica or Not to Replica

    Thanks Again, I'll do some research tonight. That might be the way to go. Bones
  9. B

    To Replica or Not to Replica

    Thanks, My thoughts are that he was given bad information. I did some research last night on the subject. I will back the DB often. I need to search the forums to see how I can import the tables for back up with a click of the button using VB. What do you think? Bones
  10. B

    OpenFile Help

    Thanks ghudson, I think I am getting the hang of VB. This is a great site and with out it I couldn't have built my database. Thanks to you and everyone thats been helpful! Bones
  11. B

    How to search my entire database

    try this Someone posted this a while back. Its probably the best search tool for access I've seen. All the people who use my database love the way it narrows down the records during every key stroke. Whom ever built it deserves the credit. Bones
  12. B

    To Replica or Not to Replica

    The Master is on the server in another folder. I asked him why he was using a replica and he said because many people needed to access it over the network.
  13. B

    To Replica or Not to Replica

    Thanks for the input. The data exchange is not that heavy so loosing a day or two will not have an impact. Our exsisting database, that is a replica is a lot of maintenance.
  14. B

    To Replica or Not to Replica

    Hi All, With the help of many people on this forum, my database is coming along well (Thank you!). My DB will end up on a server where it will be accessed. My question is; should I use the replica function, or back up the file every day or so. The database I am replacing has been a replica...
  15. B

    Help with User Defined not defined

    Thanks...That explains things
  16. B

    Help with User Defined not defined

    I ran the Demo on Access 2003 and it works fine, but I get the same error on Access 2000. Any thoughts?
  17. B

    Help with User Defined not defined

    I am running the code on Access 2000. When I ran it on my work computer (access 2003) it works fine. Is this a short fall of Access 2000? I'll take a look at the Demo you attached. Thanks
  18. B

    Help with User Defined not defined

    Hi Everyone, I am trying to load all my printers into a combo box and I keep getting the error "User-Defined type not Defined". Does anyone know the Reference library for "Dim PRT as Printer"? Private Sub Command2_Click() Dim prt As printer For Each prt In Application.Printers...
  19. B

    OpenFile Help

    Answer! In case anyone was interested, here is the solution: Private Sub bOpenFile_Click() On Error GoTo Err_bOpen_Click Dim PT As String Me.tbHidden.SetFocus If IsNull(tbFile) Or tbFile = "" Then MsgBox "Please browse and select a valid file to open.", vbCritical, "Invalid...
  20. B

    OpenFile Help

    Hi Everyone, I have a code to open a file. The Code gets the file name from a field called "tbFile". The users that need to access this file and open it are on a server and have mapped their drives with different letters. So I want the Code to be used from anyones computer. How do I...
Back
Top Bottom