Search results

  1. I

    Many-to-Many relationship question?

    Thanks for the response. The reason that i had to use the AgentID in the primary key is that this program will be used in four different offices. In four different cities. And i can't have them all share the same database because speed is such a factor. So i put in AgentID into the primary...
  2. 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...
  3. I

    Two DB's One Table

    Ok, I didn't get any reponses, but I'm going to try again. I know someone out there knows how to do this type of thing. Maybe if I make my question clearer. I've been working on the problem I stated in the first post. And what I have now is four DB's on servers located in four cities. All...
  4. 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...
  5. I

    Display picture dependant on date, regardless of year

    Nevermind, Got it to work. Thanks for the help PDX MAN.
  6. I

    Display picture dependant on date, regardless of year

    How would you do a conditional test with this type of format? Can you give me an example? And i'm in Seattle. Not that it matters, but I just noticed you are from Portland.
  7. I

    Display picture dependant on date, regardless of year

    Thanks, I was hoping to use both the day and the month to get this as accurate as possible, but I'm having a hell of a time getting that to work, so maybe i will just use the month. Thanks for the help.
  8. I

    Display picture dependant on date, regardless of year

    Thanks for the response, but I have already looked in access help and couldn't find a solution to this problem. Any more suggestions anyone?
  9. 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...
  10. 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...
  11. I

    Problem with divide by zero in linked table?

    I should mention that the subreport is based on a query that queries the first query you helped me on. Sorry was that confusing. And this other query is the one that is now having the overflow problem.
  12. I

    Problem with divide by zero in linked table?

    The query is working now, but i'm getting an overflow error when I try and open the report. You wouldn't happen to have an idea on that would you. Thanks again.
  13. I

    Problem with divide by zero in linked table?

    That should work. WOW i was really trying to do it the hard way. I'll give it a try and let you know. THanks for the help.
  14. I

    Problem with divide by zero in linked table?

    Do you mean inside the Do until loop? Basically I need to check every record in the table, to make sure that the square feet field is not zero, and if it is change it to "" so that it won't blow up the query. I just don't know the code that would accomplish this. And where to put it. Here is...
  15. 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...
  16. I

    Graph Sales By Quarter

    Thanks, for the help, i only had to modify it a little for it to work perfectly.
  17. 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...
  18. I

    problem with Editing a record with a combobox

    Thanks again for the responses. But I have already tried to make the RepId the bound column for the combobox, but it then stopped updating the rest of the form. I created the combobox with the wizard, and don't exactly know what causes it to update the rest of the form. When I go into the row...
  19. I

    problem with Editing a record with a combobox

    I already have an autonumber field used as the Primary Key in the table. But what is going on is, I want to fill out the form for editing using a combobox. The combobox uses a field that I created in a query that displays the firstname and lastname fields as one. The problem is that the...
  20. 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...
Back
Top Bottom