Search results

Sorry for being too clear. I have a number of queries which work off different range of FYs. Having these FYs sit as a function, allows me to modify my queries globallly as soon as I move to a new FY. Currently I am restricted to values as part of "FY From and To" functions I have created. But...

I use following functions to centrally change FYs. I use these functions in my queries. Function getFromFY() As String getFromFY = "FY 10" End Function Function getToFY() As String getToFY = "FY 12" End Function But sometimes I have had to change the range. So does it mean that I need to...

Thanks a lot for providing me the encouragement. It worked. I wasn't too sure of my own changes to the code.

Iwasn't very confident and just wanted to take small steps so broke it down to something I can see happening. You are right I should be able to simplify it. I tried but I could not quite achieve this. If I were to modify this code, would following work? Sub Monthlyroutine() Dim dbs As...

I routinely import excel files into my DB and then update the contents of existing tables. To do this programatically, I used the following code. I am not very confident user of VB so would like some help in improving this. It works one time but next time it freezes. However, if I delete...

Thanks. The message appears as a system generated message box access has. So the routine is that I have a command button which I click to open a report matching the project ID. At the same time, print dialogue box also opens up for user to print the report. At this point if user prints, there...

I have a command buton which allows users to clik and run a report for the matching record and print it. It works well if they proceed to print. But if they dismiss the print dialogue box, they get following message. The expression On Click you entered as the event property setting: the...

Thanks for ypur help.

Thanks. I really don't have much concerns on data quality. May be I try the code in this amended form. Do you think this will achieve the same thing? Sub Monthlyroutine() Dim dbs As Database, tdf As TableDef Set dbs = CurrentDb On Error GoTo Macro1_Err DoCmd.SetWarnings False ' RunSQL...

Thanks. No I am not performing any validation. But can I directly update a table without exporting first? If so, could you help?

I routinely import excel files into my DB and then update the contents of existing tables. To do this programatically, I used the following code. I am not very confident user of VB so would like some help in improving this. It works one time but next time it freezes. However, if I delete...

Thanks Wayne. I am not using switchboard to open the report. But having said that I do have a switchboard to navigate to different parts. Do you think that should still be an issue. Funny thing is not all reprts are affected. If I can have an answer as to why do I have an issue with MDE...

... including snapshot report? If so, do I add the existing form to a report as sub report?

Yes, I tried this but there isn't any option. When you select File|Send to menu option, the only usable options you get is the Excel and that merely copies the chart heading.

Sure. following is the link. http://support.microsoft.com/kb/903727

Ms Access has a decent facilty to send info by email by using Send To option from the menu. I have noticed that I cannot send a chart created in MS Access in any format available. Is there some trick to do this?

I wonder how things change in a database by themselves. I have several system but one of our user pointed put that when she tried to open one system and preview a report and there was no data, she dismissed the dialogue bos and gets this error message. I tried to test the db and I could not...

Just to make it easier, I have added a cut down version of the DB. This has the same functionality as original and intermittantly shows the issue I have. If you go to a pre filled in record after hitting the icon on the opening menu, and try to print several times, you will see that it...

Thanks. No I don't have any thing on the on load event of the report. I am usug PDF driver that appears as one of the printers as part of the print dialogue box that appears as soon as a user hits the command button which has the code I have written above. So the print dialogue sits on top of...

Yes, I do have something like this: Private Sub Report_NoData(Cancel As Integer) MsgBox "The report has no data." _ & "The requested report has been canceled. " _ & "Please check the criteria you have entered. ", vbOKOnly + vbInformation Cancel = True End Sub