Search results

I kind of asked this yesterday but not as a seperate topic. I am trying to get a button which, when you click it, opens up a new query in design view every time. Is this possible.......I just can't figure it out. :confused:

Excellent, it worked. I don't know why it didn't before though but I tinkered and tweaked and it is all good now. Will look into opening a new query in design view.

I still can't get it to work. What do I put in Row Source Type?? Sorry to be thick but I don't know much VBA. Also, is there a way of having a button that opens a brand new query (in design view) every time? I couldn't work out a macro to do this. Thanks again Ben

I have a form from which I want users to be able to query the database, access a list of previously created queries and create a new one. I don't really however, want users to access the database window. Does anyone know how I should go about this? If not can I create a button on the form...

Of course. It worked, Cheers.

What is the best way of finding the average value for a field? For Example, I have a Legacy database and need to find out the average Legacy Amount.. Thanks Ben

Hello All, I want to take a value from a field that only appears in a form and put it into a table. Do I do this using an update query? If so, how? The file is called Age of Will in the form LegacyResearch. The value in the field comes from a function (=Year of Death - Year of Will), I...

Hello All, This is probably really easy. I have a table containing a column of bank account numbers that I need to clean. Firstly I want to pick out all of the numbers that are less than eight characters...how do I do this in query. I thought I could just sort the table by that column and...

I have a couple of fields where I want to store dates. I want the user to be able to enter 98 (for example) and have Access automatically enter 1998. Any way?

Hello All, I may not explain this very well. I have a database where I want the user to be able to run queries but not have access to the database window from the form which they can see. I have set up a button that opens a blank query but wnat them to have access to a list of past...

I have a User Guide for my database and I wanted to have a command button on one of my forms that the user can click to open this guide. Can I do this using a macro?

Another possibly simple question from me........ I have created a couple of fields on a form in my fundraising legacy database that have functions that work out specific dates. For example, one takes the date of death minus the date the will was made to work out the age of the will. The date...

Hello All, I'm am sure this is a very simple question once again. I have a Message Box that comes up from a Macro when you click a command box to exit the database saying 'Do you want to Exit?', the user can then click OK to exit the database. Is there any way to have yes and no boxes on this...

Hello All, I have set my database to open to a specific form but would like to know whether there is anyway for this form to automatically be MAXIMISED when opened. Thanks Ben

Hi, This is my first question on the forum. I am creating a form and want to have a field that is a sum of two other firlds in the same form and table. I basically want to divide an amount recieved field by a total value field.... How do I do this? Any help would be appreciated. Ben Whitestone