Search results

before a user deletes a record I want to display a message to confirm whether they wish to proceed, once this is done the record is saved or updated. what is the best method for this?

Hi, I am currently printing reports on a select monthly basis, using some code like below: WHERE (((Format([SaleDate],"yyyy"))=Forms![Sales Search]!cbo_Year) And ((Format([SaleDate],"mm"))=Forms![Sales Search]!Cbo_Month)); What is the best way to generate a report for a year or financial year...

I am using forms to input data into tables, just wondered if there was a way to prevent data entry into the tables so that the data is only added once a user presses the "save" button? is this possible? Not a major issue if not, just want to prevent the entry of incomplete records.

Hi, Just wanted to know if there is a way to enable a small menu for the user to print once a report is in print preview mode. I have the report appear in print preview mode pop up in a form. Other than right clicking and pressing print that way, is there a way to add a print button to the pop...

Hi, I have generated a series of reports that show financial info, sales, payments made etc. And I would like to be able to print select months payments. All payments and sales are assigned a date already. Just wondered how I could do this. Like allowing the user to select a month; or search for...

Hi, I am trying to generate a set of reports, which show the payments made to a particular payee, and the VAT paid. Each payment has a particular description, and the table has a category for each type. Eg. Phone bill, sub contractor, misc. Then a general gross payment and VAT. I want to print...

Hi, I am relatively new to Access. I have created a master form or main menu, from which I want to go to all other forms from. I want to do this by having a combobox rather than 5 or 6 buttons if possible. The user will select their form choice and press a navigation button to access that...