Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

I use the run command from within VFP to use Word (RUN /N C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\WINWORD.EXE) and I would like to be able to set the default directory that Word uses to open and save files to be the directory name contained within a variable in VFP. For example - I have a...