I'm looking to set up a tracking database that tracks holidays & sickness and gives a report of how many for each employee so far at any point in the year. Is...

I'm creating a db in Access 2007 that has a rptg structure hierarchy, i.e. 1, 2, 3, 4. Basically, level 2 reports to level 1and level 3 reports to level 2...

I am puzzled as to how to proceed, I'm hoping someone can give me guidance or suggestions. Please bear with my long-winded explanation as there is a lot...

I'm trying to construct a database the relates a building info table with a utility accounts table, utility provider table, utility type table, and...

I want to create 1 template, save it and later reuse it under a different file name. Is this possible, and if so, how do I do it? Your help is appreciated.

Hi, I am on Access 2003 via MS Office Pro - 2003. I am working on a club membership tracking in Access. Originally, the software was built for the...

I have been told that you can improve performance of an Access database by turning off the Subdatasheet Name property of the tables that don't require this...

Hi, I'm designing a database to keep track of my agency's volunteers - we were using an outdated Excel spreadsheet before and a hack-job of a Word document...

I'm new at this and trying to do it by the book and would appreciate some guidance on the layout. I have tables (Customers and Contacts) that I related...

I want to get a price for a specific period based on a single date. My table has Customer#, Effective Date, and Price. (This table has many dates in...

CAn anyone please figure out wha't wrong with the query formula below? Thanks! NBV122009: IIf((0 And 0),(-*12),IIf((0 And 0),(-*12),0, and...

Can anyone help me make my report show zero's in a number field on my report? The table's field is blank therefore the Q returns a blank field.

I created this application a long time ago (Office 95) and it was used by a few users who were able to work through and with each other to search and add...

Hello, My wife has asked me to look at a database she uses at school. It is currently a databse that was designed years ago that holds student...

I have a form with many fields on it (Management Review) where data is entered. I'd like to enlarge the field if someone wants to enlarge it to view or do...

Allen Browne wrote a response called "Creating an Audit Log" in which he states that if the database is distributed (front-end forms, back-end tables) the...

Hi, I wonder is someone can help me please. I did post a similar thread a week or so ago but I didn't do too well on receiving replies, perhaps because...

Hello, I "Split" a 2003 Access Database with the BE table and FE all the rest linking to the table in the BE "I used the Access Splitter wizard". I did the...

In Access table design is it possible to set the default value on a field referencing the value to another field in the same table. For example field A and...

I am creating a DB to track invoices and in the future i would like to run queiries or reports that would separate invoices from one month to the other. For...