Recent content by rdeanh

  1. R

    details section won't split into 2 pages

    I have a form that records memos,along with customer information, and a report that prints them. I have the memo section on my report as one line that can grow. The problem is that if I have more than a page worth of memo, it prints two pages. The first page only has the customer...
  2. R

    starting autonumber on 1000 instead of 0

    I would like to make my autonumber start at 1000. Does anyone know how to do this? I already have 0-5 in the system and would like to change them to 1000-1005 while I'm at it. Is this possible? Rocky H
  3. R

    troubles updating records

    I have a form that stores memos and a button that tells it to preview a report of the memo. The problem is that if I change anything after previewing it, I have to exit the form and go back in to get the report preview to show what I just added. I also have a similar problem when I try to add...
  4. R

    compile error: expected end of statement

    I have a code for a pop-up box that appears when a product is not in the list allowing you to add a product and requery. I can't seem to get it to work. Here it is: Private Sub ProductID_NotInList(NewData As String, Response As Integer) Private Sub ProductID_NotInList(NewData As String...
  5. R

    Calculating subform on a form

    Please help. I am going crazy. All I want to do is make my form(Orders) display the order total from the subform (Order Details) that is linked to it. I can get the subform to show the total but not the form. The subform control has the following control source...
  6. R

    tables with more than one primary key

    Could anyone help me? Within each order I have order details. Is there any way to start each order off with a new order detail 1 (i.e. order 1, ord det 1-5; order 2, ord det 1-7; etc.). Obviously, autonumber cannot be applied. Both the order and order detail are primary keys in the same...
  7. R

    editing a calculated field

    I have an order detail line that pulls manufacturer's item prices from a table and I type in the number of items for it to be multiplied by. It then gives me a total in the "total" field. The problem is that once in a while I need to change the total of a particular item but when I select the...
  8. R

    selecting next record and repeating data

    I am trying to (1)print current screen, (2) select next record, (3) copy and paste customer ID and Reference number from the former screen. I figured out how to do the first two things but can't do the third.
See more
Back
Top Bottom