Search results

thank you very much guys I will create my own form and add buttons manually... cheers!! will let you know how I get on

I hate the limitations of switchboard forms so do what I do - create your own form for the interface. Re: building your own form to act as a switchboard, how do I link the buttons to reports and queries? Remember I am a total newb? Do I need to know VBA? Do I just add a button and then use the...

When I open the database, then go to the code view in VBA there is no code anywhere...its completely blank...are we talking about the same thing? please advise cheers..

The find option is greyed out... Any ideas why?

how do I link the buttons though? Remember I am a total newb? Do I just add a button and then use the options available from the wizard? Finally how do make that form open up when the end user runs the database? Please advise.. thanks for your help

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

ignore me I just answered my own question..... tell me how can I learn these expressions? they are so handy and not so difficult but I really need a starting point - do you have any tips please? thanks in advance... cheers

that works a treat... tell me, why when I setup a query and use the same expression, I not only see the documents expired or due to to expire but also see a different set of documents that are still in date? please clarify.. thank you so much for your help...

hey its working!!! wooohooo thank you very much.... the dates its showing me are wrong?? they are more then 7 days from 7th July 2009, when I need the system to alert of documents due to expire within 7 days... the expression I am using is:- which I thought would show me any dates that...

would it be possible for you to upload that database with the changes you made? I believe I also made the same three changes and it still does not work... please help thanks

i am sorry for being so silly but there is obvisiously something really minor I am doing wrong which is stopping me from acheiving my end result. Is there any way you could kindly make the required changes on my files and upload it for me? to save us going back and forth. Having read your...

am so close to the end of completing my very first database, please continue to help and support... thanks in advance..

here is the expression I am using as per your recommendation:- So each time I run the query a box appears asking me to enter the date.... I really want the system to be able to use todays date whatever the date is today / tomorrow / next month etc upon opening the system each time so when I...

hmmm but now the box appears as a prompt box with the label "insurance expiry date" I was hoping when I clicked a button, the report would automatically show me the insurance and MOTs due to expire within the next 7 days... Theres something wrong? But what? The format is correct because...

thanks... can i ask, if i have two fields with diff field names both with expiry dates then what would be the expression?? cheers really appreciate ya help

cant post the DB sorry... lets assume the field name is "insuranceexpirydate" please advise the exact expression I should use to obtain what I require? thanks

so to clarify should it read this instead:- please confirm

this is exactly what I put in the expression box... but I am now prompted with a box that asks me to enter the date, once I do that it returns the expired dates in red on my report I was hoping for the system to automatically use todays date.... What am I doing wrong? Please advise...