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

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.

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

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

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

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

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

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.

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

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

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

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