Recent content by bfdeal31

  1. B

    Book DB Entry Form--multiple author entry

    Book DB Entry Form--multiple author entry? Hi, I am working on a database to keep track of books and their authors. It has the following tables and fields: [tblBook--BookID, Title, Subtitle, Edited, Year Published, Location Published, PublisherID, Category, ISBN, Notes]...
  2. B

    Book Database: Books with multiple authors? Advice?

    Setting up the book entry query/form?? Hi again, I took the advice I was given and reworked my database. It now has the following tables and fields: [tblBook--BookID, Title, Subtitle, Edited, Year Published, Location Published, PublisherID, Category, ISBN, Notes], [tblLinkBookAuthor--AuthorID...
  3. B

    Book Database: Books with multiple authors? Advice?

    Thank you and question on posting to web? Hi Graham and Tess, Thank you very much for your help. This Access Forum has been a great resource. It ended up being a real life saver with an internship I had last year where I had to design a billing/collections invoice database and had trouble...
  4. B

    Book Database: Books with multiple authors? Advice?

    Hi, I have a question that will probably be fairly simple to answer. I am working on a database to keep track of books and created a simple database that primarily consists of one table "TblBook" which contains the following fields: ID (autonumber), Title, Subtitle, Last Name, First Name, Year...
  5. B

    Parameter query

    that makes sense, thanks. Thanks for replying. What you said makes sense. I played around with what I was trying to do and now I have something that I'm happy with. Thanks.
  6. B

    Parameter query

    Open Selection Form Automatically?? Hi, I had a question similar to the one asked under this topic and successfully duplicated the suggested actions. However, I was wondering if it would be possible to have the form (used for selecting the city) open automatically when the query is run? That...
  7. B

    All Dates as Month/year [not just format]

    second date for range Thanks everyone, for trying to help me. Raskew, what you suggested is closest to what I need to do, and would probably work the best for my particular situation. However, how would I modify that code so that the user enters in two dates? I'm trying to get a range, and...
  8. B

    User selected date range appear on report?

    thanks. That worked great and was what I was trying to do. Thanks for your help. -Steve
  9. B

    All Dates as Month/year [not just format]

    Hi, I didn't see this question answered/asked anywhere else and I'm not sure if this will make sense or not, but how can I get all of the dates in my database to all be the first of whatever month and year the date is for. (ie. if the date is 7/18/02 how do I automatically have it exist as...
  10. B

    User selected date range appear on report?

    thanks, but... Thanks but I believe what I am trying to do is a little different. Originally I did have a copy of the date from the detail area in the header but it's not exactly what I want. What I have is one date field in my table, the date of an invoice. In the query design under the...
  11. B

    User selected date range appear on report?

    Hello, I have several reports based on queries that ask the user to input dates for a time range. My queries have the following criteria for the date column: Between [Enter a Beginning Date: ] And [Enter and Ending Date: ] How would I make the report show what data range the info is for? I...
  12. B

    New tables/queries/forms etc. based on existing format?

    Thanks. Shane, I took your advice and made a seperate company table and related it to my existing tables through a one-to-many relationship and it works great. Thanks for your advice. Steve
  13. B

    New tables/queries/forms etc. based on existing format?

    Shane, Thank you. That makes a lot of sense. I can't believe I didn't think of that before. It's like a light bulb just came on. I guess the best way to differentiate between the different invoices is to add a "Company Code" field or something like that. I feel kind of dumb now but once I get...
  14. B

    New tables/queries/forms etc. based on existing format?

    Hi, I have created a series of relationships, tables, queries, and forms in a database for keeping track of the invoices for one particular client company. Is there an easy way to quickly duplicate all of those relationships, tables, etc. for use with a different client company? Basically I...
  15. B

    Newbie needs help filling out forms automatically ASAP

    New Lease Entries Tom, that file you have created has worked great. I've used it as a model on which I've based my DB. The form has to have preexisting leases and I am now trying to add a form (instead of having the user go through tables) in order to add new leases. However, what...
Back
Top Bottom