Search results

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]...

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...

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...

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...

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.

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...

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...

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

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...

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...

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...

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

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...

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...

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...

Thanks That was easy enough. Thanks Rich.

Hi, This is probably a quick and easy question but how do you get Access to display dates as just the month and year? It appears Excel allows you to do displays dates month/year(eg. June 2002) whereas Access forces you to include the day(June 25, 2002). What do I have to do? Thanks. Steve

Thanks Thanks Alex. That worked perfectly. -Steve

This is probably an easy question but I haven't found the answer anywhere.. In a form, when I click on the button to add a new record, how do I make the cursor/focus automatically go to the first field/control in my form? For example, I'm working on a music database and when the user clicks to...

More info to hopefully clarify I'll explain the logic behind my project; first of all, the company I'm interning at has leases to different businesses for furniture,etc. For the past two years, each month, the paper billing invoices get entered into Excel. They now want to go enter the data...