Search results

Can anyone help? I have set up some reports based on queries using access 2003. I have a form which prompts the user for a start and end date which is the criteria that is used to run the report. At the top of the output report I have set up a text box to show the dates that the user entered...

Hi Can anyone help! I have a Access 2003 database which I plan to roll out to users who will be using it via access runtime - as they have limited menu option on their toolbars, is it possible for the users to change their own passwords without having full access to the security menu. Many thanks

I have set up a secured database using access 2003 which I want to roll out to users who will only have access runtime installed on their pc's. The problem is there are some additional options that I want to add to a new menu (export, change password etc) that I need them to be able to view in...

Hi I have set up a form to prompt for start and end dates so that users can input their own dates which will return a report that is based on a query. However if they enter 01/04/07 to 30/04/07 it doesn't include the last date. I have tried putting the following into the query Between...

Hi I hope you can help. I have set up a form with 2 unbound text boxes for the user to enter a start and end date, along with an OK and cancel command buttons. The problem is I want make BOTH dates mandatory before they can click on the OK button to run the report, at the moment it will work...

Hi As part of my macro I need to define the IsLoaded function - I have tried searching through the Access help pages but IsLoaded doesn't seem to be listed on any of them. Can anyone help?? Thanks

I am having a problem trying to link a form to a report. I have set up a form which prompts for a start and end date criteria to run a report, however, when I click on the OK command button I have set up report that I have set up, it gives the error message You entered an expression that has...

I have set up a report which prompts the user for a start and end date. However, if they want to run it for a full month they enter eg. 01/07/07 and 1/07/07 - this will not include entries ending on 31/07/07. Is there a way I can change the criteria prompt so that it read both dates entered as...

Hi I am trying to set up access for multiple users, whereby they will open the database to see a switchboard with a list of all the reports they can run/view. I am a bit flummoxed by all the various security books I have read, is it possible to set this up without losing my own access into the...

I am trying to develop my database with the use of a switchboard which will enable certain groups of users to be able to see their relevant switchboard items (reports) - what I need to know is, if I set up one user account and password for each group of users who would require the same access...

Hope you can help! I have an access table which lists a customers address, however, if the customer has a temporary address it will also list that on a separate line - CustID Address Type 1234 5 The Street P 1234 12 The Street T 2345 13 The Road P...

Is it possible to convert fields listed down to show across. IDNo Code Position AAA B01 1 AAA C01 2 AAA D01 3 AAA E01 4 I want to show it as IDNo Code Code Code Code AAA B01 C01 D01 E01 Is this...

Help! I want to add a statement to my access query which lists one field if another field matches the criteria STATUS PROCCODE Complete ABCD Incomplete DEFG Complete JHLM Incomplete BDEF I only want to show the Proccode if the Status field is Complete, if its...

I have a field which shows numbers 1-8 or is null. I want to group this to show if its 1,3,5,7 then it shows as "BOOK" else if its 2,4,6,8 then its "CHAIR" and if its null then show it as null Can anyone help - I am using Access 2003