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!

Register Log in
  • Congratulations Chriss Miller 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. dobber

    Excel to PDF - Hyperlink Problems

    We have an Excel worksheet (running Office 2003 Pro) for which we have written VBA (Excel) code, placed behind a button on the worksheet. When the button is clicked, the Excel worksheet is converted to a PDF file. This works fine, except the hyperlinks (links to other PDF files, Word docs...
  2. dobber

    Excel to PDF - Hyperlink Problems

    We have an excel worksheet (running Office 2003 Pro) for which we have written VBA (Excel) code, placed behind a button on the worksheet. When the button is clicked, the Excel worksheet is converted into a PDF file. This works fine, except the hyperlinks (links to other PDF files, Word docs...
  3. dobber

    MailMerge fails - MDE File Locked

    I have a mailmerge that works perfectly well with an MDB file named WOW.mdb, but if I try to run it using an MDE (of the same database - WOW.mde), it fails. At first the problem involved another instance of Access being called up. I solved this by using some code I found to set the...
  4. dobber

    Mailmerge - locked MDE file

    I have a mailmerge that works perfectly well with an MDB file named WOW.mdb, but if I try to run it using an MDE (of the same database - WOW.mde), it fails. At first the problem involved another instance of Access being called up. I solved this by using some code I found to set the...
  5. dobber

    Help - Mailmerge failure with MDE file

    I have a mailmerge that works perfectly well with an MDB file named WOW.mdb, but if I try to run it using an MDE (of the same database - WOW.mde), it fails. At first the problem involved another instance of Access being called up. I solved this by using some code I found to set the...
  6. dobber

    How can I automate future code updates?

    Our organization has an Access 2000 Database named "Audit" containing numerous forms, queries, reports, etc. We also have a database named "AuditData" that houses data only (containing tables linked to "Audit"). These databases reside on about 40 separate laptop...
  7. dobber

    Enable and Disable Text Box

    Thanks for the great responses. I was able to both solve my problem and gain some better ideas for designing forms in the future. I really appreciate it.
  8. dobber

    Enable and Disable Text Box

    I have fourteen text boxes on a form named "txtBox1", "txtBox2", "txtBox3", etc. I have another text box named "txtNumColumnsNeeded" into which the user types a number (1 to 14). Depending on what number is typed into "txtNumColumnsNeeded", I...
  9. dobber

    Excel cell linked to Access table record

    I have an Access table containing one record and one field named "color". The data in this field (green, blue, etc.) changes with input from an Access form. I also have an Excel spreadsheet where I want the "color" data from the table to be linked to cell A1, so that when...
  10. dobber

    Simple Question - Link Excel Cell to Access field

    I have an Access table containing one record and one field named "color". The data in this field (green, blue, etc.) changes with input from an Access form. I also have an Excel spreadsheet where I want the "color" data from the table to be linked, so that when the...
  11. dobber

    Possible to Display Report Output in a TextBox?

    Please help - I know someone else also asked this question a few days ago, but they didn't get a response. Since, I also need a solution for this - I'm asking the same question myself this time. I have a form that picks random samples to be used to review financial documents. The user inputs...
  12. dobber

    Determine Number of Saturdays in a Given Year?

    Thanks to both Michael & Ronnie, both pieces of code worked well and did exactly what I needed. However, I refuse to disclose which one I actually used in my project. I really do appreciate all the help. I'm relatively new to Access, having been a Visual Foxpro programmer. Its going to take...
  13. dobber

    Determine Number of Saturdays in a Given Year?

    Thanks Lonnie, That worked great. Just what I needed. I had struggled a while on the problem, but could not come up with a solution that seemed simple enough (I don't like very complex code to accomplish a (seemingly) simple task). I appreciate you help...
  14. dobber

    Determine Number of Saturdays in a Given Year?

    Does anyone know of an Access procedure/function to determine the number of Saturdays in any given year (the years could include Leap Years)? Thanks in Advance for all reponses..
  15. dobber

    Determine if Access Table is Empty (no Records)

    Thanks Terry, That's exactly what I needed. I'm fairly new at Access and I wasn't even aware of dcount.
  16. dobber

    Determine if Access Table is Empty (no Records)

    Help, Help Does anyone know of a procedure for Access 2000 that will look at a table, determine if it is empty (contains no records), and then return a True/False? I've tried everthing I can think of, and I'm stuck on this code for the day.
  17. dobber

    Linking Word to a VFP Database Field

    No I use a VFP Form for all data input. I'm only trying to get Word to link to the database and display the ever-changing sales total from the field. This way I can have a proforma Word document created that will say something like "as of November 1, 2000, our year-to-date sales total is...
  18. dobber

    Linking Word to a VFP Database Field

    I have a VFP Database named 2000SALES.DBF. It only contains one field named TOT_SALES. I would like to create a Word Document (Office 2000) named SALES.DOC that will be linked to the field TOT_SALES, so that each time I open up SALES.DOC it will automatically update the link and show the...
  19. dobber

    Help Running Word from VFP

    To Robje: I work for an organization that provides audit services for companies at their place of business. I am trying to develop a sytem for the auditors that will use VFP for the front end (menus, etc) and to store database type data. It will call up Word and allow the user to retrieve...
  20. dobber

    Help Running Word from VFP

    I'm running Word from VFP and I am attempting to change the default directory the users will retrieve and create Word documents in to be C:\AUDITS. I'm using the following code, but I keep getting an error (OLE error code 0x80020006:unknown name). Does anyone know what's wrong or a better way...

Part and Inventory Search

Back
Top