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

Would you be able to point me in the right direction as to how to go about this? Thanks again

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

Finally got it to work using >=[forms]![formname]![cbostartdate] and <=[forms]![formname]![cboenddate]&" "&#23:59:59# Thanks everybody for all the help and suggestions

Thanks - just tried that but it doesn't seem to include the last date - seems to be taking everything before it

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

Thanks - I should have mentioned that the report, although it runs when only one date is entered, doesn't actually return any data as my query uses the AND operator. I have added a warning message into my macro highlighting that both dates need to be populated for the report to work, however...

Hi Sorry but where exactly do I need to put this text? Is it in the actual macro or do I need to define it elsewhere so I can use it in other macros later on? Thanks again

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

Do I still need to split the database if users will only be running reports and not entering data?

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

Some records will be populated with a code and some may not yet be coded or may never have a code allocated to them IDNo Code Position AAA B01 1 AAA C01 2 AAA D01 3 AAA E01 4 BBB CCC When I run the crosstab query it only listed the records with a code allocated and doesn't include any rows...

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

This works great!!! Thanks for your help! One last thing - I have some entries where the code field may be empty - is it possible to include them in this query or would I be better running a separate append query? Thanks

I actually want to show the data rather than count it. Is a pivot the best way to go for that?