Search results

Hi All I have a report which users run again passtocredit dates. How ever some dates are blank which are not showing on the report. Does anyone know what I need to enter in the query to show all values whether they are blank or not Thanks R

Hi All Im trying to have a command button so that when you click on it you will get a message and then the option to answer yes or no buttons. If they select yes one report will open and if they select no another report will open. does anyone know how I would start this coding? THanks R

Hi All I would like to set a command button so that when a user clicks on it, they get an option to show the summary version of the report or a detailed one. Can anyone advise on how to do this please? Using Access 2007 Thanks R

Hi All I would like it so when users hover over a command button a message appears. The command prompts open up reports, but they have to put certain criteria in text boxes for this run. There are that many different reports with different criteria its hard for users to remember everything...

Hi I have a macro set so when a user click inside a field a form pops which is a calendar, but Im struggling to find how to connect what the user has entered to show in the field. any help greatly appreciated Thanks R Office access 2003

Hi All I have a form which requires users to enter dates in several fields. I have got it so they select a date from the calender, but i would like it so they cant enter the date manually and they have to enter the date via the calender. Can anyone advise me how to do this please? Access...

Hi All I have form with thousands of records where users input data One the boxs is a text box and the user has to enter the date. I would like it so if the user clicks or tabs into the box it will automatically show the current date. But I only want it to show if the user clicks into the...

Hi I have a database that runs all the outstanding warranties. When i run the report lets say between 01/02/09 and 01/03/09 it will only give me results of warranties entered between 02/02/09 and 28/02/09, it is not including the dates that I actually enter but is between them Is there...

Hi I have an Access 03 database that is centrally on the server, I then put a short cut link on users desktop to the database. I would like to know how to not let users have access to the back end of the database, users have been going in and altering tables etc, I only would like them to...

Hi I have set up a form and a table for users to enter there user name and password. I have set the table with 2 user names and passwords to go with them. How ever when the I enter the users name and password the first one works, but the second one says invalid. even though I know I have...

Hi I am trying to write the code so when a user deletes a record they get prompt msg box to enter password. I have the below to delete the record but Im not sure how to get a prompt to enter password then if the correct one is entered to delete the record and if it isnt it will say wrong...

Hi all Does any know the coding to to prevent users entering the same data twice in a field on a form? If they enter the same data I want a warning message saying you can not enter this data as data already exists. Thanks R

Hi All Im trying to edit a report that currently shows the number of warranties that have been claimed. It currently show the total amount for each department. I am now trying to show the total count within each department which of those claims are assigned to a certain fault code. I.E 01A=...