Search results

  1. I

    Query for Exporting to Excel

    I've been searching for a good solution for this and can't find it. Hopefully something like this is possible. I need to produce a report in excel from my database that needs to include information from 5 different tables. The relationship between two of these tables is a many-to-many...
  2. I

    How to prevent widow records?

    What is the best way to prevent widowed records? By widow record I mean records in the parent table that do not have a related record in the child table. I have a tblOrder that is linked to a tblProductOrder by the OrderID field. I don't want the user to be able to create a record in...
  3. I

    Relationship problem

    I have three tables. tblAgent, tblRep, and tblOffice. I have included a picture to show the current relationships. Normally, an office will be associated with only one Rep. When we start dealing with a new office, a single rep is associated with that office. However, occasionally reps...
  4. I

    Ternary relationship?

    Ok, I have a problem. I am creating a customer database, with the tables tblRep, tblAgent, and tblOffice. Each agent is assigned to one rep and one office. However, each office can have more then one rep and each rep may have more then one office. Now after saying that, in general an office...
  5. I

    Many-to-Many relationship question?

    Here is my problem. I have three tables. tblOrder, tblProduct, and tblOrderDetails. tblOrder and tblProduct have a many-to-many relationship so I created tblOrderDetails that contains both primary keys from the other tables. The primary key in tblOrder is two fields OrderID(autonumber) and...
  6. I

    Two DB's One Table

    I have a real problem here. I am creating an order tracking program for our customer service department. (Note - I am not an expert with access, but am the best we have) However, we have customer service people located in four different cities, all relatively close. They need to share the...
  7. I

    Display picture dependant on date, regardless of year

    I have a report that needs to show a different picture with each seasonal change. One for summer, Spring, etc. Right now I have an IF then statement set up that tests the current date against predefined dates for the Seasonal changes. If Date < #9/21/2004# then blah blah However, I want...
  8. I

    Change column order in pivot chart?

    I have a Pivot chart that displays total sales by quarter. Such as "Jan-Mar", "Apr-Jun", etc. The problem is that the chart puts "Apr-Jun" first because it sorts it alphabetically. I have already searched this forum for help, but everyone seems to reference column headings in a cross-tab...
  9. I

    Problem with divide by zero in linked table?

    I need to display a Price per Square feet calculation on a report. The problem is that, the query that calculates this is based off a linked table that can sometimes contain a zero value in the square feet field. The data can be manipulated if need be (although I didn't think it was possible...
  10. I

    Graph Sales By Quarter

    I need to show a graph on a report, that displays the total number of houses sold during the last year, by quarter. We are using a calander year, so the first quarter would be Jan-March. The field in the table that has the date the house was sold is called DocDate. I'm having problems setting...
  11. I

    problem with Editing a record with a combobox

    I have a form for the user to edit sales rep information. Things like first last name, phone number, and email. Well, I set it up so that the user selects a rep by name in a combobox (I used the combobox wizard to create it) which fills out the rest of the form with the rep's information...
  12. I

    How do I use vbPropercase?

    I have some fields that are in all uppercase, but I want them to show up on my report with only the first letter of each word in uppercase. I have heard that vbPropercase will do this, but can I use this in the expression builder of a query. I tried using StrConv([tblFieldName],vbPropercase)...
  13. I

    importing dbf files

    When I am importing .dbf files into access to create a new table I want to be able to replace old tables with the same name. I can do this when importing an excel file to create a table, but when Importing a .dbf if a table exists with the same name access renames the new table. For example if...
Back
Top Bottom