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

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

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

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

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

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

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

Hi, I'm designing a billing/invoice database at my internship and am at a standstill and quite frustrated. I've looked in "Access Bibles" and online help sites but am still having trouble. I'm trying to create a form that will eventually allow me to add new entries with minimal effort to...