I hope that's even the correct term. if I have a collection and I want to see what's (and how many) items are in the collection, how do I go about...

I have a problem I can no longer compact and repair my database that I built in Access 2003. I also can not convert it to Access 2007. In both instances it...

need a template for employee's seniority list for MS Access 2003

How could you lose the disc, costs a fortune? Click Start menu, Click Settings Click Control Panel Click Add or Remove Programmes. Select Access 2007 and...

Hi Tom, thanks for your reply. Is there any way I can do this (just searching a table) for a keyword using a query which I can then base a report on so if I...

Trading system. Parent accounts and child accounts. Trader buys five mil into a parent account. Now they have to allocate that amount across a number of...

I am trying to have an expression that displays for all current contracts the word Current and for expired the word expired. But for the current ones I also...

When I count check boxes for a specified condition how do I get them to count in positive values opposed to the negative values

I need to do a v-look up from a file that is in Excel 2007 compatibility mode to a spreadsheet built in 2007. Normally I have the identifier as the column...

I need to display the row counts of all the 200+ linked tables in my database in some kind of table/report/query. Does anyone know how to do this?

2003 All works well except the INSERT INTO. By that I mean, I have a routine which finds and deletes offsetting dollar-amount records - if certain...

Is there a simple way to use two seperate tables on the same pivotchart? They have a relationship linked by their autonumber fields (unique). What i'd like...

Hi All, I need to import an excel file with different columns, ie: A3:B, D3:E and G3,J. I don't need column C and F. I am using code below but it doesn't...

Dear all, I want to fill Word document with Access data, please guide me how to do it. Thanks. Chlaris

Hi, Version: Access 2k3 Creating a form to centralize some commands and pre-defined queries. Click on button which triggers event within which call is made: ...

2003 The following statement causes all records to be transferred in defiance of the WHERE statement. dBs.Execute "INSERT INTO CHOOSEOffsets SELECT * FROM...

Hi, bear with me, I'm not a novice, but far from an expert. I have a database that I have setup that users enter batch information to log charges, payments...

Dear All, Does anyone know if it is possible to format memo field text. I have a form field (a Textbox) that uses a tables memo field as it's source. I would...

I am trying to make a presentation that can have numbers entered into an equation that will be displayed in a powerpoint, any ideas on how to do this or what...