Search results

  1. S

    Using 2000 can I do this without VB knowledge?

    :confused:I have created a small DB to keep track of meetings. Main Form customer Sub form meetings with customer At the end of each meeting I make notes on the sub form and enter an agreed date for next meeting. Q 1. I would like the sub form to open at new record, or last record and with...
  2. S

    goto last record

    :confused: Have not worked with access for a long time am trying to update an oldie. Main form has a sub form. With each new service to customer I select next on the sub forms navigation button. 1 customer might have 6 records on his sub form and another might only have 2. Problem is that when...
  3. S

    mail merge addressee tangle

    Hi, I have an access table with 3 different types of addressees. 1. Couples with same LastName 2. Couples with different LastNames 3. Individuals. I'm trying to use mail merge. But it can't differentiate between the 3 different varieties what I would like is: 1. Anna & Jay WHITE - This...
  4. S

    Access Mail merge and SMS Text

    How would I go about using mail merge from a query in access? I am doing a simple database for a group with several hundred members that keep contact via post. Letters and recipients will change depending on situation but mainly there are 3 groups of members, but letter content varies...
  5. S

    Single entry for two tables?

    I have a table containing info that I would like to access thru a PDA. Problem is when reading data the PDA can only screen the first column e.g. FieldID only shows the number not the details from the lookup, unless you tab and that gets messy on a small screen. Can I create a second table...
  6. S

    Opening Cash Register Draw

    I am writing a very simple access database for a retailer friend. Currently it is a stand alone pc next to a cash register. I need to be able to open the Cash Register when a sale is finalized. Can anyone help? Firstly is this possible for all CR or only some? I need to know how/what is the...
  7. S

    total for groupings?

    My report has several groupings Field1, Field2 etc. I am trying to get a total on the major groups. feks: need a total for New or Chair. All my totals = 5. New_____Chair_____Green __________________Blue ________Table _____Green __________________Blue Old_____Chair______Grey Help? :confused:
  8. S

    Half Report headings + Count woes!!

    Q1 I have a report where there are 40 check box results. I only need the totals. I can't find a way to put the first lot(20) of field headings on the top half of the report and the next lot(the remaining 20) on the bottom half. Report only has a total of 10 lines down, but is 2 landscape pages...
Back
Top Bottom