Search results

Thanks for the reply. I actually had done it already; just panicked in thinking that I hadn't! Just not on certain buttons! And google sometimes provides a poor answer that makes the situation worse! Thanks anyway.

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?

So using that above code; what would be the best way to implement a selection method for a combobox of years? So that the user can select for instance "2010/2011" from a combobox and press a select button. This function then generates the report for april 2010 until april 2011? Apologies if i...

But if I make the "year"; user input dependant, would that be something like: WHERE [Date] between #06/04/"cbo_year"#? Or is that done in some other way?

Legendary, thanks for that.

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

Is it possible to generate a report with the filter of the financial yearend? So for instance a report that when a user selects a yearend eg. 2011, the report generates all information from April 2010 to April 2011? Can this be done with only one input from the user? In the form of a combobox...

Thanks for the help; but I know the way I want to do it seems like it is not possible in Access. I thought there would be an inbuilt option bar on the print preview pop up, obviously not. Ctrl+P or right clicking and printing will have to suffice.

No, I want a print option once within the print preview pop up. Not a separate form for printing. That way the user can view and decide whether they want to print the report or not.

Right; I was hoping to add some buttons to the form that appears so the user can just press that. Is it not really possible?

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

Yeah thanks. I had this issue for a while, until I realised I had incorrectly typed DISTINCT as DISTINT. Schoolboy errroR! Think everything is all good now. Thanks for the help.:D

I think I have fixed the issue now. Just need to make sure that the reports are generated from the selection of the month.

Right I have had a look, and I sort of understand what is going on. I can populate my combobox with dates. But how do I remove the duplicate years from the selection? So say I want to show payments from Jan 2011 for instance? The combobox can only show the year, which leads to 10 selections of...

er. Maybe a nicer explanation would be brilliant! I'm sort of new to Access, but I have found that techniques are quite easy to pick up once I've got my head round it. :D

Thanks. I will give it a try shortly. How could I link this to a textbox so that the user has complete control of what is printed? In a month/year format?

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

Yeah it worked a treat. Thanks very much. As for the >0 >=0, I did ask a very daft question! I realised after I read again! :D

Right I shall try that. Would that method not print options that have a value of 0 though regardless? Thanks.