Search results for query: *

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

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

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

Hello, I have been using Access for a couple of years but I am new to 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? Thanks, Heath

Hello, I have been using Worksheet.cells(1,2).value in Excel to cycle through data using a For statement. This works great other than there are certain cells that I want to put a Sum (=Sum(a1:a4)) statement in. I can't figure out a way to do this using just the index values for the row...

Hello, I am new with Crystal Reports. I wanted to make the detail lines on the check stub bigger. After making the text bigger, I can't fit as many line items on the check stub. This is only a problem when all the detail lines don't show up and Crystal doesn't show the text...

Hello, I have two tables with at most 700 records. I have a one - to - many relationship between the tables. Basically, one table is Purchase Order information and the other contains the line items for the Purchase Order with the Purchase Order number being the relationship between the...

Does anyone know the file name of the Purchase Order Recap Report? thanks, Heath

Hello, I am trying to customize a PO report. I can find info on modifing checks and other reports. (Thanks for the help on modifying Purchase Orders.) I would like to have a summary report that shows what was ordered and what accounts they go to. I would also like to be able to use...

Hello, I have used Crystal Reports to display the account number on the Purchase orders. I would like to also add the account description. The account description is not in any of the tables MAS 90 use for the purchase order. I guess I need to write a SQL statement to look up the...

Hello, I have tried to create an expression in a query to look up how much time each employee has taken for vacation using a Dsum. I can't get the criteria section to work. I need the employeeID for each record in the query to match employeeID in the attendance table, but I don't know how...

Hello, I have report that lists employee vacation hours and their pay rate. I created a field ("Text19) on each line that takes the two fields and multiplies them together. This works fine. I am trying to sum this field over the whole report. I have tried =sum([Text19]) but when I...

Hello, I have created a wage report that groups attendence records based on employeeID (autonumber). (I did this since I have several employees with the same last name.) Everything works other than I would like to sort the groups based on the lastname field rather than the employeeID...

Hello, There are two tables involved, employee and attendance. The employee table has an employee number (autonumber), lastname, firstname, etc. The attendance table has employee number, date, and hours worked. I have a report that lists absences for each employee. There is a...