Search results

  1. C

    Form Template with Pre-Filled Set of Values

    One of the managers has requested to set up a form to enter the date at the top of the form and then enter in data for all the plants below for that day. I thought I could just use a form/subform combo with the date (and any other information repeated to all the plants), but the catch is, he...
  2. C

    Access 2007 Computers Lock Up on Split Database

    We use an Access database to issue purchase orders. I split the tables into a separate database that is on a shared network drive as well as individual databases for each user which contains the Forms and Queries (also on the network). We have had no problems with multiple users being in the...
  3. C

    Email Macro ActiveWorkbook.SendMail

    I'm using the following macro on a button on a spreadsheet to mail the workbook to multiple people: ActiveWorkbook.SendMail Recipients:=Array("user1@isp.com", "user2@isp.com", "user3@isp.com") Subject:="Production Report", ReturnReceipt:=False I have about 19 address in the Array() part...
  4. C

    Rounding Dollar Amounts

    Hello Everyone, I'm using the following on a form in my database: =(-Int(-Sum((IIf([LineTaxExempt]=Yes,(([Qty]*[Price])+([ShippingHandling])), ((([Qty]*[Price])+[ShippingHandling])*1.06))*100))))/100 In this case, I want to calculate a total for an order. If the LineTaxExempt field is...
  5. C

    Excel Macro to Open and Print Other Spreadsheets

    Hello Everyone, I have a spreadsheet that containts 2 columns-Part Number and Drawing Location. The sheet looks something like this: ---A------------------------B------------------------- Part#-----------Drawing Location Part 1----------c:\drawings\part1.xls Part...
  6. C

    Print Hyperlink Contents

    I have a table with a hyperlink field pointing to an Excel file that I would like to automatically print out on a report form. For example, I have a table: Part--------Drawing(hyperlink field) ---------------------------------------------------------------------------*------------...
  7. C

    Report Help: Reading Records From Same Field

    Hello Everyone, Let me explain my problem. I have included 2 dashes between each pair of records to make it easier to see what goes together. In reality, it is just a long list of results from my query. Contract--------QTY--------COMPONENT--------LENGTH-------PCS 11111111 2...
  8. C

    Check Off Items in Form

    Hello, I have a form that users type in a part number and a due date. I then run a report that prints the part number, the components needed and the processes needed. For example: ------User Form------- Part 1 6/25/05 Part 2 6/28/05 Part 3 7/1/05 ---------Report--------...
  9. C

    Subreport Page Breaks?

    Is it possible to do page breaks in a subreport?--I want to have a report that prints page 1 of the main report followed by multiple subreport pages, followed by page 2 of the main report and so on. I want a page break on the main form before the subreport so it starts on page 2, and then...
  10. C

    Wildcards in OLE Linked Object File Name

    Hello Everyone, I have a field set up in a table that is an OLE object with a link to an external Excel spreadsheet. My question is whether you can use a file path that contains wildcards. Each Excel file has a filename something like this: Company Name Part Number Revision 05-31-05.xls Is...
  11. C

    Report With Multiple Image Pages Following Each Group

    I have a report that shows all the parts used in the previous week. It looks something like this: ------------------------------------ Part Group AAA Part Number QTY ------------ ----- Part 1 23 Part 2 35 Part 3 48 Part 4 16...
  12. C

    Fields Containing Drawings

    I have a table of parts that I would like to add a field for drawings. These drawings are image files that are on different tabs in an Excel Workbook--1 image/drawing per worksheet/tab. Most of the Excel workbooks have 2 tabs. I need to print these drawings in a report. I added an OLE...
  13. C

    Beginner Needs Help With Setting Up Part Tables

    Hello everyone. I'm pretty new to access and need some advice on table structure for a new project I've been given. One of our customers sends us an Excel spreadsheet each week containing their order. Currently, someone formats the spreadsheet, prints it out, and manually picks out the...
  14. C

    Need Help Adjusting Counting Query

    Hello Everyone, I need some help adjusting this query: Expr1: (SELECT Count(A.ID) FROM Label_Info AS A WHERE A.HW_Number = Label_Info.HW_Number And A.ID <= Label_Info.ID)-(SELECT Count(Nz(A.Packed_With)) FROM Label_Info AS A WHERE A.HW_Number = Label_Info.HW_Number And A.ID <= Label_Info.ID...
  15. C

    Print Summary of a Field

    Hello Everyone, I have a table that has a field called Contract_Number. I would like to print a list of unique Contract Numbers. Several of the records might have the same contract number. For example: Part Contract Number 1 111111 2...
  16. C

    Counting Up Until Number Changes-With New Condition

    I appreciate the help on this board. I want to assign a number to each record that will be part of a shipping number. I want the number value to count up until the contract number changes. Then, I want the number to go back to 1 and start counting up again until the next contract change...
  17. C

    Print Multiple Reports in a Certain order?

    Hello, I have a form which contains the shipment destination information and the ship date of our company shipments. I have a subform set up which contains all the boxes in that shipment. I have a "Print Labels" button on the subform that sends the appropriate box information on the subform...
  18. C

    Counting Up Until Field Value Changes?

    Hello, I want to assign a number to each record that will be part of a shipping number. I want the number value to count up until the contract number changes. Then, I want the number to go back to 1 and start counting up again until the next contract change. For example Contract 1111111 Box...
Back
Top Bottom