Search results

Hi there, I need to setup a simple invoice database for a movie store so far I have two tables: - customers - invoices Points: 1) Each customer rents numerous movies each month 2) At the end of each month they are sent an invoice detailing the movies they rented, plus rental cost for that...

Hi, I want to set up a rent sheet database for 20 tenants that would allow me:- - track rent payments - carry over balances to the following fiscal week Can I do this MS Access? I would have a switchboard and forms and reports behind that switchboard. I wanted MS Access to calculate...

Hi there, I have now completed my database. However I realised there is a potential flaw with it that needs rectifiying. How do I tweak my database to allow for:- - if a driver leaves I retain his records but can assign his call sign i.e. 01 or 02 to a new driver that joins whilst...

Hi There, Firstly I am close to completing my first ever access database in Access 2007 Unfortunately I discovered you cannot add more then 8 items to a switchboard. Having Googled the problem, I found the following solution:- But I cannot work out how to get past this part of the...

Hi there, Having completed my first database I wanted to let other use it so I tried creating an ACCDE and it failed. Having gone into the visual basic part of MS Access and clicked on "compile database" I receive the following error "Private Sub Command22_Click() GoToPage (7,{7},{7} ) End...

Hi there, I am very new to ms access having just created 1 database... I need to learn more about expressions for example the different types of expressions. It does not have to be indept but just basics like you would get in ms excel Does anyone have a list ? Or can you point me in the...

Hi there, I have setup a report in access, the field already has a date within it, I would like that date to go red 7 days before the due date. So when I run the report I can easily view which dates are due to expire 7days from today. How can I set this up? Please clarify which formulas or...

Hi there, I decided to learn MS Access so having read many tutorials and guides I wanted to try to create my first database. "I am confused about how best to set up relationships in Access" As I am in the transport industry I thought I would try and create a database to help me automate...