Getting Started

Combo box storing wrong field
Access 2003 Not sure if using right approach. 3 tables:Job, Employee, Equipment, Trucks. I have a form-Schedule that uses the table Job. The user chooses a job, a date range, the uses combo boxes to choose Employee, Equipment, Trucks. They can choose up to 9 rows per combo box. Then I want to use an append qry... 23 May 2008 16:33

Multiple tables - need 1 report
5 tables, each with vendor names, locations, trade and bid amount for a specific project (construction). I need one report showing all the bids from one vendor, i.e. plumber with the name of each project, his bid amounts and a few other items. I do not know how to get this info from each table and consolidate... 22 May 2008 19:37

2 Hot Chicks - a funny video
It was Kool "Visitbazaar Info" wrote: 2 Hot Chicks - a funny video ... 23 May 2008 08:51

How do I make a commision spreadsheet?
I am trying to make a spreadsheet that includes commission percentages and overhead. ... 22 May 2008 14:55

Maximum Rows for a table
In Access 2000, what is the recommended maximum number of rows in a table? Is there also a maximum number of columns that works well with that? Thank you, Cathy ... 23 May 2008 12:26

"First" Function
Access 2003 I am missing something about using First in a query. Why wouldn't this retrieve the first and ONLY the first record for each different Region in Table1? SELECT First(Table1.Region) AS FirstOfRegion, Table1.Class, Table1.Item, Table1.Price FROM Table1 GROUP BY Table1.Class, Table1.Item, Table1.P... 22 May 2008 14:08

Access 2003 date-based prompt
I am building a database in Access 2003 for equipment inspection. How do I set up a prompt or notification that an action must happen on a certain date? Example, I need to receive each Wednesday a prompt telling me the equipment scheduled the following week? My equipment is listed in a table with an attached f... 25 May 2008 18:50

Problem with lookups
Access 2003- I put together a PO database some time ago. The other day, after some macros 'hatled' I found a couple of lines in a macro missing. I replaced them but found my supplier lookup is malfunctioning. When I click the drop down in my lookup table, the list of suppliers is supposed to pull down. It's bla... 5 Jun 2008 21:26

database setup
Hi, I'm new to access and I'm having difficulty setting up my training records database. The purpose of this database is to monitor when an employee will be moving up to the next labour grade (i.e. promoted). There are certain courses offered within the organization that will enable an employee to move up to ... 22 May 2008 10:58

Undound Fields
My last question is how can I have a unbound data to not duplicate in a different record? What I meant is, on day 1 whenever I put a value in my unbound data and when I open a new record (day2), I still have that value in the undound field. When I changed it on day 2, it changes too on day 1. Is there a way to... 22 May 2008 10:58