Search results

thanks for the guidance, I will continue with my project later this afternoon... No doubt I may need to return here for some clarity or further guidance Thanks in advance for your help and support

thanks for your advise could I not export each invoice to excel format and then save them in for example "june 2010 invoices" folder and so on so that I can keep records? thats it, once I have the query setup I would then need to change the date each month right so that it corresponds with...

How do you track the films? Currently when a customer rents a film, a small piece of paper is completed and left in a rentals box, when they return the film I write the number of days the film was rented and total rental cost End of the month rentals - so if someone rents a movie on the 30th...

primarily because I have the time to set this up myself It would be good practice to get me back into ACCESS It will make me feel good when I have done it so back to my post, can anyone advise how best to do this?

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

hey drcake, thanks for pointing me in the right direction and clarifying the setup, I assume once i have setup these tables the rest is merely a case of setting up expressions for calculations :) I will give it a go later... re: my previous post, perhaps I do know more but am being modest...

thanks for your responses... sorry for being silly but JJTurner are you saying forms and queries is basically all I need to set this up? I do not mind tackling this project with tutorials that can be found on the web I just do not know how best to begin.. To begin with I can only see one...

i love you you rock thank you very much

thanks... any ideas then where I can get hold of a template database that will do this for me? cheers!!

I have thought about it and the more I think about I believe I would have only one table:- - table 1 = tenants personal details Table 1 would also be a form What I am unsure about is how it would work i.e. when I enter the amount paid for each tenant the process is complete.. Im not sure...

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, Im a bit stuck... I understand what you are saying about there is no point in opening a query from switchboard manager but I do not know how to create a report or form that will enable me to view the data in the same format as a query allows? If you could clarify this for me step...

Access Junkie, yes please can you write the instructions on how to open a query from switchboard manager... Thanks

thats what I thought... But how do I do that? Do I need to use VBA code? Any chance of a step by step guide? Am slightly confused.. please clarify thanks

What I would like to do is for my report to show me a list of peoples documents that have expired or are due to expire in one week using the date as a determining factor... Currently my report is setup to highlight any dates that fall within this category. However it shows me all records, so...

the " ' " trick worked a treat.......tis great.... thank you very much :)

gotcha!!! followed it and works a treat... I just created more forms, so button 8 would open up another switchboard page consisting of 8 more buttons... Thanks for your help and especially for creating a new page on your site for me :) Finally can I ask, is there a way I link one of these...

access junkie et al..... I fail to see how you have clearly explained step by step how do add more then 8 items to a switchboard menu??????? All I need help in doing is changing the preset 8 to 15 but do not know where to click to get change this preset?? If anyone could please write me a...

I have 8 buttons on my switchboard I have even changed the onclick and event commands in properties But I cannot get the code for it, this is the part I really need some help with:- Please help me access the code, I tried in the VBA part of access but still cannot do it... How do I do...