Search results for query: *

Hi, I have two subforms -> rpt_sub1 & rpt_sub2. I then drag-n-drop theese into a main form called rpt_main. When I open one of the subreport and they don't contain any data I use the "on no data" event, to put in some textboxes/textfields. It all works fine when I open a subreport...

Ok, but that could be a problem for me.. There must be a workaround? As I can see the coulumn headings and other "titles" when I view the subreport manually. (not via a mainreport) ~amcodah()

Hi, I have 8 subreports.. which I drag-and-drop into a main report. It all works fine when there's data in the subreports.. But when I make a report where some of the subreports doesn't contain any data (they'r based on queries) they don't show up. If I open only the subreport that contains...

Howcome the subforms I have don't show in the main form when they has no data. I'm using the "On no data" event for displaying some messages, and I want to show the subforms in the mainform. Even if they don't contain any data. When I open a subform with no data it displays it...

Oh yes! thanks alot ;) I'm so stupid.. I don't have the english language on this version of Access so I never found the On No Data event.. It worked like a charm, gave you a deserved star.

Hi, I have a main_form and a sub_form. I want to hide a warning_textfield of the main_form if the sub_form has no data: I've tried to add this code on the Report_Open event: Private Sub Report_Open(Cancel As Integer) If Me.rpt_subForm.Report.HasData = False Then...

Thanks alot! :) Gave you a star.

An even easier solution, will be to run the code in the sub_report. Like this. But I can't still check if Me.Name contains anything. [COLOR=blue] Private Sub Report_Open(Cancel As Integer) If IsNull(Me.Name) Then Me.Warning.Visible = False End If End Sub [color] If no names...

I want to check if a report (sub_report) contains any data. If it doesn't it should not show. If it does it should show. I've tried this so far, but it doesn't work. Any ideas? (The sub_report is based on a query) Private Sub Report_Open(Cancel As Integer) If IsNull(Me.rpt_subReport) Then...

Yes, that's what I thought about doing aswell. But woudln't that me cpu/time-demanding operation? Isn't there a easier way to solve it? Thanks for your quick feedback anyway ;) ~amcodah()

Hi, I need some help here. I have a query which prints out some data IE: ID 1 2 I need to put that data into a string, so it would look like this : "1, 2" .. hence if there would be more data (id numbers) then it would go like this : "3, 6, 9, 14" for example. Any...

Me.textfield.visible = false.. yes that worked. I had an error in the report causing it not to work before. Stupid me ;)

Let me simplify the question: What I'm looking for is the VBA code for hiding a textfield in a report. Any Ideas?

Yes, this is quite simple to remove. After opening you'r form in design view. Choose Propeteries. You'll find the propeteries of Minimize/Maximize aswell as Close buttons visible property there. Just set them to "no" ~amcodah()

Hi, I seem to have problems figuring out how to set a textfield in a report to not visible. At forms it works fine by using Me.Name.Visible = False etc.. But this won't work at report fields. I want to hide some textfields depending on the outcome of an If check. (prints warning message if user...

Hi, you'd want to look at "thread702-625033". ~amcodah()

Yes, that's what I pointed out to you. You can send variables through the OpenArgs method. But yet a simpler method of solving this, since it seems like you'r not an experienced VBA user.. Would be to create a dummyform which is based on a query that gets data from the latest record. Then do...

This should help. Sub Form_Load() Me.TimerInterval = 1000 '1sec End Sub Sub Form_Timer() DoCmd.RunSQL "DELETE FROM table_name WHERE column_name = some_value;" End Sub ~amcodah()

Forms!subformname.OpenArgs Have a look at OpenArgs in help, that should solve things for you. ~amcodah()

Private Sub Form_Load() DoCmd.RunMacro mcr_Macroname End Sub Is this what you wanted? If not specify you'r question more. ~amcodah()