Recent content by heathlovell

Not yet. I realized I had 6.0 standard instead of Pro. I am waiting on my copy of Pro to arrive. I believe I will either do it with Javascript/ODBC or with VBA. Let me know if you have any luck before I do. Thanks, Heath

Hello, I have a Word document that has about 20 places I need to add information. I have an employee database in Access that contains the 20 pieces of info for each employee. This seems to be too complicated for Mail Merge. How can I go through my database and create a page for each...

Hello, I have used Adobe Acrobat 6.0 Pro to create a .pdf file from a word file. I would like to add fields to this document, but I don't know how to do this. It seems this process has changed since the older Acrobat's. Thanks, Heath

Hello, I have Adobe 6.0 Pro. My document (one page) has about 20 different fields in it. I have a database for all of my employees. I would like to use Adobe to take my employee database from Access and create a document for each employee. I have tried to use import fields from a text...

Hello, I have a report in Access that shows the detail lines and a summary line. The export feature had been working fine up to about a month ago. Then when I export it to Excel, none of the summary lines show up. The data summary feature has always worked on the lefthand side of Excel...

How do I get from the form to the report? I can picture creating a form with two text boxes on them for the dates. Do I just leave the text box open and then run the report? What do I set the source for the report to? Where do I put the criteria? The two tables are related by the equipment...

I have one table that has dates, unit and production minutes Example: 10/1/03, 1 unit, 465 (minutes) 10/1/03, 2 unit, 465 10/2/03, 1 unit, 510 I have another table that has the delays. Example: M1, Electrical, 10 (minutes) M2, Mechanical, 5 I have a query that takes the delay table and only...

Is there any way to get numbers (such as Grand Totals) from macros or VBA? Can I create a a query with VBA in the report to grab certain information? Thanks, Heath

Hello, What is the best way to combine data from different reports? For example, I have a one query/report that sums the production hours for the month for the different production units that we have. I have another query/report that has a detail line for each time a piece of equipment...

We just upgraded to Version 3.71. We are starting to look at the Customizer option. However, I think it creates additional tables for your data rather than letting you add fields to existing tables.

Hello, I would like to add a custom field to my PO2 table. I would also like to add a combo box on the PO screen that is linked to the custom field. I don't have the customizer module. Does anyone know of another way of doing this? Is there a way someone with the customizer could help...

Hello, I have been using Access and Visual Basic 6 for a couple of years but I am new to VBScript and ASP. I want to create a simple web site that lets users type in a date and then displays the records for that date. Does anyone have a website or tutorial that will help get me started...

Hello, I would like to write a macro or VBA module to import a table from an ODBC source. Can anyone help me with this? Thanks, Heath Lovell

Hello, I am trying to write a macro (or VBA) to import three PO tables. Can anyone help me out with this? Thanks, Heath

That will work great. The only problem I have is where to put the macro and the listed code. When I first created the macro, Excel put it in the module for the spreadsheet I was working on. For me to use the macro, I have to have the spreadsheet open. Where do I put the code you listed so...